About Power BI Certification Course - Overview

Power BI is BI & Data Visualization Tool by Microsoft way advanced than SSRS by Microsoft
According to Gartner's Magic Quadrant, it is amongst top 3 BI Tools in Industry
Since it is a Microsoft Product it is widely used with Ms SQL Server and many other databases. Hence there is huge opportunity in Industry.
Since it is among Top BI Tools in Industry it is one of High Paying Technologies in Industry
Pre-requisites To Learn - none. To Implement Basic SQL is required

Syllabus

1.5 months (32 hours)

Introduction to Power BI
- What is Power BI and Why Power BI
- Installing Power BI Desktop
- Exploring the Power BI Workflow
- Adjusting the settings of the Power BI Desktop
- Comparison of Power BI vs Other Reporting Tools
ETL in Power BI
- Connecting to different sources
- Different connecting Options(DirectQuery vs Import Data Vs Live Connection)
- Shaping and transforming data with Power Query
- Editing,Merging,Appending queries etc
Modeling with Power BI
- Introduction to Modeling
- Building Relational Models(Setup and Manage Relationships)
- Creating table relationships
- Understanding the filter flow
- Cardinality and Cross filtering
DAX
- Understanding Dax Syntax
- Calculated Columns vs Measures
- Functions:
  - Filter
  - Financial
  - Logical
  - Parent-Child
  - Relationship
  - Text
  - Statistical : Median, Norm, Percentile etc.
  - Time Intelligence etc
M Functions
- Data Access
- Binary
- Combiner
- Date Time
- Duration

Visualising Data with Reports
- Creating Visualisations
- Color & Conditional Formatting
- Setting Sort Order
- Scatter & Bubble Charts & Play Axis
- Tooltips
- Slicers, Timeline Slicers & Sync Slicers
- Cross Filtering and Highlighting
- Visual, Page and Report Level Filters
- Drill Down/Up
- Hierarchies
- Constant Lines
- Tables, Matrices & Table Conditional Formatting
- KPI's, Cards & Gauges
- Map Visualisations
- Custom Visuals
- Managing and Arranging
- Drillthrough
- Custom Report Themes
- Grouping and Binning
- Bookmarks & Buttons

Introduction to Power BI Service
- Introduction to the Power BI Service
- Quick Tour of Power BI Service
- Connecting to Data from Power BI service
- Building Blocks of Power BI Service
Sharing and Collaboration Tools in Power BI Service
- Sharing and Collaboration Options Overview
- Publish from Power BI Desktop
- Publish Reports to Web
- Printing and Exporting from Power BI Service
- Sharing Reports & Dashboards
- Workspaces (My Workspace vs App Workspace)
- Publishing Apps in Power BI Service
- Row Level Security in Power BI Desktop and Service
Power BI Gateway and Refreshing Datasets
- Understanding Gateways in Power BI
- Difference between Personal and On-Premise Gateway
- Installation of Personal Gateway
- Installation of On Premise Enterprise Gateway
- Setting Up a Gateway in Power BI Service
- Understanding Data Refresh(Manual vs Scheduled Refresh)
- Troubleshooting Refreshing scenarios
Case Study