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 […]
Search Results for: best pract
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 […]
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” […]
Microsoft Fabric Capacity
Understanding Microsoft Fabric capacity is paramount for organizations aiming to turn an ever-growing torrent of information into a meaningful competitive advantage
Semantic Models Give You (and Microsoft) the AI Upper Hand – Plus a History Lesson on Why Frontends Matter
Back in 2010, Tableau beat smarter tools with a better demo. No brain, all charm and the market loved it. Fast-forward to now: same playbook, new costume. The AI dashboard […]
What Is Data Activator In Microsoft Fabric?
Data Activator in Microsoft Fabric turns real-time streaming data into instant, automated business actions from one centralized platform.
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 […]
How AI Is Improving Data Management
AI is revolutionizing data management by automating routine tasks, enhancing data quality, and delivering real-time insights that drive business growth