{tocify} $title={Table of Contents}
Tutorial: View analytics with Power BI
Intro
Purpose
The
BOT framework Composer sample provides a Power BI template that can be used to
understand how your bot is performing.
Overall usage
Personalize your experience for your brand and customers.
All dialogs overview
All dialogs' popularity and status based off of SDK telemetry
Dialog overview
Review a specific dialog's popularity and status
LUIS intents
A count of LUIS intents per day
All conversation metrics
Highlights the average number of conversations per unique user and the average duration by day https://lkgforit.com/power-bi-report-on-bot-analytics-for-chatbot-in-bot-framework-composer
Conversations drill down
Per conversation, this highlights the dialogs triggered and common utterances https://lkgforit.com/power-bi-report-on-bot-analytics-for-chatbot-in-bot-framework-composer
Transcript
Review interactions, sessions, and the transcript between a bot and its users https://lkgforit.com/power-bi-report-on-bot-analytics-for-chatbot-in-bot-framework-composer
Demographics
See where users are connecting to your bot https://lkgforit.com/power-bi-report-on-bot-analytics-for-chatbot-in-bot-framework-composer
Word Cloud
Sentiment analysis
QnA Maker insights
User feedback
Prerequisites
• Download the Bot Composer analytics Power BI template
• Create a Bot in Composer to deploy your
Azure resources
Scenario
A
Power BI dashboard showing Application Insights telemetry captured from a Bot
Composer BOT.
Tutorial:
View analytics with Power BI
Get
your Application Insights Application ID
1. Log
in to the Azure
Portal.
2. Navigate
to the Application Insights resource created.
3. In
the sidebar, navigate to Configure > API Access on the sidebar.
4. Copy the Application ID for the next step.
Tutorial: View analytics with Power BI
Open the Power BI template
1. Open
the Bot Composer analytics template and paste
your Application Insights Application ID.
2. After loading the tables with your populated data, you should now see insights from your Virtual Assistant.
Note:
You may run into authentication issues when opening the template, particularly
if you have opened the template previously using another Application ID. If so,
perform the following steps to re-authenticate the template with your
Application Insights service:
1. Open
the Template
2. File
> Options and Settings > Data Source Settings
3. Click
"Global permissions"
4. Click
on anything resembling "api.logalytics.io" and Clear Permissions >
Clear Permissions > Delete
5. Close
and Re-open the Template
6. Paste
your Application Insights AppId
7. Click
Load
8. Important:
Select Organizational Account > Sign In > Connect
Additional Telemetry
By
default, a Bot composer Bot based project collects personally identifiable
information (e.g. Conversation drill-down and transcripts) which will lead to
the respective sections in the PowerBI dashboard to function as expected. If
you wish to not collect this information make the changes to appsettings.json by following this
article: https://docs.microsoft.com/en-us/composer/how-to-capture-telemetry?tabs=v2x#configure-telemetry
Raised
a PR to Bot Framework Composer: https://github.com/microsoft/BotFramework-Composer/pull/8641