A complete business sales analysis project developed using Microsoft Excel and Python to solve the same real-world business problem through two different analytical approaches.
This project was completed during the Excel to Python Bootcamp, where the objective was to analyze a real-world Amazon sales dataset using both Microsoft Excel and Python.
Instead of relying on a single tool, the complete business analysis was recreated in both environments to understand how Excel and Python approach the same analytical problems.
The project demonstrates practical data analysis techniques, dashboard creation, visualization, KPI tracking, and business insight generation.
The primary objectives of this project were to:
- Analyze Amazon sales data
- Clean and organize raw business data
- Generate meaningful KPIs
- Visualize sales performance
- Identify business trends
- Compare Excel-based analytics with Python-based analytics
- Build an interactive dashboard for decision making
This repository contains two complete implementations of the same project.
The Excel version includes:
- Interactive Dashboard
- KPI Cards
- Pivot Tables
- Pivot Charts
- Slicers
- Dynamic Filtering
- Business Insights
The Python implementation recreates the complete analysis using:
- Pandas
- NumPy
- Matplotlib
The notebook performs:
- Data Cleaning
- Data Exploration
- KPI Calculation
- Sales Analysis
- Customer Analysis
- Product Analysis
- Monthly Sales Trend Analysis
- Payment Mode Analysis
- Business Visualizations
Excel_to_Python_Bootcamp/
│
├── Amazon_Original_DataSet_For_Colab.xlsx
├── Amazon_Excel_to_Python_Bootcamp_DataSet.xlsx
├── Excel_to_Python_bootcamp.ipynb
├── Mini Project excel to python bootcamp.pdf
└── README.md
- Dashboard Development
- KPI Cards
- Pivot Tables
- Pivot Charts
- Slicers
- Business Reporting
- Pandas
- NumPy
- Matplotlib
The project covers several important business analyses, including:
- Total Sales Analysis
- Order Analysis
- Average Sales
- Product Performance
- Customer Analysis
- Payment Mode Analysis
- Monthly Sales Trends
- Sales Distribution
- Business KPIs
- Data Visualization
- Interactive Excel Dashboard
- Python Data Analysis Notebook
- Data Cleaning Workflow
- Business KPI Calculation
- Professional Charts
- Comparative Analysis (Excel vs Python)
- Beginner-Friendly Code
- Well-Structured Analysis
Add screenshots of your Excel Dashboard and Python visualizations here.
Example:
Images/
├── excel_dashboard.png
├── monthly_sales.png
├── payment_analysis.png
└── sales_chart.png
git clone https://github.com/YOUR_USERNAME/Excel_to_Python_Bootcamp.git
cd Excel_to_Python_Bootcamppip install pandas numpy matplotlibOpen the notebook using Jupyter Notebook or Google Colab.
jupyter notebookor upload the notebook to Google Colab.
Open
Mini Project excel to python bootcamp.pdf
to explore the dashboard created in Microsoft Excel.
The dashboard provides:
- Interactive filtering
- KPI Summary
- Business charts
- Sales insights
Open
Excel_to_Python_bootcamp.ipynb
to view the complete Python implementation, including:
- Data preprocessing
- Exploratory Data Analysis (EDA)
- KPI calculations
- Charts
- Business insights
Through this project, I gained hands-on experience in:
- Data Cleaning
- Data Visualization
- Business Analysis
- Dashboard Design
- Excel Analytics
- Python for Data Analysis
- Pandas
- NumPy
- Matplotlib
- Converting spreadsheet workflows into Python code
One of the biggest takeaways was understanding how the same business problem can be solved using both Microsoft Excel and Python. While Excel is excellent for interactive dashboards and quick reporting, Python provides greater flexibility, automation, and scalability for larger datasets.
Possible enhancements include:
- Plotly Interactive Dashboard
- Streamlit Web Application
- Power BI Dashboard
- Advanced Business KPIs
- Predictive Sales Analysis
- Machine Learning Models
- Automated Reporting
Contributions, suggestions, and feedback are always welcome.
If you have ideas to improve this project, feel free to:
- Fork the repository
- Create a feature branch
- Submit a Pull Request
If you found this project helpful or interesting, consider giving it a Star ⭐ on GitHub.
It motivates me to continue learning and sharing more data analytics projects.
Hasnat Ahmad
Aspiring Data Analyst | Python Enthusiast | Microsoft Excel | Data Visualization
Connect with me on LinkedIn and GitHub to follow my learning journey.