Blossom-Africa/Ghana-Food-Prices

# Ghana Food Prices Dashboard This repository contains an interactive dashboard analyzing food price trends across 10 regions in Ghana over an 18-year period. The data explores the fluctuations in average prices for various food items such as cereals, tubers, meats, fruits, and vegetables, with a special focus on rice (local vs imported). ## Key Features - **Regional Price Comparisons**: Visualizes price differences across Ghana's regions to understand regional market trends. - **Product Category Breakdown**: Provides insights into the pricing of different food categories (e.g., cereals, meat, fish, vegetables). - **Rice Analysis**: Focuses on local vs imported rice pricing, highlighting import reliance and domestic production issues. - **Seasonal Trends**: Shows price variations by month and year, highlighting the effects of seasonality and long-term trends. - **Interactive Filters**: Users can filter data by year, region, product type, and individual food items for more granular insights. ## Technologies Used - **Power BI/Excel/Power Query**: For data visualization and report generation. - **Python**: For data processing and analysis (if applicable). - **GIS Mapping**: Integrates map-based visualizations to show geographical price distributions. ## How to Use 1. Open the pbix file in your Power BI to interact with the data filters. 2. Explore food price trends by adjusting the filters based on region, year, and food categories. ## Data Source The data for this analysis was sourced from the "World Food Programme Price Database" tracking food prices across Ghana. ## Insights Key takeaways from the analysis include: Price variations are significant between regions, with urbanized areas showing higher costs. Imported rice is consistently priced higher than local rice, emphasizing the need for increased local production. Food prices show clear seasonal variations, with dips and peaks aligned with harvest seasons and economic conditions. ## Sneak Peak