Course Details

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