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
Category: Power BI
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.
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:
Power Query (M)agic: Parameters for Dataflows!
I’ll get to parameters for dataflows in a bit. To begin, let’s talk about dataflows. Dataflows are Power Query queries that live outside of Power BI reports and can be refreshed on a schedule within Power BI service.
Are my people working when the work needs to be done? Headcount Analysis with Power BI
One of the nice things about the Power Suite (the term I generally use to refer to Power BI, Power Pivot, and Power Query; does anyone else have any good terms?)
DST Refresh Date Function Power BI Service
Quick tip for DST Refresh Date function Power BI Service. I’ll put the code up front, and explain it below.
Finding the Flow: A Beginner’s Guide to Microsoft Flow
For the new year, I have a question for you: What do you think of when you hear the word “Flow”?