Customer Data Analysis Using SQL.
Publicada el 2026-07-13
Descripción de la oferta
Customer Data Analysis using SQL: Recently completed a hands-on Customer Data Analysis Project using SQL, where I explored and analyzed 81,446+ customer transaction records to uncover valuable business insights. Key Analysis Performed: Identified total transactions based on gender, product category, and payment method. Analyzed which gender purchased the highest number of products. Calculated total revenue generated by each gender. Compared category-wise transactions, units sold, and revenue. Evaluated purchase patterns across categories and genders. Examined payment method-wise revenue and transaction performance. Segmented customers into different age groups to analyze buying behavior. Found the age group with the highest product purchases. Identified the most frequent category, age, and gender combinations. Calculated average transaction value, total revenue, and units sold by payment method. Skills & Tools Used: SQL (Joins, Aggregations, Group By, Order By, CASE Statements, Revenue Calculations).Data Cleaning & Data Exploration Business Insight Generation This project helped me strengthen my SQL skills and understand how raw customer transaction data can be transformed into actionable insights for better business decision-making.
Skills
Fuente original: freelancer