Syllabus

1.5 months (40 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
Getting and Transforming Data with Power BI Desktop
- 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
Introduction to DAX
- Understanding Dax Syntax
- Calculated Columns vs Measures
- Common Dax functions and formulae
- Understanding the evaluation context in DAX

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