Familiarize the environment

Text transformations 1

Text transformations 2

Text transformations 3

Date transformations Part 1

Date transformations Part 2

Number transformations

Grouping, transposing, and unpivoting data

Adding columns in the power query

Merge queries

Data Profiling 1

Data Profiling 2

An overview of power apps, power automate, dataverse, etc.

Creating basic charts – Part 1

Creating basic charts – Part 2

Formatting visuals part 1

Formatting visuals part 2

Formatting visuals part 3

Formatting report page

Applying themes to reports

Data refresh using the power query editor

Understanding the fact and dimension tables

Loading tables to Power BI Desktop

Simplifying the data model using append queries

Creating the date dimension

Drill up and drill down

Creating a hierarchy in the Location data table

Dax Intro

Sum, Sumx, and Related Functions

Adding Currency symbol and Display units of card visual, Funnel Chart

Creating a measure table

Time intelligence functions – an overview

Sameperiodlastyear

Dateadd

Conditional formatting – Table

Applying conditional formatting to other visuals (column chart)

Grouping data using the “New Group” option

The slicer visual

Using “Edit Interaction” to control the visuals

Creating tooltips

Creating drill-through reports

Calculating cumulative sales

Using Quick measure to calculate cumulative sales

Ranking using Rankx function

Filter Pane – Types of filters

Levels of filters

Parameter

Creating a Power BI service account and signing in to the Power BI desktop

Connecting to Appsource and getting extra visuals

Creating Bookmarks and using buttons to access bookmarks

Hiding visuals using the selection pane

Other buttons

Calculated Columns

Calculated columns using logical operators

Calculated Tables 1

Calculated Tables 2

Variables

import mode and direct query mode comparison

Connecting to oracle database using import mode

Connecting to oracle database direct query mode

Automatic page refreshes in direct query mode

QnA visual

Key influencers

Decomposition tree and narrative

Performance Analyzers

Python Visuals 1

Python Visuals 2

Adding dynamic reference lines – Analytics pane

Forecasting

RLS & OLS – Overview

Implementing RLS

Introduction to Power BI Service

Publishing reports

Creating dashboard

Sharing – Share and Subscribe options assigning roles

Data refresh using Data Gateways

Paginated reports – An overview