This project is a part of the KPMG Data Analytics Consulting Virtual Internship hosted by Forage. Link to the internship: https://www.theforage.com/virtual-internships/theme/m7W4GMqeT3bh9Nb2c/KPMG-Data-Analytics-Virtual-Internship?ref=RWKXu8PZoEgdzjhmP.
The internship is designed to simulate a real-life consulting project. It gave a wonderful opportunity to experience as to what it is like to be inside the firm and got an exprience around what they do day-to-day in terms of collecing and capturing data, analyzing that data, and drawing out deep insights to be able to present those to the clients.
DATA SOURCE: Excel file containing the data used, has been uploaded.
Our task was to analyze the data provided by the client, which contained information about their customers, transactions, and demographic data. We used various tools, including Python to clean, manipulate, and visualize the data. Through this process, we were able to identify key trends and insights, which were used to provide recommendations to the client.
- Data Quality Assessment
Data quality assessment was conducted to ensure that the data provided by the client was accurate and complete. We performed various checks, including verifying the completeness of the data, identifying and removing duplicate entries, and validating the accuracy of the data.
- Data Insights
Targeting high value customers based on customer demographics and attributes. Used Jupyter notebook(Python) to perform statistical analyses, to identify correlations between variables. Also, created pivot tables and charts to visualize the data and identify trends.
- Data Insights and Presentation
In this module, we used PowerBI to create interactive dashboards that presented the data in a visually appealing and easy-to-understand way.
- Data Analysis (Using Python - Jupyter Notebook)
- Customer Segmentation (Conducted RFM Analysis)
- Data Dashboards (Analytical Dashboard Creation)
(Using Power BI to build interactive and high quality dashboards)
This internship provoded me with a valuable learning opportunity. I gained an in-depth understanding of how to interpret and analyze data to identify key insights that could help businesses make informed decisions. I also learned how to present this information in a clear and concise manner, ensuring that clients understood the findings and their potential impact.