This repository contains the work I completed as part of the KPMG AU Data Analytics Virtual Internship on Forage. This program is designed to provide insights into what a career in data analytics at KPMG would be like.
The project involved conducting detailed data analysis for Sprocket Central Pty Ltd, a fictitious organization specializing in high-quality bikes and cycling accessories. The datasets provided contained information about customers' demographics, transactions, and addresses. My task was to assess the data quality, prepare the datasets for analysis, derive actionable insights, and identify high-value customers from a new customer dataset.
This repository includes the following files and folders:
Data: This folder contains the raw datasets.Email Draft.pdf: A draft of the email containing the data quality assessment and recommendations.Sprocket_Central_Customer_Insights.ipynb: Jupyter notebook with the full analysis, including data cleaning, exploration, and visualization.Sprocket Central Analysis.twb: Tableau workbook with interactive dashboards showcasing the insights derived from the analysis. Click here for the Tableau Dashboard.sprocket.png: Company logo image used in the reports.Strategic Revenue Insights.png: Visualization image showing revenue insights, including profit distribution by past bike purchases, revenue by top postcodes, state-wise revenue, and revenue trends across tenure and property valuation.Profit Insights Overview.png: Visualization image providing an overview of profit distribution across gender, age groups, wealth segments, and job industries.
- Python for data processing and analysis, with libraries such as Pandas, NumPy, Matplotlib, and Seaborn.
- Tableau for creating interactive dashboards and visualizations.
- Jupyter Notebook for documenting the analysis process.
This is a completed virtual internship project, and as such, it is not open for contribution. However, feedback and suggestions are welcome!
The datasets and materials provided by KPMG AU are their intellectual property. The analysis and visualizations contained within this repository are made available for educational purposes only.