How sangwanamit621/sales-and-revenue-analysis works
This repository is a 2019 Amazon sales-and-revenue analysis project. Its principal workflow is to prepare monthly sales data, explore and consolidate it, then present sales and revenue insights in Power BI dashboards. The README documents the dashboard capabilities; artifact names indicate the data and analysis stages. Source excerpts were unavailable, so the graph omits uncertain implementation details and links.
Main entry points: Analyzing Amazon Sales Dashboard.pbix Sales analysis dashboard · Amazon Sales Analysis Data Transformation and Basic EDA.ipynb Transformation and EDA · AllYearSales.csv Consolidated sales data · amazon sales raw data Monthly sales CSVs
Components 9
Data preparation
- Monthly sales CSVs
amazon sales raw data - Consolidated sales data
AllYearSales.csv
Analysis
- Transformation and EDA
Amazon Sales Analysis Data Transformation and Basic EDA.ipynb
Reporting
- Sales analysis dashboard
Analyzing Amazon Sales Dashboard.pbix - Sales dashboard
Analyzing Amazon Sales Dashboard.pbix - Revenue dashboard
Analyzing Amazon Sales Dashboard.pbix - Sales and revenue report
Amazon Sales and revenue DPR.pdf - Sales and revenue presentation
Amazon Sales and revenue Presentation.pptx
Other components
- Analyst
Connections 7
- Monthly sales CSVs → Transformation and EDA: input data
- Transformation and EDA → Consolidated sales data: consolidates
- Consolidated sales data → Sales analysis dashboard: analysis data
- Sales analysis dashboard → Sales dashboard: shows sales
- Sales analysis dashboard → Revenue dashboard: shows revenue
- Analyst → Transformation and EDA: explores data
- Analyst → Sales analysis dashboard: reviews insights