KPMG VIRTUAL INTERNSHIP PROGRAM

This repository contains my solution to KPMG virtual internship tasks

A step-by-step approach to improve the quality of dataset

Potential Business: Optimizing marketing strategy

Here is the background information on the task

Sprocket Central Pty Ltd , a medium size bikes & cycling accessories organization.The company is looking to leverage the insights and analysis provided by KPMG to grow its business by optimizing its marketing strategy.

The client provided KPMG with 3 datasets to start the preliminary data exploration and identify ways to improve the quality of Sprocket Central Pty Ltd’s data:

1. Customer Demographic
2. Customer Addresses
3. Transaction data

In a nutshell, the tasks involve analyzing business data sets, improving their data quality and suggesting recommendations to ensure quality of future data. Creating customer segments based on customer behavior trends and patterns. Creating visualizations and dashboards in tableau to derive insights from existing customers and new customers.

✨Tableau Vis: Insights into existing customers and customer segments
✨Tableau Vis: Insights into new customers

Insights into Customer Segmentation

Insights into Existing Customers

Insights into New Customers

Internship Completion Certificate