Question: Task 1: Import the ProductInfo.CSV data to Power BI Transform the PRODUCTINFO table from: OriginalDataforAssign4-1.JPG to: TransformedDataAssign4.JPG Task 2: Open Power Query and perform the

Task 1: Import the ProductInfo.CSV data to Power BI Transform the PRODUCTINFO table from: OriginalDataforAssign4-1.JPG to: TransformedDataAssign4.JPG Task 2: Open Power Query and perform the following tasks. Task 3: Rename the SSL column header as SAFETY STOCK LEVEL Task 4: Remove duplicate rows. RemoveDuplicatesAssign4.JPG Task 5: In the CATEGORY column (field), replace Dwafs by Dwarfs. Task 6: Create a measure to determine the number of items that have a Safety Stock Level. Task 7: Create two cards: One card that will determine the total items that have a Safety Stock Level. One card that will determine the average Safety Stock Levels. Examples of unformatted cards UnformattedCardsAssign4.JPG Task 8: Create a table to show Code, Description, Category, QOH and Safety Stock Level for only Dwarfs and Artistocats. An example of an unformatted table is below: UnformattedTableasExampleNov.JPG Task 9: Format the cards with different color themes. This is your choice but both card visualizations should have a different background. Task 10: Format the table so that the column headers have a color background withTask 1: Import the ProductInfo.CSV data to Power BI Transform the PRODUCTINFO white text. Task 11: Save your file with YourlastnameAssign4 and submit to Canvas.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!