data visualization

Data Visualization - 11-27-2012 by James Lani - Statistics Solutions - http://www.statisticssolutions.com Data Visualiz...

0 downloads 202 Views 20KB Size
Data Visualization - 11-27-2012 by James Lani - Statistics Solutions - http://www.statisticssolutions.com

Data Visualization by James Lani http://www.statisticssolutions.com/data-visualization/ Click here for to get help with your Thesis or Dissertation. Click here for FREE Thesis and Dissertation resources (templates, samples, calculators).

Data visualization is the process of gathering your data from different company silo’s, putting it in a usable form, and graphing out key indicators and metrics. The benefits include: Visualize distribution of a variable and see patterns (e.g., sales in ‘000 over 1 year) with line charts, histograms and trend lines. See relationships between variables with scatter plots (E.g., relationship between calls and number of sales) and heat maps. Classify variables (e.g., percent of gross revenue by salesperson) with bar charts. Here are a few examples: You Peak at Your Customers Number of Visits

You look at the Average Sale Over Time

The Percentage of Customers that Never Purchase Again, then ask why!

You Run an RFM Analysis

Case Study: Foreclosure Home Buying Company: When we met: Company bid on auctioned/foreclosed houses. Company had home attributes and the final sale disposition data.

1/2

Data Visualization - 11-27-2012 by James Lani - Statistics Solutions - http://www.statisticssolutions.com

What we did: Coded and labeled data in suitable format. The result: Created charts showing trends of homes sold by bank and time. The result: Table 1 showed the home buying company which banks were selling homes for relative to the assessed value. This intelligence told the company how much to consider bidding for a $100,000 from Bank 7 compared to Bank 1. Table 1.

Deliverables: An executive summary: Key findings of the analyses, opportunities and threats, and competitive advantages. Explanation of each figure and table. Actionable recommendations. Key variables.Key variables drilled down by region, sales person, time, product, or other variables that make sense (e.g., most and least profitable customers) Distribution.Visualize distribution with line charts, histograms and trend lines. Relationships. Relationships between variables with scatter plots and heat maps. Classifications. Classify variables with bar charts. _______________________________________________

2/2 Powered by TCPDF (www.tcpdf.org)