dj-tiayon/Fake-Drug-Detection-Via-Pharmacy-Sales-Analytics

This project analyzes pharmacy sales transactions to identify suspicious drug distribution patterns that may indicate counterfeit or substandard medicines within the pharmaceutical supply chain in Nigeria. # Fake Drug Detection via Pharmacy Sales Analytics **Using Excel and Power BI to identify suspicious pharmaceutical distribution patterns and support counterfeit drug monitoring in Nigeria.** ## 📌 Project Overview This project analyzes pharmacy sales transactions to identify suspicious drug distribution patterns that may indicate counterfeit or substandard medicines within the pharmaceutical supply chain in Nigeria. Using Excel and Power BI, the analysis focuses on detecting anomalies related to unusually low drug prices, abnormal sales quantities, unknown brands, supplier behavior, and near-expiry drugs. An interactive Power BI dashboard was developed to support data-driven decision-making by helping stakeholders: - 💊 Detect suspicious drug transactions - 🚨 Identify high-risk suppliers and pharmacies - 📉 Monitor unusual pricing and sales patterns - 🔍 Investigate potential counterfeit drug activity - 🏥 Support public health monitoring and regulatory actions The project combines anomaly detection, risk scoring, and business storytelling techniques to transform raw pharmacy sales data into actionable insights for non-technical stakeholders. ## 🚨 Business Problem Counterfeit and substandard medicines remain a major public health challenge in Nigeria, particularly in areas where pharmaceutical supply chains are difficult to monitor and regulate effectively. Suspicious activities such as unusually low drug prices, unknown brands, abnormal sales spikes, unreliable suppliers, and near-expiry drugs can easily go unnoticed when relying solely on manual inspections and traditional monitoring methods. To support better pharmaceutical surveillance and risk monitoring, this project analyzes pharmacy sales data to answer the following key business questions: 1. 💰 Which pharmacies sell drugs at significantly lower prices than expected? 2. 🏷️ Are there brands with high sales volumes but unknown or unverified origins? 3. 🚚 Are specific suppliers frequently associated with …