Course overview
1. Introduction to Power BI
26 mins
2. Resources
20 resources
Dashboard
Finance report
Pie chart
Report
1.1 Financial Sample
1.2 Transforming Data
1.3 Employees
1.4 Employee Details
1.5 Managing Relationships Between Data
1.6 Creating Relationships Between Tables
1.6 Optimizing Data Models with Relationships
1.7 Best Practices for Data Modelling
1.8 Create Calculated Columns using DAX
1.9 DAX_Aggregation_Data
1.10 Time Intelligence Functions in Power BI
1.11 Creating Bar Charts Sample Data
1.12 Creating Pie Charts
1.13 Creating Tables
1.14 Creating Dashboard Data
1.15 AdventureWorks Sales
3. Setting up Power BI Desktop Environment
31 mins
Downloading and installing Power BI desktop
Overview of Power BI desktop interface
Basic settings and navigation
4. Connecting and Shaping Data
1 hr
Types of data sources
Connecting Power BI to excel and csv files
Transforming data
Introduction to Power Query editor
Cleaning and shaping data
Combining and merge (join) in Power Query
Managing relationships between data tables
5. Data Modelling in Power BI
31 mins
Overview of data modelling
Creating relationships between tables
Optimizing data models with relationships
Best practices for data modelling
6. Data Analysis Expressions (DAX) in Power BI
37 mins
Basics of Data Analysis Expressions (DAX)
Create calculated columns using DAX formula
Create measures using DAX formula
Use DAX calculations in visualizations
DAX functions for aggregations
Filtering and conditional calculations
7. DAX - Time Intelligence Functions in Power BI
18 mins
Prepare data for functions
Year-to-date (YTD) sales
Month-to-date (MTD) sales
Quarter-to-date (QTD) sales
Year-over-year (YOY) growth
Use measures in visualizations
8. Data Visualization in Power BI
17 mins
Types of visualizations in Power BI
Creating bar charts
Creating pie charts
Creating tables and formatting
9. Project: Designing Interactive Dashboards in Power BI
31 mins
Best practices for dashboard design
Loading dashboard sample data
Total revenue card for dashboard
Revenue by region bar chart for dashboard
Units sold over time line chart for dashboard
Product distribution pie chart for dashboard
Adding slicers for interactive dashboard
Save and publish the dashboard
10. Export - Publishing and Sharing in Power BI
14 mins
Export Power BI template
Export to PDF file
Publishing to Power BI service
Sharing reports and dashboards
11. Exploring Power BI Mobile App
7 mins
Design mobile dashboard layouts
Viewing reports on mobile devices
