PrincessJoseph3124/MedRx-Pharmacy-Sales-Analysis

A comprehensive Excel pharmacy sales analytics solution for MedRx, covering revenue performance, product insights, regional analysis, and sales rep performance across Nigeria. The project spans January 2024 – May 2025 and tracks 8 drugs across 4 drug categories, 4 Nigerian regions, and 5 sales representatives. # MedRx Pharmacy Sales Analysis Dashboard > An interactive Excel-based business intelligence dashboard analyzing pharmaceutical sales performance across four Nigerian regions — built with raw transaction data, manual data cleaning, Pivot Tables, and fully designed dashboards. --- ## Dashboard Previews ### Sales Intelligence — Revenue & Trend Overview ### Market Pulse — Product Intelligence & Seasonal Demand --- ## Project Overview **MedRx** is a pharmacy sales analytics project designed to uncover revenue performance patterns, regional drug demand, sales rep efficiency, and seasonal consumption dynamics across Nigeria's pharmaceutical retail landscape. The project covers **2024–2025 fiscal data** spanning **502 transactions**, **8 drug SKUs**, **4 product categories**, **4 geographic regions**, and **5 sales representatives**. --- ## File Structure ``` MedRx-Pharmacy-Sales-Analysis ├── Pharmacy_Sales_Analysis.xlsx │ ├── Raw_Data ← Original unprocessed transaction log │ ├── Clean_Data ← Transformed & standardized dataset │ ├── Pivot_Analysis ← All aggregated pivot summaries │ ├── Sales Intelligence ← Dashboard 1 (KPIs, trends, regional breakdown) │ └── Market Pulse ← Dashboard 2 (Top drugs, seasonal demand, rep performance) ├── Raw_Data.png ├── Cleaned_Data.png ├── Pivot_Table.png ├── Sales_Intelligence.png ├── Market_Pulse.png └── README.md ``` --- ## Sheet 1 — Raw Data The **Raw_Data** sheet is the original, unprocessed transaction log as it was collected. It contains **14 columns** and intentionally includes real-world data quality issues that needed to be resolved before analysis. **Columns in Raw_Data:** | Column | Description | |---|---| | `Date` | Transaction date | | `Region ID` | Regional code (e.g., WN/101, NN/101) | | `Region` | Geographic region name | | `DRUG ID` | Short drug identifier code | | `Drug Name` | Product name | | `Category ID` | Drug class code | | `Category` | Drug class name | …