HOTSPOT You publish the dataset to powerbi.com. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area:

HOTSPOT You need to create a visualization to meet the reporting requirements of the sales managers. How should you create the visualization? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.…

You need to create relationships to meet the reporting requirements of the customer service department. What should you create? A. an additional date table named ShipDate, a one-to-many relationship from Sales[sales_date_id] to Date[date_id], and a one-to-many relationship from Sales[sales_ship_date_id] to…

You need to provide a solution to provide the sales managers with the required access. What should you include in the solution? A. Create a security role that has a table filter on the Sales_Manager table where username = UserName()…

You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do? A. In the Weekly.Returns table, create a new calculated column named date-id in…

What should you create to meet the reporting requirements of the sales department? A. a measure that uses a formula of SUM (Sales [sales_id]) B. a calculated column that use a formula of COUNTA(sales [sales_id]) C. a measure that uses…

You need to create the required relationship for the executive’s visual. What should you do before you can create the relationship? A. Change the data type of Sales[region_id] to Whole Number. B. In the Sales table, add a measure for…

You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use? A. FORMAT(‘Date’, “MMM YYYY”) B. FORMAT(‘Date’ , “M YY”) C. FORMAT(‘Date'[date_id], “MMM”) & “” & FORMAT(‘Date’, “#”) D.…

You need to address the data concerns before creating the data model. What should you do in Power Query Editor? A. Select Column distribution. B. Select the sales_amount column and apply a number filter. C. Select Column profile, and then…

Topic 1, Litware, Inc. Case Study This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and…