1)

How can cards, such as multicards, provide you with cleaner visuals?

Select an answer:

• They remove irrelevant data and display the most relevant data.

• They provide summary data and an easier way of sorting through data.

• They provide step-by-step instructions for applying filters.

2)

Your sales manager asks you to pull out the top 25 customers based on order amount. You are allowed to set the business rule. Which business rule makes the most sense with this ask?

Select an answer:

• Noise will be removed from the customer order data before ranking.

• The customer will not be included in the top 25 if they have an outstanding invoice.

• Customers will be ranked by the highest single order amount.

3)

Your company recently moved to a new data storage system. As part of your monthly work, you check for any invoices that do not have a CustomerOrderID. You find 10. What does this most likely mean?

Select an answer:

• Some data from the old system did not move to the new system.

• The old system did not have a verification system for invoices and orders.

• Ten customers were invoiced even though they did not place orders.

4)

What is the first step in doing a custom sort in Power BI?

Select an answer:

• Define the columns to sort.

• Choose Ascending or Descending.

• Create a custom table.

5)

Why is it often beneficial to unpivot data?

Select an answer:

• to create new pivot tables

• to have easy-to-read data visualizations

• to reduce the amount of space a visual requires