The Big Book of Dashboards: Visualizing Your Data Using Real-World Business Scenarios

(VISUALIZE-DATA.AE1)/ISBN:978-1-64459-319-6

This course includes
Lessons
TestPrep
Hand-on Lab
AI Tutor (Add-on)

The Big Book of Dashboards: Visualizing Your Data Using Real-World Business Scenarios course covers a detailed understanding of Big Book data visualization by providing objective-based interactive lessons and hands-on experience with live labs. It covers the fundamentals of data visualization, the application of dashboards in business scenarios, and then the challenges faced in the real world. The live labs provide the live experience of working with dashboards.   

Lessons

37+ Lessons | 74+ Exercises | 145+ Quizzes | 68+ Flashcards | 68+ Glossary of terms

TestPrep

Hand on lab

19+ LiveLab | 19+ Video tutorials | 01+ Hours

Here's what you will learn

Download Course Outline

Lessons 1: Introduction

  • How This Course Is Different?
  • How This Course Is Organized?
  • How to Use This Course?
  • Succeeding in the Real World
  • What to Do and What Not to Do
  • What Is a Dashboard?
  • Final Thought: There Are No Perfect Dashboards 

Lessons 2: Data Visualization: A Primer

  • Why Do We Visualize Data?
  • How Do We Visualize Data?
  • Color
  • Common Chart Types
  • When Our Visual Processing System Betrays Us
  • Every Decision Is a Compromise
  • Summary

Lessons 3: Course Metrics Dashboard

  • Scenario
  • How People Use the Dashboard
  • Why This Works
  • The Traditional Approach and Why You Should Avoid It
  • Author Commentary

Lessons 4: Comparing Individual Performance with Peers

  • Scenario
  • How People Use the Dashboard
  • Why This Works
  • Other Considerations
  • Alternative Approach
  • Author Commentary

Lessons 5: What-If Analysis: Wage Increase Ramifications

  • Scenario
  • Why This Works
  • Dashboard Designer Commentary
  • Author Commentary

Lessons 6: Executive Sales Dashboard

  • Scenario
  • How People Use the Dashboard
  • Why This Works
  • Author Commentary

Lessons 7: Ranking by Now, Comparing with Then

  • Scenario
  • How People Use the Dashboard
  • Why This Works
  • The Traditional Approach, and Why You Should Avoid It
  • Other Approaches
  • Author Commentary

Lessons 8: Are We on Pace to Reach Our Goals?

  • Scenario
  • How People Use the Dashboard
  • Why This Works
  • Author Commentary

Lessons 9: Multiple Key Performance Metrics

  • Scenario
  • How People Use the Dashboard
  • Why This Works
  • Alternative Approaches
  • Author Commentary

Lessons 10: Power Plant Operations Monitoring

  • Scenario
  • How People Use the Dashboard
  • Why This Works
  • Ben Shneiderman's Mantra
  • Author Commentary

Lessons 11: Showing Year-to-Date and Year-over-Year at the Same Time

  • Scenario
  • How People Use the Dashboard
  • Why This Works
  • The Traditional Approach, and Why You Should Avoid It
  • Dashboard Designer Commentary
  • Author Commentary

Lessons 12: Premier League Player Performance Metrics

  • Scenario
  • How People Use the Dashboard
  • Why This Works
  • Author Commentary

Lessons 13: RBS 6 Nations Championship Match Performance Analysis

  • Scenario
  • How People Use the Dashboard
  • Why This Works
  • Author Commentary

Lessons 14: Web Analytics

  • Scenario
  • How People Use the Dashboard
  • Why This Works
  • Author Commentary

Lessons 15: Patient History Analysis of Recent Hospital Admissions

  • Scenario
  • How People Use the Dashboard
  • Why This Works
  • Dashboard Designer Commentary
  • Author Commentary

Lessons 16: Hospitality Dashboard for Hotel Management

  • Scenario
  • How People Use the Dashboard
  • Why This Works
  • Author Commentary

Lessons 17: Sentiment Analysis: Showing Overall Distribution

  • Scenario
  • How People Use the Dashboard
  • Why This Works
  • Other Approaches
  • Author Commentary

Lessons 18: Showing Sentiment with Net Promoter Score

  • Scenario
  • How People Use the Dashboard
  • Why This Works
  • Avoiding the Traditional Approach to NPS
  • More Thoughts on Visualizing Sentiment
  • Author Commentary

Lessons 19: Server Process Monitoring

  • Scenario
  • How People Use the Dashboard
  • Why This Works
  • Author Commentary

Lessons 20: Big Mac Index

  • Scenario
  • How People Use the Dashboard
  • Why This Works
  • Author Commentary

Lessons 21: Complaints Dashboard

  • Scenario
  • How People Use the Dashboard
  • Why This Works
  • Other Approaches
  • Author Commentary

Lessons 22: Hospital Operating Room Utilization

  • Scenario
  • How People Use the Dashboard
  • Why This Works
  • Author Commentary

Lessons 23: Showing Rank and Magnitude

  • Scenario
  • How People Use the Dashboard
  • Why This Works
  • Another Approach: A Bump Chart
  • Author Commentary

Lessons 24: Measuring Claims across Multiple Measures and Dimensions

  • Scenario
  • How People Use the Dashboard
  • Why This Works
  • Author Commentary

Lessons 25: Showing Churn or Turnover

  • Scenario
  • How People Use the Dashboard
  • Why This Works
  • Other Use Cases and Approaches
  • Author Commentary

Lessons 26: Showing Actual versus Potential Utilization

  • Scenario
  • How People Use the Dashboard
  • Why This Works
  • Author Commentary

Lessons 27: Health Care Provider Productivity Monitoring

  • Scenario
  • How People Use the Dashboard
  • Why This Works
  • Author Commentary

Lessons 28: Telecom Operator Executive Dashboard

  • Scenario
  • How People Use the Dashboard
  • Why This Works
  • Author Commentary

Lessons 29: Economy at a Glance

  • Scenario
  • How People Use the Dashboard 
  • Why This Works
  • Author Commentary

Lessons 30: Call Center

  • Scenario
  • How People Use the Dashboard
  • Why This Works
  • Author Commentary

Lessons 31: Want to Engage People? Make Your Dashboards Personal

  • Overview
  • Personalized Dashboards
  • Make the Demographics Dashboard Personal
  • But What If You Still Want to Make Something Beautiful?
  • Conclusion

Lessons 32: Visualizing Time

  • Introduction
  • How Much Time Do You Want to See?
  • How Does Today Compare with the Start of a Time Period?
  • Are There Cyclical Patterns in My Data?
  • How Can I Look Up Trends Across Two Time Dimensions?
  • How Can I Look at Rank, Not Value, Over Time?
  • How Can I Compare Growth Rates of Things That Happen at Different Times?
  • How Can I Show the Duration of Events?
  • How Can I Focus on Bottlenecks in a Process?
  • Which Time Chart Should I Use on My Dashboard?

Lessons 33: Beware the Dead-End Dashboard

  • Review Your KPIs
  • Track Usage with Data
  • Speak to Your Users
  • Build Starter Dashboards
  • Summary

Lessons 34: The Allure of Red and Green

  • Designing Color-Blind-Friendly Visualizations
  • Conclusion

Lessons 35: The Allure of Pies and Donuts

  • Background
  • Conclusion

Lessons 36: Clouds and Bubbles

  • The Allure of Word Clouds and Bubble Charts
  • Marist Poll and Views of the 2016 Presidential Election
  • Conclusion

Lessons 37: A Journey into the Unknown

  • Keep Asking Questions
  • The Squiggle of Visual Exploration

Hands-on LAB Activities

Data Visualization: A Primer

  • Creating and Analyzing Chart Types
  • Visualizing Data

Course Metrics Dashboard

  • Using the Show Me Toolbar
  • Creating a Connection in a New Workbook
  • Creating a Dashboard and Implementing Actions

Ranking by Now, Comparing with Then

  • Creating a Regional Scoreboard

Power Plant Operations Monitoring

  • Building a Bullet Graph

Showing Year-to-Date and Year-over-Year at the Same Time

  • Performing Quick Table Calculations

Patient History Analysis of Recent Hospital Admissions

  • Viewing the Aggregate Data

Showing Sentiment with Net Promoter Score

  • Creating a Stacked Bar Chart

Server Process Monitoring

  • Enhancing the User Experience, Analysis, and Visualizations

Complaints Dashboard

  • Creating Filled, Symbol, and Density Maps

Hospital Operating Room Utilization

  • Creating a Gantt Chart

Want to Engage People? Make Your Dashboards Personal

  • Creating a Dashboard in Excel
  • Creating a Story
  • Building a Dashboard

Visualizing Time

  • Creating a Line Chart

Clouds and Bubbles

  • Creating a Bar Chart

A Journey into the Unknown

  • Highlighting Categories of Interest