Hotel Booking Analysis & Revenue Optimization
Analyzed 119,000+ booking records using Python, SQL, and Power BI to identify drivers of cancellations and revenue loss. Built an interactive KPI dashboard covering cancellation rate, ADR, and booking channels; identified the relationship between longer lead times and cancellation probability; recommended pricing and overbooking strategies to reduce revenue leakage.
Retail Transaction Analysis & Customer Segmentation
Performed transaction-level analysis using Python, SQL, and Excel to identify high-value customer segments and product performance. Built KPI-based reports with Pivot Tables and Lookups, identified top revenue-contributing customer segments, and suggested targeted marketing strategies to improve retention and profitability.
Credit Risk Analysis (Fintech Case Study)
Analyzed loan datasets using Python and SQL to identify patterns in customer default behavior. Segmented customers into risk categories based on financial attributes, generated insights for risk-based decision-making, and recommended strategies to minimize default rates and improve approval efficiency.