oluwasijibomibalogun-glitch/Market-Trends-and-Inflation-Impact-Analysis-

This data analytics project examines inflation trends across selected African countries to understand how rising consumer prices affect affordability, economic stability, and purchasing power. The study leverages CPI data to generate insights that support economic planning, pricing strategies, and policy interventions. Market Trends and Inflation Impact Analysis ## Description This data analytics project examines inflation trends across selected African countries to understand how rising consumer prices affect affordability, economic stability, and purchasing power. The study leverages CPI data to generate insights that support economic planning, pricing strategies, and policy interventions. ________________________________________ ## Project Overview The project analyses historical inflation data from 2011 to 2024 across Ghana, Kenya, Nigeria, Rwanda, and South Africa. Using Excel, Python, and Power BI, trends were explored, compared, and visualized to identify volatility patterns, stability levels, and regional economic differences. ## Data Sources: • World Bank CPI Dataset • IMF & National Bureau of Statistics (cross-referenced) Tools Used: • Excel (data cleaning & transformation) • Python (exploratory analysis & visualization) • Power BI (interactive dashboards) ________________________________________ ## Data Cleaning Actions • Removed missing and inconsistent CPI records • Standardized year and country naming formats • Validated inflation values through cross-referencing sources • Handled extreme outliers and formatting errors • Structured dataset for trend and dashboard analysis ________________________________________ ## Key Business Questions Answered 1. How has inflation changed across each country from 2011–2024? 2. Which countries experienced the highest inflation volatility? 3. Which economy maintained the most stable price levels? 4. What is the average inflation rate by country? 5. Are there periods of deflation or abnormal price movements? 6. How do regional inflation trends compare over time? 7. What economic risks emerge from sustained high inflation? 8. Which countries require targeted policy interventions? ________________________________________ ## Findings • Ghana and Nigeria recorded the highest inflation peaks over the study period • Nigeria maintained con …