W7C1 In-Class Exercise: Identifying Key Performance Indicators
Part 1KPIs Warm Up Exercise
Step 1: Identify Key Performance Indicators (Enter your 5 individual KPIs here)
Step 2: Determine the Best KPIs (Group)
Meet with your group
W3C2 Answer Template for Data Visualizations: The Good,
The Bad and the Aesthetically Challenged
From your group, choose one of each and report here.
Part 2: Compare and Report
The Good One
Name of Viz:
Copy and paste the URL here:
ABC is a pharmaceutical company located in Indiana. ABC employs 100 employees at its
Indianapolis location, and employs more than 10,000 employees worldwide. The HR Manager in
the Indianapolis office is Elaine Oliver.
Rick Alvarez is the South American Di
Date: January 11, 2017
Sherrie Nutson, Administrative Assistant
From: John Laurie, North America Director of Sales
Subject: Final Written Warning
As we previously discussed, we recently learned that you logged on to the
payment system by
Every employee has the duty and the responsibility to be aware of and abide by existing rules
and policies. Employees also have the responsibility to perform their duties to the best of their
ability and to the standards as set fort
V479 Exam 2: Chapter 4-7
Name: Morgan Schenck
Date: Wednesday, March 29th 11:15 a.m.
Short Answer: Be sure to fully support your response and I want them in your own words not
quoted from the text book. If you do quote something, keep it short
W8C2In-Class Exercise: Creating Interactive Dashboards
Objective: Create a dashboard with interactive data filtering using Tableau
Understand how to create an interactive dashboard in Tableau.
Select and apply filters that add to the us
W6C2 In-Class Exercise: Locating Bad Data Using Excel
Objective: Find and fix a data set with incorrect values
Use Excel to identify incorrect values and outliers in a data set
Selectively apply corrections to a data set
Assignment 4: Cleaning a Data Set
Name: Morgan Schenck
Part 1: Errors in Product Names
Insert rows to question 2 as needed (there may be more than two incorrectly named products!).
Answer Template for Hack2: Data Prep & Tableau
Part 1: Identify Errors
#1: Record the number of errors for each section. Insert rows as needed.
Same Day Class
Chicago O'Hare Flight Delay Information
Total Flights Delays
Ratio of Delayed Flights
1. Calcuate the ratio of d
Assignment 6: Analyze a Data Set Using Tableau
Task: Use Tableau to analyze and reveal various relationships within a data set.
Scenario: Earlier in the course you worked with a data set containing fuel economy data for 2015 model
year cars. Now youre goi
Test 2 Answer Template
Tableau Public URL (copy and paste link):
Section 1: Excel Data Prep
1: Which states (names) need to be changed and how
2: How many orders took 6 or more days to ship?
3: How many Item