You will use Tableau for your data analysis and data visualization and generate
frequency distribution tables,
histograms, and
pie charts
for the quantity sold and orders for the
Ship Mode,
Country,
Category, and
Sub-Category.
The 4 pie charts must include labels that show the percentage and the descriptors.
The 4 histograms must include labels that show the quantity and the descriptors.
The 4 frequency distribution tables must include the descriptors, the quantity, and the percentages.
You will also provide a written analysis that includes 3 bullet points:
1) the largest percentage,
2) the second-largest percentage, and
3) the sum of the largest and second-largest or top 10.
for the quantity sold and orders
for the Ship Mode, Country, Category, and Sub-Category.
Step : 1 Upload this Amazon dataset into Tableau. You will use Tableau to generate the statistical outputs and data visualizations.
Attached is the template you must use to organize your report. Copy and Paste your outputs from Tableau into this Microsoft WORD file.
Save your file as YourFirstName-YourLastName-Amazon-Tableau-Fall-24.docx
Upload both your Microsoft WORD file and your Tableau file.
Reviewing the atttached slides will be of great assistance to you.
1 https://youtu.be/7HF00Ox4wx0
2 https://m.youtube.com/watch?v=MkcdKDKDNE8
Orders: 42,220 Quantity: 159,294 items.
How to create a pie chart, histogram, and frequency distribution table
regarding the quantity sold and orders in less than 10 minutes.
Create Calculated Fields to compute the SUM([Quantity])/TOTAL(SUM)([Quantity]))
I attached two YouTube video links above to help you and guide you on how to do all of the charts and assist you.
To access Tableau :
Login information will be available for the assigned writer.