Logo Lanfrica
  • Home
  • Atlas
  • Insights
  • Docs
  • Sign in

© 2026 Lanfrica. All rights reserved. All copyrights of the resources shown on the Lanfrica website belong to the original copyright holders, unless explicitly stated otherwise.

nafisalawalidris/HiCi-African-Foods

Domain:

agriculture
Creator:
naf
Host:
HiCi African Foods: Excel dashboard & pivot table analysis of EU food rejection data to identify risks & recommend focus areas for market expansion. HiCi African Foods - Excel Dashboard and Pivot Table Project Overview This project focuses on analyzing and visualizing data related to HiCi African Foods' expansion into the European Union market. The goal is to identify potential risks and provide insights for overcoming regulatory hurdles using an Excel dashboard and pivot tables. Data Cleaning Prior to analysis, the raw data from the EU Food Safety Standard Agency Portal was subjected to a data cleaning process to ensure accuracy and reliability. This included handling missing values, removing duplicates, and standardizing inconsistent data points. Excel Dashboard An Excel dashboard was created to present key findings and visualizations from the data analysis. The dashboard includes interactive charts, tables, and pivot tables to provide an intuitive and comprehensive view of the data. Pivot Tables Pivot tables were utilized to aggregate and summarize the data, enabling easy exploration and identification of trends. The pivot tables allow for dynamic grouping, filtering, and calculation of metrics, providing valuable insights into the food rejection patterns and associated factors. Findings and Recommendations Based on the analysis, the following key determinants were identified: The EU member country with the highest number of food rejections. The most rejected food products. The country of origin for the most rejected food products. The most common actions taken against food exported to the EU. The most reported origin (country) of food exports. Additionally, risks associated with different food products were evaluated. Recommendations for HiCi African Foods management were provided based on the identified risks, emphasizing the need to focus on specific food products to mitigate potential regulatory hurdles. Getting Started To reproduce the analysis and view the Excel dashboard: Obtain the raw data from the EU Food Safety Standard Agency Portal. Perform data cleaning using the appropriate software or …

Visit

github.com

Tags

data-analysisdata-cleaningdata-visualizationeu-food-rejectionexcel-dashboardhici-african-foodsmarket-expansionpivot-tables

Similar

African Foods Datasetsadechisomeje/west-african-foodsAfrican Foods Dataset (Ghana & Cameroon)Characterization of five African staple foodsAfrican Sorghum-Based Fermented Foods: Past, Current and Future ProspectsSENSORY TEXTURE PROFILE OF AFRICAN FOODS MADE FROM YAM AND CASSAVA

African Foods Datasets

This data represents 6 different foods from Ghana and Cameroon. Data was collected from different so

adechisomeje/west-african-foods

# west-african-foods Structured nutrition data for West African foods — with the aliases, household

African Foods Dataset (Ghana & Cameroon)

Food recognition systems, AI training for food classification, cultural preservation, nutrition stud

Characterization of five African staple foods

This data was obtained as part of a project to develop and implement analysis methods to characteris

African Sorghum-Based Fermented Foods: Past, Current and Future Prospects

Sorghum (Sorghum bicolor) is a well-known drought and climate resistant crop with vast food use for

SENSORY TEXTURE PROFILE OF AFRICAN FOODS MADE FROM YAM AND CASSAVA

The textural characteristics of African foods made from yam and cassava were characterized by the se