How to Create a Dashboard for Data-Driven Decisions
Learn how to create a dashboard in Excel and Google Looker Studio for data visualization and data analysis from start to finish!
Lesson 1: Welcome!
Lesson 2: Why is Data Important?
Lesson 3: What is a Dashboard and How Do They Help?
Lesson 4: Let's Talk Tools
Questionnaire
Lesson 1: Data Prep and Why It Is Important
Lesson 2: Analysis Paralysis - Start With ONE Thing
Identify Your One Big Thing
Lesson 3.1: (EXCEL) Preparing Your Automated Data File
Lesson 3.1: (Google Sheets) Preparing Your Automated Data File
Lesson 3.2 Data Base Format and How to Get There With Your Standard CSV Download
Lesson 4: Getting Your Data From Source To Dashboard
Lesson 1: Dashboard Staples
Lesson 2.1: Excel Dashboard - Preparing your KPIs. (Data Validation)
Lesson 2.2 Excel Dashboard - Preparing your KPIs. (Conditional Formatting)
Lesson 2.3: Excel Dashboard - Visuals
Lesson 2.4: Excel Dashboard - Breakdowns and Conditional Formatting
Lesson 3.1: Google Looker (Data) Studio Dashboard - Adding Your KPIs
Lesson 3.2: Google Looker (Data) Studio - Supporting Charts
Lesson 3.3: Finishing Touches and Consuming your Dashboard
You Did It! You Can Now Put Your Data To Work!
Final Questionnaire