Home / Companies / Retool / Blog / Post Details
Content Deep Dive

Visualize CSV Data and Build a Dashboard to Track Your Amazon Spending

Blog post from Retool

Post Details
Company
Date Published
Author
Amit Jotwani
Word Count
2,933
Language
English
Hacker News Points
-
Summary

In a detailed exploration of personal Amazon spending, the author describes building an "Amazon Purchases Insights Dashboard" using tools like Google Sheets, Retool, and ChatGPT to analyze purchase data from 2022. By downloading purchase history as a CSV from Amazon, importing it into Google Sheets, and utilizing Retool's integration, the author was able to create a dashboard that visualizes monthly and category-based spending, highlights the most expensive purchases, and identifies trends such as a high expenditure in June due to travel-related shopping. ChatGPT assisted in categorizing items into broader groups to simplify analysis. The dashboard revealed significant spending on baby-related items, a high return rate of 20%, and an average monthly expense of $838, emphasizing the ease of overspending with online shopping. This project offers insights into personal spending habits and provides a framework for more effective budgeting in the future.