Yash Panwala

Data Analyst with 1+ year of experience turning large-scale, messy datasets into executive-ready dashboards and automated reporting pipelines. Specialized in Power BI dashboard development, SQL query optimization, and Python-based EDA across retail, customer, and healthcare domains. Proven ability to reduce manual reporting overhead, surface churn and revenue insights, and present findings directly to business stakeholders.

Actively applying data governance best practices and A/B testing frameworks to improve data quality and decision-making speed.

Data Analyst at CodeInYourself (2025-04 – Present)

• Improved data accuracy by 15% across 20,000+ records, as measured by pre/post data quality audits, by designing and enforcing a data governance framework using Python (Pandas, NumPy) — including null handling, deduplication, and format standardization — and presenting findings in weekly stakeholder reviews.
• Reduced manual reporting time by 3 hours per week, as measured by team time-tracking logs, by writing 40+ optimized SQL queries (joins, window functions, CTEs, subqueries) to automate data extraction and transformation pipelines within MySQL.
• Enabled real-time business monitoring for executive decision-making, as measured by adoption across 3 business units, by designing and deploying 5+ interactive Power BI dashboards tracking KPIs including revenue trends, customer retention, and operational performance — presented in monthly business reviews.
• Achieved 75% prediction accuracy on structured business datasets, as measured by held-out test set evaluation, by contributing to 3+ machine learning models in scikit-learn — covering feature engineering, hypothesis testing, and A/B testing to ensure statistical rigor.
• Reduced data-to-insight turnaround time by 20%, as measured by stakeholder feedback across quarterly reporting cycles, by collaborating with cross-functional teams to translate business questions into analytical frameworks and delivering structured data storytelling reports to support executive decision-making.

Bachelor of Commerce in Commerce – Aggarwal Vidhya Vihar College, Veer Narmad South Gujarat University (2022 – 2025)

Higher Secondary Certificate in Commerce – L.N.B. Daliaya School (2019 – 2021)