Microsoft Power BI Course Content
Power BI Complete Introduction
- Power BI Introduction
- Data Visualization, Reporting
- Business Intelligence(BI), Traditional BI, Self-Serviced BI
- Cloud Based BI, 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 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 – Applying 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 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
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
DAX Functions Categories
- Date and Time Functions
- Logical Functions
- Text Functions
- Math & Statistical Functions
- Filter Functions
- Time Intelligence Functions
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
DAX Text Functions
-
- LEN, CONCATENATE (&)
- LEFT, RIGHT, MID
- UPPER, LOWER
- TRIM, SUBSTITUTE, BLANK
DAX Logical Functions
-
-
- IF
- TRUE, FALSE
- NOT, OR, IN, AND
- IFERROR
- SWITCH
-
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
-
DAX Filter Functions
-
-
- CALCULATE
- ALL
- RELATED
-
DAX Time Intelligence Functions
-
-
- Time Intelligence Introduction
- TOTALMTD, TOTALQTD, TOTALYTD
- PREVIOUSDAY, PREVIOUSMONTH, PREVIOUSQUARTER, PREVIOUSYEAR
- NEXTDAY, NEXTMONTH, NEXTQUARTER, NEXTYEAR
- SAMEPERIODLASTYEAR
- YOY Growth
- MOM Growth
-
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
-
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
-
Visualizing Tabular Data, Geographical Data & R Script Visual
-
-
- Create and Format Table Visual, Matrix Visualization
- Create and Format Map Visual, Filled Map Visual, Arc GIS Maps Visual
- Create and Format R Script Visual
-
Power BI Service
Power BI Service Introduction
-
-
- Power BI Service Introduction, Power BI Cloud Architecture
- Creating Power BI Service Account, SIGN IN to Power BI Service Account
- Publishing Reports to the Power BI service, Import / Getting the Report to PBI Service
- My Workspace / App Workspaces Tabs
- DATASETS, WORKBOOKS, REPORTS, DASHBOARDS
- Working with Datasets, Creating Reports in Cloud using Published Datasets
- Power BI Datasets Live Connection using Desktop
- Working with Workbooks, working with Reports, Sharing Reports
-
Dashboards Development
-
-
- Creating Dashboards
- Pin Visuals and Pin LIVE Report Pages to Dashboard
- Advantages of Dashboards
- Interacting with Dashboards
- Adding Tiles to Dashboards
- Web Content, Image, Text Box,Video
- Formatting Dashboard
- Sharing Dashboard
-
Data Gateways
-
-
- Introduction to Data Gateways
- How Data Gateways work
- Connect to an on premise Data Source by using a Data Gateway
- Download Data Gateway
- Installing a Data Gateway
- Types of Gateways
- On-premises Data Gateway, On-premises Data Gateway (personal mode)
- Manage Data Gateway
- Add and Remove Administrators
- Add Data Source, Add or Remove Users to a Data Source
- Refresh On Premise Data
- Configuring Automatic Refresh using Schedules
-
Collaboration in Power BI using App Workspace
-
-
- Introduction to App Workspaces
- Create an App Workspace
- Add Members to App Workspace to Collaborate
- App Workspace Access
- Admin, Member, Contributor
-
Sharing Power BI Content using Apps and Content Packs
-
-
- Introduction to App
- Publish an App
- Update a Published App
- Manage Content in App
- Include in App, Exclude in App
- Sharing App
- Entire Organization, Specific individuals or group
- Un publishing an App
- Content Pack Introduction
- Create Content Pack
- Sharing Content Packs
- Specific Groups, My Entire Organization
- Selecting the Content / Items to Publish or Share
-
Row Level Security in Power BI
-
-
- Introduction to Row Level Security
- Row Level Security (RLS) with DAX
- Manage Roles, Creating Roles, Testing Roles
- Adding Members to Roles in Power BI Service
- Dynamic Row Level Security
- Creating Users Table and Adding to the Model
- Capturing users using UserName () or UserPrincipalName () DAX Functions
-
ADD ON
-
- Real-time Project Explanation
- Resume Preparation
- Interview Questions Discussions
- Mock Interviews
Watch Microsoft Power BI Demo