See attached file.

Assignment 1 0 – Power BI 30 Points Use 2 different workbooks and have each plot in its own worksheet. I. (15 points) Use the data in McDonalds - Small .csv to: 1. (3 points) Create a bar chart to show the number of calories for each item on the menu . Decide if you should use horizontal or vertical bars. 2. (3 points) Create a grouped bar chart to show the carbs and protein for each item on the menu . 3. (4 points) Create a stacked bar chart to show the protein, carbs and total fat for each menu item. 4. (5 points) Create a scatterp lot that will help you understand if there is a relationship between the calories and the carbs. II. (15 points) Use the data in Walmart_store_sales.csv 1. (3 points) Plot the weekly sales (use column weekly sales and plot the data for each day) for store # 3. Apply a filter to select the store. 2. (8 points) Plot the average fuel prices for the 3 years in the data. Do it using a bar chart and a pie chart (i.e 2 different charts). a. (4 points) On the bar chart drop the numeric axes and instead have the price show on the inside end of the bars. b. (4 points) On the pie chart show the price using only two decimal places. Wha t other information does it make sense to show here. 3. (4 points) Create a bar chart to show which store has the highest average temperature. Show the top 5 highest bars only (use the filter options) and ch ange the colo r of the highest bar to highlight it. For each plot , label the axes appropriately , have a meaningful legend (if you need it), have a title. Feel free to add custom styling. SUBMISSION REQUIREMENTS: Submit both workbooks (.pbix files ) and screenshots of all plots .