Become A Microsoft Power BI Data Analyst

Course Curriculum

Chapter 1: Get Started with Microsoft Data Analytics

Lecture 1: Introduction

Lecture 2: What is Microsoft Data Analytics

Lecture 3: Overview of Data Analysis

Lecture 4: Roles in Data Analysis

Lecture 5: Tasks of a Data Analyst

Lecture 6: Overview of how to Become A Microsoft Power BI Data Analyst

Chapter 2: Power BI Setup and Microsoft 365 Setup

Lecture 1: What is Power BI

Lecture 2: What is Power BI Desktop

Lecture 3: Install Power BI Desktop

Lecture 4: Exploring Power BI Desktop Interface

Lecture 5: Microsoft 365 Setup

Lecture 6: Getting started with Microsoft 365

Lecture 7: Creating a new user account in Microsoft 365

Chapter 3: Overview of Power BI

Lecture 1: Power BI Overview: Part 1

Lecture 2: Power BI Overview: Part 2

Lecture 3: Power BI Overview: Part 3

Lecture 4: Changing regional settings

Lecture 5: Parts of Power BI

Lecture 6: Power BI Building blocks

Lecture 7: Exploring Power BI Service

Chapter 4: Connect, Transform, Visualize and Publish Web Data

Lecture 1: Connect to Web Data

Lecture 2: Clean & transform data: Part 1

Lecture 3: Clean & transform data: Part 2

Lecture 4: Combine data sources

Lecture 5: Creating Data Visuals: Part 1

Lecture 6: Creating Data Visuals: Part 2

Lecture 7: Publish report to Power BI Service

Chapter 5: Microsoft SQL Server Setup

Lecture 1: What is SQL Server

Lecture 2: SQL Server Editions

Lecture 3: SQL Server Installation Requirements

Lecture 4: Download SQL Server

Lecture 5: SQL Server Installation

Lecture 6: SQL Server Configuration Manager

Lecture 7: Installing SQL Server Management Studio

Lecture 8: Connect to SQL Server with SSMS

Lecture 9: Restore AdventureWorksDW2020 Database

Chapter 6: Connect to data sources from Power BI

Lecture 1: Create a new Power BI Desktop file

Lecture 2: Set Power BI Desktop Options

Lecture 3: Get data from a relational database (SQL Server)

Lecture 4: Get data from files ( CSV)

Lecture 5: Get additional data from files ( CSV)

Chapter 7: Clean, transform and load data into Power BI

Lecture 1: Configure the Salesperson Region query

Lecture 2: Configure the SalespersonRegion query

Lecture 3: Configure the Product query

Lecture 4: Configure the Reseller query

Lecture 5: Configure the Region query

Lecture 6: Configure the Sales query

Lecture 7: Configure the Targets query

Lecture 8: Configure the ColorFormats query

Lecture 9: Update the Product query

Lecture 10: Update the ColorFormats query

Chapter 8: Model Data in Power BI Desktop

Lecture 1: Create Model Relationships

Lecture 2: Configure the Product table

Lecture 3: Configure the Region table

Lecture 4: Configure the Reseller table

Lecture 5: Configure the Sales table

Lecture 6: Bulk update properties

Lecture 7: Review the model interface

Lecture 8: Create quick measures

Lecture 9: Create a many-to-many relationship

Lecture 10: Relate the Targets Table

Lecture 11: Enforce row-level security

Chapter 9: Working with DAX in Power BI Desktop

Lecture 1: What is DAX

Lecture 2: Create the Salesperson Calculated table

Lecture 3: Create the Date calculated table

Lecture 4: Create calculated columns

Lecture 5: Complete the Date table

Lecture 6: Mark the Date table

Chapter 10: Time Intelligence and Measures

Lecture 1: Create simple Measures

Lecture 2: Create additional measures

Lecture 3: Create a matrix visual

Lecture 4: Manipulate filter context

Lecture 5: Create a YTD measure

Lecture 6: Create a YoY growth measure

Lecture 7: Publish Power BI Desktop File

Chapter 11: Design and Publish Reports in Power BI

Lecture 1: Create a new file

Lecture 2: Create a live connection

Lecture 3: Design page 1

Lecture 4: Design page 2

Lecture 5: Design page 3

Lecture 6: Publish report

Lecture 7: Explore the report

Lecture 8: Configure Sync Slicers

Lecture 9: Configure drill through page

Lecture 10: Add Conditional Formatting

Lecture 11: Add Bookmarks to Report

Lecture 12: Add Buttons to Report

Lecture 13: Publish Updated Report

Lecture 14: Explore Updated Report