Power BI
We offer Microsoft Power BI training program which is user-friendly software tool for business intelligence, Data mining, modelling, analysis, and visualization services integrating with Microsoft excel and other products where users can connect data sets from multiple sources and perform advanced data analysis using this powerful tool for building charts.
Power BI Course content
Microsoft Power BI Course Content
Power BI Complete Introduction
1.Power BI Introduction
1.1Data Visualization, Reporting
1.2 Business Intelligence (BI), Traditional BI, Self-Serviced BI
1.3 Cloud Based BI, On Premise BI
1.4 Power BI Products
1.5 Power BI Desktop (Power Query, Power Pivot, Power View)
1.6 Flow of Work in Power BI Desktop
1.7 Power BI Report Server, Power BI Service, Power BI Mobile
1.8 Flow of Work in Power BI / Power BI Architecture
1.9 A Brief History of Power BI
2.PBI Desktop Installation, PBI Desktop &Service Overview
2.1 Power BI Desktop Installation
2.2 Building Blocks of Power BI
2.3 Datasets, Visualizations, Reports, Dashboards, Tiles
2.4 Power BI Desktop User Interface
2.5 Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab, Canvas
2.6 Overview of Power Query / Query Editor – Extract, Transform & Load Data
2.7 Connecting to Data Sources, Establish connection to the Excel source
2.8 Importing Data into Power BI or Query Editor
2.9 Transforming the Data using Power Query
2.10 Model the Data using Power Pivot – Relationship View
2.11 Creating New Measures and New Columns using DAX – Data View
2.12 Visualizing the Data using Power View and Power Maps – Report View
2.13 Saving and Publishing the Visuals or Reports
2.14 Logon to Power BI Service
2.15 View the Reports in PBI Service and Share the reports
3.Power Query
3.1Introduction to Power Query – Extract, Transform & Load
3.2 Data Transformation, Benefits of Data Transformation
3.3 Shape or Transform Data using Power Query
3.4 Overview of Power Query / Query Editor, Query Editor User Interface
3.5 The Ribbon (Home, Transform, Add Column, View Tabs)
3.6 The Queries Pane, The Data View / Results Pane, The Query Settings Pane, Formula Bar
3.7 Advanced Editor – Complete ETL Code
3.8 Saving Your Work – Applying ETL Changes – Loading into Power Pivot Model
3.9 Power Query Conceptually
4.Datatypes and Filters in Power Query
4.1 Datatypes, Changing the Datatype of a Column
4.2 Filters in Power Query
4.3 Auto Filter / Basic Filtering
4.4 Filter a Column using Text Filters
4.5 Filter a Column using Number Filters
4.6 Filter a Column using Date Filters
4.7 Filter Multiple Columns
5. Inbuilt Column Transformations
5.1 Remove Columns / Remove Other Columns
5.2 Name / Rename a Column
5.3 Reorder Columns or Sort Columns
5.4 Add Column / Custom Column
5.5 Split Columns
5.6 Merge Columns
5.7 PIVOT, UNPIVOT Columns
5.8 Transpose Columns
6. In built Row Transformations
6.1 Header Row or Use First Row as Headers
6.2 Keep Top Rows, Keep Bottom Rows
6.3 Keep Range of Rows
6.4 Keep Duplicates, Keep Errors
6.5 Remove Top Rows, Remove Bottom Rows, Remove Alternative Rows
6.6 Remove Duplicates, Remove Blank Rows, Remove Errors
6.7 Group Rows / Group By
7.Combine Queries (Append Queries & Merge Queries)
Append Queries / Union Queries
7.1 Append Queries
7.2 Append Queries as New
7.3 Append 2 or more files individually with different queries
7.4 Appending multiple files of same type from a folder using single query
7.5 Query Options
7.6 Copy Query, Paste Query
7.7 Delete Query, Rename Query
7.8 Enable Load, Include in report Refresh
7.9 Duplicate Query, Reference Query
7.10 Move to Group, Move Up, Move Down
8.Merge Queries / Join Queries
8.1Merge Queries, Merge Queries as New
8.2 Default Types of Joins / Join Kinds / Merge Type
8.21 Left Outer (all from first, matching from second)
8.22 Right Outer (all from second, matching from first)
8.23 Full Outer (all rows from both)
8.24 Inner (only matching rows)
8.25 Left Anti (rows only in first)
8.26 Right Anti (rows only in second)
8.3 Cartesian Join or Cross Join
9. Power Pivot
Power BI Data Modeling – Relationship View
Data Modeling Introduction
Relationship, Need of Relationship
Relationship Types / Cardinality in General
One-to-One, One-to-Many (or Many-to-One), Many-to-Many
AutoDetect the relationship, Create a new relationship, Edit existing relationships
Make Relationship Active or Inactive
Delete a relationship
Cross filter direction (Single, Both), Assume Referential Integrity
10.Enhancing the Data Model – DAX
What is DAX, Calculated Column, Measures
DAX Table and Column Name Syntax
Creating Calculated Columns, Creating Measures
Implicit Vs Explicit Measures
Calculated Columns Vs Measures
DAX Syntax & Operators
DAX Operators
Types of Operators
Arithmetic Operators, Comparison Operators, Text Concatenation Operator, Logical Operators
11. DAX Functions Categories
Date and Time Functions
Logical Functions
Text Functions
Math & Statistical Functions
Filter Functions
Time Intelligence Functions
12. DAX Date & Time Functions
YEAR, MONTH, DAY
WEEKDAY, WEEKNUM
FORMAT (Text Function), Month Name, Weekday Name
DATE, TODAY, NOW
HOUR, MINUTE, SECOND, TIME
DATEDIFF, CALENDAR
Creating Date Dimension Table
13. DAX Text Functions
LEN, CONCATENATE (&)
LEFT, RIGHT, MID
UPPER, LOWER
TRIM, SUBSTITUTE, BLANK
14. DAX Logical Functions
IF
TRUE, FALSE
NOT, OR, IN, AND
IFERROR
SWITCH
15. DAX Math and Statistical Functions
INT
ROUND, ROUNDUP, ROUNDDOWN
DIVIDE
EVEN, ODD
POWER, SIGN
SQRT, FACT
SUM, SUMX
MIN, MINX
MAX, MAXX
COUNT, COUNTX
AVERAGE, AVERAGEX
COUNTROWS, COUNTBLANK
16. DAX Filter Functions
CALCULATE
ALL
RELATED
17. DAX Time Intelligence Functions
Time Intelligence Introduction
TOTALMTD, TOTALQTD, TOTALYTD
PREVIOUSDAY, PREVIOUSMONTH, PREVIOUSQUARTER, PREVIOUSYEAR
NEXTDAY, NEXTMONTH, NEXTQUARTER, NEXTYEAR
SAMEPERIODLASTYEAR
YOY Growth
MOM Growth
18. Power View
Report View / Power View
Report View User Interface
Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab, Canvas
Visual Interactions
Interaction Type (Filter, Highlight, None)
Visual Interactions Default Behavior, Changing the Interaction
19. Filters in Power View
Filter Types
Visual Level Filters, Page Level Filters, Report Level Filters, Drill Through Filters
Filter Sub Types
Basic Filtering, Advanced Filtering, Top N, Relative Date Filtering
Numeric field filters, Text field filters, Date and Time field Filters
20. Grouping, Binning & Sorting
Grouping and Binning Introduction
Using grouping, Creating Groups on Text Columns
Using binning, Creating Bins on Number Column and Date Columns
Sorting Data in Visuals
Changing the Sort Column, Changing the Sort Order
Sort using column that is not used in the Visualization
Sort using the Sort by Column button
21. Hierarchies and Drill-Down Reports
Hierarchy Introduction, Default Date Hierarchy
Creating Hierarchy, Creating Custom Date Hierarchy
Change Hierarchy Levels
Drill-Up and Drill-Down Reports
Data Actions, Drill Down, Drill Up, Show Next Level, Expand Next Level
Drilling filters other visuals option
22.Power BI Visualizations
Visualizing Data, Why Visualizations
Visualization types, Field Wells
