MS POWER BI ONLINE TRAINING

 

 

1 Welcome to the course!

 

2 Getting Started

 

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

 

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

 

Role of Data Analyst

 

 

3 Business Intelligence (BI) Concepts

 

Introduction & importance of Business Intelligence

 

Tools and Technologies in Business Intelligence area

 

Power BI Vs. Tableau

 

 

 

4 About Microsoft Power BI

 

Power BI Architecture

 

Power BI introduction and Its components

 

Power BI over Excel

 

 

5 Power BI Desktop - An Introduction

 

PBI Flow – Most Important

 

Download PBI Desktop & Interface tour

 

Understanding Key backstage options (file tab)

 

Understanding Case Study 1 and Role play

 

 

 

 

 

 

6 Connecting Power BI with Different Data sources

 

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

 

Get Data from OData Feed

 

Connect to local folder

 

 

7 Data Transformation through Power Query

 

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

Connect to multiple files in a folder

 

 

 

 

 

 

8 Data Modeling in Power BI

 

How to build relationship and relationship cardinality

 

Understanding filter flow & Cross Filter direction

 

Building entire model

 

Snowflake & Star schema

 

Add Related tables

 

 

9 Understanding Data Analysis Expressions (DAX)

 

Understanding DAX and its Types

 

Difference between calculated columns and measures

 

 

10 Basic DAX functions - (Calculated Columns)

 

Logical DAX

 

Another example of conditional column

 

Understanding SWITCH function

 

Understanding Year and Today function

 

Playing with Text functions (Left and Search)

 

 

11 Relational Functions

 

Bringing Data from any Related table using RELATED Function

 

Opposite of related function - RELATEDTABLE Function

 

12 Understanding Contexts in Power BI

 

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

 

 

 

 

13 Understanding Measures

 

Understanding Measures Practically

 

Creating Measure table

 

Counting Values using Count Function

 

 

14 Most Common DAX - CALCULATE & FILTER

 

Condition Based Calculation - Calculate Function

 

Building Calculated Table using Filter Function

 

Understanding Variable with Calculate, Filter and Sameperiodlastyear function

 

 

15 DAX for Iterators

 

Iterator Functions

 

Iterator Function - MAXX

 

 

16 Filtering Data using DAX

 

Crossfilter (Activate filter direction virtually)

 

Ignoring Filter Context by using ALL Function

 

Nesting of Filter and Calculate Function

 

 

17 Date & Time DAX

 

Month,Qtr.,Year to Date calculation

 

Previous Day,Month,Qtr.,Year calculation

 

Periodic Calculation

 

 

 

 

 

18 Report setup in Power BI Desktop

 

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

 

 

19 Building Report

 

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

 

 

20 Advanced Visualizations

 

Showing monthly trend with line chart

 

Setting up forecasted revenue in line chart

 

Presenting data in an Area chart with awesome tooltip feature

 

Building amazing KPI's

 

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

 

 

21 Advanced Report options

 

What if Parameter

 

Setting RLS (Row Level Security)

 

Tooltip Page

 

Different types of filters in report view

 

Change how visuals intereact in a report

 

 

22 Publish the Report to Cloud

 

Publish the report to Power BI service

 

 

23 Intro. to PBI Service

 

Understanding Power BI Service

 

Creating New PBI Service account

 

PBI Interface tour

 

24 Type of Content Containers

 

My workspace Vs. Workspaces Vs. Apps

 

25 Reports and Dashboard

 

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

 

 

26 Gateways and Scheduled Refresh

 

Understanding Gateways and its types

 

Enabling scheduled refresh through Personal gateway

 

 

27 Sharing & Collaboration

 

Assigning user roles and giving permissions

 

Sharing through publishing apps

 

Implementing RLS

 

 

28 Advanced Power BI Service

 

Real time data streaming connection

 

Real time data Dashboard

 

29 PBI Mobile Application

 

Downloading and understanding PBI Mobile App interface

 

30 DA-100 Certification Exam Prep

 

Set-1

 

Set-2