A Cautionary Rhyme for the Analytically Inclined On gold layers, dimensional modeling, and why your AI agent cannot squint KIMBALL · FABRIC · POWER BI · COPILOT · DATA AGENTS A Note Before We Begin Though Wex works in sales — his pipeline, his reps, his regional woes — the principles that broke his world are… Read more

Just Because Power Query Can Doesn’t Mean It Should Power Query is incredible. It’s one of the most powerful, flexible, and misunderstood tools in the Power BI ecosystem. It can join data, reshape it, cleanse it, deduplicate it, apply business logic, detect types, generate calendars, and perform transformations that rival full ETL pipelines. And yet… Read more

Why “Why?” is the most important question When people hear the word why, they often brace themselves. It can feel combative.Invasive.Judgmental. As if the person asking is about to clutch their pearls and say, “I’m sorry… you want to do what with the data?” But in data, analytics, and AI—especially when designing solutions in Microsoft… Read more

After a very long day yesterday I was thinking about thigs I wanted to do with my daughter over Thanksgiving break and it reminded me of the year that Frozen came out and I took her to the movies for the very first time the day before Thanksgiving. What does this have to do with… Read more

By: Audrey Gerred Why I’m a Broken Record About Star Schema in Power BI The Repetition Is Intentional I talk about star schema again and again because it’s foundational. It’s not just a best practice — it’s the difference between scalable, performant, governable models and ones that become brittle, slow, and hard to trust. Power… Read more