Yash Chavan

Supported the owner and small team with sales tracking and digital reporting across the Spice Junction online grocery platform and physical store. Maintained weekly Excel records for 80–100 online orders and in-store sales, tracking revenue by product category. Set up basic Google Analytics views to monitor website traffic, top-visited product pages, and drop-off points across the checkout flow. Created simple monthly reports summarising best-selling SKUs, seasonal demand patterns, and stock movement across

Worked within a 3-person BI team delivering weekly reporting cycles for two business units. Designed and maintained 2 Tableau dashboards tracking 6 core KPIs, enabling data-backed management decisions every week. Authored 15+ SQL queries on datasets of around 5,000–8,000 rows, improving report turnaround time for the team. Standardised KPI definitions and documented data processes to keep reporting consistent across departments.

Worked across 3 active client projects in a fast-paced agency setting, handling the full cycle from raw data collection through to final reporting. Gathered and structured website performance data on a weekly basis, turning unorganised exports into clear, presentation-ready summaries. Developed monthly performance snapshots using Excel, covering audience behaviour, channel attribution, and content engagement metrics. Contributed to search visibility research for 2 clients by mapping out relevant keyword opp