Power BI Advanced Series · Module 1 — Lesson 1 · by Raushan Ranjan, MCT
Why the Advanced Track Is Different
You already know what Power BI is. You may have built a few reports. The beginner series teaches you to drive the car. The advanced track teaches you how the engine works — so that when your 10M-row import times out, your DAX measure returns wrong numbers, or your published report shows stale data, you know exactly why and exactly what to fix.
Lesson 1 builds the mental model you will use for every subsequent lesson: what data analysis actually is, the four types every analyst performs, the role you are training for, and the six-step workflow Power BI is built around.
- Four analysis types: Descriptive, Diagnostic, Predictive, Prescriptive — in order of increasing insight value
- Power Query handles stages 1–2 (Acquire and Transform)
- The data model and DAX handle stages 3–4 (Model and Analyse)
- Power BI Desktop and Service handle stages 5–6 (Visualise and Share)
The Four Types of Analysis — What the PL-300 Expects You to Know
These four types are not theoretical. The PL-300 exam tests them directly, and interviewers use them to filter candidates. More importantly, every stakeholder request you receive in your career maps to one of these four types — and knowing which one tells you which Power BI tool to reach for.
| Type | Question It Answers | Power BI Feature Used | Enterprise Example |
|---|---|---|---|
| Descriptive | "What happened?" | Bar charts, line charts, matrices, card visuals | Total sales by region last quarter — summarising what occurred |
| Diagnostic | "Why did it happen?" | Drill-through, Key Influencers visual, decomposition tree | Revenue dropped 12% in Q3 — drilling into product category, region, and sales rep to find root cause |
| Predictive | "What will happen?" | Forecasting on line charts, Python/R visuals, Azure ML integration | Projecting next quarter's demand based on 3-year seasonal trend |
| Prescriptive | "What should we do?" | What-if parameters, scenario analysis, goal seek | Modelling the impact of a 10% price increase on margin across product lines |
The Data Analyst's Role — Five Responsibilities
The PL-300 is structured around the Data Analyst's responsibilities. These map directly to exam task areas:
The Six-Stage Workflow — Your Mental Map for Every Task
Every action you take in Power BI fits into one of these six stages. When you feel lost, ask yourself: "Which stage am I in right now?" That question alone will point you to the right tool.
| Stage | Tool | Output | Common Mistake |
|---|---|---|---|
| 1. Acquire | Power Query — Get Data | Raw query connected to source | Using ODBC instead of native connector — loses query folding |
| 2. Transform | Power Query Editor | Clean, typed, shaped table | Doing transformations in Excel before import — breaks repeatability |
| 3. Model | Model view / Relationships | Star schema with defined cardinality | Skipping this stage — DAX breaks on missing or incorrect relationships |
| 4. Analyse | DAX measures in Report view | Calculated KPIs and metrics | Using calculated columns where measures are needed — inflates model size |
| 5. Visualise | Report canvas | Interactive report pages | Using too many visuals per page — cognitive overload, slow render |
| 6. Share | Power BI Service | Published dataset + workspace | Publishing without configuring refresh or RLS — stale data and security gaps |
- Starting in Report view before transforming data. The canvas is the most inviting part of Power BI Desktop. But dragging fields before your data is clean and your model is defined means you will rebuild everything after you fix data issues. Always complete Power Query → Model before touching the canvas.
- Connecting to data with the wrong mode and never revisiting it. The connectivity mode (Import / DirectQuery) is set at connection time. Changing it later requires rebuilding queries. Decide before you connect: how large is this dataset? How fresh does it need to be? That decision takes 30 seconds up front and saves hours later.
- Publishing to "My Workspace" and sharing from there. My Workspace is a personal sandbox — it cannot be assigned a Premium capacity, cannot use deployment pipelines, and its datasets cannot be certified. For any report shared with others, create a dedicated app workspace from the start.
- The four analysis types (Descriptive, Diagnostic, Predictive, Prescriptive) map every stakeholder request to a specific Power BI tool
- The six-stage workflow (Acquire → Transform → Model → Analyse → Visualise → Share) is your mental map for every Power BI session
- Power Query handles stages 1–2; the data model and DAX handle 3–4; Desktop and Service handle 5–6
- Never start on the report canvas before your data is clean and your model is defined
- The PL-300 exam is organised around the Data Analyst's five responsibilities — every exam topic maps back to one of them
Q1. A financial analyst asks: "Based on last year's seasonal patterns, how many units should we order for Q4?" Which analysis type is this, and which Power BI feature would you use to answer it?
Show Answer
Predictive analysis — it is asking "what will happen?" based on historical patterns.
Power BI feature: the Forecast option on a line chart (Analytics pane → Forecast) for simple projections, or an Azure Machine Learning integration / Python visual for more sophisticated models. What-if parameters can also model order quantity scenarios (which edges into Prescriptive).
Q2. You are about to connect Power BI to a 500MB SQL Server table that updates every 30 minutes and must reflect data no older than 1 hour. Which connectivity mode do you choose, and why?
Show Answer
DirectQuery. The 500MB size is below the practical Import limit, but the 1-hour freshness requirement rules out Import (which on shared capacity refreshes at most every 30 minutes, and refresh scheduling has overhead). DirectQuery queries the source directly on every interaction, guaranteeing data is always current. Trade-off: report performance depends on SQL Server query speed.
Q3. In which stage of the six-step workflow does DAX belong, and what is the key mistake that makes DAX measures return incorrect results even when the formula is written correctly?
Show Answer
DAX belongs to Stage 4 — Analyse.
The key mistake is skipping Stage 3 (Model). DAX measures use filter context propagated through relationships. If the relationship between your fact table and dimension table is missing, has wrong cardinality, or uses the wrong cross-filter direction, DAX formulas will return incorrect totals, ignore filters, or throw blank results — even when the formula syntax is perfectly correct.
- RR Skillverse: Power BI Cheat Sheets →
- MS Learn: Get started with Power BI Desktop →
- MS Learn: PL-300 Certification overview →