analytics-case-study

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

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.

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

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

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.