Calculation Groups to the Rescue!
o set the stage, I need you to travel back in time with me a bit. The year was 2019, and none of us had ever heard of COVID-19…those were simpler times.
Content Type: Blog Post
We’re Changing Our Name (and Nothing Else!)
In the Fall of 2009, I created PowerPivotPro.com in order to begin blogging about this new technology called Power Pivot. I’d seen what it could do, and knew it was going to change the world. People needed to know about it! So, the blog was born.
Planning at the speed of COVID: P3 Adaptive and Power On
During “normal” times, you can often get away with guessing that tomorrow will resemble yesterday, and simply following your well-worn business map.
Free Workshop From Microsoft and P3: Modern Excel Analyst In A Day
Do you have Excel Analysts spending hours wrangling data week after week to provide updated reporting and analytics?
How Do You Know Your Power BI Security Roles are Right?
You need insights from your data, but you don’t want the wrong people seeing data that’s confidential or outside their responsibilities. In the Power BI service, there’s a robust way of ensuring that the right people get the data that they need for their purposes
Power BI and Paginated Reports: Better Together
Today we’ll be concluding our 3-part series on Analysis versus Reporting, Power BI versus SSRS and Paginated Reports, and looking closely at our habit of using the word “versus” so liberally
Paginated Reporting and Power BI: Why You Probably Need Both
Technologies always come with tradeoffs, and an interactive canvas is ultimately a place where you arrange a bunch of pre-built objects.
Power BI and Paginated Reports: Have We Come Full Circle?
There are few stories as tortured and twisted as my relationship with Analysis and Reporting. In 2002, as part of the Excel team at Microsoft, I was introduced to the concept of Business Intelligence
Agile Reaction to Change: Cleaning Up with Bar Keepers Friend
Over the years, I’ve written multiple times about how BI spending increases during hard times
A Completely New Site for a New Era
P3 Adaptive version 3” Clarifies What We Can Do For You
Speed up your Power BI DAX formulas by up to 95% using the new OPTIMIZEDAX() function
This is an April Fools’ joke. OPTIMIZEDAX() doesn’t exist, but we hope the post gives you a laugh nonetheless.
“Head to Head” Comparison Infographic in Power BI
This is one of those things where I spent a lot of time figuring out how to do something non-obvious. And hey, that’s usually a good thing to share! Keeps others from burning needless time, pushes the envelope a bit, inspires “riffs” and improvements on the core idea, etc.