FAISAL BIN FORHAD

Implemented K-Means clustering on e-commerce data, uncovering 5 distinct customer segments based on their order behavior.

Identified critical segments such as high-value free users, low-spending trial users, premium customers, and lifetime buyers with low satisfaction ratings.

Developed data-driven strategies to upsell free users, enhance retention for top spenders, and improve satisfaction for lifetime customers.

Developed an interactive Power BI dashboard utilizing a star schema with 7 datasets and over 10,000 sales records to analyze 2 years of FMCG performance across 4 regions.

Identified a 22.2% Year-over-Year sales drop despite a 6.1% order growth, revealing a shrinking basket size.

Provided strategic recommendations to enhance customer loyalty in Dhaka (addressing a 3% gap), introduce high-revenue personal care items, and optimize online channel offerings.

Segmented over 2,800 car sales records using MySQL, classifying 90+ unique customers based on purchasing behavior.

Computed Recency, Frequency, and Monetary scores to group customers into distinct segments.

Identified key customer segments, including 35% Champions and 16% Churned, to inform data-driven marketing and retention strategies.

Analyzed 3 years of sales data (2019-2021) using Excel Power Pivot, identifying a 137% revenue growth and a 12% gross margin decline in 2021.

Identified that a single retail channel drove over 70% of sales with the lowest gross margin, while new products contributed 52.9% to 2021 sales.

Proposed strategic recommendations, including pricing resets, Europe market expansion, and channel optimization, projected to recover 5-7% gross margin.