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 practice
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 […]
Data Management Consulting
The role of a Data Management Consultant is pivotal for businesses striving to leverage data as a strategic asset.
The Crutches Paradox (and Why Senior Software Engineers Don’t Care About AI)
Rob and Justin are back, catching up after a short break with an episode that’s part big ideas, part funny stories, and full of surprises. They kick things off with […]
A Lifelong Learner Embraces AI, w/Brian Julius
This week on Raw Data, Justin’s flying solo and catching up with Brian Julius, a true data veteran with a unique journey from government work to AI exploration. Brian’s path […]
Resilience Sometimes Beats Prevention, and Six Ways to Get off the Starting Line with AI
In this episode, Rob Collie and Justin break down life lessons learned from a simple tool: the Green Biscuit puck. It’s a perfect example of how resilience sometimes beats prevention—because […]
Head to Head: Can ChatGPT Replicate Rob’s Inspired Solution to a Power Query Challenge?
In this episode, Rob Collie and Justin Mannhardt step onto the data gridiron to test if AI can tackle the complexities of fantasy football data. Rob starts with a Power […]
Modernizing through Data for Literal Growth with Paul Grissom of PAR
Think farming and data don’t mix? Think again! In this episode, Paul Grissom from Pacific Ag Rentals (PAR) brings the heat, showing how data is shaking things up in agriculture. […]
A Bathtub of Data Holds an Ocean of Information (plus the Midmarket Paradox and Other News)
Is the Midmarket Secretly Winning with the Microsoft Data Platform? In this episode, host Rob Collie explores a surprising quirk in how Microsoft’s powerful data tools like Power BI and […]
Is SQL Data Modeling?
SQL data modeling stands as a cornerstone technique, essential for architecting robust, efficient databases that drive enterprise applications forward.