POWER BI Dashboard

Data Analyst (DBS)– Al-Dawaa Pharmacies

Built a Power BI performance dashboard to monitor agent KPIs and pharmacy sales

Analyzed insurance vs cash sales trends, branch performance, and agent achievements

Delivered insights that supported decision-making and improved sales performance

Cleaned and prepared raw data using Excel and Power Query, fixing missing values, and ensuring data accuracy

Built DAX measures to calculate key performance indicators (KPIs) including

Total Sales, Insurance vs Cash Sales Ratio, Sales per Agent, Sales per Pharmacy / Region, Target Achievement %

Developed interactive visuals with slicers (Date, Region, Pharmacy, Agent)