Grocery Spend Analysis

Project involved a comprehensive analysis of household grocery spending patterns and creating a Looker Studio dashboard to visualize key metrics and insights. The analysis covered over multiple years of transaction data across multiple grocery brands and categories. Primary goals: Identify trends in total grocery spend, number of visits, and average costs over time Break down spending by grocery brand, category, and specific items Quantify the impacts of price inflation on the grocery basket Develop a dashboard to monitor metrics and extract insights Analysis Components: Gathered and preprocessed raw transaction data from multiple sources Performed data wrangling and transformation to calculate derived metrics Analyzed total spend, visits, brand/category breakdowns using visualizations Tracked top purchased items, spend per item, monthly changes Measured year-over-year price inflation across the product basket Built an interactive dashboard with charts, tables, and filtering capabilities Processes: Data cleaning and preprocessing Exploratory data analysis Data visualization (charts, graphs, tables) Dashboard design and development