abhisheky1806/africa-food-export-excel

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 …