Ihr Weg

Stufe 1
Exam map and the Power BI landscape~1,5 Std. · Start
Stufe 2 · ~2 Std. · laut Plan des Autors nach „Exam map and the Power BI landscape“innerhalb einer Stufe ist die Reihenfolge frei
Connect to data: sources, shared semantic models, credentials and parametersDomain 1 · Prepare the data
Storage modes: Import, DirectQuery and Direct LakeDomain 1 · Prepare the data
Workspaces, apps, publishing and distributionDomain 4 · Manage and secure Power BI
Stufe 3
Profile and clean the data~2 Std. · Domain 1 · Prepare the data · laut Plan des Autors nach „Connect to data: sources, shared semantic models, credentials and parameters“
Gateways and scheduled refresh~2 Std. · Domain 4 · Manage and secure Power BI · laut Plan des Autors nach „Workspaces, apps, publishing and distribution“
Security and governance: roles, item access, RLS and sensitivity labels~2,5 Std. · Domain 4 · Manage and secure Power BI · laut Plan des Autors nach „Workspaces, apps, publishing and distribution“
Bridge to Microsoft Fabric: lakehouse, Direct Lake and the road to DP-600~2 Std. · Optional · Fabric · laut Plan des Autors nach „Storage modes: Import, DirectQuery and Direct Lake“
Stufe 4
Transform I: types, columns, grouping, pivoting and JSON~2,5 Std. · Domain 1 · Prepare the data · laut Plan des Autors nach „Profile and clean the data“
Exam rehearsal: a case study, time management and traps~3 Std. · Exam rehearsal · laut Plan des Autors nach „Security and governance: roles, item access, RLS and sensitivity labels“
Aldervane: client confidentiality in Power BI~2 Std. · Optional · Aldervane · laut Plan des Autors nach „Security and governance: roles, item access, RLS and sensitivity labels“
Stufe 5
Transform II: merge, append, reference vs duplicate, keys and load settings~2 Std. · Domain 1 · Prepare the data · laut Plan des Autors nach „Transform I: types, columns, grouping, pivoting and JSON“
Stufe 6
Star schema: facts, dimensions and table properties~2 Std. · Domain 2 · Model the data · laut Plan des Autors nach „Transform II: merge, append, reference vs duplicate, keys and load settings“
Stufe 7 · laut Plan des Autors nach „Star schema: facts, dimensions and table properties“
Relationships: cardinality, cross-filter direction and role-playing dimensions~2,5 Std. · Domain 2 · Model the data
A common date table~1,5 Std. · Domain 2 · Model the data
DAX I: measures, calculated columns and evaluation context~2 Std. · Domain 2 · Model the data
Build the report: visuals, formatting, themes, filters and paginated reports~2 Std. · Domain 3 · Visualize and analyze data
Developer mode: PBIP, TMDL, Git integration and deployment pipelines~2 Std. · Optional · For developers
Stufe 8
DAX II: CALCULATE and context transition~2,5 Std. · Domain 2 · Model the data · laut Plan des Autors nach „DAX I: measures, calculated columns and evaluation context“
Optimize model performance~2 Std. · Domain 2 · Model the data · laut Plan des Autors nach „DAX I: measures, calculated columns and evaluation context“
Copilot in Power BI~2 Std. · Domain 3 · Visualize and analyze data · laut Plan des Autors nach „Build the report: visuals, formatting, themes, filters and paginated reports“
Storytelling: bookmarks, tooltips, interactions, navigation and drillthrough~2,5 Std. · Domain 3 · Visualize and analyze data · laut Plan des Autors nach „Build the report: visuals, formatting, themes, filters and paginated reports“
Analyze: patterns, trends, outliers and AI visuals~2,5 Std. · Domain 3 · Visualize and analyze data · laut Plan des Autors nach „Build the report: visuals, formatting, themes, filters and paginated reports“
Stufe 9
DAX III: time intelligence, semi-additive measures, statistics and quick measures~2,5 Std. · Domain 2 · Model the data · laut Plan des Autors nach „A common date table“, „DAX II: CALCULATE and context transition“
Visual calculations~1,5 Std. · Domain 3 · Visualize and analyze data · laut Plan des Autors nach „DAX II: CALCULATE and context transition“
Usability: mobile, personalization, accessibility, export and page refresh~2 Std. · Domain 3 · Visualize and analyze data · laut Plan des Autors nach „Storytelling: bookmarks, tooltips, interactions, navigation and drillthrough“
SQL to DAX phrasebook~2 Std. · Optional · For developers · laut Plan des Autors nach „DAX II: CALCULATE and context transition“
Stufe 10
Calculation groups~2 Std. · Domain 2 · Model the data · laut Plan des Autors nach „DAX III: time intelligence, semi-additive measures, statistics and quick measures“
PrüfungAbschluss · im Browser, ohne den Assistentengesperrt · in den Kurs einschreiben

0 von 28 Einheiten abgeschlossen · ~51 Std. ohne die optionalen Einheiten, ~59 Std. mit ihnen

SQL to DAX phrasebook

Was die Einheit vermittelt

Translate WHERE, GROUP BY, HAVING, COUNT DISTINCT and CASE into DAX measures and DAX queries, and say who does the grouping in a report (the visual, not the measure)
Replace joins with relationships, RELATED, RELATEDTABLE, LOOKUPVALUE and TREATAS, and choose the right one for a lookup, an aggregate or a table without a relationship
Express NOT EXISTS, window functions (OVER, PARTITION BY, RANK, running totals) and CTEs in DAX, and predict the result in a given cell
Recognise DAX pitfalls that SQL habits cause: blank rows that disappear or reappear, ranks for empty members, variables that do not re-evaluate inside CALCULATE, BLANK compared with zero
Name the cost of each pattern: FILTER over a fact table, densifying with + 0, LOOKUPVALUE in calculated columns, both-direction relationships instead of TREATAS

Diese Einheit ist für Eingeschriebene zugänglich

Die Einschreibung ist kostenlos — dadurch kann sich der Server Ihren Fortschritt zwischen den Sitzungen merken.

Anmelden und einschreiben Zurück zur Kursseite