Power BI, Semantic Models & Dashboards

This is the part of the Azure data stack most people actually see. All the storage, pipelines and warehouses from earlier modules exist so that, at the end, someone can look at a clear chart and make a decision. Power BI is Microsoft’s tool for turning prepared data into reports and dashboards — the visuals you open in a meeting. If you only ever touch one tool in this course, it’ll be this one.

Reports and dashboards: the visible layer

A report in Power BI is an interactive set of charts, tables and figures built around a topic — say, a sales report with revenue by month, a regional map and a top-products table. The magic word is interactive: click a region on the map and every other chart updates to match. A dashboard is a single screen that pins the most important visuals together for an at-a-glance view, often gathering highlights from several reports. The simplest way to keep them straight: a report is the full, explorable story you click around in; a dashboard is the one-screen summary you glance at. Both are just polished windows onto the data underneath.

Semantic models: the brain behind the charts

Behind every good report sits something quieter but vital: a semantic model (you may also hear the older word dataset). This is the prepared layer of data that the report draws from — but it’s more than a table. It also holds the agreed definitions the business runs on. What exactly counts as “revenue”? Does “active customer” mean this month or this year? A semantic model bakes those answers in once, so every chart, every report and every person uses the same meaning. That’s why it’s called semantic — it captures the meaning, not just the numbers.

The payoff is consistency. Without a shared model, two analysts can pull “total sales” and get two different figures because they defined it differently — the classic meeting-derailing argument. With one well-built semantic model, there’s a single agreed answer, and everyone’s report tells the same story.

A report is what you see; the semantic model is the agreed data and definitions it’s built on.

DAX: the language of measures

Those agreed definitions — “revenue”, “year-on-year growth”, “active customers” — are written in a small language called DAX. You won’t write it and you don’t need to read it; just know what it is. DAX is the formula language used inside a semantic model to define measures, which are the calculated figures your charts display. Think of it as the spreadsheet-style formulas that turn raw rows into the totals and ratios people care about. When an analyst says “I’ll add a DAX measure for margin”, they simply mean “I’ll define how margin is calculated so every report shows it the same way”. That’s the whole role of DAX in your world: the place the business’s calculations are written down once.

Refresh: keeping it current

A report is only as good as the data behind it, and that data doesn’t update itself. Refresh is the act of pulling the latest figures from the warehouse or lake into the semantic model so the visuals reflect today, not last week. Refreshes are usually scheduled — often overnight — so the morning’s reports are current. This connects back to Module 3: a Data Factory pipeline frequently prepares the data, and then a Power BI refresh pulls it in. When someone says “the report hasn’t refreshed”, they mean the visuals are showing yesterday’s numbers because the latest refresh hasn’t run or has failed.

Spot it: Power BI concepts

Read each situation and decide for yourself, then tap a card to flip it and check your answer.

Sort the Power BI concepts

Drag each item into the bucket it belongs to — or tap an item, then tap a bucket. Hit Check placement when you’re done.

How to use it

You’ll live in Power BI more than any other tool here, so the phrases matter. If two reports disagree, the right question is “are they on the same semantic model?” — different models mean different definitions. If a figure looks wrong, ask “when did this last refresh?” before assuming the data is broken. And if you ever request a new metric, you now know the analyst will add a DAX measure to the model so it appears consistently everywhere. Seeing Power BI as the visible tip of everything earlier in this course — storage, pipelines and warehouses all feeding one trustworthy report — is exactly the mental model that makes you useful in these conversations.