Belal1khalil/pharmacy-sales-analysis

Exploratory analysis of 10,000 pharmacy transactions (2023–2024) revealing sales trends, profit margins, and customer patterns across an 8-branch pharmacy chain in Egypt. This project analyzes 10,000 pharmacy transactions spanning January 2023 to December 2024 across 8 branches in 6 Egyptian governorates. The goal is to turn raw sales records into clear, actionable insights on revenue drivers, profit margins, customer behavior, and operational performance — the kind of analysis a pharmacy chain could use to guide inventory, staffing, and marketing decisions. Key Findings Revenue & Profitability Total revenue: EGP 114,182.61 · Total profit: EGP 38,095.71 · Overall profit margin: 33.4% Average basket value: EGP 11.42 per transaction Vitamins carry the highest profit margin (39.6%), while Diabetes medication has the lowest (27.4%) despite being the top revenue category — consistent with cost-heavy chronic care products like insulin. Top Performers Diabetes is the top-selling category overall; Insulin is the single best-selling product. Tanta branch and Cairo city lead in total sales. LifeMed is the most profitable supplier, contributing ~33% of total profit despite not being the highest-volume supplier. Customer Behavior Customers are nearly evenly split by gender (50.6% male / 49.4% female) with an average age of 48.9 years, skewing toward an older, chronic-condition customer base. Prescription medicines drive 54.2% of total sales value vs. 45.8% for over-the-counter products. Mobile Wallet is the most popular payment method (25.2% of transactions), reflecting strong digital payment adoption