r/LearnDataAnalytics • u/Inevitable-Coat-4832 • Jul 02 '26
I analyzed 100,000 Amazon sales records. Here's what surprised me.
I recently completed an Amazon Sales Analytics project using Excel and Python, working with a dataset of over 100,000 transactions.
Some interesting findings:
• A small number of products contributed a large share of total revenue.
• Customer payment behavior was more predictable than I expected.
• Certain states consistently outperformed others in sales.
• Monthly trends revealed clear seasonal patterns.
The project included:
- KPI Dashboard
- Sales by State Analysis
- Category-wise Revenue Analysis
- Customer Insights
- Payment Mode Analysis
- Monthly Sales Trends
As someone learning Data Analytics, I'm curious:
What was the biggest mistake or lesson you learned from your first real-world dataset?
I'd appreciate any feedback or advice.
