Data Analytics Consulting
By :-
Mohammad Waseem Shaikh
17cs002052
INTRODUCTION
The KPMG virtual online internship included completing a three-part
module focused on Data Analytics means analyzing business data sets and
data quality, targeting clientele through the analysis of customer trends
and behavior and finally creating a summary and results of the total
analysis using a dashboard and the following Tools: Tableau and Excel ,
Jupyter Notebook. Take the mystery out of big data and learn what it’s
like to produce business results with the KPMG data analytics team .
DATASET
Sprocket Central Pty Ltd , a medium size bikes & cycling accessories organization
approach KPMG .They help with its customer and transactions data. The organization
has a large dataset relating to its customers, but their team is unsure how to effectively
analyze it to help optimize its marketing strategy. This client provided KPMG with 3
datasets:
• Customer Demographic.
• Customer Addresses.
• Transactions data in the past 3 months.
MODULES
Over the period of KPMG virtual internship there will be three main
modules which I completed for the data analytics:
Data Quality Assessment.
Data Insights.
Data Insights and Presentation.
Data Quality Assessment
• For this task I had to assess the quality of their data; as well as make
recommendations on ways to clean the underlying data and mitigate these
issues.
• The dataset which i received have various issues with the data regarding
things like accuracy, completeness ,consistency or duplicate values so in
this task we assess the quality before start any analysis.
After reviewing the dataset errors which I found in the dataset .
Suggestions of following points in order to improve the data quality, which
will eventually help us to driven the better analytics.
• We can take a mode year value for the missing records of customers
DOB.
• We can replace the F and femal gender by Female, also replace M by male .
• We can assign a uniform last name of customers, which values are missing.
• Replace gender ‘U’ with reference to the customer name and make a
consistency.
• Blank orders can be eliminate by considering it fake orders.
Data Insights
For this module I have to create a presentation which allows the organization(Sprocket
Central Pty Ltd) to see my methodologies of targeting high value customers based on
customer demographics and New customer list data for analyzing the dataset. In this
module I have to provide the information on three phases.
1.Data exploration.
2.Model development.
3.Interpretation and report.
Data Exploration
By Customers’ age distribution:
By New Customer dataset By Customer demographic(old) dataset
q1: Under 25; q2: 25 to 48; q3: 48 to 59; q4: Over 59
Model Development
Bike purchases in last 3 years by New customer list(dataset)
Interpretation
By Job industry category
By customer demographic (old) dataset By new customer list
dataset
Interpretation
Wealth segments by age
By customer demographic (old) dataset By new customer list dataset
Data Insights and Presentation
After building the model need to present our results back to the organization.
Visualizations such as interactive dashboards often help us highlight key findings
and convey our ideas in a more succinct manner. A list of customers or algorithm
won’t cut it with the client, we need to support our results with the use of
visualizations. So I create a dashboards to better visualize the data to
organization.
Reference
• https://drive.google.com/file/d/1OaVwvPiNiTeo69WpiiaOPJhK- WYbCy4Z/
view?usp=sharing
• https://
www.theforage.com/virtual-internships/theme/m7W4GMqeT3bh9Nb2c/KPMG-Dat
a-Analytics-Virtual-Internship
• https://public.tableau.com/profile/bharat3740#!/
vizhome/KPMGVirtualInternship_15871253812950/Dashboard1
• https://www.tutorialspoint.com/python/python_functions.htm
• https://www.youtube.com/watch?v=Nr31rv9tsJ8
• https://www.geeksforgeeks.org/graph-plotting-in-python-set-1/
THANK YOU
