analytics-case-study

End-to-end Power BI analytics project on profitability, revenue growth, and commercial performance using Adventure Works.

End-to-end fintech analytics case study analyzing user behavior, churn, transaction trends, and pricing strategy using Power BI.

Affinity-based consumer segmentation analysis linking product attributes to distinct customer personas, with strategic implications for pricing, positioning, and portfolio design.

Cleaned and analyzed real-world public transit delay data using Python (pandas, NumPy) with Matplotlib/Seaborn visualizations to uncover temporal and route-level reliability patterns.

Advanced SQL analytics project demonstrating CTE layering, window functions, percentile modeling, and structured data transformations.

A customer attrition risk tool built with SQL and Power BI. The project transforms raw banking data into a weighted scorecard to identify high-risk customers, surfacing a Critical segment with a 90% churn rate, a 4.4x lift over the ~20% baseline. Outputs an actionable Hit List to enable proactive, data-driven retention strategies.