How to Build a Data Dashboard
Using the techniques from this workshop, transit managers can make informed decisions to plan for the future of their agency, and show stakeholders the information they use to reach those decisions.
Introduction & Learning Objectives
Data Download
Installing Power BI
Data and Transit
Role of Data (Data-Information-Knowledge-Wisdom Framework)
Transit Metrics: Importance and Examples
Transit Data Sources
Data Quality: Indicators and Best Practices for Data Collection
Chapter 1 Quiz
Chapter 2 Learning Objectives and Skills of Focus
Understanding Data: Rates and Benchmarks
Data Types
Data Manipulation in Excel
Chapter 2 Quiz
Chapter 3 Learning Objectives and Skills of Focus
Power BI Workflow
Power BI Interface
Connecting Data to Power BI
Aggregation Settings
Organizing and Joining Data
Chapter 3 Quiz
Chapter 4 Learning Objectives and Skills of Focus
Visualizations in Power BI
Using Filters and Slicers
DAX - Data Analysis Expressions
Enriching Data with Calculated Columns
Calculating Statistics using Measures
Theming and Styling Reports
Chapter 4 Quiz
Chapter 5 Learning Objectives and Skills of Focus
Sharing Dashboards
Best Practices when Sharing Dashboards
Design Principles and Accessibility
Chapter 5 Quiz
Course Closeout