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 with white text. Task 11: Save your file with YourlastnameAssign4 and submit to Canvas.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started