The Ultimate Power BI Exam PL-300 Preparation Course

Course Curriculum

Chapter 1: 1. Get Data from Data Sources

Lecture 1: Welcome to the Course

Lecture 2: Download the Course Files

Lecture 3: Installing SQL Server

Lecture 4: Installing the Sample Databases

Lecture 5: Resolving Data Source Issues

Lecture 6: 1. Identify And Connect to a Data Source

Lecture 7: 2. Change Data Source Settings

Lecture 8: 3. Select a Shared Dataset or Create a Local Dataset

Lecture 9: 4. Choose between DirectQuery, Import, and Dual mode

Lecture 10: 5. Change the Value in a Parameter

Chapter 2: 2. Clean the Data

Lecture 1: 1. Evaluate data, including data statistics and column properties

Lecture 2: 2. Resolve inconsistencies, unexpected or null values, and data quality issues

Lecture 3: 3. Resolve data import errors

Chapter 3: 3. Clean, Transform, and Load the Data

Lecture 1: 1. Select appropriate column data types

Lecture 2: 2. Create and transform columns

Lecture 3: 3. Transform a query

Lecture 4: 4. Design a star schema that contains facts and dimensions

Lecture 5: 5. Identify when to use reference or duplicate queries and the resulting impact

Lecture 6: 6. Merge and append queries

Lecture 7: 7. Identify and create appropriate keys for relationships

Lecture 8: 8. Configure data loading for queries

Chapter 4: 4. Design and Implement a Data Model

Lecture 1: 1. Configure Table and Column Properties

Lecture 2: 2. Implement Role-Playing Dimensions

Lecture 3: 3. Define a Relationship's Cardinality and Cross-Filter Direction

Lecture 4: 4. Create a Common Date Table

Lecture 5: 05. Implement Row-Level Security roles

Chapter 5: 5. Create Model Calculations by Using DAX

Lecture 1: 1. Create Single Aggregation Measures

Lecture 2: 2. Use CALCULATE to Manipulate Filters

Lecture 3: 3. Implement Time Intelligence Measures

Lecture 4: 4. Identify implicit measures and replace with explicit measures

Lecture 5: 5. Use Basic Statistical Functions to Enhance Data

Lecture 6: 6. Create Semi-Additive Measures

Lecture 7: 7. Create a Measure by Using Quick Measures

Lecture 8: 8. Create calculated tables

Chapter 6: 6. Optimize Model Performance

Lecture 1: 1. Improve Performance by Identifying and Removing Unnecessary Rows and Columns

Lecture 2: 2. Identify Poorly Performing Measures, Relationships, and Visuals

Lecture 3: 3. Improve Performance by Choosing Optimal Data Types

Lecture 4: 4. Improve Performance by Summarizing Data

Chapter 7: 7. Create Reports

Lecture 1: 1. Identify and Implement Appropriate Visualizations

Lecture 2: 2. Format and Configure Visualizations

Lecture 3: 3. Use a Custom Visual

Lecture 4: 4. Apply and Customize a Theme

Lecture 5: 5. Configure Conditional Formatting

Lecture 6: 6. Apply Slicing And Filtering

Lecture 7: 7. Configure The Report Page

Lecture 8: 8. Use the Analyze in Excel Feature

Lecture 9: 9. Choose When to Use a Paginated Report

Chapter 8: 8. Enhance Reports for Usability and Storytelling

Lecture 1: 1. Configure Bookmarks

Lecture 2: 2. Create Custom Tooltips

Lecture 3: 3. Edit And Configure Interactions Between Visuals

Lecture 4: 4. Configure Navigation For A Report

Lecture 5: 5. Apply Sorting

Lecture 6: 6. Configure Sync Slicers

Lecture 7: 7. Group and layer visuals by using the Selection pane

Lecture 8: 8. Drilldown Into Data Using Interactive Visuals

Lecture 9: 9. Configure export of report content, and perform an export

Lecture 10: 10. Design Reports For Mobile Devices

Lecture 11: 11. Incorporate the Q&A feature in a report

Chapter 9: 9. Identify Patterns and Trends

Lecture 1: 1. Use the Analyze feature in Power BI

Lecture 2: 2. Use Grouping, Binning and Clustering

Lecture 3: 3. Use AI visuals

Lecture 4: 4. Use Reference Lines, Error Bars, and Forecasting

Lecture 5: 5. Detect Outliers and Anomalies

Lecture 6: 6. Create and Share Scorecards and Metrics

Chapter 10: 10. Create and Manage Workspaces and Assets

Lecture 1: 1. Create And Configure A Workspace

Lecture 2: 2. Assign Workspace Roles

Lecture 3: 3. Configure And Update A Workspace App

Lecture 4: 4. Publish, Import, Or Update Assets In A Workspace

Lecture 5: 5. Create dashboards

Lecture 6: 6. Choose a distribution method

Lecture 7: 7. Apply Sensitivity Labels To Workspace Content

Lecture 8: 8. Configure Subscriptions

Lecture 9: 9. Promote or Certify Power BI Content

Lecture 10: 10.Manage global options for files

Chapter 11: 11. Manage Datasets

Lecture 1: 1. Identify when a gateway is required

Lecture 2: 2. Configure A Dataset Scheduled Refresh

Lecture 3: 3. Configure Row-Level Security Group Membership

Lecture 4: 4. Providing Access To Datasets

Chapter 12: Case Studies