SAMYAK KATIYAR

Driven Data Analyst skilled in SQL, Power BI, DAX & Excel. Developed 3 interactive dashboards that analyzed sales performance, tracked KPIs, and forecasted trends—contributing to 15% YoY sales growth and identifying top-performing customers driving 30% of revenue. Seeking Business Analytics internship to leverage data modeling and visualization skills for actionable insights.

Power BI Hospital ER Operations Dashboard | Healthcare Analytics

• Analyzed 9,216 ER records to optimize workflows and patient experience
• Revealed critical insights: 35.3 min avg wait time, 4.99/10 satisfaction, peak volumes at 11AM/1PM/7PM/11PM
• Identified top referral departments (General Practice: 1,840 cases) and admission trends (4,612 admitted)
• Enabled data-driven staffing decisions to reduce wait times
• Enabled data-driven decisions to reduce wait times and improve patient experience

Mobile Sales Analytics Dashboard | Power BI, DAX, Power Query

• Developed 3 interactive dashboards analyzing 12+ months of sales data, tracking 15+ KPIs including YOY growth, daily sales vs. targets, and pricing impact
• Identified top 5% of customers driving 30% of revenue ($2.1M), enabling targeted retention strategies
• Forecasted sales trends with 92% accuracy using DAX measures, informing inventory planning for 3 product categories