This repository contains a collection of Excel-based analytics projects that demonstrate the end-to-end workflow of preparing, analyzing, and visualizing data. Each project showcases the complete lifecycle from data cleaning and transformation to modeling, feature engineering, and dashboard creation for insights.
The following techniques and components were used while preparing Excel dashboards:
- Data Cleaning & Transformation
- Handling missing values, duplicates, incorrect data types, and inconsistent formats.
- Standardizing date fields, text categories, and numerical formats.
- Deriving new columns such as day, hour, and product or category groupings for deeper analysis.
- Feature Engineering
- Creating additional analytical fields including time-based splits, bucketed categories, and calculated business metrics.
- Preparing lookup sheets and structured tables to simplify repeat analysis.
- Data Modeling using Power Query & Power Pivot
- Using Power Query to clean, merge, append, and reshape datasets from multiple sources.
- Building Power Pivot models with relationships between fact and dimension tables.
- Defining measures and calculated fields to support dynamic analysis within dashboards.
- Dashboard Design
- Constructing visually organized dashboards with charts, PivotTables, PivotCharts, matrices, and slicers.
- Designing both static and interactive dashboards depending on the project requirements.
- Applying themes for consistent formatting and improved readability to highlight insights effectively.
- Excel Projects