Data Modeling for Power Pivot and Power BI
An article on Data Modeling for Power Pivot and Power BI as well as a brief explanation about what we do written by the experts at P3 Adaptive .
Search Results for: best practice
Two Tricks to Make Your Cube Formula Scorecards Drama-Free!
Guest Post by Andrew Todd Cube Formulas: Ultimate flexibility for your reports but lots of drama to update… A while back, I was tasked with finding a way to automate […]
DAX – Trended Moving Averages
I’ve always been a firm believer that moving averages probably give a better insight into trends within a business than a simple trend line associated to a set of values such as monthly sales
A few tips on maintainability
Eat This Not That, PowerPivot Edition! Just like normal Excel, PowerPivot requires little or no premeditation – you can just jump right in and build something quite impressive. But if […]
Using Excel CUBE Functions with PowerPivot
Arriving Here from a Search Engine or via Excel Help? This article below by Dick Moffat, as well as the one by Dany Hoter, is an excellent, detailed example of […]
Power BI for Healthcare
Simply put, Power BI helps healthcare professionals cut through the data overload. Power BI is the ultimate healthcare multitasker.
Now You Can: Reinvent Your Relationship with Sales Data
A Fresh Take on the Reports You Rely On Somewhere along the way, sales data got a bad reputation. Not because it can’t help you, just because your current system […]
One Data Model to Rule them All?
Listener John sent in a classic question: should you build one all-encompassing data model, or should each part of your business have its own? If you think the answer is […]
Miller’s Theorem: A Principle for Getting Off the Fence
Ever find yourself overthinking a problem until you’ve thought yourself right into a corner? Yeah, we’ve been there too. But what if there was a way to cut through the […]
Rethinking the ROI of Dashboards
For years, dashboards have been the go-to for business intelligence. Built with the best intentions, loaded with visuals, and meant to empower decision-makers. But are they actually delivering? A recent […]
The Data Gene Transforms Non-Football Fans into Fantasy Football Devotees, w/ Adam Harstad
What happens when you mix fantasy football, data analytics, and a little bit of chaos? You get a conversation that refuses to follow a straight line—but somehow lands exactly where […]
What Drives Costs for Data Projects, and How are They Changing Over Time?
What if we told you that, before Power BI, most of the money spent on data projects didn’t go where you thought it did? In this episode, Rob Collie and […]