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 Category:

• Generate a bar chart to display the total sales for each product category.

Sales Trend:

• Analyze the sales performance by category.

Regional Sales Breakdown:

• Use a map visualization to display the sales distribution by region.
• Color code the map based on sales volume.

Step 3: Interactivity

Enhance your visualizations with interactivity:

• Add filters to allow users to select specific product categories or time periods.

Step 4: Analysis and Findings:

Analyze the visualizations and draw conclusions:

• Identify the top-selling product categories and regions.
• Explore sales trends and patterns by category.
• 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.

ProductCategoryRegionQuantityPriceTotal SalesProduct CCategory 2Region 36515.531009.45Product DCategory 2Region 39547.424504.9Product ACategory 1Region 23725.79954.23Product DCategory 3Region 48213.491106.18Product ACategory 1Region 21361.74802.62Product CCategory 2Region 34427.351203.4Product CCategory 3Region 47517.081281Product CCategory 2Region 1646.66279.96Product BCategory 3Region 33723.8880.6Product CCategory 3Region 12483.251998Product DCategory 2Region 44575.983419.1Product DCategory 2Region 48298.778099.14Product BCategory 2Region 46323.351471.05Product DCategory 3Region 19193.78526.7Product DCategory 3Region 4952.66473.94Product ACategory 2Region 192524784Product BCategory 2Region 26356.533561.39Product DCategory 1Region 43332.011056.33Product ACategory 2Region 13869.472639.86Product BCategory 3Region 11175.18826.98Product CCategory 1Region 17352.493831.77Product BCategory 1Region 28778.216804.27Product DCategory 2Region 35054.972748.5Product CCategory 1Region 33248.891564.48Product CCategory 2Region 44346.722008.96Product CCategory 3Region 38010.28822.4Product CCategory 1Region 15110.72546.72Product BCategory 3Region 31771.991223.83Product ACategory 1Region 18929.512626.39Product ACategory 3Region 27349.963647.08Product ACategory 1Region 4520.74103.7Product BCategory 1Region 36522.951491.75Product CCategory 3Region 27184.445995.24Product ACategory 3Region 17570.525289Product BCategory 1Region 13063.681910.4Product BCategory 2Region 22419.91477.84Product ACategory 2Region 46940.782813.82Product CCategory 1Region 38770.526135.24Product ACategory 3Region 45130.281544.28Product ACategory 1Region 2149.1649.16Product DCategory 3Region 14064.932597.2Product BCategory 2Region 39595.539075.35Product DCategory 3Region 44856.432708.64Product CCategory 3Region 356201120Product DCategory 2Region 17062.324362.4Product ACategory 2Region 19816.51617Product DCategory 2Region 41011.79117.9Product ACategory 3Region 49985.098423.91Product DCategory 2Region 48326.012158.83Product CCategory 3Region 45634.261918.56Product ACategory 2Region 4678.65471.9Product BCategory 3Region 35481.594405.86Product CCategory 3Region 19155.435044.13Product DCategory 1Region 49116.781526.98Product DCategory 1Region 13894.883605.44Product ACategory 2Region 16423.321492.48Product DCategory 1Region 28520.41734Product BCategory 1Region 47123.091639.39Product DCategory 3Region 43632.991187.64Product ACategory 1Region 32929.06842.74Product DCategory 2Region 26672.284770.48Product ACategory 1Region 35934.732049.07Product CCategory 1Region 15253.732793.96Product DCategory 3Region 21147.08517.88Product DCategory 1Region 429371073Product ACategory 2Region 11945.42862.98Product CCategory 2Region 24630.091384.14Product ACategory 3Region 16964.924479.48Product CCategory 2Region 38182.466679.26Product CCategory 1Region 3827.45219.6Product CCategory 2Region 47776.635900.51Product DCategory 3Region 21746.46789.82Product BCategory 2Region 26764.814342.27Product BCategory 1Region 43046.031380.9Product ACategory 2Region 3157.6257.62Product DCategory 3Region 4657.69346.14Product DCategory 1Region 18048.153852Product ACategory 3Region 16461.483934.72Product DCategory 3Region 28813.651201.2Product BCategory 3Region 12332.82754.86Product DCategory 1Region 18714.331246.71Product ACategory 2Region 41153583Product ACategory 1Region 49153.214842.11Product DCategory 2Region 27559.564467Product CCategory 3Region 3837.83302.64Product DCategory 1Region 3475.91303.64Product DCategory 3Region 42255.381218.36Product CCategory 2Region 34519.45875.25Product CCategory 2Region 23683.282998.08Product DCategory 1Region 21212.38148.56Product CCategory 2Region 16495.216093.44Product BCategory 2Region 45412.2658.8Product DCategory 2Region 45516.21891.55Product BCategory 2Region 48563.35380.5Product ACategory 3Region 26332.592053.17Product CCategory 2Region 26263.563940.72Product BCategory 3Region 19025.72313Product BCategory 3Region 31675.371205.92Product DCategory 2Region 32839.331101.24Product DCategory 2Region 28876.426724.96Product BCategory 2Region 36495.86131.2Product CCategory 1Region 44035.461418.4Product ACategory 1Region 13323.69781.77Product BCategory 1Region 43760.572241.09Product CCategory 1Region 34393.464018.78Product BCategory 3Region 22252.271149.94Product ACategory 3Region 26079.024741.2Product DCategory 1Region 33940.651585.35Product ACategory 3Region 19524.612337.95Product DCategory 1Region 42995.792777.91Product CCategory 2Region 25267.763523.52Product DCategory 1Region 13445.661552.44Product ACategory 3Region 25189.894584.39Product ACategory 1Region 12718.67504.09Product ACategory 1Region 47779.456117.65Product DCategory 1Region 16935.832472.27Product CCategory 1Region 15849.122848.96Product DCategory 2Region 45069.423471Product DCategory 3Region 23873.122778.56