Free quest, 4 minutes
Find why sales dropped You can split a flat total into its parts over time, so a collapse hiding inside an aggregate becomes visible on the page.
Boot the rig Arc 1
Intake Bay: Getting Data In You can connect to varied sources, choose a storage mode and profile the data before touching a visual.
1 Desktop, Service and the report lifecycle You can explain which work happens in Power BI Desktop and which only happens in the Power BI Service. 10m 25xp 2 Connecting to data sources You can connect to a file, a folder and a relational database and recognise which connector each requires. 11m 28xp 3 Import, DirectQuery and Dual You can choose a storage mode based on data volume, freshness requirements and DAX feature support. 12m 30xp 4 Profiling data quality in Power Query You can use column quality, distribution and profile panes to find nulls and outliers before modelling. 11m 28xp 5 Data types and locale You can set explicit column types and diagnose conversion errors caused by locale differences. 11m 28xp 6 The Power Query editor and applied steps You can read a query as an ordered list of steps and modify one without breaking the ones after it. 10m 25xp 7 Query folding You can tell whether a step folds back to the source and reorder steps to preserve folding. 12m 30xp 8 Query parameters You can parameterise a server name or file path so the same file works across environments. 10m 25xp 9 Credentials and privacy levels You can set the correct authentication and privacy level so a combined query refreshes without a formula firewall error. 10m 25xp 10 Dataflows and reusable preparation You can decide when preparation logic belongs in a shared dataflow instead of inside a single report. 10m 25xp Arc 2
Refinery: Shaping the Data Pro You can reshape messy source tables into clean, analysis-ready tables in Power Query.
1 Removing columns and filtering rows You can reduce a table to the rows and columns the model actually needs and explain the size impact. 9m 23xp 2 Splitting and merging columns You can split a combined field by delimiter or position and recombine fields with a separator. 10m 25xp 3 Replacing values and cleaning text You can normalise inconsistent text values so grouping produces one category instead of several. 10m 25xp 4 Conditional and custom columns You can add a derived column with conditional logic and choose between the UI builder and a custom expression. 11m 28xp 5 Group By and aggregation in Power Query You can aggregate a detail table to a summary grain and decide whether that belongs in the query or in DAX. 11m 28xp 6 Pivot and unpivot You can unpivot wide crosstab data into a tidy long format suitable for modelling. 12m 30xp 7 Merging queries You can join two queries with the correct join kind and verify the resulting row count. 12m 30xp 8 Appending queries You can stack tables of the same shape and detect column name mismatches that create null columns. 10m 25xp 9 Handling errors in queries You can locate rows that produce errors and decide whether to remove, replace or fix them at source. 10m 25xp 10 Reading M code You can read a let-in expression and edit a step's M code safely in the Advanced Editor. 11m 28xp 11 Referencing versus duplicating queries You can share upstream logic across queries without copying steps that then drift apart. 10m 25xp 12 Incremental refresh You can configure a range policy so refresh reloads only recent partitions of a large table. 11m 28xp Arc 3
Blueprint Room: The Data Model Pro You can build a star schema with correct relationships, cardinality and filter direction.
1 Star schema fundamentals You can classify each table as a fact or dimension and lay out a star schema. 12m 30xp 2 Creating relationships You can create a relationship on a shared key and verify it filters in the direction you expect. 11m 28xp 3 Cardinality You can choose the correct cardinality and recognise why many-to-many introduces ambiguity. 11m 28xp 4 Cross-filter direction You can decide between single and bidirectional filtering and describe the risk of ambiguity. 11m 28xp 5 Inactive relationships and role-playing dimensions You can activate an alternate relationship inside a measure using USERELATIONSHIP. 11m 28xp 6 Building a date dimension You can create a contiguous marked date table covering the full range of your facts. 12m 30xp 7 Hierarchies You can build a drillable hierarchy and describe how ambiguous levels break the drill path. 9m 23xp 8 Calculated columns You can add a calculated column and explain when it is evaluated compared with a measure. 11m 28xp 9 Calculated tables You can create a derived table in DAX and justify it against doing the same work in Power Query. 10m 25xp 10 Model hygiene and metadata You can hide technical columns, set display folders and formats so the field list is usable by report authors. 9m 23xp 11 Reducing model size You can identify the columns driving model size and reduce cardinality to shrink it. 11m 28xp 12 Aggregation tables You can add a summarised aggregation table so common queries avoid scanning the detail fact table. 11m 28xp Arc 4
Formula Core: DAX Fundamentals Pro You can write measures that behave correctly under any filter context.
1 Measures versus columns You can decide whether a calculation belongs in a measure or a column based on how it must respond to filters. 11m 28xp 2 Aggregation functions You can choose between SUM, AVERAGE, COUNT, COUNTA and DISTINCTCOUNT for a given question. 10m 25xp 3 Filter context You can explain how slicers, rows, columns and page filters combine into the context a measure sees. 12m 30xp 4 Row context and iterators You can use an iterator such as SUMX to compute row by row and then aggregate. 12m 30xp 5 CALCULATE You can use CALCULATE to modify filter context and predict the result of a simple filter argument. 12m 30xp 6 Context transition You can explain why CALCULATE inside a row context converts that row into filters. 12m 30xp 7 ALL, ALLEXCEPT and REMOVEFILTERS You can remove specific filters to compute a percentage of total that behaves correctly at every level. 12m 30xp 8 FILTER and table expressions You can pass a FILTER table expression to CALCULATE when a simple predicate is not enough. 11m 28xp 9 Variables in DAX You can use VAR to make a measure readable and avoid recomputing the same expression. 10m 25xp 10 Conditional logic in measures You can branch a measure's result with IF and SWITCH without breaking the total row. 10m 25xp 11 Safe division and blanks You can handle division by zero and distinguish blank from zero in results. 9m 23xp 12 Organising and documenting measures You can group measures into a dedicated table with folders and descriptions so a model stays maintainable. 9m 23xp Arc 5
Time and Comparison Pro You can build time intelligence, ranking and what-if calculations that hold up at every level of a report.
1 Time intelligence prerequisites You can verify a model meets the requirements for time intelligence functions to work. 10m 25xp 2 Year, quarter and month to date You can compute cumulative to-date totals and shift them to a non-calendar fiscal year end. 11m 28xp 3 Prior period comparison You can compare a value against the same period last year and handle partial current periods. 11m 28xp 4 Rolling and moving windows You can compute a rolling twelve month total that smooths seasonality. 11m 28xp 5 Ranking measures You can rank items within a visual and control tie handling and the total row. 11m 28xp 6 TOPN and dynamic segmentation You can build a measure that reports on the top N items while an other bucket captures the remainder. 11m 28xp 7 What-if parameters You can add a numeric parameter that lets a user drive a scenario calculation from a slicer. 10m 25xp 8 Calculation groups You can apply one set of time calculations across many measures without duplicating each one. 11m 28xp 9 Measuring DAX performance You can read a query plan summary and identify whether time is spent in the storage engine or the formula engine. 11m 28xp Arc 6
Display Deck: Report Design Pro You can choose, configure and lay out visuals that answer a question at a glance.
1 Choosing the right visual You can match a chart type to the question being asked about comparison, trend, distribution or composition. 11m 28xp 2 Field wells and aggregation defaults You can place fields into the correct wells and override an unwanted default summarisation. 10m 25xp 3 Tables and matrices You can build a matrix with nested rows and columns and control subtotal display. 11m 28xp 4 Conditional formatting You can drive cell colour, data bars or icons from a measure rather than a static rule. 10m 25xp 5 Slicers and filter panes You can choose between a slicer and a filter pane entry and control which visuals each affects. 10m 25xp 6 Filter scope levels You can apply a filter at visual, page or report scope and predict how the levels combine. 10m 25xp 7 Drillthrough pages You can build a detail page that receives context from the visual the user right-clicked. 11m 28xp 8 Bookmarks and selection You can capture a report state and switch between views with a button. 11m 28xp 9 Report page tooltips You can build a custom tooltip page that displays extra detail on hover. 9m 23xp 10 Themes, layout and alignment You can apply a consistent theme and align visuals on a grid for a professional layout. 9m 23xp 11 Accessible report design You can make a report navigable by keyboard and readable without relying on colour alone. 10m 25xp 12 Mobile layout You can build a phone layout that shows the essential visuals in a vertical order. 9m 23xp Arc 7
Insight Lab: Analysis Features Pro You can use built-in analytical features to explain drivers, detect anomalies and forecast.
1 Reference and trend lines You can add average, constant and trend lines to give a chart an interpretive baseline. 9m 23xp 2 Grouping and binning You can bucket a continuous measure into bins or combine categories into a group without editing the source. 9m 23xp 3 Clustering in scatter charts You can apply automatic clustering to a scatter chart and interpret the resulting segments cautiously. 9m 23xp 4 Key influencers visual You can configure a key influencers visual and describe why its output is correlation and not causation. 10m 25xp 5 Decomposition tree You can break a metric down interactively by successive dimensions to find where a change originated. 10m 25xp 6 Anomaly detection You can enable anomaly detection on a time series and tune the sensitivity to reduce noise. 9m 23xp 7 Forecasting You can add a forecast with a confidence interval and state the assumptions it relies on. 9m 23xp 8 Q and A natural language You can prepare a model with synonyms so natural language questions return the intended fields. 9m 23xp 9 Smart narrative You can add a generated summary and edit it to include dynamic measure values. 8m 20xp Arc 8
Operations Wing: Publish, Secure, Maintain Pro You can publish, secure and operate content for an audience in the Power BI Service.
1 Workspaces and roles You can choose the right workspace role for a collaborator and explain what each role may do. 10m 25xp 2 Publishing apps You can package workspace content into an app and target it at a defined audience. 10m 25xp 3 Scheduled refresh and gateways You can configure refresh for a published model and explain when a gateway is required. 11m 28xp 4 Row-level security roles You can define a role with a DAX filter and test it from Desktop before publishing. 11m 28xp 5 Dynamic row-level security You can filter data by the logged-in user with USERPRINCIPALNAME and a permissions table. 11m 28xp 6 Shared semantic models You can build a report on an existing published model rather than duplicating the model. 10m 25xp 7 Deployment pipelines You can promote content through development, test and production with rules that swap data sources. 10m 25xp 8 Sensitivity labels and governance You can apply a sensitivity label and describe how it travels with exported data. 9m 23xp 9 Monitoring usage and performance You can review usage metrics and refresh history to decide what to optimise or retire. 10m 25xp