Welcome to my Excel Portfolio, where I showcase a collection of real-world data analysis projects powered entirely by Microsoft Excel. These projects demonstrate my ability to clean, transform, analyze, and visualize data using Excel features like Power Query, Pivot Tables, formulas, and interactive dashboards.
Each repository contains a unique use case, aiming to deliver clear insights and business value through data storytelling.
An interactive dashboard analyzing real estate sales across suburbs like Auburn and Burwood using property sales data.
Highlights:
- Power Query used for data transformation and cleanup
- Pivot tables for price range and agency breakdowns
- Visual insights on seasonal trends, top agencies, and bedroom-price correlation
A workforce analytics dashboard built in Excel to examine employee demographics, salary distribution, departments, and retention rates.
Highlights:
- Gender-wise and department-wise analysis
- Salary brackets and tenure visualizations
- Turnover and retention insights using filters and KPIs
A personal finance dashboard that tracks monthly income, expenses, and savings across various categories.
Highlights:
- Dynamic monthly breakdown using slicers
- Categorized expenses and savings visualized with charts
- Budget comparison and goal tracking using Excel formulas
A retail sales analytics solution showcasing regional performance, product trends, and customer segmentation.
Highlights:
- Sales trends by region, segment, and category
- Customer profitability and buying patterns
- Data modeled using pivot tables and conditional formatting
- Power Query: Data extraction, cleaning, and reshaping
- Pivot Tables: Aggregating data for summaries and KPIs
- Excel Formulas: Logical and statistical operations (
SUMIFS,COUNTIF,IFERROR, etc.) - Conditional Formatting: Highlighting insights visually
- Interactive Charts & Slicers: Enhancing exploration and filtering