Yash Solanki

I’m an IT graduate and Data Analyst focused on turning messy data into clear, executive-ready insights. I build dashboards and analytics products that help teams move faster with reliable, business-relevant signals.

In my current Data Analyst Intern role, I engineered and deployed the Visibility IQ Dashboard, a real-time Streamlit application integrated with SQL Server for monitoring battery health, device performance, and operational disruptions. I also designed an executive-level Looker Studio dashboard analyzing ₹1.85B+ in sales revenue across product categories, improving KPI visibility and leadership decision-making.

I’m hands-on with the full workflow—optimizing complex SQL queries and automating end-to-end reporting pipelines to reduce refresh time, improve data availability, and accelerate cross-functional reporting. I enjoy the practical challenge of making analytics not just accurate, but fast and easy to use.

My projects reflect the same drive: end-to-end sales analytics, predictive dashboards with interactive exploration, and a customer churn model using RFM segmentation and K-Means clustering (k=4) to support targeted retention. I bring strong feature engineering and exploratory analysis skills, and I’m motivated by work that turns insights into action through thoughtful visualization and modeling.