I built a sales and inventory analysis project for a pharmacy chain, turning data from four source datasets into validated, decision-ready insights.
Using SQL, I analyzed revenue, gross profit, transactions, and sales trends across products, branches, and customers. CTEs and window functions helped me calculate month-over-month growth.
I also assessed inventory risk across four branches using stock levels, sales velocity, and days of inventory cover to flag overstocked and stockout-risk products.
I created an interactive Tableau executive dashboard with KPI cards, time-series analysis, branch and category comparisons, and user-controlled filters. My toolkit includes SQL, Excel, Tableau, and Python, alongside my pharmacy education.
