Data for everyone is where I explain, without needless jargon, how data platforms are built and what they actually cost. Technical when it needs to be.
July 27, 2026 · LinkedIn
Power Query ➔ model ➔ DAX ➔ visual looks like the only path while you're learning, and it isn't. Everything Power BI solves beyond the interactive report.
May 4, 2026 · LinkedIn
AI removes friction, but handing documentation to an agent is worthless if nobody can read it afterwards. A refresher on Power Query, connectors, modelling and DAX, so you don't depend on what you don't understand.
April 29, 2026 · LinkedIn
Power BI is only good for the autopsy of a business once everything has already happened." Why that argument mistakes the visualisation layer for the whole analytics ecosystem behind it.
November 26, 2025 · LinkedIn
The classic webinar question: with a sixty-million-row fact table, is it Import, DirectQuery or Direct Lake? How to decide, and where the bottleneck actually shows up.
November 19, 2025 · LinkedIn
A conversation with a client where a seemingly administrative renaming caused an expensive mix-up. Role, licence and capacity are three different things, and confusing them costs you when sharing.
November 17, 2025 · LinkedIn
What an SVG visual is and why it scales without losing quality. The formula that works out how many boxes to draw from the data, instead of fixed squares.
November 12, 2025 · LinkedIn
The client asks for ten identical reports, each filtered to its own region. Row Level Security with a boolean expression, so you maintain one instead of duplicating the work.
November 10, 2025 · LinkedIn
Turning a matrix of flat percentages into thermometers and gauges that change with the hierarchy level you're looking at, combining SVG with DAX.
November 5, 2025 · LinkedIn
Like it or not, Excel is still the database of many organisations. How to consolidate several monthly workbooks into one table, automatically and proof against the usual errors.
November 3, 2025 · LinkedIn
Out of FP20 Analytics' Challenge 31: how to use DAX so a visual stops showing numbers and starts telling you what happened.
October 29, 2025 · LinkedIn
How to reference an intermediate applied step from another query by injecting metadata at the end. The use case I found for it: handling errors without losing the source data.
October 27, 2025 · LinkedIn
A challenge that came up in the community: a tooltip that changes not just the values but the chart itself, depending on which measure you hover over in the matrix.
October 22, 2025 · LinkedIn
There's more than one way to share a report in the Power BI Service, and each carries its own risks. What implicit permissions mean and when each method makes sense.
October 20, 2025 · LinkedIn
Bookmarks give you a filter popup that saves space, but the client loses sight of what's filtered. A single DAX measure that shows the active filters on the main view.
October 15, 2025 · LinkedIn
Where your Excel and CSV files should live so Power BI reads them properly, and why the old SharePoint connector will cost you in performance.
October 13, 2025 · LinkedIn
A fact table related twice to the calendar is as everyday as it gets, and Power BI keeps only one relationship active. USERELATIONSHIP lets you use the other one without duplicating the model.
October 8, 2025 · LinkedIn
Power Query is the invisible worker behind every report: it unifies, imports and transforms data from any source. Why it pays to learn the M language instead of staying in the UI.
October 6, 2025 · LinkedIn
DAX doesn't only live in Power BI: it's also in Excel through Power Pivot and in Analysis Services. What it is, how it resembles Excel formulas and where you'll run into it.
October 1, 2025 · LinkedIn
When a query needs many custom columns, the Applied Steps panel grows out of control and becomes unmaintainable. The M pattern that creates them all at once, in two steps.