Havila Boddepalli

Consumer Buying Behavior Analysis – Domino’s Pizza (MIHAN, Nagpur)

Conducted end-to-end market research to analyze consumer buying behavior for Domino’s Pizza to assess feasibility of a new outlet in MIHAN, Nagpur. Executed exploratory (FGDs, in-depth interviews) and conclusive research (online surveys) to evaluate customer preferences, awareness, and purchase drivers. Performed data analysis using ANOVA, factor analysis, cross-tabulation, and Van Westendorp pricing model to identify optimal price points and key satisfaction factors. Delivered actionable recommendations on pricing, menu strategy, delivery vs. dine-in feasibility, and customer experience to support business expansion decisions.

Sales Performance & Profitability Dashboard | Power BI

- Built an optimised star schema data model to improve performance and scalability. - Developed KPI framework tracking Revenue ($140M+), 9M units sold, 25K shipments, and 57% profit margin. - Implemented advanced DAX time intelligence (CY vs PY, YTD, MTD) for trend comparison and growth tracking. - Created dynamic Top-N ranking measures for products and salespersons. - Designed shipment distribution analysis to identify order quantity patterns. - Automated monthly reporting, reducing manual effort and improving reporting accuracy. - Identified high-margin products (up to 68%) and loss-making SKUs (-34%), enabling margin optimisation and portfolio rationalisation. - Analysed geographic revenue contribution to prioritise high-performing markets (~29% revenue share region). - Evaluated salesperson productivity using revenue, volume, and profit contribution metrics. - Enabled leadership to detect margin leakages and refine pricing strategy. - Strengthened data-driven decision-making.