Designing for Usability in Power Pivot and Power BI
An article on improving the usability in Power Pivot and Power BI as well as where the current program is at now and how to improve key flaws.
Search Results for: best practice
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 .
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 […]
Is Azure Synapse the Same as Databricks?
Azure Synapse is built for data warehousing and BI, serving as a centralized analytics hub seamlessly integrated with the Azure ecosystem.
Can AI Go Straight from Requirements to Power BI Models?
Nobody loves requirements docs. They’re the corporate equivalent of writing a novel just so someone can skim the back cover. The real question is whether you can ditch all that […]
What Is An Enterprise Data Warehouse (EDW)?
Enterprise data warehouse (EDW) is far more than a centralized data store—it’s the engine of strategic business transformation
AI In Data Warehousing: Trends And Applications
Welcome to the dawn of the AI data warehouse, where legacy systems meet the strategic imperative of today’s data-driven landscape.
The Million-Token Myth and the Magic of Digital Colleagues
AI looks unstoppable… until you hand it a hundred pages of meeting notes. Rob and Justin dig into why context windows and token limits quietly run the show. That “million-token” […]
Everything’s Real, Everything Matters, and Everyone Knows It w/ Quadrant Concrete CFO Joseph Graziano
Let’s say your business runs on sun, sweat, and schedule precision. You’ve got crews in the field, materials that don’t wait, and about 90 minutes to get it right before […]