In this project, I developed an interactive HR analytics dashboard that enables organizations to monitor employee attrition, workforce demographics, job satisfaction, and departmental trends in a single view, using DAX-driven KPIs, intuitive visual storytelling, and data-driven insights to support HR decision-making and employee retention strategies.
In this project, I analysed Northwind's operations across five tables using advanced SQL to assess revenue trends, product performance, customer segmentation, and employee sales rankings leveraging CTEs, window functions, and RFM modelling to surface actionable business insights.
A three-page interactive Power BI dashboard analysing 16,000+ daily pharmacy sales records across 8 ATC drug categories from 2014–2019. Built on a star schema data model with a custom Date Table and 8 DAX measures covering time intelligence, rolling averages, and month-over-month and year-over-year growth calculations. Features include dynamic slicers, cross-page sync filters, conditional formatting, and a custom tooltip page surfacing ATC drug category references on hover. Key finding: Paracetamol (N02BE) accounts for 49% of total sales volume with a notable autumn demand spike, while respiratory drugs (R03) peak sharply in December, consistent with seasonal flu patterns.
Tools: Power BI Desktop · DAX · Power Query · Data Modelling
In this project, I built an interactive Netflix analytics dashboard that provides insights into movies and TV shows across genres, ratings, release trends, and global distribution in a single report view, using DAX-powered KPIs, dynamic visualizations, and storytelling-focused dashboard design.