Real Time Analytics for Global Food Consulting Firm

This project is a business investigation project gone at 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.

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

Overall the Dashboard is demonstrated as below (Stirrup, Nandeshwar, Ohmann & Floyd,
2016),
3 Research
Regardless, domesticated animals are feed various plant materials which are less
valuable for the human sustenance. There is information and data related to more than 700
materials which could be utilized as the creature feeds, which is stored in the FAO Animal
Feed Resources Information System. This can incorporate grasses and vegetables that could
be utilized by the ruminants and for some pigs, just as harvest and other results. The FAO has
done numerous projects for advancing the consumption of option feed stuffs and to create
incorporated cultivating frameworks where harvests and domesticated animals are
corresponding. There has been an expanding weight on the domesticated animals division to
take care of the developing demand for high-value being protein. The world's animals
division is developing at a remarkable rate and the main thrust behind this colossal flood is a
13

mix of populace development, rising salaries and urbanization. Yearly meat development is
anticipated togrow from 218 million tons in 1997-1999 to 376 million tons by 2030 (Huang,
Liu, Zhao, Hu & Wang, 2018).
There exists a solid positive connection among the dimension of salary and the
consumption of creature protein, developed from the meat’s consumption, drain and from the
eggs expanding to the detriment of the staple foods. On account of the ongoing steep decrease
in costs, the developing nations are seen setting out on large consumption of meat at an
extremely lower dimensions of total national output when compared to the industrialized
nations,accomplished in the last twenty to thirty years ago. Urbanization is an important
main thrust impacting worldwide interest for domesticated animal’s items.
Urbanization invigorates enhancements in framework, including cold chains, which
allow exchange transient products. Contrasted and the less broadened weight control plans of
the country networks, city occupants have a fluctuated eating routine wealthy in creature
proteins and fats, and portrayed by higher consumption of meat, poultry, drain and other
dairy items. The above figure demonstrates inclines in per capita consumption of
domesticated animal’s items in various locales and nation gatherings. There has been an
astounding increase in the consumption of creature items in nations, for example, Brazil and
China, in spite of the fact that the dimensions are still well underneath the dimensions of
consumption in North American and most other developed nations.
As consumption regimens wind up more extravagant and progressively different, the
high-value protein that the domesticated animals division offers enhances the sustenance of
most by far of the world. Domesticated animals items give high-value protein as well as vital
wellsprings of a wide scope of fundamental micronutrients, specifically minerals, for
example, iron and zinc, and nutrients, for example, nutrient A. For the vast lion's share of
individuals on the planet, especially in developing nations, domesticated animals items
remain an ideal sustenance for healthy benefit and taste. Exorbitant consumption of creature
items in a few nations and social classes can, nonetheless, lead to unnecessary admissions of
fat ("WHO | 3. Global and regional food consumption patterns and trends", 2019).
4 Recommendations
Recommend that, Populaces of developed nations have changed through the previous
century from commonly social leaders to urban area. Since residents of right now creating
14

nations appreciate a higher standard of salary and a more important extent of things to come
populace lives inside urban instead of country territories, this gap between sustenance makers
and shoppers is probably going to increase. There can be no uncertainty that the worldwide
domesticated animals industry faces a significant test in the following 50 years. The need to
give more sustenance to satisfy the requests of the developing worldwide populace while
countering the bunch claims identifying with the natural, financial, and social supportability
of creature generation will require proceeded logical improvement and a remarkable
dimension of coordinated effort among domesticated animals makers, creature wellbeing and
feed industry experts, analysts, and policymakers. Building up a successful, proactive
correspondence system that passes on in a convincing way the advantages of the animals
business ought to be a critical focal point of the different domesticated animals supply chains
and their exchange or proficient affiliations and associations. All foods have a natural
expense, and that cost isn't limited to sustenance’s of creature root. Creature agribusiness
utilizes assets and has a quantifiable ecological impression ("Review on Compound Animal
Feed Processing in Ethiopia: Condition, Challenges and Opportunities", 2017).
In the meantime, the advantages accumulated to society by the animals business are
generous as far as financial benefit, the supply of brilliant proteins related to large scale and
micronutrients, and the arrangement of social and societal remaining inside creating locales.
The important investment funds in natural impression and financial expense presented by
enhanced efficiency inside domesticated animal’s frameworks must be imparted to the
purchaser so as to show the additions made by advances in creature sustenance, hereditary
qualities, and the executives after some time, just as to improve shopper trust in current
farming. Result sustains are regularly depicted as "waste," a term that gives a conspicuous
negative message to the customer (Szűcs, Szabó & Bánáti, 2013). In the United States, the
estimation of sustenance scraps as feed for lawn and small holder domesticated animals was
praised during the 1940s and '50s when food contained somewhat over 20% of individual
pay. The extent of salary spent on food has since declined to under 10% and has happened
couple with both an evident want for partner creatures and domesticated animals to be
encouraged "normal" slims down that do not contain side-effects from human sustenance or
fiber produce and a societal blame identifying with creature protein consumption for
environmental or wellbeing reasons.
15

References
Adesogan, A. (2018). 400 Importance of animal-source foods for meeting global nutritional,
educational and economic needs. Journal Of Animal Science, 96(suppl_3), 164-164. doi:
10.1093/jas/sky404.359
Azzurra, A., Massimiliano, A., & Angela, M. (2019). Measuring sustainable food
consumption: A case study on organic food. Sustainable Production And
Consumption, 17, 95-107. doi: 10.1016/j.spc.2018.09.007
Broderick, G. (2017). Review: Optimizing ruminant conversion of feed protein to human
food protein. Animal, 12(08), 1722-1734. doi: 10.1017/s1751731117002592
Falguera, V., Aliguer, N., & Falguera, M. (2012). An integrated approach to current trends in
food consumption: Moving toward functional and organic products?. Food
Control, 26(2), 274-281. doi: 10.1016/j.foodcont.2012.01.051
Fiedler, J. (2013). Towards overcoming the food consumption information gap:
Strengthening household consumption and expenditures surveys for food and nutrition
policymaking. Global Food Security, 2(1), 56-63. doi: 10.1016/j.gfs.2012.09.002
Flachowsky, G., Gruen, M., & Meyer, U. (2013). Feed-efficient ruminant production:
opportunities and challenges. Journal Of Animal And Feed Sciences, 22(3), 177-187.
doi: 10.22358/jafs/65962/2013
Gennari, P. (2015). Food and Agriculture Organization of the United Nations (FAO). Choice
Reviews Online, 53(03), 53-1073-53-1073. doi: 10.5860/choice.192305
Huang, Q., Liu, X., Zhao, G., Hu, T., & Wang, Y. (2018). Potential and challenges of tannins
as an alternative to in-feed antibiotics for farm animal production. Animal
Nutrition, 4(2), 137-150. doi: 10.1016/j.aninu.2017.09.004
Review on Compound Animal Feed Processing in Ethiopia: Condition, Challenges and
Opportunities. (2017). Journal Of Nutrition & Health, 3(2), 1-5. doi: 10.13188/2469-
4185.1000030
16

Stirrup, J., Nandeshwar, A., Ohmann, A., & Floyd, M. (2016). Tableau. Birmingham: Packt
Publishing.
Szűcs, V., Szabó, E., & Bánáti, D. (2013). Short overview of food consumption
databases. Czech Journal Of Food Sciences, 31(No. 6), 541-546. doi:
10.17221/160/2013-cjfs
WHO | 3. Global and regional food consumption patterns and trends. (2019). Retrieved from
https://www.who.int/nutrition/topics/3_foodconsumption/en/index4.html
17