SQL Project – Understanding Customers and Product Performance
Mohamed El Hamly
Data Scientist
Data Analyst
Python
SQL
Overview
Project Goal: Analyze sales data for scale model products to optimize inventory, marketing strategies, and customer acquisition
Project Outcome: Identified key products for restocking, segmented customers for targeted marketing, and used the customer lifetime value (CLTV) of $39,039.59 to guide customer acquisition investments
Project Methods: Analyzed a sales database with tables covering products, customers, and orders, evaluated stock levels and product performance, segmented customers by profitability, and calculated CLTV
