arrow_back
DEMO VIDEO
Quick Overview – Data to Insight
1. Quick Overview – Data to Insight, 2. Working with Main Data, 3. Data Preparations
Overview of Data and Business Intelligence
Power BI Ecosystem
Overview of Data for Class
Load Data Using Excel
Class 1 Introduction to Power BI
Working with Main Data
Introduction to Power Query (what, why, how – graphical/formulae)
Power Bi Data Model Best Practices -Developing Data Model
Creating Join Between Tables
Creating a Basic Table Visual
Creation of Columns Gross Sales, COGS, Discount Amount and Net Sales
Class 2 Working with Power BI
Class 2
Create Measure and Theme
Measures (Discount % Margin %)
Creation of Measures (Discount % Margin %)
Why (Sum(A)/Sum(B))
Difference Between Column and Measure
Create Color Theme
Data Preparations - Part 1
Pivot Data
Unpivot Data
Transpose Data
Remove Rows
Delete Duplicate
Merge Table
Class - Basic Of Data Preparation
Data Preparations - Part 2
Append Table
Custom Column
Custom Column Using IF
Filter Mean not Available
Data Type Change
Create Table from Existing Table
Data Preparations Part 2
Class 3 PQ
Calendar
Create a Calendar and Calendar Auto
Creation Month, Week and Quarter
Week Start, Weekend and Weekday
Creation of Year
Financial Year
Custom Calendar
Calendar Class
Formula
Class 6- Calendar
Visualisation - 1
Table
Matrix – Different Type of Matrix
Show on Row
Bar Chart
Pie Chart
Line Visual
Scatter Chart
Class Visual 1
Visualisation - 2
Different Type of MAP
CARD Visual
Stacked Visual
Stacked Line Visual
Clustered Line Visual
Different Type of Filters (Visual Level, Page Level etc) – How to use them
visual part2
Visualisation - 3
Unichar
Custom Visual
Grouping – Create Group
Conditional Table Formatting
Text Boxes and Shapes
Interactions
More On Visualization
Time Intelligence - 1
Working with Time Intelligence
DATE* Formula
Previous Formula
Change % Between Time Periods
Importance of Calendar End Date
Time Intelligence-1
class 10
Time Intelligence - 2
Creating Prior Without Time Intelligence (CY, FY – Current Prior)
Behind Measures – Day Behind & Year Behind
Last Day and Last Non-Continues Day
Week Vs Week
WTD
Time Intelligence - 3
Custom Period Time Intelligence
Working Day
NETWORKDAYS
Travelling Across Workday
8. Time Intelligence-3
Time Intelligence - 4
Running Total
Rolling Sum / Avg (Moving Average)
Calculate With and Without Filter
KEEPFILTERS
Rank on Measure
Advance DAX - 1
SUMX, MINX and COUNTX
Dax Variable – When Not to Use
Rank Across Tables
Top Rank Filter
Sub Total Formula – Allexcept
DAX Advance
class 10
Advance DAX - 2
Sum of Averages
Using Summarise to Fix Row Context Sum of Averages - Semi Additive Calculation
Filter in Summarise
DISTINCTCOUNT – Relative Distinct Count
Common use DAX
How to make Left Join work Using + 0 , Show items with No Data
Advance DAX
class11
Advance DAX – 3
CalculateTable
CONTAINSSTRING , CONTAINSSTRINGEXACT
SEARCH, FIND
MID, LEFT and RIGHT
RELATEDTABLE & RELATED
Lookupvalue
class 12
Advance DAX – 4
firstnonblankvalue
lastnonblankvalue
CrossJoin
Switch
Isfiltered
HasOneValue
Power BI DAX and Service
class 13
Power BI Service - 1
Dataflow
Dataset - Shared Dataset
Report using Dataset in Desktop - Separate Reports from Models
Create Report in Service
Share Report
Class 16
Power BI Service - 2
Dashboard
Dataset Settings
Workspace Setting
Security Roles - Admin, Member, Contributor, Viewer
Power Bi Service
class 15
DQ1
Use Cases – 1
Measure Slicer – Field Parameter
Axis Slicer - Buttons and Action Actions
Axis Slicer – Field Parameter
TOPN and Conditional Formatting Axis Slicer
Use Cases – 2
Parameter Page - Page Navigation - Page and Bookmark Navigator
Drill Through
Tooltip Page
HR Case Study - Crossfilter, userelationship
Use Cases – 3
Divide on page into two - Interactions
Why we need independent Slicer - Exclude Selected Value
Two Slicer Same Column - Like for Like Comparison
Independent Date Table and Two Period Filter
Class 15
class 15 Use case 3
Use Cases – 4
Single Select with All
Customer Retention with Bucketing
Customer How Purchased Category 1 not Category 2
Cohort Analysis
Class 17
Direct Query
Connect to Database as Direct Query
Complete Development Using Direct Query
Calendar in DB
Calendar in Power BI
Limitations of Direct Query & When to use and when not to use Direct Query
Data Gateways