Data Analysis and Presentation Summary notes
Descriptive Analytics *** Question Answered: What happened?
Tools/Techniques: Exploratory data analysis, ce ntral tendency, spread, distribution,
correlation, outliers
Examples: Financial rations (Profit margins and leverage ratio), cost-per-unit, customer
acquisition, variance of budget-to-actual
Diagnostic Analytics *** Question answered: Why did this happen?
Tools techniques: Informal 5 Why's, Formal hypothesis testing and regression
Predictive Analytics *** What might happen in the future
Forecasting analytics, predicting customer behavior
Prescriptive analytics *** What should be done
Artificial intelligence, machine learning
central tendency *** Mean, media, and mode
Bar charts and box-and-whisker charts
Spread/Dispersion *** Standard deviation; quartile
Box-and-whisker charts
Distribution *** Show the spread of numeric data values
Histogram and box plot
Correlation *** Comparing how two numeric variables fluctuate with each other
Scatterplot; heat map
Trend Evaluation *** Show changes over an ordered variable
Line chart; area chart
Part-to-Whole *** Show which items make up the parts of a total
Pie chart, tree map
Benefits of visualizing data *** Process faster than written/tabular information
Visuals easier to use and needs less guidance to find information for users
Visual supports dominant learning style of population (visual learners)
Contact for help with assignments and revision materials
Descriptive Analytics *** Question Answered: What happened?
Tools/Techniques: Exploratory data analysis, ce ntral tendency, spread, distribution,
correlation, outliers
Examples: Financial rations (Profit margins and leverage ratio), cost-per-unit, customer
acquisition, variance of budget-to-actual
Diagnostic Analytics *** Question answered: Why did this happen?
Tools techniques: Informal 5 Why's, Formal hypothesis testing and regression
Predictive Analytics *** What might happen in the future
Forecasting analytics, predicting customer behavior
Prescriptive analytics *** What should be done
Artificial intelligence, machine learning
central tendency *** Mean, media, and mode
Bar charts and box-and-whisker charts
Spread/Dispersion *** Standard deviation; quartile
Box-and-whisker charts
Distribution *** Show the spread of numeric data values
Histogram and box plot
Correlation *** Comparing how two numeric variables fluctuate with each other
Scatterplot; heat map
Trend Evaluation *** Show changes over an ordered variable
Line chart; area chart
Part-to-Whole *** Show which items make up the parts of a total
Pie chart, tree map
Benefits of visualizing data *** Process faster than written/tabular information
Visuals easier to use and needs less guidance to find information for users
Visual supports dominant learning style of population (visual learners)
Contact for help with assignments and revision materials
