Real Time Analytics for Global Food Consulting Firm

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