How to navigate through the course

3 ways to use Power BI (PBI Desktop, PIB Service, PBI Mobile app)

Roles in Data (Business Analyst, Data Analyst, Data Engineer, Data Scientist, Data Admin)

Role of Data Analyst

Introduction & importance of Business Intelligence

Tools and Technologies in Business Intelligence area

Power BI Vs. Tableau

Power BI Architecture

Power BI introduction and Its components

Power BI over Excel

Download PBI Desktop & Interface tour

Understanding Key backstage options (file tab)

Understanding Case Study 1 and Role play

Power BI Practice Files

Get Data from Flat Files (CSV, Text & Excel Files)

Get Data from OData Feed

Connect to local folder

Power Query & Power Query Editor Introduction

Difference between Transform and load

Merge, Add and remove columns

Sorting in Power Query

Merge and Append queries

Transform table tools: grouping, transpose, reverse rows, count rows, use as header

Transform Column tools: detecting & changing data type, Fill, Unpivot etc.

Text Column tools: Splitting, replace values, extracting, merging, formatting and parsing columns

Number Column tools: Statistical, standard, rounding and information

Building a complete Calendar Table

Conditional, Custom, Invoke Custom, Index and Duplicate Column

Flashfill in Power Query (Columns from example)

Understanding different view options

Is Power Query smart enough?

How to build relationship and relationship cardinality

Understanding filter flow & Cross Filter direction

Building entire model

Snowflake & Star schema

Add Related tables

Understanding DAX and its Types

Difference between calculated columns and measures

Logical DAX

Another example of conditional column

Understanding SWITCH function

Understanding Year and Today function

Playing with Text functions (Left and Search)

Bringing Data from any Related table using RELATED Function

Opposite of related function - RELATEDTABLE Function

Filter & Row Context - A must watch for any Power BI user

Understanding Measures Practically

Creating Measure table

Counting Values using Count Function

Condition Based Calculation - Calculate Function

Building Calculated Table using Filter Function

Understanding Variable with Calculate, Filter and Sameperiodlastyear function

Iterator Functions

Iterator Function - MAXX

Crossfilter (Activate filter direction virtually)

Ignoring Filter Context by using ALL Function

Month,Qtr.,Year to Date calculation

Previous Day,Month,Qtr.,Year calculation

Periodic Calculation

Understanding Report view and creating a new report

Page display settings in a Power BI report

Setting color theme aligned to project/company color theme & Theme Gallery

Adding non-visualization object

Inserting Basic charts and understanding format tab

Creating Comparison visuals (Doughnut Chart)

Creating Bar chart for Top 5 Customers

Plotting Values on a Map Visual

Understanding Matrix visual along with Conditional Formatting

Comparing Actual vs. Target using Gauge Chart

Using Slicers and understanding its impact on the report

Showing monthly trend with line chart

Setting up forecasted revenue in line chart

Presenting data in an Area chart with awesome tooltip feature

Drillthrough Report Page

Custom visual (third party visual)

Story telling through Bookmarks

Ask questions from PBI and get visuals (NLQ)

Sync Slicer

Key Influencer P 1

Key Influencer P 2

Decompostition Tree

Function based visual titles

What if Parameter

Setting RLS (Row Level Security)

Tooltip Page

Different types of filters in report view

Change how visuals intereact in a report

Understanding Power BI Service

Creating New PBI Service account

PBI Interface tour

My workspace Vs. Workspaces Vs. Apps

Understanding various options in Report interface Part - 1

Understanding various options in Report interface Part - 2

3 ways of creating a Dashboard

Understanding various options in Dashboard interface

Understanding Gateways and its types

Enabling scheduled refresh through Personal gateway

Incremental Refresh (Theory)

Incremental Refresh (Practical)

Assigning user roles and giving permissions

Sharing through publishing apps

Implementing RLS

Real time data streaming connection

Real time data Dashboard

Downloading and understanding PBI Mobile App interface

Set-1

Set-2

Thank you note