Set it up to use Country for location and UnitsOnOrder for values. Add another visualization the Multi-row Card to the page: Add the following fields to the Card: ProductName and UnitsOnOrder Finally, configure a page-level filter to only include data where UnitsOnOrder is > 0 You should now be able to click on a Country on the map and see which products and how many units are on order from that country! Part 3: On Your Own: Business Intelligence for Northwind Sales. In this part, build out an SQL Server Analysis Services cube for project for the Northwind Sales. As you’re accustomed to doing do in part 3’s of labs you must work out many of the details on your own. After you complete the cube, create an Excel Pivot table, and dashboard in Power View and Power BI Desktop. Add the FactSales, DimCustomer and DimEmployee tables to the current Northwind data source view: Build out the Customer and Employee dimensions as follows: NOTE: Customer should display Company Name Create the Northwind Sales cube as follows: Create an Excel worksheet Northwind-Sales.xlsx with A Pivot table setup to show interesting data with drill downs. A Power View Chart of your choosing. For example you should choose to show sales by day of the week. Do not create a map. Create a power BI desktop dashboard Northwind-Sales.pibx different from the Power View you created in Excel. Some criteria: Try using a tool not available in Power View like the map, treemap, or doughnut chart. Make it interactive. Selecting portions of the chart updates another chart, matrix or card. Good Luck!
Set it up to use Country for location and UnitsOnOrder for values. Add another visualization the Multi-row Card to the page: Add the following fields to the Card: ProductName and UnitsOnOrder Finally, configure a page-level filter to only include data where UnitsOnOrder is > 0 You should now be able to click on a Country on the map and see which products and how many units are on order from that country! Part 3: On Your Own: Business Intelligence for Northwind Sales. In this part, build out an SQL Server Analysis Services cube for project for the Northwind Sales. As you’re accustomed to doing do in part 3’s of labs you must work out many of the details on your own. After you complete the cube, create an Excel Pivot table, and dashboard in Power View and Power BI Desktop. Add the FactSales, DimCustomer and DimEmployee tables to the current Northwind data source view: Build out the Customer and Employee dimensions as follows: NOTE: Customer should display Company Name Create the Northwind Sales cube as follows: Create an Excel worksheet Northwind-Sales.xlsx with A Pivot table setup to show interesting data with drill downs. A Power View Chart of your choosing. For example you should choose to show sales by day of the week. Do not create a map. Create a power BI desktop dashboard Northwind-Sales.pibx different from the Power View you created in Excel. Some criteria: Try using a tool not available in Power View like the map, treemap, or doughnut chart. Make it interactive. Selecting portions of the chart updates another chart, matrix or card. Good Luck!