What This Course is About
Who We Are
Important Course Information
Data Download
Folder Organization
Learning Objectives & Skills of Focus
Business Intelligence & the Role of Dashboards
Hands-on: Loading Data into Power BI
Identifying the Purpose and Audience of Your Dashboard
Developing Metrics
Visualizations: Introduction
Visualizations: Types and Use Cases
Visualizations: Degrees of Freedom
Hands-on: Visualize with Power BI
Quiz: Identify the Most Appropriate Metric/Chart
Optional Homework: Basic Visualizations in Power BI
Learning Objectives & Skills of Focus
Garbage In, Garbage Out
Data Manipulation in Excel
Hands-on: Data Cleaning and Aggregation
Data Models & Relational Datasets
Storage Modes & Data Updates
Connecting to Data
Power BI Views
Hands-on: Creating Tables and Connections
Quiz: What's Wrong With This Data Model?
Optional Homework: Analyzing Ridership Patterns
Learning Objectives & Skills of Focus
User Interface & Flow of Information
Enhance Your Reports
Manage the Flow of Information
Hands-on: Creating Advanced Visualizations
DAX Introduction
DAX Operations
Hands-on: Creating a Calculated Column for Conditional Formatting
Dealing With Large Data
Quality Assurance and Quality Control
Documentation
Quiz: Identify The Correct DAX Formula
Optional Homework: DAX Operations in Power BI
