Data Analyst FARMING DATA
Budget: $10 – $30 USD
FARMING DATA
Data: Download this Excel Workbook including these 3 tables:
● farming_data.xlsx
○ Prices_Crops_Livestock
○ Production_Crops_Livestock.
○ Land_In_Use
NOTE: These tables contain agricultural information for 20 countries and
a list of various crops and livestock products. The data is sourced from
the Food and Agriculture Organization of the United Nations where you
can find definitions and standards.
Scenario: Imagine you're a data analyst at a global agricultural organization,
entrusted with enhancing worldwide agricultural production understanding.
American stakeholders seek a comprehensive view of global farming trends as
they evaluate diverse food supply chain initiatives.
Audience: American stakeholders.
Insights: Address several questions to gain insights about your data. Select
from the following list and/or prepare your own:
● What are the primary crops and livestock produced in different
countries? How does this compare to the USA?
● How has the production of specific crops and livestock changed over
time, and in which regions do you observe notable trends?
● Is there a relationship between the quantity of various products and their
prices?
● Which countries lead in production volume, and which have the highest
prices for agricultural goods? Do these categories significantly intersect?
● Geographically, which countries and regions utilize the most land, and
how is this land utilized?
● Which countries have increased their farming land over the years? Which
have reduced their use of agricultural land?
● Are there any regional trends worldwide between various continents and
climates?
Submission Requirements:
1. Clean and prepare the data as needed.
2. Create a report in Power BI using the provided datasets.
3. Ensure the report includes more than one level of aggregation to provide
a comprehensive analysis.
note : powerbi file, word doc explaining Submission Requirements as well as Insights and Scenario and ppt file with outputs photos as well as useful formula and steps
project bought is max 25 so bid according that value
project deadline is 05/16/2024 morning
Data: Download this Excel Workbook including these 3 tables:
● farming_data.xlsx
○ Prices_Crops_Livestock
○ Production_Crops_Livestock.
○ Land_In_Use
NOTE: These tables contain agricultural information for 20 countries and
a list of various crops and livestock products. The data is sourced from
the Food and Agriculture Organization of the United Nations where you
can find definitions and standards.
Scenario: Imagine you're a data analyst at a global agricultural organization,
entrusted with enhancing worldwide agricultural production understanding.
American stakeholders seek a comprehensive view of global farming trends as
they evaluate diverse food supply chain initiatives.
Audience: American stakeholders.
Insights: Address several questions to gain insights about your data. Select
from the following list and/or prepare your own:
● What are the primary crops and livestock produced in different
countries? How does this compare to the USA?
● How has the production of specific crops and livestock changed over
time, and in which regions do you observe notable trends?
● Is there a relationship between the quantity of various products and their
prices?
● Which countries lead in production volume, and which have the highest
prices for agricultural goods? Do these categories significantly intersect?
● Geographically, which countries and regions utilize the most land, and
how is this land utilized?
● Which countries have increased their farming land over the years? Which
have reduced their use of agricultural land?
● Are there any regional trends worldwide between various continents and
climates?
Submission Requirements:
1. Clean and prepare the data as needed.
2. Create a report in Power BI using the provided datasets.
3. Ensure the report includes more than one level of aggregation to provide
a comprehensive analysis.
note : powerbi file, word doc explaining Submission Requirements as well as Insights and Scenario and ppt file with outputs photos as well as useful formula and steps
project bought is max 25 so bid according that value
project deadline is 05/16/2024 morning