Household Consumption Analysis

Executive Overview

This dashboard is a high-powered market intelligence tool designed to digitize the 2023-24 Household Integrated Economic Survey (HIES) data. It allows users to explore the consumption habits of 38.3 Million Pakistani Households across 285+ commodities, providing instant insights into market size, pricing, and consumer demographics.

🚀 Key Capabilities & Features

1. Dynamic Market Sizing Engine

• Automated Valuation: Instantly calculates the Total Monthly Market Size (in PKR) for any selected item (e.g., Rice, Milk, Electricity, Footwear) by extrapolating survey data against the 2023 Census household count.

• Volume vs. Value: Analyzes both the prevalence of consumption (% of households buying) and the expenditure (median amount spent).

2. Granular Demographic Segmentation

• Provincial Analysis: Compare consumption patterns across Punjab, Sindh, KPK, and Balochistan. Identifies which province drives demand for specific goods.

• Urban vs. Rural Split: Visualizes the divide between city and village consumption, crucial for distribution planning.

3. Economic Class (Quintile) Analysis

• Rich vs. Poor Dynamics: Breaks down data into 5 Income Quintiles (Poorest 20% to Richest 20%).

• Spending Power: Shows how expenditure shifts as household income rises (e.g., distinguishing between basic necessities vs. luxury goods).

4. Item-Level Search & Discovery

• Universal Search: A searchable dropdown containing 285+ distinct items, ranging from food staples (Wheat, Sugar) to utilities (Gas, Internet) and lifestyle goods.

• Median Price Discovery: Uses median expenditure values to remove outliers, providing a realistic view of what the “average” Pakistani household spends.

5. Interactive Visualization Suite

• KPI Cards: Top-level metrics showing Penetration Rate (%), Average Spend (PKR), and Total Market Cap (PKR Millions).

• Geo-Spatial Proxies: Bar charts representing provincial market share.

• Trend Charts: Line and area charts visualizing expenditure curves across income groups.

🎯 Strategic Use Cases

• FMCG & Retail: Estimate total addressable market (TAM) for product launches.

• Public Policy: Monitor inflation impact on essential food items across poor vs. rich households.

• Marketing: Targeted advertising based on Urban/Rural or Provincial prevalence.