Description
Case Study Part II: Data Visualization
Using the Performance Lawn Equipment dataset, complete the following data manipulation. Each process should be completed on a separate worksheet.
Save the following in an Excel file titled “CaseStudyPart2yourname”. The following worksheets should be included in the file.
PLE originally produced lawn mowers, but a significant portion of sales volume over recent years has come from the growing small-tractor market. Three years ago, a new region was opened to serve China, where a booming market for small tractors has been established. PLE has always emphasized quality and considers the quality it builds into its products as its primary selling point. In the past two years, PLE has also emphasized the ease of use of their products.
As a business analyst, you want to gain an overview of PLE’s overall business performance and market position by examining the information provided in the database for this company. Specifically, you would like to construct appropriate charts for the data in the following worksheets in the Performance Lawn Equipment Database and summarize your conclusions from analysis of these charts.
Visual Creation
Create an appropriate chart and write a short analysis for each of the following components of data
Worksheet 1. Dealer satisfaction by area (clustered bar chart)
Worksheet 2. End-User Satisfaction by area (stacked column bar chart)
Worksheet 3. Customer Survey by area (line graph of all areas on one graph with time on the horizontal axis and number of complaints on the vertical axis).
Worksheet 4. Tractor Unit Sales (line graph of all areas on one graph)
Worksheet 5. Average case response time by quarter (single line graph)
