Course Hero Logo

Question 35 drag drop you receive revenue data that

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 40 - 43 out of 90 pages.

Question: 35DRAG DROPYou receive revenue data that must be included in Microsoft Power Bl reports.You perform an initial load of the data from a Microsoft Excel source as shown in the following exhibit.You plan to create several visuals from the data, including a visual that shows revenue split by year andproduct.You need to transform the data to ensure that you can build the visuals. The solution must ensure thatthe columns are named appropriately for the data that they contain.Which three actions should you perform in sequence? To answer, move the appropriate actions from thelist of actions to the answer area and arrange them in the correct order.
Questions & Answers PDFPage 41Step 1: Select Use Header as First Row.Step 2: Select Department and Product and Unpivot Other ColumnsUnpivot Other Columns: This command unpivots unselected columns. Use this command in a query whennot all columns are known. New columns added during a refresh operation are also unpivoted.When you unpivot, you unpack the attribute-value pairs that represent an intersection point of the newcolumns and re-orient them into flattened columns:Values (in blue on the left) are unpivoted into a new column (in blue on the right).Attributes (in green on the left) are unpivoted into a new column (in green on the right) and duplicatesare correspondingly mapped to the new Values column.Reference:-49c1-9d95f588221c7098Answer:Explanation:123
Questions & Answers PDFPage 42Question: 36Your company has employees in 10 states.The company recently decided to associate each state to one of the following three regions: East, West,and North.You have a data model that contains employee information by state. The model does NOT include regioninformation.You have a report that shows the employees by state.You need to view the employees by region as quickly as possible. Whatshould you do?

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 90 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
N/A
Tags
Microsoft SQL Server

Newly uploaded documents

Show More

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture