Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 withimage text in transcribed 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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions