Microsoft's skills measured for PL-300 as of April 20, 2026, mapped to the chapters of Ultra Transcenders PL-300: Microsoft Power BI Data Analyst.
| Objective | Chapters |
|---|---|
| Prepare the data (25–30%) | |
| Get or connect to data | 2. Connecting to data: sources, storage modes, settings and parameters |
| Profile and clean the data | 3. Profiling and cleaning data in Power Query |
| Transform and load the data | 3. Profiling and cleaning data in Power Query; 4. Transforming and loading data with Power Query; 5. Designing the data model |
| Model the data (25–30%) | |
| Design and implement a data model | 5. Designing the data model |
| Create model calculations by using DAX | 5. Designing the data model; 6. DAX measures and CALCULATE; 7. Time intelligence, semi-additive measures, calculation groups and visual calculations |
| Optimize model performance | 8. Optimising model performance |
| Visualize and analyze the data (25–30%) | |
| Create reports | 7. Time intelligence, semi-additive measures, calculation groups and visual calculations; 9. Creating reports: visuals, formatting, themes and filters; 10. Copilot, AI visuals and analysis features |
| Enhance reports for usability and storytelling | 11. Interactive, accessible and mobile-friendly reports |
| Identify patterns and trends | 10. Copilot, AI visuals and analysis features |
| Manage and secure Power BI (15–20%) | |
| Create and manage workspaces and assets | 1. Power BI for data analysts: the platform, licences and the end-to-end workflow; 12. Workspaces, publishing, apps and distribution; 13. Gateways and semantic model refresh |
| Secure and govern Power BI items | 14. Securing and governing Power BI content |
The full list of tasks under each objective is in the official PL-300 study guide and practice assessment. The book is organised by technology, so one chapter often serves several objectives.