Complete the following tasks, using the following spreadsheet Exercise File.xlsx Download Exercise File.xlsx. Each of the 4 visualizations that you are asked to create in steps 4-7, is worth 3 points, with 2 points being awarded for the correct chart. Create a single visualization for 4 through 6. The data model that you are asked to create in steps 1 through 3 is worth 18 points, with 2 points each being awarded for the calculated fields, and the remaining 10 points for the rest of the data model.

1. Build the data tables by importing the data from the spreadsheet into Power BI. Note: It may be the case that one of the sheets in the spreadsheet is problematic. If so, before you load the sheets, you therefore first have to inspect them. You can fix the problematic sheet in the Power Query Editor and, rather than loading it directly, you therefore have to transform the data in it.
2. If Power BI has not created the links yet, link the sheets as follows (NOTE: To add a link between two tables, go to the model view, click on the field you want to link from, hold the mouse and drag it to the field you to link to):
   1. Between Country in Suppliers, and Country Name in Countries
   2. Between SupplierID in Suppliers and SupID in Products
   3. Between ProdID in Products and ProductID in Orders
   4. Between CustID in Customers and CustID in Orders.
3. Add the calculated fields Gross Revenue by multiplying Qty from Orders by List Price from Products, Cost by multiplying Qty from Orders by Unit Cost from Products, and Net Revenue by subtracting Cost from Gross Revenue.
4. Create a visualization, that shows the Gross Revenue, Cost and Net Revenue by geographical area. Choose a suitable visualization. I should be able to drill down to get the information by country and by supplier in that country. Give the sheet with the visualization a meaningful name and title.
5. Create a visualization that answer the question "What is the Gross Revenue, Cost and Net Revenue for each Product except for Olive Oil?" Give the visualization a meaningful title.
6. Create a visualization that answer the question "What is the Net Revenue and Cost generated by each supplier, except for Olive Oil, and what country is the supplier from?"
7. Create a dashboard from the visualizations you created in 4, 5 and 6.