Power BI Complete Course

             Power BI Introduction

             Data Visualization, Reporting

             Business Intelligence (BI), Traditional BI, Self-Serviced BI, enterprise 100Tb azure bi $5000

             Cloud Based BI cloud service VS On Premise BI

             Power BI Products

             Power BI Desktop (Power Query, Power Pivot, Power View)

             Flow of Work in Power BI Desktop

             Power BI Report Server, Power BI Service, Power BI Mobile

             Flow of Work in Power BI / Power BI Architecture

             A Brief History of Power BI

PBI Desktop Installation, PBI Desktop & Service Overview

             Power BI Desktop Installation

             Building Blocks of Power BI

             Datasets, Visualizations, Reports, Dashboards, Tiles

             Power BI Desktop User Interface

             Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab, Canvas

             Overview of Power Query / Query Editor - Extract, Transform & Load Data

             Connecting to Data Sources, Establish connection to the Excel source

             Importing Data into Power BI or Query Editor

             Transforming the Data using Power Query

             Model the Data using Power Pivot – Relationship View

             Creating New Measures and New Columns using DAX – Data View

             Visualizing the Data using Power View and Power Maps – Report View

             Saving and Publishing the Visuals or Reports

             Logon to Power BI Service

             View the Reports in PBI Service and Share the reports 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 Behaviour, Changing the Interaction

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

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

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

Power BI Visualizations

             Visualizing Data, Why Visualizations

             Visualization types, Field Wells

             Visuals for Filtering, Visualizing Categorical Data, Visualizing Trend Data

             Visualizing KPI Data, Visualizing Tabular Data, Visualizing Geographical Data

             Leveraging Power BI Custom Visuals

Visuals for Filtering

             Slicer Visualization

             When to use a Slicer

             Create and format Slicer Visualization

             Hierarchy Slicer (Custom Visualization)

             When to use a Hierarchy Slicer

             Create and format Hierarchy Slicer

             Advantages of Hierarchy Slicer

Visualizing Categorical Data

             Create and Format Bar and Column Charts

             Create and Format Stacked Bar Chart Stacked Column Chart

             Create and Format Clustered Bar Chart, Clustered Column Chart

             Create and Format 100% Stacked Bar Chart, 100% Stacked Column Chart

             Create and Format Pie and Donut Charts

             Create and Format the Tree Map Visual

             Create and Format Scatter Charts

Visualizing Trend Data

             Line and Area Charts

             Create and Format Line Chart, Area Chart, Stacked Area Chart

             Combo Charts

             Create and Format Line and Stacked Column Chart, Line and Clustered Column Chart

             Create and Format Ribbon Chart, Waterfall Chart, Funnel Chart

Visualizing KPI Data

             Create and Format Gauge Visual, KPI Visual

             Create and Format Card Visualization, Multi Row Card

Power Query

Introduction to Power Query – Extract, Transform & Load

             Data Transformation, Benefits of Data Transformation

             Shape or Transform Data using Power Query

             Overview of Power Query / Query Editor, Query Editor User Interface

             The Ribbon (Home, Transform, Add Column, View Tabs)

             The Queries Pane, The Data View / Results Pane, The Query Settings Pane, Formula Bar

             Advanced Editor – Complete ETL Code

             Saving Your Work – Appling ETL Changes – Loading into Power Pivot Model

             Power Query Conceptually

Datatypes and Filters in Power Query

             Datatypes, Changing the Datatype of a Column

             Filters in Power Query

             Auto Filter / Basic Filtering

             Filter a Column using Text Filters

             Filter a Column using Number Filters

             Filter a Column using Date Filters

             Filter Multiple Columns

Inbuilt Column Transformations

             Remove Columns / Remove Other Columns

             Name / Rename a Column

             Reorder Columns or Sort Columns

             Add Column / Custom Column

             Split Columns

             Merge Columns

             PIVOT, UNPIVOT Columns

             Transpose Columns

In built Row Transformations

             Header Row or Use First Row as Headers

             Keep Top Rows, Keep Bottom Rows

             Keep Range of Rows

             Keep Duplicates, Keep Errors

             Remove Top Rows, Remove Bottom Rows, Remove Alternative Rows

             Remove Duplicates, Remove Blank Rows, Remove Errors

             Group Rows / Group By

Combine Queries (Append Queries & Merge Queries) Append Queries / Union Queries

             Append Queries

             Append Queries as New

             Append 2 or more files individually with different queries

             Appending multiple files of same type from a folder using single query

             Query Options

             Copy Query, Paste Query

             Delete Query, Rename Query

             Enable Load, Include in report Refresh

             Duplicate Query, Reference Query

             Move to Group, Move Up, Move Down

Merge Queries / Join Queries

             Merge Queries, Merge Queries as New

             Default Types of Joins / Join Kinds / Merge Type

             Left Outer (all from first, matching from second)

             Right Outer (all from second, matching from first)

             Full Outer (all rows from both)

             Inner (only matching rows)

             Left Anti (rows only in first)

             Right Anti (rows only in second)

             Cartesian Join or Cross Join

Power Pivot

Power BI Data Modelling – Relationship View

             Data Modelling 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

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