A curated collection of real-world Excel dashboard and data analysis projects designed to showcase analytical thinking, reporting, and business intelligence skills using Microsoft Excel.
These projects demonstrate practical experience in transforming raw business datasets into actionable insights using Power Query, Pivot Tables, KPI reporting, charts, and interactive dashboard design.
This portfolio demonstrates hands-on experience in business reporting, sales analytics, customer analysis, and dashboard engineering using Excel-based analytics workflows.
Each project focuses on building interactive dashboards and business reports that support strategic decision-making through clear visualization and KPI-driven insights.
Target Roles: Data Analyst · Business Analyst · BI Developer · Reporting Analyst · MIS Analyst
| # | Project | Industry | Analytics Type | Key Technologies | Core Focus |
|---|---|---|---|---|---|
| 01 | FNP Sales Analysis - Excel Dashboard | Retail / Gifting | Sales & Operational Analytics | Excel, Power Query | Revenue & Customer Insights |
| 02 | Swiggy Sales & Customer Behavior Analysis | Food Delivery | Customer & Sales Analytics | Excel, Pivot Tables | Order & Customer Analysis |
| 03 | Coming Soon | Multiple Domains | Business Analytics | In Progress | Upcoming Dashboard Projects |
📁 Folder: Project_01_FNP_Sales_Analysis/
Business Problem: Analyze sales performance, customer purchasing behavior, and operational efficiency for Ferns N Petals (FNP) to support better business decision-making.
Approach: Developed an interactive Excel dashboard using Power Query, Pivot Tables, KPI reporting, and visualization techniques to monitor revenue trends and customer 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
Excel · Power Query · Pivot Tables · Charts · KPIs · Slicers · Timelines
🔗 Repository Link:
Project_01_FNP_Sales_Analysis/
📁 Folder: Project_02_Swiggy_Sales_Analysis
Business Problem: Analyze food delivery sales, customer behavior, ratings, and regional performance to identify operational and business growth opportunities.
Approach: Built an end-to-end Excel dashboard solution using Power Query, Pivot Tables, KPI reporting, and interactive visualizations for sales and customer analytics.
- 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
Microsoft Excel · Power Query · Pivot Tables · Pivot Charts · Map Charts · KPIs · Slicers
🔗 Repository Link:
Project_02_Swiggy_Sales_Analysis
📁 Folder: Upcoming_Projects
Status: In Progress... ⏳
- HR analytics dashboards
- Retail business reporting
- Financial performance analysis
- KPI tracking dashboards
- Executive-level business reporting
| Category | Tools & Technologies |
|---|---|
| Spreadsheet Tools | Microsoft Excel (Advanced) |
| Data Transformation | Power Query (ETL & Data Transformation) |
| Analytics | Exploratory Data Analysis (EDA) · Trend Analysis |
| Reporting | KPI Reporting · Business Reporting · Performance Tracking |
| Visualization | Pivot Charts · Dashboard Design · Interactive Reporting |
| Interactivity | Slicers · Filters · Timelines |
Excel-Projects-Portfolio/
│
├── Project_01_FNP_Sales_Analysis/
│ ├── FNP_Sales_Dashboard.xlsx
│ └── README.md
│
├── Project_02_Swiggy_Sales_Analysis/
│ ├── Swiggy_Sales_Dashboard.xlsx
│ └── README.md
│
├── Upcoming_Projects/
│ └── In_Progress
│
└── README.md ← You are here- Excel Analytics: Pivot Tables · Pivot Charts · Data Analysis · Dashboard Engineering
- Business Reporting: KPI Tracking · Sales Reporting · Customer Analytics
- Data Transformation: Power Query · Data Cleaning · Data Validation
- Visualization: Interactive Dashboards · Charts · Executive Reporting
- Trend Analysis: Daily · Weekly · Monthly · Quarterly Analysis
- Business Insight: Converting raw business data into actionable insights
This portfolio is built to:
- Demonstrate Excel-based data analysis in real-world business scenarios
- Showcase dashboard-building and reporting skills
- Build job-ready analytics and reporting projects
- Strengthen business intelligence and visualization capabilities
Shivam Kumar
Aspiring Data Analyst & BI Developer focused on:
- Business Intelligence & Reporting
- Dashboard Engineering & Visualization
- Excel & Power Query Analytics
- Data Cleaning & Transformation
- Strategic Business Insights
LinkedIn:
https://www.linkedin.com/in/shivam-kumar-2a0371246/
GitHub:
https://github.com/shivee-code
Role:
Data Analyst / BI Developer
"The goal is to turn data into information, and information into insight." — Carly Fiorina