This repository contains related work for the tasks assigned during the Data Analytics Consulting Virtual Internship offered by KPMG with InsideSherpa. The virtual internship program can be found here: https://in.insidesherpa.com/virtual-internships/theme/m7W4GMqeT3bh9Nb2c/KPMG-Data-Analytics-Virtual-Internship
All datasets used for the assigned tasks can be found in the Datasets folder. Some of these datasets were provided during the virtual internship while others have been generated using the provided datasets. The generated datasets were prepared using Tableau Prep. The relevant Flow files and Extracts can be found in the Tableau folder. Simple regression model was applied to forecast the profit when the new customers are targetted and profit margin is increased. Python code for the same can be found in the Python Scripts folder.
The final presentation and Tableau Packaged Workbook has also been included. The dashboard prepared for the presentation and other Tableau Worksheets can be found in Sprocket Customers.twbx file. The TargetCustomers.xlsx file contains details about the new customers that must be targetted in the future.
Pratham Sharma
Student at Vellore Institute of Technology, Vellore, Tamil Nadu, India
Reach out to me: prathams2425@gmail.com
LinkedIn profile: https://www.linkedin.com/in/prathamSharma25/
Kaggle profile: https://www.kaggle.com/prathamsharma123