Exploring Sales Data with Tableau

Analyze and visualize sales data using Tableau to gain insights and present findings effectively.

Step $1$: Data Loading and Analysis

Download the "Sales Data" dataset provided on Moodle.

Step $2$: Data Visualization

Create the following visualizations using Tableau: $($Hint: By default, Tableau will aggregate the data $($you can see SUM in front of each entry$).$ To change this, right$-$click on the field on the Columns shelf and select "Dimension" instead of "Measure."$)$

Total Sales by Product and Category:

Generate a bar chart to display the total sales based on products and categories.

Sales Trend:

Analyze the total sales performance for each year in line graphs. $($Hint: In Tableau, ensure that the columns and rows are in the continuous option$)$

Step $3$: Interactivity

Enhance your visualizations with interactivity:

Add filters to allow users to select specific product categories or time periods. Generate a bar chart to display your filter.

Add filters to analyze the quantities and price based on region for each product.

Step $4$: Analysis and Findings:

Analyze the visualizations and draw conclusions:

Identify the top$-$selling product categories and regions.

Note any significant insights or observations. Calculate central tendencies $($mean$,$ median, mode, standard deviation$)$ for each feature and the output variable. Analyze these measures to gain insights into the data distribution.

Submission:

Submit:

A PDF file containing all the solutions, explanations and figures requested. Save your file as FirstName$-$LastName.PDF$.$