operations-analysis

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

Analysis of food delivery delays using Python, Pandas, NumPy, and Tableau, focusing on traffic, peak hours, and vehicle performance.

Tableau dashboard for takeout platform store operations: traffic funnel, ad ROI, customer mix and delivery distribution across 11 stores on Meituan and Eleme

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

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

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

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

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.

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).

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

Industrial Engineering operations optimization project using Excel, SQL, Power BI, and Lean Six Sigma to analyze throughput, yield, downtime, quality, and pickup performance.

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

Power BI customer support analytics project covering SLA compliance, ticket operations, escalation risk and workforce capacity.