KPMG customer DATA ANALYSIS USING EXCEL

KPMG Customer Data Analysis – Cleaned, processed, and analyzed large customer datasets using Excel and Power Pivot, uncovering key trends in demographics and purchasing behavior. Built interactive dashboards that provided actionable marketing strategy recommendations.

KPMG Customer Data Analysis
This project involved analyzing customer demographic, transaction, and address data to uncover trends that could guide marketing and sales strategies. Using Excel and Power Pivot, I cleaned and merged multiple datasets, handled missing values, performed exploratory data analysis (EDA), and calculated key metrics such as Customer Lifetime Value (CLV), purchase frequency, and property-based customer segmentation.

Tools Used: Excel, Power Pivot, Data Cleaning Techniques, Pivot Tables, Conditional Formatting 

Key Outcomes:

• Identified high-value customer segments based on CLV and spending patterns.

• Highlighted customer clusters with the highest potential revenue.

• Discovered correlations between property valuation and customer wealth segment.

• Provided actionable recommendations for targeting and retention strategies.

Impact:
The solution allowed KPMG to visualize their customer base more effectively, prioritize high-value prospects, and design data-backed marketing campaigns, leading to improved targeting efficiency and higher potential ROI.