My Amazon Spending

Challenge

Going into the project, I assumed that data acquisition would be as simple as a 1 - click download from Amazon. However, given that I requested large amount of data, it took about 2 weeks to retrieve my personal Amazon history. The second challenge was that Amazon products often have subcategories nested within other subcategories, and I found that the 'Product Category' column did not accurately categorize the products. This involved the manual categorization of each product which ensured that the data was structured and organized for effective visualization and analysis in Tableau.

Results

I must clarify that I don't use Amazon Prime Exclusively, I am sharing it with 10 other people. I did not spend over $4,500 on Amazon shopping alone, it was very much a group effort. I also interesting found it interesting to see which of my friends are using it more than I am. It is also important to preface that this was during lock down, so most people had nothing better to do than just online shop. I remember building my first personal computer at the time, and you can see that reflected in the 'Most Popular Categories' chart.