Check your knowledge

Completed

Answer the following questions to see what you learned.

1.

A report writer has been asked to create a Power BI report by using records from an instance of Dynamics 365 Customer Voice. After downloading and installing Power BI Desktop, they need to get the correct data. Which data connection category should they start with?

Database

Online services

Microsoft Power Platform

2.

A report writer is working on a custom report in Power BI Desktop. They want to know the number of survey invitations that have been sent and where the survey has been started but not yet submitted. Which method would provide the report writer with the accurate result?

Add a chart visual to display all the survey invitations that were generated and sent by the actualstart date column from the msfp_surveyinvite table.

Add a card visual to display a Count (Distinct) of activityid from the msfp_surveyinvite table, filtered by msfp_invitestatus to only show those with a status of Started.

Add a table visual to list the details of all the survey invites from the msp_surveyinvite table and list all the columns, including the msfp_invitestatus column.

3.

The Customer Experience manager wants to analyze survey feedback and to review and filter data by using the Net Promoter Score feedback. The data on a Survey Response record in Dynamics 365 Customer Voice is stored as a number rather than showing the type of response given. What is the simplest way to display if a customer is considered Promoter, Passive, or Detractor based on the response that they gave?

Create a new column on the msfp_surveyresponses table called NPS Type by using a switch statement. This approach will show Promoters if 9 or above, Detractors if 6 or below, or Passive if a 7 or an 8. Add the column to the Power BI report.

Create a new measure on the msfp_surveyresponses table called NPS Type to calculate the Net Promoter Score given, and then multiply by the average NPS from all responses.

Create a new column on the contact table called NPS Type by using a switch statement. This approach will show Promoters if 9 or above, Detractors if 6 or below, or Passive if a 7 or an 8. Add the column to the Power BI report.

4.

The data for Dynamics 365 Customer Voice is made up of a series of tables that are stored in Dataverse. These tables can be linked together through specific columns, and report writers can then create reports in Power BI to share with their organization, providing a mechanism to analyze and filter the data as needed. Which of the following options are Dynamics 365 Customer Voice tables?

msfp_question, msfp_surveyresponse, and msfp_surveyanswers

msfp_question, msfp_surveyresponse, and msfp_surveyinvite

msfp_surveyinvite, msfp_surveydetails, and msfp_question

You must answer all questions before checking your work.