Excel data analysis advanced projects
A collection of interactive dashboards built in Microsoft Excel, demonstrating the ability to transform raw data into actionable business intelligence. Focused on driving decision-making in sales, HR, and operations.
| Project | Description | Key Skills | | [🏪 1. Vrinda Store Annual Report] | Analyzed sales data to improve profitability through product and operational insights. | PivotTables, Slicers, Dashboard Design | | [👥 2. HR Analytics Dashboard] | Reduced employee attrition by identifying key trends and drivers over a 13-year period. | Data Analysis, Trend Analysis, Demographic Segmentation | | [🌍 3. Multi-Branch Performance] | Optimized performance for 15 global branches by analyzing $4M in revenue against costs. | Power Query, Data Modeling, Comparative Analysis | | [📈 4. July Regional Sales] | Measured and compared sales performance across regions and representatives. | Power Query, Sensitivity Analysis, Slicers |
- Advanced Excel: PivotTables, PivotCharts, Advanced Formulas (XLOOKUP, SUMIFS), Conditional Formatting
- Data Transformation: Power Query Editor for data cleaning, merging, and consolidation
- Data Visualization & Dashboarding: Creating interactive reports with Slicers and Timelines for dynamic filtering
- Business Analysis: Trend analysis, sensitivity analysis, KPI calculation, and root cause investigation
Objective: Improve store profitability by generating deep insights into product category performance, customer segments, and operational efficiency.
Approach:
- Built an interactive dashboard with slicers for dynamic category, channel, and time-based filtering.
- Leveraged PivotTables to analyze sales trends, customer demographics, and shipping performance.
Result:
- Identified 3 underperforming product categories for strategic review.
- Clarified significant shipping delays in specific regions, leading to logistical improvements.
- Provided data-driven size recommendations to optimize inventory and reduce returns.
Business Need: Reduce employee attrition and optimize workforce planning by understanding why employees leave.
Approach:
- Analyzed comprehensive HR data from 2010–2023.
- Uncovered key insights into attrition rates, hiring trends, demographic factors, and departmental turnover.
Result:
- Provided management with a clear view of attrition drivers, enabling targeted retention strategies.
- Identified hiring trends to better align talent acquisition with business cycles.
Scope: Analysis of 15 global branches generating a combined $4M in annual revenue.
Approach:
- Cleaned and merged disparate data sets from multiple branches using Power Query.
- Built a centralized dashboard with slicers for branch and year selection (2013–2018).
- Visualized the crucial relationship between revenue and cost using PivotTables and charts.
Result:
- Enabled leadership to quickly compare branch performance and profitability.
- Identified top-performing and underperforming branches for resource re-allocation.
Need: Measure and compare sales performance across regions and individual representatives.
Approach:
- Consolidated data from multiple sheets using Power Query Editor.
- Implemented slicers for intuitive regional and representative-level filtering.
- Conducted sensitivity analysis on pricing and quantity variations to model their impact on revenue.
Result:
- Provided sales managers with a clear tool to track team and regional performance in real-time.
- Offered insights into how pricing strategies could maximize revenue.
In today's data-driven world, the real value lies in turning numbers into narrative and insight. These projects highlight:
-
✔️ Technical Proficiency: Mastery of Advanced Excel, Power Query, and dashboard design.
-
✔️ Business Acumen: Moving beyond analysis to provide clear observations and actionable recommendations.
-
✔️ Storytelling: Making complex data accessible, understandable, and actionable for decision-makers.
-
✔️ Technical Proficiency: Mastery of Advanced Excel, Power Query, and dashboard design.
-
✔️ Business Acumen: Moving beyond analysis to provide clear observations and actionable recommendations.
-
✔️ Storytelling: Making complex data accessible, understandable, and actionable for decision-makers.