This repository contains solution data analytics virtual internship provided by KPMG via Forage. The main goal of this project is to work on real data based on a real life business problem. This programme covers all of the key skills of a data analytics consultant: -Data Quality Assessment -Data Insights -Data Insights and Presentation
Sprocket Central Pty Ltd needs help with its customer and transactions data. The organisation has a large dataset relating to its customers, but their team is unsure how to effectively analyse it to help optimise its marketing strategy.
The client provided KPMG with 3 dataset:
- Customer Demographic
- Customer Addresses
- Transactions data in the past 3 months
There are three task must be completed
Assessment of data quality and completeness in preparation for analysis.
Targeting high value customers based on customer demographics and attributes.
- In building this recommendation, we started with a PowerPoint presentation which outlined the approach which we will be taking.
- The client has agreed on a 3 week scope with the following 3 phases as follows - Data Exploration; Model Development and Interpretation.
- Prepared a detailed approach for completing the analysis including activities – i.e. understanding the data distributions, feature engineering, data transformations, modelling, results interpretation and reporting.
Developed a dashboard using Tableau that displays the data summary and results of the analysis. Some of the focussed business context when presenting findings were:
- What are the trends in the underlying data?
- Which customer segment has the highest customer value?
- What do you propose should be Sprocket Central Pty Ltd ’s marketing and growth strategy?
- What additional external datasets may be useful to obtain greater insights into customer preferences and propensity to purchase the products?
- Data Exploration
- Data Cleansing
- Data Visulaization
- Python (pandas, numpy)
- Google Spreadsheet
- Tableau