Microsoft Certified: Data Analyst Associate with Power BI

Course Curriculum

Chapter 1: Introduction

Lecture 1: Welcome! Course Overview

Lecture 2: A Note About the Course Structure

Lecture 3: Installing Power BI Desktop

Lecture 4: Setting Up Power BI Service

Lecture 5: Signing Up for Microsoft Trial Account

Lecture 6: Get the Materials

Lecture 7: Excel vs. Power BI

Lecture 8: Setting Expectations

Lecture 9: What is the Value of a Power BI Certification?

Lecture 10: How to Get an Analytics Job Podcast

Lecture 11: EXTRA: Learning Path

Chapter 2: Power BI Basics

Lecture 1: Section Introduction

Lecture 2: Business Challenge Blueprint

Lecture 3: Prepare the Data

Lecture 4: Model the Data

Lecture 5: Visualize the Data

Lecture 6: Analyze the Data

Lecture 7: Deploy and Maintain Deliverables

Chapter 3: Preparing Data with Power BI

Lecture 1: Section Introduction

Lecture 2: Get Data from Different Sources

Lecture 3: Choosing the Correct Type of Query

Lecture 4: Data Source Settings

Lecture 5: Select a Shared Dataset or Create a Local Data Set

Lecture 6: Select a Storage Mode

Lecture 7: Identify Query Perfomance Issues

Lecture 8: Use Parameters

Lecture 9: Profile The Data

Lecture 10: Identify Data Anomalies

Lecture 11: Examine Data Structures

Lecture 12: Interrogate Column Properties and Statistics

Lecture 13: Clean, Transform and Load the Data

Lecture 14: Resolve Inconsistencies, Unexpected or Null Values, and Data Quality Issues

Lecture 15: Apply User Friendly Value Replacements

Lecture 16: Identify and Create Appropriate Keys for Joins

Lecture 17: Evaluate and Transform Column Data Types

Lecture 18: Apply Data Shape Transformations to Table Structures

Lecture 19: Combine Queries Through Merge

Lecture 20: Combine Queries Through Append

Lecture 21: Apply User-Friendly Naming Conventions to Columns and Queries

Lecture 22: Leverage Advanced Editor to Modify Power Query M Code

Lecture 23: Configure Data Loading

Lecture 24: Resolve Data Import Errors

Lecture 25: Additional Prepare the Data Lectures

Lecture 26: Query Editor

Lecture 27: Changing Locale

Lecture 28: Basic Transformations

Lecture 29: Text Transformations

Lecture 30: Date Transformations

Lecture 31: Creating a Calculated Column

Lecture 32: Creating Conditional Columns

Lecture 33: Understanding Pivoting and Unpivoting

Lecture 34: Connecting to a Folder

Lecture 35: Query Dependency View

Lecture 36: Case Study Introduction

Lecture 37: Case Study Part 1.1

Lecture 38: Case Study Part 1.2

Chapter 4: Modeling the Data with Power BI

Lecture 1: Section Introduction

Lecture 2: What is a data model?

Lecture 3: Design a Data Model

Lecture 4: Define the Tables

Lecture 5: Configure Table and Column Properties

Lecture 6: Define Quick Measures

Lecture 7: Flatten Out a Parent Child Hierarchy

Lecture 8: Design the Data Model to Meet Performance Requirements

Lecture 9: Resolve Many to Many Relationships

Lecture 10: Create a Common Date Table

Lecture 11: Define the Appropriate Level of Data Granularity

Lecture 12: Create Calculated Tables

Lecture 13: Create Hierarchies

Lecture 14: Implement Row-Level Security Roles

Lecture 15: Set Up the Q&A Feature

Lecture 16: Create Measures by Using DAX

Lecture 17: Use DAX to Build Complex Measures

Lecture 18: Use CALCULATE to Manipulate Filters

Lecture 19: Implement Time Intelligence Using DAX

Lecture 20: Replace Numeric Columns with Measures

Lecture 21: Remove Unnecessary Rows and Columns

Lecture 22: Additional Model the Data Lectures

Lecture 23: Understanding Cardinality

Lecture 24: Types of Tables

Lecture 25: Filter Direction

Lecture 26: Two Way Filtering Direction

Lecture 27: Manage Query Group

Lecture 28: Case Study Part 2

Chapter 5: Visualize the Data with Power BI

Lecture 1: Section Introduction

Lecture 2: Create Reports

Lecture 3: Add Visualization Items to Reports

Lecture 4: Choose an Appropriate Visualization Type

Lecture 5: Format and Configure Visualizations

Lecture 6: Import a Custom Visual

Lecture 7: Apply Filtering

Lecture 8: Configure the Report Page

Lecture 9: Set Mobile View

Lecture 10: Use the Q&A Feature

Lecture 11: Create Custom Tooltips