Agile BI Moves from “If” to “How”
My 2010 Wake Up Call Eight years ago, I lucked into an epiphany: IT-driven BI was going to give way to biz-driven BI (aka “self-service” or “Agile” BI). The new wave of BI tools – led by Power Pivot at…
Using DAX Magic For Variable Forecasting
I often have inputs I know today and want to “run them out” into the future applying certain parameters along the way to create a projection. I’m in finance, so my needs will almost always have a financial planning bias,…
March Madness in Power BI
It's time again for the March Madness tournament and another excellent opportunity to introduce/teach people at your company/organization about Power BI. This article explains one approach for doing March Madness Power BI style, and using everyone's bracket data to teach…
Share your story or technique here on PowerPivotPro!
Talk About Your Personal Journey OR Share a Technique – Either Way, it’s Time YOUR Voice is Heard Are you ready to see your name in lights? Hi folks! I know, I know… long time, no write. I’ve been busy,…
PBI Spotlight: NEW & IMPROVED Tooltips
Hello again P3 Nation! I’m SUPER excited today to talk about an updated feature in Power BI Desktop. This month had a bunch of updates, all of which are pretty great. Some of my favorites are that bookmarks are now…
How Refreshing: An interaction with Rob Collie
A few years ago, on February 14th, 2013, I fell head over heels onto a rocket ship that kicks just as much, well it kicks more ass than Tyler Durden on his best day. Valentine’s Day coincidence? Maybe I’ll get…
The Great Function Project – Part 1
Your First Co-Development Project P3 has tried many different flavors of our brand of “consulting” through the years, but co-development projects that combine real projects with coaching and knowledge transfer have turned out to have been the sweet spot in…
How to Get Power BI Service to Work for You
What I didn't know about the Power BI Service (PBIS): I've been using the Power BI Service (PBIS) daily for five months, and before that, I consulted on challenging DAX problems for over a year. So, when I attended a…
Coffee Talk: PowerPivot Utilities
Welcome to the latest PowerPivotPro Coffee Talk, where members of the community discuss various topics related to Power BI, Power Pivot, and Analytics/BI in general. These conversations take place during the week on a Slack channel and are then lightly…
Power Query (M)agic: Dynamically remove leading rows AND columns
The scenario – source data sheets that are structured differently! Does Power Query sometimes seem too rigid? It’s great for defining a sequence of transformations to clean your data but requires the incoming data to be in a consistent format.…