Scribd
Upload
50 views

Tableau Data Virtualization

The Average Sales per Manufacturer (use line chart) The Total Sales per Model -The Total Sales per Quarter for each Show the Correlation between the Price and the Sales Check the difference if you added an extra fee for the Price product for cars prices more than 5 thousand Combine the car width with the sales in one chart to see if the width affects the sales.

Uploaded by

Lamees Elghazoly
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
50 views

Tableau Data Virtualization

The Average Sales per Manufacturer (use line chart) The Total Sales per Model -The Total Sales per Quarter for each Show the Correlation between the Price and the Sales Check the difference if you added an extra fee for the Price product for cars prices more than 5 thousand Combine the car width with the sales in one chart to see if the width affects the sales.

Uploaded by

Lamees Elghazoly
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 34

DATA VISUALIZATION

Supervised By Created By
Dr. Mohamed Eltaweel Lamees El-Ghazoly
The Company Performance
Analysis
The Average Sales per Manufacturer (use line chart)
The Total Sales per Model
-The Total Sales per Quarter for each
Show the Correlation between the Price and the Sales
Check the difference if you added an extra fee for the Price product for cars
prices more than 5 thousand
Combine the car width with the sales in one chart to see if the width affects the
sales.
Introduction to Tableau
Tableau is a powerful Data Visualization tool
that allows users to create interactive and
insightful charts, graphs, and dashboards from
their datasets. Its user-friendly interface
empowers individuals to explore and analyze
data visually, gaining valuable insights to make
data-driven decisions.

Now, let's dive into the descriptions for each


required point along with the respective
Tableau charts:
1. Average Sales per Manufacturer
(Line Chart):
You can use a line chart to see the average sales per
manufacturer.
Each line represents a different manufacturer, and the x-axis
shows time (e.g., years).
This chart provides a trend analysis of how each manufacturer's
sales have evolved.
Addition chart to show the Average Sales per Manufacturer
2. Total Sales per Model
Create a bar chart illustrating the total sales per car model.
Categorize the bars based on price ranges or any relevant
classification (e.g., entry-level, mid-range, luxury). This detailed
bar chart offers a comprehensive sales distribution across
various car models.
The Total Sales per Model
The Total Sales per Affordable Models
The Total Sales per Mid-Range Models
The Total Sales per Luxury Models
The Total Sales per Sports and Performance Models
The Total Sales per SUVs and Crossover.
3-Total Sales per Quarter for 2011,
2010, and 2009
Utilize a line chart to display the quarterly sales for 2011, 2010,
and 2009. Each line corresponds to a specific year; the x-axis
represents the quarters. This chart facilitates a comparative
analysis of sales performance across the three years.
The Total Sales per
Quarter for 2011
The Total Sales per
Quarter for 2010
The Total Sales per
Quarter for 2009
4-The Correlation between the
Price and the Sales
Construct a scatter chart to showcase the correlation between car
prices and sales.
Each data point represents a car model, with the x-axis displaying
prices and the y-axis indicating sales. This scatter chart visually
examines whether there is a relationship between the two
variables.
5- The difference if you added extra
fee for the Price product for cars
prices more than 5 thousand
Introduce a calculated field that adds an extra fee for car prices
exceeding 5 thousand.
Create a Calculated Field by using:

Use a dual-axis line chart to display the original and adjusted


prices. This chart visually highlights the impact of the extra fee on
sales and allows for a direct comparison.
6- The impact of combining the car
width to the sales in one chart.
7-Impact of Engine Size and Fuel
Efficiency on Sales
Create a chart (scatter plot or other suitable visualization) to
illustrate the impact of engine size and fuel efficiency on sales. This
analysis helps uncover any patterns or correlations between these
attributes and sales performance, providing valuable insights for
marketing and product strategy.
The Dashboard.
Sales Performance per Model
The Dashboard.
Sales Performance per classified Models
The Dashboard.
Sales Performance per classified Models
The Dashboard.
Sales Performance in quarter
The Dashboard.
Sales Performance in quarter
The Dashboard.
The impact of Engine size and
Fuel efficiency on Sales perf
The Dashboard.
The impact of Engine size and
Fuel efficiency on Sales perf
I am sincerely grateful for your dedicated efforts and commitment
to sharing knowledge has been truly inspiring.
Thank you for the wealth of information and guidance you've
provided us.
Your passion for teaching has made a significant impact on our
learning journey.
I appreciate your invaluable contributions and the positive
environment you create in the classroom.
Wish You all the best
Thank You

You might also like