Jittered Scatter Charts in Power BI via DAX and Power Query
In a recent post, I hinted that I’d be using the Football Project V2 as my “platform” for some future techniques-oriented posts. T
Category: Power BI
Power Query (M)agic Part 3: Divide & Conquer
Welcome back P3 Adaptive Nation! By now we’re in full swing with this Power Query (M)agic series, three posts and counting!
Interview with Chris Finlan on Power BI Report Server
The Man, The Myth, The On-Prem Server Guy… Chris Finlan and I have known each other for some time now. He emailed me out of the blue 3.5 years ago […]
DAX Reanimator Series: Top Performers using SUMMARIZE
Welcome back P3 Adaptive nation, today I’d like to demonstrate some exciting ways to show Top Performing “things” using DAX. Most of what we’ll discuss has been covered before in […]
Chatting with John Michaloudis & Rob Collie
The #1 Supporter of our 2nd Edition Book Sits Down for a Virtual Interview
Power BI Feature Spotlight: Report Drill Through
Every month Power BI gets an update that adds a nice handful of new features. Here at P3 Adaptive we ALL get excited for new Power BI features!
DAX Reanimator Series: Moving Averages Controlled by Slicer (Part 1)
DAX Moving Averages measure controlled by slicer in Power BI, using what-if-parameters, GenerateSeries, and disconnected table.
Power BI (DAX and M) vs. R: A Summer of Perspective
Based on what I’ve learned from Zoe, and what I’ve read to fill in the gaps, I think the two big differentiators are “how much statistical rigor do you require” and “how many different variations of the question do you need to ask?”
The Difference Between Forecasting & Predictive Analytics
Forecasting is when we anticipate the behavior of lots of people on long timelines. Predictive Analytics anticipate the behavior of One person…
DAX Reanimator Series – Part 3: Compare Product Performance After Launch
Welcome back readers, to another chapter in the DAX Reanimator Series! The post I’ll be re-envisioning today is one I’m very excited about.
Stick a Drop Pin in It: Visualize Data With Maps (DAX Reanimator Series: Part 2)
Greetings P3 Adaptive Nation! I’m here today to talk about maps, maps, globes, charts, topographical representations, and…well frankly I’m out of map synonyms. However there’s at least twice as many […]
Why Excel’s Power Query Refresh Speeds Suck
Ever noticed that Power Query refresh is slower in Excel than Power BI? Ken Puls, PQ Expert, explains the problem and what you can do to fix it!