Skip to content

Targeting top 1000 customers using RFM ANALYSIS with Excel & PowerBI

Notifications You must be signed in to change notification settings

salmaH4/KPMG-virtual-internship

Repository files navigation

KPMG internship

  • Completed a simulation focused on advising a client on customer targeting with the Data, Analytics & Modelling team
  • Assessed data quality and completeness in preparation for analysis
  • Analysed data to target high-value customers based on demographics and attributes
  • Developed dashboards to communicate findings with visuals

Customer RFM Analysis

  • Who are the best clients?
  • Who are the most loyal customers?
  • Which clients are about to leave?
  • Who should be considered a “lost” client?

tools used:

  • Excel
  • PowerBI

methods used:

  • Data Cleaning & Quality Assessment
  • Data Exploration
  • Presentation

Releases

No releases published

Packages

No packages published