Animal Feeding Company

D.Z Company Data Analysis Report
Project Title: Customer Analysis for D.Z's Company
Report Prepared by: Mohamed Azzaz, Data Analyst
Date: June 2024

Executive Summary
This report analyzes customer behavior for D.Z's company during the period from January 2023 to December 2023. The main goal was to discover customer behavior and product performance to support decision-making. Customers were segmented using the RFM model, revealing that the majority of customers belong to the Gold category, which is the most active and contributes the highest revenue. We also identified the customers who have been lost and those who are at risk of being lost. The company should target these two segments with appropriate promotions and campaigns to determine why they stopped purchasing from the company.

The main sales results indicate a seasonal increase in sales during December, with feed products being the largest contributor to revenue. Recommendations include increasing stock during high-demand months and promoting products in the low-demand months that did not perform well, using targeted marketing campaigns.

Despite the stoppage of sales in the chick division in June, the company’s revenue was not affected. On the contrary, it significantly increased due to the focus on selling feed products. This analysis was conducted using Python, Excel, and Power BI, incorporating descriptive statistics and trend analysis.