This project is part of a virtual job simulation by Deloitte, aimed at solving client-facing data problems using core analytical techniques. The scenario focused on cleaning raw data, generating meaningful KPIs, and presenting insights to stakeholders.
To perform data cleaning and analysis on client performance metrics, identify trends and outliers, and propose actionable business strategies.
- Microsoft Excel (data cleaning, pivot tables, charting)
- Basic statistical analysis
- Tableau dashboards
- Removed nulls, duplicates, and outliers from raw sales data.
- Performed segmentation and cohort analysis.
- Used pivot tables and charts to identify key metrics.
- Recommended actions to improve performance based on trends.
- Made dashboards on Tableau for data visualisation.
- Identified top-performing and underperforming regions.
- Detected seasonal trends affecting sales and product demand.
- Proposed resource reallocation to optimize performance.
Deloitte_Sales_Data_Analysis.xlsx: Cleaned dataset with calculations and visuals.Deloitte_Forage_Certificate.pdf: Official certificate of completion.- 'Deloitte_Data_Analytics_New.twb': Tableau dashboard
- Raw data sets in json and excel files