Data Analyst at Spardha School of Music,Pune

Dipali Salunke  • Peerlist

<p>Built an interactive Retail Superstore Sales dashboard using a synthetic 1,000‑order dataset to analyze performance across time, products, customers, regions, and shipping modes. The dashboard highlights key KPIs (Sales, Profit, Profit Margin), trends by month and year, and drilldowns into categories/sub‑categories and top products. Geographic views reveal regional opportunities, while customer segmentation and Pareto analysis surface high‑value cohorts for targeted retention and upsell. Operational insights include average shipping time by ship mode and its relationship to repeat purchase behavior, informing logistics optimization. The project showcases end‑to‑end skills in data prep, modeling, and dashboard design for decision‑ready insights.</p>

Sales Performance Analysis Dashboard

Data Analytics professional at Schenider Electric having 2+ years of experience with Excel,SQL, Python,Tableau

<p>As a data analyst, I conducted an in-depth analysis of historical data from a pizza shop to identify factors contributing to a decline in revenue and areas for improvement. Through the examination of various key performance indicators (KPIs), I focused on seasonal variations, top-selling and bottom-selling pizzas, and compared attributes such as pricing, ingredients, size, and preparation methods between the bestsellers and worstsellers. This comprehensive analysis aims to provide actionable insights for the pizza shop, enabling better management of staff allocation during peak and off-peak seasons, as well as the strategic utilization of offers and promotions to enhance overall&nbsp;performance.</p>