Projects

An end-to-end business intelligence and analytics solution designed to evaluate flight ticket pricing dynamics, route yield efficiency, and carrier market share. Raw booking transactions undergo statistical quality control and feature engineering in Python before powering an interactive 4-page Power BI dashboard featuring dynamic pricing elasticity models, city-pair route heatmaps, and competitive airline benchmarking.

An end-to-end HR Analytics project examining workforce composition, employee attrition patterns, job satisfaction, and department-level trends across 1,470 employee records. Features PostgreSQL database scripts for complex aggregation queries, Microsoft Excel calculations and pivot tables, and an interactive Power BI dashboard.

Cleaned and modeled India-wide State/UT healthcare metrics across zones (North, South, East, West, Central) using Advanced Excel & SQL. Created dynamic Pivot Tables and KPI index cards tracking Total Cases, Active Infections, Discharge Averages, and Mortality Ratios. Designed an executive dashboard with interactive slicers and zone-wise trend charts to evaluate recovery benchmarks across states.

Conducted Exploratory Data Analysis (EDA) on the global Netflix dataset using Python and Power BI to uncover media release trends. Built an interactive Power BI report visualizing movie vs. TV show distribution, top genre saturation, avg rating splits, and release velocity.