Power BI Basics:
Basics, Power BI Components: Desktop, Service, Mobile
Power BI Architecture
Installing and Setting up Power BI Desktop
Getting started with data:
Importing Data from Various Sources,
Data Types and File Formats,
Connecting to Excel, SQL Server, Web, Refreshing Data and Scheduled Refresh
Power Query Editor:
Introduction to Power Query, Data Transformation Techniques,
Applied Steps and Query Dependencies,
Appending and Merging Queries
Data Modeling:
Creating Relationships Between Tables
Star vs Snowflake Schema,
Managing Relationships,
Understanding Filter Context
Data Analysis Expression:
Introduction to DAX,
Calculated Columns vs Measures,
Basic DAX Functions (SUM, AVERAGE, COUNT)
Logical and Text Functions,
Time Intelligence Functions,
FILTER, ALL, RELATED, CALCULATE
Data Visualization:
Creating Basic Charts (Bar, Line, Pie)
Using Slicers and Filters
Formatting Visuals
Tooltips and Titles
Advanced Visualizations:
Tree Map, Waterfall, Funnel, Map Visuals,
KPI Cards and Gauge Charts
Custom Visuals from Marketplace
Bookmarks and Selections
Dashboards and Reports:
Report Layout and Design Tips,
Multi-Page Reports
Interactivity Between Visuals
Drill Down and Drill Through
Publishing and Sharing:
Publishing Reports to Power BI Service,
Work spaces, Apps
Sharing Reports and Dashboards,
Embed Reports in Web Pages or SharePoint
Row-Level Security (RLS):
What is RLS, Creating RLS Roles in Power BI Desktop, Testing and Managing Roles Implementing RLS in Power BI Service
Power BI Service Features:
Creating Dashboards from Reports,
Alerts and Notifications,
Dataflows and Data Gateway,
Usage Metrics and Q&A Visual.
Row-Level Security (RLS):
Optimizing DAX Queries,
Model Size and Performance, Best Practices for Data Modeling,
Performance Analyzer Tool.
