The Part of Data Modelling Everyone Skips (That Breaks Everything Later)
Your measure is right, your data reconciles, and your year-to-date is still wrong - because the model never had a real date table, only a date column pretending to be one.
Power BI
// 24 postsPosts about Power BI.
Power BI posts
-
-
Star Schema Done Right, Part 2: Dimension Tables and Why Cardinality Matters
A dimension table isn't just a lookup. Why fact-to-dimension relationships have to be many-to-one, why bidirectional filtering always causes problems, and how to build dimensions your DAX can trust.
-
Build a SharePoint List-Connected Power BI Report (And Handle the 5,000-Row Problem)
Connect Power BI to a SharePoint List the way that doesn't fall over at 5,001 rows - OData filtering at the source, an indexed filter column, and a refresh schedule that doesn't need a gateway.
-
What Actually Changes When You Go From Analyst to Senior Analyst
The title changes, the salary changes, and the list of skills that matter changes completely. Worse, the things that made you good as an analyst quietly start working against you at the senior level.
-
Star Schema Done Right, Part 1: What a Fact Table Actually Is (And Isn't)
Most introductions to star schema start with the diagram. The star, the centre, the spokes. This one starts with the question: what problem does a fact table solve that a flat table doesn't? Part 1 builds the intuition before the vocabulary, so the rest of the series makes immediate sense.
-
What I Wish Someone Had Told Me About Working With Data in a Small Team
In a small team, you're the analyst, the engineer, the dashboard designer, and the person who explains what a p-value is at the all-hands.
-
The Skill Nobody Told You Was Half the Job: Asking Good Questions
The analysts who get traction aren't the fastest at pulling data, they're the best at unpacking what was actually being asked. The skill is asking good questions, and nobody trains for it.
-
Build a Power Automate Desktop Flow That Exports a Report and Emails It Daily at 7am
Step-by-step from a blank flow, including how to handle the parts that break the first time.
-
Not Everything Should Be Automated — Here's How to Tell the Difference
Automation bias is real: if you can automate something, it feels like you should. But some processes contain judgement calls that automation silently gets wrong, edge cases that require human revie…
-
How to Say No to a Data Request Without Burning the Relationship
You can't build every dashboard that gets requested. But 'no' lands differently depending on how you say it — and most data people either say yes to everything and resent it, or say no in ways that…
-
Python for Excel Users, Part 2: Grouping, Aggregating, and Replacing Your SUMIFS
SUMIFS and COUNTIFS are great — until your data has 500,000 rows and Excel is grinding. Part 2 shows how to do everything your SUMIFS does, but with pandas groupby — faster, more flexible, and on d…
-
Your Power BI Report's Performance Problem Is Probably Your Data Model, Not Your DAX
Slow reports get blamed on complex measures. Complex measures get rewritten. And the report is still slow — because the actual problem is a flat table with 47 columns, many-to-many relationships, a…
-
Getting Credit for Work That 'Looks Easy'
The more competent you get, the less people see the effort behind what you deliver. A clean dashboard looks effortless. A fast turnaround looks like it was always fast.
-
The Difference Between a Dashboard and a Decision Tool (And Why It Matters)
Most dashboards answer the question 'what happened?' Very few answer 'what should we do?' The gap isn't data — it's intent. A dashboard built for the former often actively gets in the way of the la…
-
Why Your Stakeholders Keep Asking for the Wrong Chart
They ask for a pie chart when they need a bar chart. They ask for a table when they need a trend line. This isn't ignorance — it's that they're translating a question into a visual type without kno…
-
DAX Context Demystified, Part 4: Iterator Functions and When Row Context Returns
SUMX, AVERAGEX, MAXX — these functions bring row context back into a measure, which sounds helpful until they don't behave the way you expect inside a CALCULATE. Part 4 closes the series with the p…
-
When Your Manager Doesn't Understand What You Built
You delivered a clean model, a solid dashboard, a real solution — and got a blank look in the room. The work was right. But explaining technical work to someone who doesn't share your frame of refe…
-
DAX Context Demystified, Part 3: Time Intelligence and Why Your YTD Is Probably Wrong
Time intelligence functions look simple - TOTALYTD, SAMEPERIODLASTYEAR — until they aren't. The reason they break isn't the function. It's that context transition interacts with your date table…
-
Power Query Is Not the Right Tool for Every Data Problem
Power Query is a brilliant transformation tool. Most of the M code in production is doing things that belong in DAX, SQL, or Python - and the models are slow and the code is unmaintainable.
-
Avoid Bragging: Talk About Your Work Effectively
Stop cringing. There's a way to talk about your accomplishments in Excel and Power BI that sounds competent, not arrogant. It's all about framing.
-
DAX Context Demystified, Part 2: CALCULATE and Context Transition
CALCULATE is the most powerful function in DAX - and the most misunderstood. Once you see how it deliberately replaces the filter context rather than adding to it, every confusing measure result …
-
Your Power BI Report Has Too Many Visuals and Not Enough Story
More charts don't mean more insight. Every visual you add is a question your stakeholder has to answer before they understand the point - and most reports ask them to answer fifteen questions bef…
-
Build a One-Page Executive Dashboard in Power BI That Stakeholders Actually Open
You'll build a clean single-page report: KPI cards, a trend line, and one slicer. The kind that gets opened voluntarily, not just emailed as a screenshot. Starting from a blank canvas, ending with …
-
Nobody Knows What You Actually Do (And That's Partly Your Fault)
You deliver good work consistently, your manager knows you're reliable — and yet somehow you're invisible at promotion time. The problem isn't your output. It's that you've never made your work l…