ajay gupta

Associate - Analytics

Physics Wallah Pvt. Ltd.

Oct 2023 - Present

Designed and deployed key dashboards across Admissions, ARPU, and Sales in Power BI, providing day-to-day business information and actionable insights to enable data-driven decision-making for leadership, ensuring 98% accuracy. Built an automated Marketing Budget & Spend Tracker dashboard in Google Sheets, enabling real-time monitoring of budget utilization across multiple cohorts, reducing manual effort by 80%. Conducted customer behavior and engagement analysis to identify high-potential leads for PI Tab purchases based on interactions and subscription patterns, contributing to a 10% increase in sales. Performed funnel analysis across multiple marketing campaigns to analyse organizational and channel-level data to track lead presence, engagement, and activity trends, resulting in better resource allocation. Managed academic and non-academic KPI-based monthly contests among 120+ offline centres that help analyse their performance on various levels and identify areas for improvement. Addressed 50+ ad-hoc data requests with high-priority insights that influenced key decisions across marketing, finance, and operations, improving turnaround by 40%. Automated lead updates and calling summaries by integrating Python with Google Sheets, enabling real-time data synchronization across multiple sheets and providing live summaries. Served as the Power BI SPOC for offline vertical teams, handling 20+ requests—from building dataflows, data models to implementing Power Query transformations, measures, row-level security (RLS), visualizations, etc. Developed dbt models to streamline high-volume datasets, reducing refresh time by 30-40%. Conducted Sanity checks, ensuring 95% accuracy and compliance with organizational policies. Supported Annual Operating Plan (AOP) and Profit & Loss (P&L) analysis across 150+ centers, enabling accurate financial planning and performance tracking. Analyzed dynamic AOP and P&L requirements, delivering actionable financial insights on discount, cost, and revenue optimization that improved financial efficiency by 20%.