operations-analysis

Property Management analytics case study focused on portfolio profitability, pricing opportunities, operating costs, and owner decision-making.

Supply chain operations dashboard built in Google Looker Studio tracking sales by category, late delivery risk, and order volume trends across 180,000+ orders.

SQL operations analysis using the Northwind database revenue, fulfillment speed, employee workload, and customer inactivity.

Lean Six Sigma DMAIC case study demonstrating statistical analysis, root cause analysis, and process improvement in a manufacturing environment.

SQL portfolio project analyzing sales, customers, products, regional performance, profitability, returns, and shipping operations.

Project analyzing Metrocar user funnel, ride lifecycle, cancellations, waiting time, and platform performance using SQL, Excel, and Power BI.

Business Analyst case study analyzing cold storage retail operations, checkout queue bottlenecks, staffing gaps, workforce management, customer experience, and process improvement opportunities.

Healthcare workflow automation case study for prior authorization readiness using Python, JSON-style contracts, and rule-based validation.

Transformed restaurant chain POS data into actionable staffing and operational insights, identifying 33% higher weekend demand and peak hour patterns across five locations.

Operations & Performance Analysis of Shishu Mela Theme Park using Power BI (Dashboard), SPSS (Hypothesis Testing), and BigML (Decision Tree).

Interactive Power BI dashboard analyzing sales, profitability, products, customers, regions, returns, and shipping performance.