QUESTION 1 [5 marks]

You are given production values of a range of crops over time in the file: Crop_data.xlsx.

Complete the following tasks using Power BI desktop.

(1) Create a single visual that can identify the value of production ($M) of different crops

over time (use a slicer to select different crops). Provide commentary on the observed

trend in Maize and Sunflower Seeds (2.5 marks).

(2) Display the value of production of crops (SM) by year using a Funnel visual and

comment on the value of production of crops in the year 2021(2.5 marks).

Submit the visuals as a Power BI report file. Interpretation can be done in a Word document.