Welcome to my Excel Projects Portfolio — a curated collection of real-world data analysis and dashboard projects designed to showcase my analytical thinking, reporting, and business intelligence skills using Excel.
These projects focus on transforming raw business data into actionable insights using Excel features such as Power Query, Pivot Tables, KPI reporting, and interactive dashboards.
A comprehensive sales performance analysis for Ferns N Petals (FNP), aimed at understanding revenue trends, customer behavior, and operational efficiency.
Key Analysis & Insights:
- Revenue trends across time and occasions
- Occasion-wise and category-wise sales performance
- Identification of top-selling products
- Customer order behavior analysis
- Delivery time and fulfillment performance insights
- Interactive dashboard for quick business decision-making
Tools Used: Excel, Power Query, Pivot Tables, Charts, KPIs, Slicers, Timelines
An end-to-end Excel dashboard project analyzing food delivery sales, order trends, customer ratings, food preferences (Veg vs Non-Veg), and geographic performance for Swiggy.
Key Analysis & Insights:
- Total Sales, Total Orders, Average Order Value (AOV), and Ratings KPIs
- Monthly, weekly, daily, and quarterly sales trend analysis
- Veg vs Non-Veg food revenue contribution
- Top-performing cities and state-wise sales analysis
- Customer satisfaction analysis using ratings data
Tools Used: Microsoft Excel, Power Query, Pivot Tables, Pivot Charts, Map Charts, KPIs, Slicers
Additional Excel dashboard and analytics projects covering HR, retail, and financial datasets will be added soon.
Tools:
- Microsoft Excel (Advanced)
- Power Query (ETL & Data Transformation)
Core Concepts:
- Data Cleaning, Transformation & Validation
- Exploratory Data Analysis (EDA)
- Pivot Tables & Pivot Charts
- KPI Design, Tracking & Performance Reporting
- Dashboard Design & Data Visualization
- Slicers, Filters & Timelines for Interactivity
- Business, Sales & Customer Analytics
- Trend Analysis (Daily, Weekly, Monthly, Quarterly)
This portfolio is built to:
- Demonstrate Excel-based data analysis in real-world business scenarios
- Showcase dashboard-building and reporting skills
- Serve as a job-ready portfolio for Data Analyst, Business Intelligence, and Business Analyst roles
- GitHub: shivee-code
- LinkedIn: Shivam Kumar
⭐ If you found this repository helpful, feel free to star it and explore my upcoming projects.