PL-300 Design and manage analytics solutions using Power BI Training

Certification: Microsoft Certified: Power BI Data Analyst Associate

Dynamics Edge courses and labs are enhanced Instructor-Led Training (ILT) materials designed specifically for live, guided instruction and follow a structured curriculum.

Our materials are intentionally different from Microsoft Learn paths in both structure and flow to better prepare for actual work, answer questions, real-time engagement, and deeper learning.  Microsoft Learn paths are self-paced study resources.

You Will Learn:

• Ingest, clean, and transform data
• Model data for performance and scalability
• Design and create reports for data analysis
• Apply and perform advanced report analytics
• Manage and share report assets
• Create paginated reports in Power BI

 Course outline

Module 1: Get Started with Microsoft Data Analytics

1. Understand the role and responsibilities of a data analyst

2. Explore the data analysis process and lifecycle

3. Identify business needs and translate them into data insights

4. Discover how Power BI supports data storytelling through reports and dashboards

5. Recognize the value of business intelligence in enterprise decision-making

Module 2: Prepare Data for Analysis with Power BI

1. Connect to a variety of data sources in Power BI

2. Choose appropriate storage modes and data connectivity types

3. Use Power Query to clean and transform raw data

4. Perform data profiling to identify and resolve quality issues

5. Load data into Power BI for analysis and modeling

Module 3: Model Data with Power BI

1. Design a logical and efficient semantic data model

2. Write DAX formulas to create dynamic measures and calculations

3. Add calculated columns and tables to enhance your model

4. Implement relationships and hierarchies in the data model

5. Use time intelligence functions for date-based insights

Module 4: Build Power BI Visuals and Reports

1. Design intuitive, interactive reports using Power BI Desktop

2. Apply report filters and slicers to enhance user exploration

3. Customize report layouts for optimal user experience

4. Use visual analytics features like tooltips, drill-throughs, and bookmarks

5. Perform data analysis directly within visuals using built-in tools

Module 5: Manage Workspaces and Datasets in Power BI

1. Create and manage workspaces in the Power BI service

2. Publish and share reports and dashboards with stakeholders

3. Schedule and manage dataset refreshes for real-time data

4. Create and customize dashboards from multiple reports

5. Implement row-level security to restrict data access by user role