DATA VISUALIZATION
HANEESH
What is Data Visualization?
Art of converting complex data sets into beautiful, simple diagrams that tease out unseen patterns and connections. Main goal of data visualization is to communicate information clearly and effectively through graphical means.
Why is Visualization Important?
With
large datasets, need an efficient way to understand a vast amount of data. The human visual system is the highest-bandwidth channel to the human brain.
A picture is worth a thousand words
Commonly used Visualizations
Heat map of sales and Profits
Three important features of a heat map. 1.Size of the box -Here sales values depict the size
2.Color -Profits are shown using intensity of color
3.Label -State name is the label
Word Cloud-movies to be watched
A tag cloud (word cloud, or weighted list in visual design) is a visual representation for text data, typically used to depict keyword metadata(tags)on websites, or to visualize free form text
-
Wikipedia
Two things to consider are 1.Font size highest frequency 2.Font Color -genre
Bubble Chart-US Accident Data
A bubble chart is a type of chart that displays three dimensions of data.
Things to consider in a Bubble chart are 1.Size of the Bubble -No. of accidents
2.Color -No. of causalities
3.Label -State name is the label
Scatter Plot
Scatter Plots (also called scatter diagrams) are used to investigate the possible relationship between two variables that both relate to the same "event."
Retail Customer Segmentation
DRAMA/DR ACTION/AC COMEDY/CO SCIENCE FICTION/SF SCIENCE FICTION/SF ACTION/AC TELEVISION DRAMA/DR COMEDY/CO ANIME ROCK/POP FAMILY/FA 1.000 0.335 0.306 0.131 1.000 0.285 0.261 0.233 0.209 0.181 0.105 0.10 PLAYSTATION 2 SOFTWA PS2 GREATEST HITS PLAYSTATION 2 HARDWR PLAYSTATION 2 MEMORY PLAYSTATION 2 MISCEL PLAYSTATION 2 CONTRO LCD MONITORS CPU'S INK JET PRINTERS CABLES/CONNECTORS MULIFUNCTION PRINTER XBOX SOFTWARE XBOX HARDWARE XBOX CONTROLLERS XBOX MISC. XBOX PLATINUM HITS GAMECUBE SOFTWARE
GAMECUBE HARDWARE
GAMECUBE CONTROLLERS GAMECUBE MEMORY
High Revenue: High Size:
MEMORY INTERNAL HARD DRIVES GRAPHICS PC COMPONENTS
Low
Low
GAMECUBE MISC.
The products are grouped into different categories. Each box represent a category. Size of the box depicts the volume of sales happened. The color depicts the revenue.
DISHWASHER TOP MOUNT REFRIG MAJOR APPL. ACCESS. ELECTRIC DRYERS WASHER SIDE BY SIDE ELECTRIC RANGES TOP MOUNT REFRIG DISHWASHER INSTALL MAJOR APPL. ACCESS. GAS RANGES ELECTRIC RANGES OTR ICEMAKERS
Overlapping boxes suggest the people who buy products in one box tend to buy products in other box.
How Data can Deceptive??-Anscombes Quartet
Property Mean of x Variance of x Value 9 11
Mean of y
Variance of y Correlation Linear Regression
7.5
4.122 or 4.127 0.816 y = 3.00 + 0.500x
The 4 data sets have similar properties
Same Regression Line, But Very Different Distributions
Various BI Data Visualization Specialists
Tableau Qlikview Tibco Spotfire Adobe Azure
Introduction to Tableau
Tableau is based on three simple concepts:
1.Connect
Connect Tableau to any database that you want to analyze. Tableau allows connect to the database directly or to store data in-memory in tableau proprietary format.
2.Analyze
Analyzing data means viewing it, filtering it, sorting it, performing calculations on it, reorganizing it, summarizing it, and so on.
3.Share
You can share results with others either by sharing workbooks with other Tableau users, by pasting results into applications such as Microsoft Office, printing to PDF or by using Tableau Server to publish to view on web and on mobile devices.
Sample Dataset
Connect excel dataset to tableau
Dimensions and Facts
After connecting, tableau will figure out list out all the dimensions and measures based upon field values.
Note: Although tableau figures out dimensions and facts, we need to check and define. Because Keys are considered measures by default(since they are numeric)
Analyze-Create visualizations
Analyze using maps
Rise of DV tools-Gartner Magic Quadrant
Jan-2011 Report Feb-2013 Report
The above Reports shows the rise of DV tools from challengers to leaders quadrant .
Data Visualization vs. Traditional BI Reporting
Traditional BI Reporting Key Buyers IT Monitoring Reporting -Canned Reports -Ad-hoc Reports -Dashboards Data Visualization Business
Key Features
Data Analysis Exploration Experimentation Self Service BI Visualization Consultants, Business Small, fast growing companies like Tableau, QlikView, TIBCO Spotfire
User Interface Report / KPI Dashboard Development Consultants Vendors Mega vendors like SAP, IBM, Microsoft
Fight back by Market Leaders
Traditional BI Vendors came up with their own data visualization tools to catch up in the race. IBM Cognos Insight Microsoft PowerPivot and Power View MicroStrategy Visual Insight SAP Business Objects Explorer, Visual Intelligence Now Lumira for DV SAS Visual Analytics
Conclusion
Although DV tools help us visualize the data in simple and beautiful ways, they cannot replace traditional BI tools like BO,Cognos etc. They cannot handle complex data models like BO,cognos etc. does. DV tools and traditional reporting tools co-exist.
Reference
Online DV training, Level 1: Introduction to Data Visualization is now available. Link to course in myLearning: https://mylearning.accenture.com/accenture/langen/management/LMS_ActDetails.asp?UserMode=0&ActivityId=1014225
