A curated collection of Excel-based Data Analytics and Business Intelligence projects focused on transforming raw business data into interactive dashboards, actionable insights, and executive-level reporting systems.

This repository showcases practical implementations of:

• Data Cleaning
• Data Modeling
• Dashboard Engineering
• KPI Tracking
• Business Intelligence
• Interactive Reporting
• Data Visualization

using Microsoft Excel and advanced analytical workflows.

The purpose of this repository is to demonstrate real-world analytical thinking using Excel as a Business Intelligence tool rather than just a spreadsheet application.

Each project emphasizes:

• Clean backend data architecture
• Interactive dashboard design
• Business-driven insights
• Executive reporting workflows
• UI/UX-focused visualization principles

An interactive Excel dashboard built using 1,000+ supermarket transaction records to analyze:

• Revenue trends
• Product performance
• Customer behavior
• Payment methods
• Regional sales analysis

• Dynamic KPI Cards
• Connected Pivot Tables
• Universally Wired Slicers
• Interactive Charts
• GETPIVOTDATA Modeling
• Dashboard UI/UX Design

• Microsoft Excel
• Pivot Tables
• Pivot Charts
• Slicers
• Power Query
• GETPIVOTDATA
• Data Visualization Techniques

By dynamically segmenting the dataset, the dashboard identified:

Female shoppers in the Yangon branch showed strong purchasing behavior in the Food & Beverages category, with significant usage of E-wallet payment methods.

This repository highlights practical skills in:

• Data aggregation
• Trend analysis
• Customer segmentation
• KPI reporting

• Executive dashboard creation
• Interactive reporting systems
• Analytical storytelling
• Decision-support analytics

• Advanced Pivot Table architecture
• Dynamic formulas
• GETPIVOTDATA logic
• Slicer synchronization
• Dashboard optimization

• Layout structuring
• Visual hierarchy
• Gridless dashboard systems
• Business-focused visualization design

Excel-Projects/
│
├── Supermarket-Sales-Dashboard/
│   ├── Dataset/
│   ├── Dashboard/
│   ├── Backend/
│   ├── Architecture/
│   ├── Excel-File/
│   └── README.md
│
└── README.md

The projects inside this repository generally follow this workflow:

Raw transactional or business datasets

Data transformation using Power Query and Excel techniques

Building backend analytical structures using Pivot Tables

Interactive charts, slicers, KPI systems, and UI optimization

Converting raw numbers into actionable recommendations

Upcoming additions to this repository may include:

• Sales Forecasting Dashboards
• HR Analytics Dashboards
• Financial Analysis Models
• Customer Segmentation Systems
• Inventory Management Dashboards
• Power BI Integrated Projects
• SQL + Excel Analytics Workflows

Aspiring Data Analyst focused on:

• Data Analytics
• Business Intelligence
• Dashboard Development
• Excel Engineering
• Data Visualization
• UI/UX for Analytics

If you found these projects useful or interesting:

• Star this repository ⭐
• Fork the repository 🍴
• Connect with me on LinkedIn 🔗

• LinkedIn: www.linkedin.com/in/aziz-chharchhodawala