Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Data Visualization with Power BI : Visualize, Analyze, Predict
Introductions to Power BI and Data Basics - Day 1
Prerequisites
What is Power BI? Overview of tools(Power BI Desktop, Service, Mobile)
Understanding BI Concepts: ETL, DAX, Dashboards
Installing Power BI Desktop
Data Types and Sources(Excel, CSV, Web, SQL)
Activity - Day 1 Load a Sample Dataset In Power BI
Quiz
Assignment - Day 1
Data Transformation with Power Query - Day 2
Power Query Editor Overview
Data Cleaning: Removing Rows/Columns, Filtering
Transformations: Split, Merge, Pivot/Unpivot
Appending vs Merging Queries
Activity - Day 2 Clean Messy Dataset and Prepare For Analysis
Quiz
Assignment - Day 2
Data Modeling - Day 3
Introduction to Data Modeling
Relationships: One-to-Many and Many-to-Many
Star vs Snowflake Schemaa
Creating Calculated Columns and Tables
Activity - Day 3 Build a Data Model from Multiple Tables in Power BI
Quiz
Assignment - Day 3
DAX Basics (Data Analysis Expressions) - Day 4
DAX Syntax and Functions
Calculated Columns vs Measures
Common Functions: SUM, AVRAGE, COUNTROWS, CALCULATE, FILTER
Time Intelligence: YTD, MTD, Previous Month
Activity - Day 4 Create useful KPIs and Calculations
Quiz
Assignment - Day 4
Data Visualization and Report Design - Day 5
Visual Types : Bar, Line, Pie, Matrix, Card, Map, etc.
Slicers, Filters and Bookmarks
Custom Visuals and Themes
Activity - Day 5 Design a Dashboard from Scratch
Quiz
Assignment - Day 5
Publishing, Sharing and Final Project - Day 6
Publishing Reports to Power BI Service
Creating Dashboards on Power BI Service
Sharing and Collaboration with Others
Data Refresh and Gateways (Basic Intro)
Activity - Day 6 Build and Present a mini Dashboard with Insights
Quiz
Assignment - Day 6
Common Functions: SUM, AVRAGE, COUNTROWS, CALCULATE, FILTER
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock