Tableau Visualization Workbook
docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
504
Subject
Information Systems
Date
Dec 6, 2023
Type
docx
Pages
2
Uploaded by MateMorning11558
Overview
Data visualization is a quick, easy, and effective way to convey
concepts in a universal manner. Visualized data helps you
understand large and complex data sets easily so you can make
decisions based on the analysis. It also helps you identify new
patterns, trends, and correlations in the attributes.
Now you will take a deeper dive into the analysis with measures of
central tendency. After having spent time reviewing your initial
discoveries, your vice president has asked you to create an in-depth
visualization of the data. You will be required to create multiple
charts of each type: trend, pie, and column. Your analysis should
now focus on the subcategories: seller type, transmission, and fuel
type. Different visualizations can help one discover new aspects of
the data. Examining the subcategories will provide further insight as
you begin to identify new patterns, trends, and relationships or
correlations in the key attributes.
Prompt
First, you will be using Excel to create pivot tables based on key
variables.
Second, you will be using a visualization software (Power BI or
Tableau) to create multiple charts of each type: trend, pie, and
column. Then explain the new insights that you have gathered
during your continued analysis.
1.
Using Excel, create a pivot table that gives the average age,
km driven, price, and # of seats based on each of the
categorical variables (transmission, fuel type, seller type).
2.
Create multiple charts
to represent these trends within the
categorical variables.
Use the Car Sales dataset and the workbook from your
previous completed assignment to complete this step.
The charts should be copied as a .jpeg from
Tableau/Power BI and pasted within a worksheet titled
Data_Visualization.
3.
Explain the identified patterns, trends, and
correlations
between the key attributes and subcategories
within a textbox on Excel.
Describe your observations of the categorial variables
and their relationship to the key attributes within the data
set.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help