DealDive
Built a dynamic Power BI and Excel dashboard analyzing 1,000+ Shark Tank India pitches, including funding, equity, sector, deal success patterns, investor trends, funding trends, and high-performing sectors to support startup advisory and pitch improvements.
CareNavigator
Created a Power BI and Excel dashboard analyzing 10K+ monthly inpatient and outpatient patient records, highlighting operational bottlenecks and peak admission periods to optimize staffing; improved patient satisfaction by 25% through enhanced tracking and resource allocation.
Topping and Trends
Designed MySQL queries to analyze over 10,000 pizza orders, performed cohort and time-series analysis, identified that weekend evenings contributed 22% of sales volume, and improved inventory efficiency by 12% through low-performing SKU analysis.
Youtube Insights
Developed a powerful analytics tool to extract meaningful insights from YouTube data using the YouTube Data API v3. The project analyzes video performance, country-wise trending content, and comment sentiment through both a CLI and an interactive Streamlit web app. It converts raw data into clear dashboards and charts, enabling data-driven decisions for content optimization and audience growth.
Email-Echoes
Designed a minimalistic, insight-focused Power BI dashboard to analyze email communication performance. The solution tracks open rates, click-through rates, delivery status, and engagement trends through interactive reports. With a calm, clutter-free UI and dynamic filters for date, campaign, audience, and region, ZenMail enables clear performance tracking, helping teams identify high-performing emails and optimize communication strategies efficiently.
Care - Navigator
Designed and implemented a data-driven care navigation system that unified patient records, appointment histories, and referral data into a secure relational architecture. Built analytical workflows to monitor engagement metrics and utilization trends, enabling proactive interventions. The solution improved service turnaround time by 35%, increased follow-up adherence by 25%, and enhanced real-time operational visibility while maintaining regulatory compliance.