insights from data visualization - dr. jeff camm (university of cincinnati)
DESCRIPTION
BDPA Cincinnati chapter seeks to learn more about the world of data analysis and visualization. As data continues to proliferate our lives and work, the question of how to make sense of it and turn it into information and knowledge becomes more and more challenging. At the same time, powerful tools are becoming available to help analysts sift through data and present it in a way that draws attention to key bits of knowledge than can be derived. As such, the skills related to using these tools effectively have become highly sought-after as organizations seek to dig out the treasures hidden in their data troves. Our guest speaker is Dr. Jeff Camm (University of Cincinnati)TRANSCRIPT
![Page 1: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/1.jpg)
Data Visualization
Jeff Camm, PhD, DirectorJeff Camm, PhD, Director
UC Center for Business Analytics
Lindner College of Business
513.556.7146
BDPA 1
![Page 2: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/2.jpg)
Analytics
BDPA 2
![Page 3: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/3.jpg)
Big Data
BDPA 3
![Page 4: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/4.jpg)
What is Analytics?
Analytics is the scientific process of Analytics is the scientific process of
transforming data into insight for making better
decisions
BDPA 4
![Page 5: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/5.jpg)
• Descriptive Analytics - the use of data to figure out what happened in the past.
• Predictive Analytics – the use of data to find out
Analytics
• Predictive Analytics – the use of data to find out what could happen in the future
• Prescriptive Analytics – the use of data to prescribe the best course of action to increase the chances of realizing the best outcome.
BDPA 5
![Page 6: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/6.jpg)
Descriptive Analytics ExampleDescriptive Analytics Example
BDPA 6
![Page 7: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/7.jpg)
Cincinnati Zoo: Where are our
members?
20101990
BDPA 7
![Page 8: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/8.jpg)
Predictive Analytics ExamplePredictive Analytics Example
BDPA 8
![Page 9: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/9.jpg)
Targeted Marketing Example
• Zoo wants to start a targeted mailing campaign to increase annual membership sales. Who should receive these mailings?
• What determines likelihood of becoming zoo member?
• Income
• Number of children
• Education attainment
• Distance from zoo
BDPA 9
![Page 10: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/10.jpg)
Targeted Marketing Example
• Fit a regression equation to existing data where• For each postal code we are trying to predict how
many zoo members should be present in that postal code based on:postal code based on:
• Distance from zoo
• Average income in that postal code
• Number of households with children in that postal code
• % of residents attaining certain degrees (high school, bachelor’s, etc.)
•Identify “underrepresented” markets by comparing predicted members in that postal code to actual number of members
US Census data
BDPA 10
![Page 11: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/11.jpg)
Prescriptive Analytics ExamplePrescriptive Analytics Example
BDPA 11
![Page 12: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/12.jpg)
North American Product
Supply Study
• $250M savings
per year
BDPA 12
![Page 13: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/13.jpg)
Data Visualization
Data Visualization - - the use of graphical
displays to explore, summarize and present
BDPA 13
Data Visualization - - the use of graphical
displays to explore, summarize and present
information about a data set.
![Page 14: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/14.jpg)
BDPA 14
![Page 15: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/15.jpg)
Insights with Graphics
• Some Principles
– Simpler is better. Do not use more dimensions, text or color than are needed.than are needed.
– Use simple fonts
– Format appropriately (if a number is in dollars, use a currency format)
– Clearly label the axes of a graph, including units used.
– Use a key to explain different colors or formats
– If a key is used, place the key as close as possible to the data
– Sort for clarity
BDPA 15
![Page 16: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/16.jpg)
Which is better?
BDPA 16
![Page 17: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/17.jpg)
The Only Acceptable Pie Chart• Humans are very
poor at judging differences in spatial area.area.
• Because of this, pie charts are almost never the preferred way to present comparative data.
BDPA 17
![Page 18: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/18.jpg)
BDPA 18
![Page 19: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/19.jpg)
BDPA 19
![Page 20: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/20.jpg)
BDPA 20
![Page 21: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/21.jpg)
BDPA 21
![Page 22: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/22.jpg)
BDPA 22
![Page 23: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/23.jpg)
BDPA 23
![Page 24: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/24.jpg)
Total Disaster
BDPA 24
![Page 25: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/25.jpg)
Bad Charts have an Impact on Your
Credibility and Message
BDPA 25
![Page 26: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/26.jpg)
And it is not just Fox News…….
BDPA 26
![Page 27: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/27.jpg)
Other types of Bar Charts
8,000
10,000
Nu
mb
er
of
Co
ntr
ibu
tors
Most Common Annual Gift Amounts, 2011-2012
Side-by-SideStacked
0
2,000
4,000
6,000
52 130 26 260 25 78 100 50 104
Nu
mb
er
of
Co
ntr
ibu
tors
Annual Gift Amount
2011 2012
BDPA 27
![Page 28: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/28.jpg)
Combining a Table and a Chart
BDPA 28
![Page 29: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/29.jpg)
Scatter Charts
Data for 51 major
U.S. Cities for
1981 to 2010.
BDPA 29
![Page 30: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/30.jpg)
Scatter
Chart
New York City Rent Data
Chart
Matrix
BDPA 30
![Page 31: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/31.jpg)
Displaying Time Series DataLine Chart
% Change Bar Chart
BDPA 31
![Page 32: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/32.jpg)
Bad Charts have an Impact on
Your Credibility and Message
BDPA 32
![Page 33: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/33.jpg)
Using Color and Reducing Dimensions
BDPA 33
![Page 34: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/34.jpg)
Using Color and Reducing Dimensions
BDPA 34
![Page 35: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/35.jpg)
Big Data Visualizations
• Networks
• Word Clouds• Word Clouds
BDPA 35
![Page 36: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/36.jpg)
BDPA 36
Source: WebLog Pro Olivier Berger
![Page 37: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/37.jpg)
Word Cloud from President Obama’s Speech on
Health Care Reform
Source: ReutersBDPA 37
![Page 38: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/38.jpg)
Excel Charts/Graphs
• Much Improved in Excel 2013
BDPA 38
![Page 39: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/39.jpg)
Other Packages
• SAS Visual Analytics
• JMP• JMP
• Tableau
• Cognos
• Spotfire
• R
BDPA 39
![Page 40: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/40.jpg)
An Extreme Example
• Hans Rosling
• It is about telling the story of the data.
BDPA 40
![Page 41: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/41.jpg)
Good References
BDPA 41
![Page 42: Insights From Data Visualization - Dr. Jeff Camm (University of Cincinnati)](https://reader033.vdocuments.us/reader033/viewer/2022060120/5592b3ba1a28ab770d8b462e/html5/thumbnails/42.jpg)
Thanks!
BDPA 42
Questions?