uCertify

Data Visualization

(UOP-DSC560.AE1)
Lessons
Lab
TestPrep
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Data Visualization: A Primer

  • What Is a Dashboard?
  • Final Thought: There Are No Perfect Dashboards 
  • 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
2

The Scenarios Part I

  • Course Metrics Dashboard
  • Comparing Individual Performance with Peers
  • What-If Analysis: Wage Increase Ramifications
  • Executive Sales Dashboard
  • Ranking by Now, Comparing with Then
  • Are We on Pace to Reach Our Goals?
  • Multiple Key Performance Metrics
  • Power Plant Operations Monitoring
  • Showing Year-to-Date and Year-over-Year at the Same Time
3

The Scenarios Part II

  • Premier League Player Performance Metrics
  • RBS 6 Nations Championship Match Performance Analysis
  • Web Analytics
  • Patient History Analysis of Recent Hospital Admissions
  • Hospitality Dashboard for Hotel Management
  • Sentiment Analysis: Showing Overall Distribution
4

The Scenarios Part III

  • Showing Sentiment with Net Promoter Score
  • Server Process Monitoring
  • Big Mac Index
  • Complaints Dashboard
  • Hospital Operating Room Utilization
  • Showing Rank and Magnitude
  • Measuring Claims across Multiple Measures and Dimensions
  • Showing Churn or Turnover
  • Showing Actual versus Potential Utilization
  • Health Care Provider Productivity Monitoring
  • Telecom Operator Executive Dashboard
  • Economy at a Glance
  • Call Center
5

Engaging Dashboards and Visualizing Time

  • Making Your Dashboards Personal - Overview
  • Personalized Dashboards
  • Make the Demographics Dashboard Personal
  • But What If You Still Want to Make Something Beautiful?
  • Conclusion
  • 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?
6

Visualization Best Practices

  • Review Your KPIs
  • Track Usage with Data
  • Speak to Your Users
  • Build Starter Dashboards
  • Designing Color-Blind-Friendly Visualizations
  • The Allure of Pies and Donuts - Background
  • The Allure of Word Clouds and Bubble Charts
  • Marist Poll and Views of the 2016 Presidential Election
  • Keep Asking Questions
  • The Squiggle of Visual Exploration

1

Data Visualization: A Primer

  • Creating and Analyzing Chart Types
  • Visualizing Data
2

The Scenarios Part I

  • Using the Show Me Toolbar
  • Creating a Connection in a New Workbook
  • Creating a Dashboard and Implementing Actions
  • Creating a Regional Scoreboard
  • Building a Bullet Graph
  • Performing Quick Table Calculations
3

The Scenarios Part II

  • Viewing the Aggregate Data
4

The Scenarios Part III

  • Creating a Stacked Bar Chart
  • Enhancing the User Experience, Analysis, and Visualizations
  • Creating Filled, Symbol, and Density Maps
  • Creating a Gantt Chart
5

Engaging Dashboards and Visualizing Time

  • Creating a Dashboard in Excel
  • Creating a Story
  • Building a Dashboard
  • Creating a Line Chart
6

Visualization Best Practices

  • Creating a Bar Chart
  • Highlighting Categories of Interest

Related Courses

All Courses