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 edited for publication. In this installment of our Coffee Talk series, we’ll be chatting with The Power Pivot Utility team: Bertrand d’Arbonneau and Marco Russo, along with P3’s Reid Havens and Matt Allington. Let’s introduce everyone.
P3: Why I STILL Teach DAX in Excel: My Lament to Microsoft
Article by: Reid Havens
Welcome back readers! Today I want to talk to you about a few the reasons why I still like to teach DAX in EXCEL. A HUGE part of our jobs here at PowerPivotPro is teaching analysts & data junkies throughout the world how to use the best features of Excel and Power BI. Teaching is in our blood, we love doing it, and frankly we’re great at it (I definitely know this is last part is true because my even mom told me).
P3: Rediscovering (fire)matting: a truly amazing BI "tool"
Article by: Reid Havens
A little automation goes a long ways! Hello P3 Nation, (can this be a thing?)…I’m excited to show you a piece of software that I’m confident near 100% of you will utilize! I’m here to talk to you about an…
P3: Mighty Morphing Pivot Tables or: How I learned to automatically change hierarchy levels on rows
The Pivot Table featured below acts as if we’ve swapped out fields on rows – in response to a slicer click! First off…my first post! Being one of the newest (and youngest) members of the PowerPivotPro family has been very exciting…