April-hash/Market-Trends-and-Inflation-Analysis-in-Nigeria

A financial consulting firm wants insight into how inflation, foods prices and exchange rates are affecting consumer goods affordability in Nigeria or across Africa. As an analyst you must analyze public economic dataset to show patterns and proposed data driven recommendations. # Market-Trends-and-Inflation-Analysis-in-Nigeria (2008–2024) > A financial consulting firm wants insight into how inflation, foods prices and exchange rates are affecting consumer goods affordability in Nigeria or across Africa. As an analyst you must analyze public economic dataset to show patterns and proposed data driven recommendations. This project analyzes how inflation, food prices, transport costs, and crude oil exports affect consumer goods affordability in Nigeria between 2008 and 2024. --- ## 🎯 Project Objectives > Understand Nigeria’s inflation trend Compare inflation across key sectors Analyze the relationship between crude oil prices, exports, and inflation Identify the major drivers of rising cost of living --- ## 🧰 Tools & Technologies - **Excel** – Data cleaning and preprocessing - **Python** – Data analysis using Pandas and Matplotlib - **Power BI** – Interactive dashboards and visualizations - **PowerPoint** – Final presentation --- ## 📊 Key Insights - **Food and Transport** sectors show the highest inflation impact - **Crude oil exports** have a strong influence on inflation - Periods of falling oil exports align with inflation spikes --- ## 📂 Data Variables | Variable | Description | |--------|-------------| | `Inflation_Rate` | National inflation rate | | `CPI_Food` | Consumer price index for food | | `CPI_Transport` | Transport cost index | | `CPI_Health` | Health sector CPI | | `CPI_Education` | Education CPI | | `Crude_Oil_Price` | International crude oil price | | `Crude_Oil_Export` | Nigeria crude oil exports | | `Production` | Local production level | ---