This project analyzes Consumer Price Index (CPI) Inflation data to identify inflation trends, category-wise contributions, and key drivers impacting overall inflation.
The analysis was performed using Microsoft Excel, Power Query, Pivot Tables, and Data Visualization techniques.
The objective of this project is to:
- Analyze CPI inflation trends over time
- Identify major inflation-driving categories
- Compare Food and Non-Food inflation
- Perform Year-over-Year (YoY) analysis
- Generate actionable business insights
- Microsoft Excel
- Power Query
- Pivot Tables
- Pivot Charts
- Data Cleaning
- Data Analysis
- Data Visualization
- Period Covered: 2013–2023
- Sectors: Rural, Urban, Rural + Urban
- Records Analyzed: 10,000+
- Categories: Food, Housing, Fuel, Health, Education, Transport, etc.
- Removed errors and null values
- Standardized data types
- Validated category information
- Unpivoted data using Power Query
- Created category mapping
- Built analytical tables
- Overall CPI trend
- Year-over-Year inflation growth
- Monthly inflation patterns
- Food Inflation
- Non-Food Inflation
- Inflation Drivers
- Category Contribution Analysis
- Food & Beverages are major contributors to CPI inflation.
- Vegetables show the highest volatility among food categories.
- Fuel & Light significantly impact Transport inflation.
- Health and Education demonstrate steady long-term inflation growth.
- CPI inflation accelerated in recent years.
The findings help understand:
- Cost of living changes
- Consumer spending patterns
- Inflation risks
- Economic planning considerations
Sadhana Pal
Aspiring Data Analyst | Excel | Power Query | Data Visualization | Business Analytics