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.
Content Type: Blog Post
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.
A Brief Treatment of DIVIDE(), RANKX(), and “N/A”
Ya know, we could probably write articles about RANKX for an entire year. There are just SO many subtleties to it, and SO many different ways you might want to rank things. Endless source of blog fodder.
Power BI Brain Candy: Value Above Replacement
In today’s article, I’m aiming to achieve three overlapping goals: