Business Analytics Project: ITECH7407 Real Time Analytics, Sem 3, 2018

This ITECH7407 project analyzes a dataset from the United Nations’ Food and Agriculture Organization (FAO) using Tableau. The project focuses on global food production and consumption, comparing food for human consumption with feed for animals. The student investigates outliers, identifies fast-growing countries in food production, and compares food and feed consumption patterns. A key component is the development of a Tableau dashboard visualizing world food production per capita, population density, meat supply by region, and regional inequalities. The analysis provides insights and recommendations for a global food consulting firm, aiming to help them manage food resources efficiently. The project addresses the challenges of a growing global population and the need for sustainable food production practices, providing a comprehensive overview of the data and its implications.

ITECH7407- Real Time Analytics
Data Analytics Assignment
Semester 3 – 2018
Student Name: *****
Student ID: *****
1

Table of Contents
Table of Contents.......................................................................................................................2
1 Project Background.............................................................................................................3
1.1 Data set Description....................................................................................................3
2 Dashboard...........................................................................................................................4
2.1 Basic Work..................................................................................................................4
2.2 Advanced work............................................................................................................8
3 Research............................................................................................................................13
4 Recommendations.............................................................................................................14
References................................................................................................................................16
2

1 Project Background
This is a business investigation project gone for producing inventive investigation
solutions for a Global Food Consulting firm working in the region of Animal agriculture and
production line farming. The objective is to analyse the given datasets from applicable
company's point of view regarding suggestions and techniques which a nation could receive
to deal with the Food assets productively and successfully.
Our total population is required to develop from 7.3 billion today to 9.7 billion in the
year 2050. Discovering solutions for sustaining the developing total population has turned
into a hotly debated issue for sustenance and agriculture associations, business visionaries
and altruists. These arrangements run from changing the manner in which we develop our
Food to changing the manner in which we eat. To make things harder, the world's atmosphere
is changing and it is both influencing and influenced by the manner in which we develop our
Food agriculture.
This project is to use the Tableau business intelligence tool to analyse the provided
data set. The provided data set is based on the United Nations’ Food and Agriculture
Organization. This dataset gives an understanding on our overall sustenance development
concentrating on a correlation between Food delivered for human consumption and feed
delivered for creatures. This Food and Agriculture Organization gives free access to
sustenance and agriculture information for more than 245 nations and domains, from the year
1961 to the latest refresh (relies upon the dataset). This Project is used to analysis the
provided data set to provide the recommendation for the CEO to improve the operations.
1.1 Data set Description
The data set provided was organized, published and gathered by the United Nations’ Food
and agriculture organization. This dataset gives an understanding on our overall sustenance
development - concentrating on a correlation between Food delivered for human
consumption and feed delivered for creatures. Content The Food and Agriculture
Organization of the United Nations gives free access to sustenance and horticulture
information for more than 245 nations and domains, from the year 1961 to the latest refresh
(relies upon the dataset).One dataset from the FAO's database is the Food Balance Sheets. It
introduces an extensive image of the example of a nation's Food supply amid a predefined
reference period, the last time a refresh was stacked to the FAO database was in 2013. The
Food accounting report appears for every sustenance thing the wellsprings of supply and its
use. This lump of the dataset is focus on two uses of every Food thing accessible:
3

 Food – Refers to the aggregate sum of the sustenance thing accessible as human
sustenance amid the reference time frame.
 Feed - Refers to the amount of the sustenance thing accessible for encouraging to the
animals and poultry amid the reference time frame. The data set is demonstrated as
below.
2 Dashboard
2.1 Basic Work
Outliers
Outliers are a perception that is not normal for alternate perceptions. It is uncommon,
or particular, or does not fit somehow or another.
Anomalies can have numerous causes, for example,
 Measurement or input error.
 Data debasement.
 True outlier’s perception
There is no exact method to characterize and recognize anomalies all in all on account of the
particulars of each dataset. In our dataset, there is no outlier.
4

Fast Growing Countries
The United States for quite some time has the power in sustenance markets and yet it is
the world's biggest food exporter. China constantly out-produces the U.S., and in a few years
India delivers more food than the U.S., yet China and India additionally end up devouring
considerably more of their own items. This bodes well as these counties’ population is largest
in the world("3. Global and regional food consumption patterns and trends", 2019). When
compared to the wholeEuropean Union, the countries like the U.S., China and India, each
deliver more food.
Effectively besting the list is the country China, which is the world's greatest maker,
merchant and customer of sustenance. A lot of China's territory is excessively sloping or
unreasonably bone-dry for cultivating; however the rich soils of the eastern and southern
areas are amazingly profitable. China likewise has the world's biggest food workforce, with a
few gauges as high as 315 million workers. The U.S can be ranked in the third position in
terms of most crowded nations.
No nation produces food as effectively as the United States. In spite of having less
workforce when compared to China, absolute U.S. horticultural itemscost high. As far as all
out calorie content, India is ranked as the second biggest food maker on the planet. At the
point when estimated with absolute estimation of agrarian production slightly, India falls
onthe fourth position and fails to even delivers exactly 50% of China's complete yield
(Adesogan, 2018).
The truth is that, the absolute food development in the U.S. has dramatically increased
after the war. Whereas the United States furthermore with India might switch positions, and
Brazil might be supplanted by the other nation dependent on how the development is
estimated, however in food production and consumption China stays as the best.
The Brazilian economy has generally center around agribusiness, especially sugarcane,
going back to its time as a European province. At any rate thirty one percent of Brazil is
utilized for the cropland, to a great extent to create espresso, soybeans, sugarcane and the
corn. Additionally, Brazil is an important maker of pineapples,coconuts,oranges and papayas
and because of its warm, natural product agreeable atmosphere.
Lately, there is hindrance in the world farming production and harvest yields’
development rates. This has allowed the feelings of anxiety to increase, which the world
won’t be able to develop the necessary sustenance and different items for guaranteeing that
the future populations are satisfactorily food. In any case, the lull has taken place not on the
account of land or water deficiencies, but instead the interest for the agrarian items has
5

likewise hindered. This is same for most of the part as the development rates of the total
population are decreasing from the late 1960s. Moreover, for an individual the genuinely
abnormal amounts of food consumption are currently coming from various countries, due to
which the further ascent would not be allowed.
Subsequently, the development of world interest in the agrarian items might tumble
from a normal 2.2 percent each year in the course of recent years to a normal 1.5 percent
every year for the next thirty years. In developing countries, the push will be progressively
sensational, ranging from 3.7% to 2% each year. This is due to the reason that China has
passed the period of fast development, with its intension of increasing their sustenance. The
worldwide food deficiencies are far-fetched, but still the difficult problems are present both at
the national and the neighbourhood levels, which could increase except if focused endeavors
are made. It is described below.
6

Comparison between food and feed consumption
Firstly, feed grain is especially a developed nation practice. 40% of oats are feed to
domesticated animals in the United States while just 14 percent are sustained in the country
like Africa. Comprehensively, nearly 670 million tons of grains are utilized for the
domesticated animals’ feed every year. Thus, this speaks to a little more than 33% of absolute
world oat use. FAO nation insights do demonstrate that there has been an expansion in the
encouraging of oats to creatures since the 1970s specifically nations, prominently the places
like Brazil and Thailand have developed effective poultry trade ventures, similar to different
items (meat and shrimp, separately). The straightforward point shows that this consumption
of grains denotes as a danger to the sustenance security; this seems to expel the fundamental
food supplies which would in some or the other way be accessible for the poor nations and
the needy families, raising the food costs. Be that as it may, the consumption of oats might
really help in achieving the sustenance security (Azzurra, Massimiliano & Angela, 2019).
The business domesticated animals division is incredibly receptive to the cost of oats; at
whatever point deficiencies raise oat costs, animals makers will in general decrease their
consumption of grains as feed, discharging more for sustenance use. Therefore, the food
consumption of oats are required to contract short. Hence the consumption of grains as feed
may fill in as a helpful cushion, shielding the food supply from yearly varieties.
Unfortunately, as the population builds, consumption of ASF is really declining,
especially in the poorer African nations. Research displayed somewhere else in this gathering
recommends that kids in such nations will profit by an enhancement of meat, eggs and drain
which contains both better physical and mental advancement. The meat contains decent
wellspring of amazing protein, it also contains accessible iron, and additionally zinc contains
generous measures of protein and lactose. The eggs are a valuable commitment to the day-by-
day admission of nutrients like retinol, D,iron,iodine, protein and Riboflavin.
As of late, the consumption of grains as domesticated animals encourages has
decreased relatively from thirty nine percent of all out oat’s usage during the mid-80s to
thirty six percent during the period of 1995 to 1997. One of the clarification for it includes the
shift of meat production to poultry that actually is more effective converter of feed to meat
when compared to the different types of residential domesticated animals. The consumption
of oilseed dinners in animals feed proportions is expanding yet this is determined by an
expanding interest for the vegetable oil to satisfy the human consumption. The valuable result
includes the high protein suppers and cakes (Broderick, 2017).
7

The worldwide population is anticipated to confront a developing food emergency
amid the following century. Around the world, one of every seven individuals have lacking
vitality and protein inside their eating regimen to keep up wellbeing and prosperity and under
food represents 12% of deaths. Food emergencies traditionally result from a blend of
elements, fundamentally fast population development, and a shortage in sustenance supply,
and destitution. The reasons fundamental the present sustenance emergency are not natural
since it has happened amid a time of impressive rural development over the previous century
and numerous locales have a more prominent per capita pay than at any other time. To be
sure, net sustenance costs have commonly fallen amid the previous century, in this manner
food is increasingly accessible to those with wages above subsistence levels. The deficiency
in food accessibility is regularly credited to inadequacies in sustenance dissemination in mix
with important sustenance squander. Worldwide grain production has dramatically increased
amid the previous 50 years, yet developing areas regularly do not have the offices and
foundation to store and transport oat crops (Falguera, Aliguer & Falguera, 2012).
2.2 Advanced work
Here, we are developed the dashboard for provided data set. The dashboard contains
the following information,
 World Food production and consumption by per capita.
 World food production and consumption according to population density in
2013.
 The global perspective of meat supply by region.
 Inequality of Food production/ consumption by region.
In World Food production and consumption by per capita,
The world highest food production and consumption is China. It is shown below.
8

Either to include or exclude China in the total developing nations in the world has a
huge effect on the meats’ total development rates, in spite of the fact that not of drain and
dairy items, provided with little load of such items in the sustenance consumption of China.
This is also proposed by the FAO's Economic and Social Department, which states that the
meat production of China might be overestimated (Fiedler, 2013).
Global perspective of meat supply by region,
The primary determinant of the per capita meat consumption is shown below. There
are specific territorial and social contrasts in the correct position of nations on the diagram.
9

In the most recent years, the development of China in meat consumption denotes the
expansion of ∼2 kg/individual/y (prompting the 39 kg/individual/y allow in the year from
1995 to1997), were to proceed for any longer, the nation could before long outperform the
per capita consumption of the mechanical nations, an illogical prospect. Along these lines, a
fairly extraordinary deceleration in any event this nation and, provided its vast weight,
likewise in the worldwide totals, is not out of the ordinary. The development of various meats
is appeared above figure. For the above provided reason, the Chinese’ pig production is
separated from whatever remains of the world (Flachowsky, Gruen & Meyer, 2013).
10

In spite of the fact that the connection among the GDP and the consumption of food,
including the meat, is notable, thought ought to likewise be provided to the converse
relationshipthat is, that the ASF development might build the GDP. From FAO's Economic
and Social Department’s ongoing distribution, it is noticed that a shockingly solid
relationship seems to connect monetary development to wholesome elements. A point by
point econometric investigation is given in that production. The effect of food on financial
development would seem to work straightforwardly, through sustenance's impact on work
profitability, just as by implication, through enhancements in future. Anyway one takes a
gander at the issue, accomplishing the objective of decreasing the pervasiveness of food
insufficiency significantly by 2015, as articulated at the World Food Summit of 1996 and
repeated as of late at the World Food Summit 5 years after the fact, will enhance the human
welfare impressively as well as generously increase the rate of financial development. In the
event that this is valid for general sustenance and vitality consumption, all things considered,
dietary quality is likewise included and thatthe consumption of ASFis additionally
influencing the human efficiency, along with themonetary development (Gennari, 2015). The
low and declining figures for Sub-Saharan Africa are hence of considerably more prominent
distress.
11

World food production and consumption according to population density in 2013,
The food consumption communicated in terms of kilocalories (kcal) per capita every
day refers to a key variable utilized for estimating and assessing the advancement of the
worldwide and territorial sustenance circumstance. An increasingly fitting term for this
variable would be "national normal evident food consumption" since the information
originate from national Food Balance Sheets as opposed to from sustenance consumption
reviews The Food consumption in 2013 is demonstrated as below (Ha, 2018).
12