This is a business analytics project aimed at generating innovative analytics solutions for a Global Food Consulting firm working in the area of Animal agriculture and factory farming) .The objective is to analyze the given datasets from relevant firm's perspective in terms of implications and strategies which a country could adopt to manage the food resources efficiently and effectively.
Project
Background
Our world population is expected to grow from 7.3 billion today to 9.7 billion in the year 2050. Finding solutions for feeding the growing world population has become a hot topic for food and agriculture organizations, entrepreneurs and philanthropists. These solutions range from changing the way we grow our food to changing the way we eat. To make things harder, the world's climate is changing and it is both affecting and affected by the way we grow our food - agriculture. This dataset provides an insight on our worldwide food production - focusing on a comparison between food produced for human consumption and feed produced for animals.
Content
The Food and Agriculture Organization of the United Nations provides free access to food and agriculture data for over 245 countries and territories, from the year 1961 to the most recent update (depends on the dataset). One dataset from the FAO's database is the Food Balance Sheets. It presents a comprehensive picture of the pattern of a country's food supply during a specified reference period, the last time an update was loaded to the FAO database was in 2013. The food balance sheet shows for each food item the sources of supply and its utilization. This chunk of the dataset is focused on two utilizations of each food item available:
Food - refers to the total amount of the food item available as human food during the reference period.
Feed - refers to the quantity of the food item available for feeding to the livestock and poultry during the reference period.
Acknowledgements
This dataset was meticulously gathered, organized and published by the Food and Agriculture Organization of the United Nations. This project is taken from Kaggle.com
Basic Work:
Animal agriculture and factory farming is a growing interest of the public and of world leaders.
- Can you find interesting outliers in the data?
- What are the fastest growing countries in terms of food production\consumption?
- Compare between food and feed consumption.
Advanced Work:
Students could perform advance work by integrating other datasets with the given dataset (i.e data.worldbank.org) to explore following
- World Food production and consumption by per capita?
- world food production and consumption according to population density ( divided by population in each country ) in 2013 (particular year/s)
- Inequality of Food production/ consumption by region/continents?
- The global perspective of meat supply by region/continents? (Item Code 2731 to 2735 student have to check more carefully is there any item code which associated with meat).
Hint: Students could download the other datasets from the link above and then could using VLOOKUP formula to import the required field.
Your task is to complete the following tasks:
Task 1- Background information
Write a description of the selected dataset and project, and its importance for the global leaders. Information must be appropriately referenced. [1 Page]
Task 2 - Reporting / Dashboards
For your project, perform the relevant data analysis tasks listed under basic and advanced work and identify the BI reporting solution and/or dashboards you need to develop for the operational manager of the indicated firm. [2-3 Pages]
Task 3 - Research
Justify why these BI reporting solution/dashboards are chosen in Task 2 (Reporting / Dashboards) and why those data sets attributes are present and laid out in the fashion you proposed (feel free to include all other
relevant justifications).
Note: To ensure that you discuss this task properly, you must include visual samples of the reports you produce (i.e. the screenshots of the BI report/dashboard must be presented and explained in the written report; use ‘Snipping tool'), and also include any assumptions that you may have made about the analysis in your Task2 (i.e. the report to the operational team of the company).[3-4 Pages]
Task4 - Recommendations for CEO
The CEO of the consulting firm would like to improve the operations. Based on your BI analysis and the insights gained from "Data Set" in the lights of analysis performed in previous tasks, make some logical recommendations to the CEO, and justify why/how your proposal could enhance food related operations and could assist in achieving operational/strategic objectives with the help of appropriate references from peer-reviewed sources. [2-3 Pages].
Task 5 - Cover letter
Write a cover letter to the CEO of the chosen firm with the important data insights and recommendation to achieve operational/strategic objectives
Other Tasks -
Please refer to marking scheme at the end of the assignment for other tasks and expectations.