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.