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

Aldervane: client confidentiality in Power BI

Was die Einheit vermittelt

Design dynamic row-level security from a security table (engagement team membership) instead of a single partner column, and predict what a given user sees
Hide confidential tables and columns with object-level security written in TMDL view, and predict what happens to measures and visuals that reference them
Avoid the rule that RLS and OLS cannot be combined from different roles, and design role membership so each user gets one consistent combination
Map each leak path (CSV, Excel, PDF, Analyze in Excel, .pbix download, Publish to web) to its control: export settings, sensitivity label protection, tenant settings, audit
Name the costs of a confidentiality design: maintenance of the security table, lost visuals for restricted roles, performance, and admin dependencies

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