PL-300 case studies
PL-300 · Put your knowledge to work in context.
The Microsoft Certified: Power BI Data Analyst Associate credential (exam PL-300) validates that you can model, visualize, and analyze data with Microsoft Power BI in line with business and technical requirements. It is an intermediate-level, data-analytics certification aimed at data analysts who deliver actionable insights, build easy-to-comprehend visualizations, and enable others to do self-service analytics. Candidates are expected to work with business stakeholders to gather requirements and to collaborate with analytics engineers and data engineers to identify and acquire data. The exam is assessed across four areas: prepare the data, model the data, visualize and analyze the data, and manage and secure Power BI. The PL-300 case studies are 5 cases and about 3,768 words.
1The incremental refresh that never increments
Contoso's on-premises SQL Server holds a Sales table with 45 million rows covering five years. The gateway is healthy and a full load takes about twelve minutes.
774 words, about 4 min2One date table, three dates
Fabrikam's Sales fact stores OrderDate, ShipDate and DueDate as date keys. The model has a single Date table, marked as the date table, related to Sales[OrderDate].
840 words, about 4 min3Prices that multiplied the sales
Northwind's Product query loads from SQL Server and then merges with an Excel price list on SKU to bring in ListPrice. The price list holds one row per SKU per price change - about 2,400 rows for 900 SKUs - joined as a left outer join with all columns expanded, and nothing is removed afterwards.
678 words, about 3 min4The pivot table that disagrees
A sales director connects to the published Sales FY24 dataset using Analyze in Excel. Her pivot table has Product Category on rows with a distinct-count Customers measure and Sales Amount.
694 words, about 3 min5The role that restricted nobody
A published app serves 300 regional managers from one dataset with a dynamic RLS role. A RegionManagers table maps UserPrincipalName to Region, and the role filters DimRegion using that mapping.
782 words, about 4 min