8. Move to a new worksheet. Be sure that you have activated the PowerPivot add-in. Select Power Pivot > Manage to open the Power Pivot screen. Move to the Power Pivot for Excel screen. Select Home > Get External Date > From Database and then select the option to connect to an Access database. Browse to the directory containing the ContosoSales database and select it. When the Table Import Wizard appears, select the DimChannel, DimProduct, and FactSales tables and click FINISH. After the import finishes, click CLOSE to close the Table Import Wizard. Go to Diagram View and make sure that the three tables are linked. Return to Date View and the FactSales table. Add a new calculated column on the right and calculate the month for the datekey field. 9. Continuing from problem 8. Select Home > Pivot Table to create a Pivot Table Report from your integrated Power Pivot tables. a. Use the ChannelName from the DimChannel table as the first rows field. Use the calculated column 1 field from the FactSales table as the second rows field. Use the SalesAmount field from the FactSales table as the values field. Change the number format to currency if necessary, change the name of the calculated column 1 in the Pivot Table Report to Month, and change the values column name from Sum of SaleAmount to Total Monthly Sales. Change the report layout to tabular form. b. Insert Slicers for both ChannelName and Month. c. Which channel had the highest total sales in January? d. Add a column Pivot Chart. Change the title to Total Monthly Sales. Use the slicers to show the comparison among channels for sales in January