Case Studies

Detailed project narratives highlighting business impact, analytics approach, and technical execution.

Browse

Smart Report Analyzer — LLM/Agent pipeline for report parsing & executive summaries Sales Data Analysis Forecasting — Demand forecasting & scenario planning Cost of Living Index — Market affordability comparisons Paris Olympics 2024 Medal Tracker — Real-time medal data

Smart Report Analyzer

GenAI / LLMAutomationExecutive Insights

Problem

Business teams spent excessive time manually reviewing reports (PDF, Excel, CSV), delaying insights for strategy and compliance.

Approach

  • LLM-powered parsing for structured/unstructured data; concise executive summaries.
  • Automated charting & anomaly surfacing; consistent outputs via STAR-style prompts.

Tools

Python, Hugging Face, LangChain/Agents, Pandas, Power BI

Impact

  • ~60% faster report review (placeholder—replace with your metric).
  • Insights distributed to 20+ stakeholders via shareable summaries.
GitHub Back to Projects

Sales Data Analysis Forecasting

ForecastingTime-SeriesPlanning

Problem

Leadership faced unpredictable demand, leading to inventory mismatches across business units.

Approach

  • ARIMA/Prophet models with seasonality; validation vs. live pipeline data.
  • Power BI dashboards with scenario planning and error bands.

Tools

SQL, Python (Pandas, statsmodels/Prophet), Power BI, Excel

Impact

  • ~20% MAPE improvement (placeholder—replace with your metric).
  • Reduced stockouts/excess; supported up to ~$500K savings.
GitHub Back to Projects

Cost of Living Index (Streamlit)

StreamlitPipelinesDecision Support

Problem

Teams needed standardized, comparable cost-of-living metrics to evaluate market entry feasibility.

Approach

  • Interactive Streamlit app; normalization across CPI, rent, groceries.
  • Filters, comparisons, and downloadable reports.

Tools

Python, Streamlit, Plotly, Pandas

Impact

  • ~40+ analyst hours/month saved (placeholder—replace with your metric).
  • Real-time comparisons for 50+ countries.
GitHub Back to Projects

Paris Olympics 2024 Medal Tracker

APIsDashboardsReal-time

Problem

Media teams needed up-to-date medal standings to support timely coverage.

Approach

  • Ingested official feeds; country/sport breakdowns; filters for day/country/event.
  • Shareable, interactive views for editorial & marketing.

Tools

Python, REST APIs, Power BI / Plotly

Impact

  • Real-time medal data for 100+ stakeholders.
  • Higher dashboard engagement; fewer manual updates.
GitHub Back to Projects