Power BI introduction
Why Power BI Is Special
Services in Power BI
Different connectors with Power BI
Download the Power BI and sample report
Different panes in Power BI
Updating the new features in Power BI
Datasets
Reports
Relationships
What is Business Intelligence
What are KPI S
What is Data Warehousing & Business Intelligence
Tools and Technologies in Business Intelligence
BI project : CRISP – DM
Power Bi Architecture
Data Modelling
Power BI Desktop
Power BI Service
Components of Power BI
Power BI roles
Connection Type

Column Chart
Stacked Column Chart
Pie Chart
Donut Chart
Funnel Chart
Ribbon Chart
Keep only and Exclude
View Data and Export
3 types of Connections
Connection of SQL Server
Connecting the secure PDF
Connecting to website from power BI (OData.org)
Creating the Custom table from Website
Table by Example
Connecting azure data lake

Map
Filled Map
Map with Pie Chart
Formatting in Map
Backgrourd Canges in Map
Map of India in power Bi
Map of Australia

Creating a Simple Table
Formatting in Table
Conditional Formatting in Table
Changing Aggregation in Table
Creating a Matrix in Power BI
Conditional Formatting in Matrix
Automatic Hierarchy in Matrix
Subtotal and Grand Total
Number Formatting in Table and Matrix

Line Chart
Drill down in Line Chart
Area Chart
Line Vs Column Chart
Scatter Plot
Waterfall Chart
Tree Map
Guage Chart

Number Card
Text Card
Date Card
Multi-Row Card
Filter on visual
Filter on Page
Filter on All Pages
Drill through

Slicer for Text
Format Text Slicer
Date Slicer
Date Slicer
Format Date Slicer
Number Slicer

Animated Bar Chart Race
Drill Down Donut chart
Drill down column chart
Word Cloud
Sankey Chart
Infographic
Play Axis
Scoller

Insert Image
Insert Text
Insert Shapes
Insert Buttons
Web URL
Page Navigation
Back
Bookmark

Creating a superstore Report
Create an account on power BI service
Publish report to power bi service account
Export (ppt, pdf, pbix) report and share
Comment, share and subscribe to a report
Create a dashboard in power bi service
Problem in power BI dashboard and its solution
Data Gateway
Create report directly in power BI service

Merge
Split and Trim
Upper, Lower and Proper
Add Suffix and Prefix
Left, Right and Mid
Extract Text with Delimiter

Year, Quarter, Month , Day
Difference between Dates, Earliest and Latest
Name of Day and Name of Month
Day of Week/Month/Year & Week of Month/year
Extract date from date and time
Calculate age in 2 button clicks
Which day of year, quarter, month your date of birth is

Add, subtract, divide, multiply
Percentage, Percent of, Modulo
Rounding the numbers
IsEven, IsOdd and Sign

Append multiple csv files from a folder
Append multiple excel tables/sheets from single file
Append excel tables with different number of columns
Append multiple excel files from a folder
Append different data source files in power query

Marge Tables/sheets in power BI
Merge Data From multiple excel files/workbooks
Merge data from different sources
Merge data having multiple matching columns or multiple criteria

Fill down and Fill up
Grouping
Transpose
Unpivot
Data types in power query
Replace errors and Values
Keep Rows and Remove Rows
Add, Remove, Goto columns

Introduction to M Language
M Functions – Date (ISIN)
M Functions – Date ( Add and Substract)
M Functions – Date ( Day, Month, Week, Year)
M Functions – Text (Basic)
Writing a small M code in Power BI
Trick to get all 900 M Function Help

Data Modelling – Power Query
Data Modelling Introduction
Benefits of Data Modelling
Introduction to DAX
Calculated Column
Calculated Measures
Quick Measures
Advanced Editors – Date Table
Calculated Table
Star Schema
Snow Flake Schema
Many to Many Relation

Pivot Column
Data type conversion
Row Transformations
Column Transformations
Group by
3 type of filters (date, Text, number)
Filter Rows
Built in Transformations (text, number, date, Conditional)
Text between Delimiters

What is ADF
Building blocks of ADF
Linked Services
Datasets
IR
Power BI to ADF

DAX EXPRESSIONS – Level 1
Purpose of Data Analysis Expresssions (DAX)
Scope of Usage with DAX. Usabilty Options
DAX Context : Row Context and Filter Context
DAX Entities : Calculated Columns and Measures
DAX Data Types : Numeric, Boolean, Variant, Currency
Datetime Data Tye with DAX. Comparison with Excel
DAX Operators & Symbols. Usage. Operator Priority
Parenthesis, Comparison, Arthmetic, Text, Logic
DAX Functions and Types: Table Valued Functions
Filter, Aggregation and Time Intelligence Functions
Information Functions, Logical, Parent-Child Functions
Statistical and Text Functions. Formulas and Queries
Syntax Requirements with DAX. Differences with Excel
Naming Conventions and DAX Format Representation
Working with Special Characters in Table Names
Attribute / Column Scope with DAX – Examples
Measure / Column Scope with DAX – Examples

DAX EXPRESSIONS – Level 2
YTD, QTD, MTD Calculations with DAX
DAX Calculations and Measures
Using TOPN, RANKX, RANK.EQ
Computations using STDEV & VAR
SAMPLE Function, COUNTALL, ISERROR
ISTEXT, DATEFORMAT, TIMEFORMAT
Time Intelligence Functions with DAX
Data Analysis Expressions and Functions
DATESYTD, DATESQTD, DATESMTD
ENDOFYEAR, ENDOFQUARTER,ENDOFMONTH
FIRSTDATE, LASTDATE, DATESBETWEEN
CLOSINGBALANCEYEAR,CLOSINGBALANCEQTR
SAMEPERIOD and PREVIOUSMONTH,QUARTER
KPIs with DAX. Vertipaq Queries in DAX
IF..ELSEIF.. Conditions with DAX
Slicing and Dicing Options with Columns, Measures
DAX for Query Extraction, Data Mashup Operations
Calcualted COlumns and Calculated Measures with DAX

⦁ Adventure works
⦁ Sales