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.
Content Type: Blog Post
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:
How Can I get a Lookup Table from a Slowly Changing Dimension (SCD)?
Your Power BI model is fed by a data warehouse, and you’d like to make some reports, but now your Customer table has several entries for each customer instead of one.
Export Power BI Data with Date Range in Title
In Power BI, every visual needs a title. Titles not only makes it easier to manage items in the selection pane, but also provide context when exporting data. Without a […]
Siloed and Slow: What Happens When You Aren’t Using Power BI’s Data Model “Brain”
Last week’s post left off here: most BI still relies on the storage layer (SQL or its many cousins) to be the brain, and storage layers are terrible brains because they were designed for storage, not for analysis.
Data Models: Power BI Has a Brain. How About Your BI Strategy?
Alternate Titles Abound! I could have just as easily titled this post ANY of the following: