Introduction

Course Intro, Downloadable Materials, and Course Certificate

3 Topics

Downloadable Materials

Course Certificate

Prepare the Data (20-25%)

Get Data from Different Data Sources

11 Topics

Identify and Connect to a Data Source

Change Data Source Settings

Select a Shared Dataset or Create a Local Dataset

Select a Storage Mode

Choose an Appropriate Query Type

Identify Query Performance Issues

Use Microsoft Dataverse (Formerly Common Data Service)

Use or Create a PBIDS File

Use or Create a Data Flow

Connect to a Dataset Using the XMLA Endpoint

Profile the Data

4 Topics

Identify Data Anomalies

Examine Data Structures

Interrogate Column Properties

Interrogate Data Statistics

Clean, Transform, and Load the Data

10 Topics

Resolve Inconsistencies, Unexpected or Null Values, and Data Quality Issues

Apply User-Friendly Value Replacements

Identify and Create Appropriate Keys for Joins

Evaluate and Transform Column Data Types

Apply Data Shape Transformations to Table Structures

Combine Queries

Apply User-Friendly Naming Conventions to Columns and Queries

Leverage Advanced Editor to Modify Power Query M Code

Configure Data Loading

Resolve Data Import Errors

1 Quiz

Section Quiz – Prepare the Data

Model the Data (25-30%)

Design a Data Model

10 Topics

Define the Tables

Configure Table and Column Properties

Define Quick Measures

Flatten Out a Parent-Child Hierarchy

Define Role-Playing Dimensions

Define a Relationship’s Cardinality and Cross-Filter Direction

Design the Data Model to Meet Performance Requirements

Resolve Many-to-Many Relationships

Create a Common Date Table

Define the Appropriate Level of Data Granularity

Develop a Data Model

6 Topics

Apply Cross-Filter Direction and Security Filtering

Create Calculated Tables

Create Hierarchies

Create Calculated Columns

Implement Row-Level Security Roles

Set up the Q&A Feature

Create Measures by Using DAX

6 Topics

Use DAX to Build Complex Measures

Use CALCULATE to Manipulate Filters

Implement Time Intelligence Using DAX

Replace Numeric Columns with Measures

Use Basic Statistical Functions to Enhance Data

Create Semi-Additive Measures

Optimize Model Performance

5 Topics

Remove Unnecessary Rows and Columns

Identify Poorly Performing Measures, Relationships, and Visuals

Improve Cardinality Levels by Changing Data Types

Improve Cardinality Levels Through Summarization

Create and Manage Aggregations

1 Quiz

Section Quiz – Model the Data

Visualize the Data (20-25%)

9 Topics

Add Visualization Items to Reports

Choose an Appropriate Visualization Type

Format and Configure Visualizations

Import a Custom Visual

Configure Conditional Formatting

Apply Slicing and Filtering

Add an R or Python Visual

Configure the Report Page

Design and Configure for Accessibility

Create Dashboards

6 Topics

Set Mobile View

Manage Tiles on a Dashboard

Configure Data Alerts

Use the Q&A Feature

Add a Dashboard Theme

Pin a Live Report Page to a Dashboard

Enrich Reports for Usability

10 Topics

Configure Bookmarks

Create Custom Tooltips

Edit and Configure Interactions Between Visuals

Configure Navigation for a Report

Configure Sync Slicers

Use the Selection Pane

Use Drill-Through and Cross Filter

Drill Down into Data by Using Interactive Visuals

Export Report Data

1 Quiz

Section Quiz – Visualize the Data

Analyze the Data (10-15%)

Enhance Reports to Expose Insights

9 Topics

Apply Conditional Formatting

Apply Slicers and Filters

Perform Top N Analysis

Explore Statistical Summary

Use the Q&A Visual

Add a Quick Insights Result to a Report

Create Reference Lines with the Analytics Pane

Use the Play Axis Feature of a Visualization

Personalize Visuals

Perform Advanced Analysis

6 Topics

Identify Outliers

Conduct Time Series Analysis

Use Groupings and Binnings

Use the Key Influencers to Explore Dimensional Variances

Use the Decomposition Tree Visual to Break Down a Measure

Apply AI Insights

1 Quiz

Section Quiz – Analyze the Data

Deploy and Maintain Deliverables (10-15%)

Manage Datasets

7 Topics

Configure a Dataset Scheduled Refresh

Configure Row-Level Security Group Membership

Providing Access to Datasets

Configure Incremental Refresh Settings

Promote or Certify Power BI Datasets

Identify Downstream Dataset Dependencies

Configure Large Dataset Format

Create and Manage Workspaces

8 Topics

Create and Configure a Workspace

Recommend a Development Lifecycle Strategy

Assign Workspace Roles

Configure and Update a Workspace App

Publish, Import, and Update Assets in a Workspace

Use Deployment Pipelines

Configure Subscriptions

Promote or Certify Power BI Content

1 Quiz

Section Quiz – Deploy and Maintain Deliverables

Final Test, Feedback, and Next Steps

Final Test, Course Feedback, Conclusion

3 Topics | 1 Quiz

Final Test – DA-100

DA-100 Course Feedback

Congratulations and Next Steps

Downloadable Materials

DA-100 Exam Prep – Power BI Certification Course Intro, Downloadable Materials, and Course Certificate Downloadable Materials