Exploring & Analyzing Data

Describe Power BI Desktop models (star schema, analytic queries, report visuals)

Choose a model framework (Import, DirectQuery, Composite Models)

Design a semantic model (tables, date tables, dimensions, relationships, cardinality)

Write advanced DAX formulas (functions, operators, variables)

Add measures (simple, compound, quick measures, calculated columns)

Use DAX time intelligence functions (time intelligence, advanced calculations)

Optimize model performance

Enforce model security

Sharing Insights:

Scope report design requirements (audience, report types, UI/UX requirements)

Design Power BI reports (layout, visuals, KPIs)

Configure report filters (designing for filtering, advanced techniques)

Enhance report designs (details, highlighting values, navigation)

Perform analytics in Power BI (statistical summary, outliers, clustering, time series, AI visuals)

Create and manage workspaces and dashboards

Manage semantic models (connect to on-premises data, query caching)

Create dashboards (data alerts, Quick insights)

Implement row-level security (static and dynamic)