MIS 0855 Study Guide - Midterm Guide: Performance Indicator, Missing Data, Zip Code
23 May 2018
School
Department
Course
Professor
Exam 2 Study Outline
7.1 Dirty Data
• Data problems
o Dirty data
o Missing values
o Inconsistent data
o Nonintegrated data (from various sources)
o Wrong granularity (level of detail)
o Too much data
• Agency Problem
o Data creator is usually not the data consumer
o Any mistakes made by the creator might not be caught or any specific terms may be
unclear to the consumer
• Best practices
o Focus on getting the new data right
o Limit time fixing old data
o Data producers should communicate with data consumers
o Check your work
7.2 Data Cleansing
• What are the best tips for cleaning data?
• Make sure abbreviations are consistent
• Look for unusual data/outliers
8.1 Choosing Relevant Data
• What is a Key Performance Indicator (KPI)?
• What is the difference between a predictor and a KPI?
• What is a idiator?
o Qualitative
o Quantitative
o Leading
o Lagging
o Input
o Process
o Output
o Practical
o Directional
o Actionable
find more resources at oneclass.com
find more resources at oneclass.com
