Microsoft Teams Virtual Appointments in Call Quality Dashboard
Call Quality Dashboard (CQD) is a self-service data environment that empowers you to access data on Teams usage throughout your organization, build reports to analyze call quality, and troubleshoot call issues. CQD tracks several hundred data points on your organization's Teams calls and stores them in a database that you can easily access using the Microsoft Call Quality connector for Power BI.
When you access this data, you can use it to analyze high-level metrics such as daily call errors and total call volume. You can also use it to determine things such as why a participant dropped a call or why a particular building has an unusually high rate of dropped calls. You can perform this analysis in Power BI by developing reports that can be published to the web, where they can automatically receive updated data at scheduled refresh times or at nearly real-time refresh rates. Once the reports are published to the web, you can distribute links within your organization and set permissions to allow users to explore the data themselves. This also allows users to export the underlying information to Excel.
Call Quality Dashboard is designed to be a quality and reliability analysis tool that relies on diagnostic telemetry returns from Teams service and client endpoints. Because of the unreliable nature of diagnostic telemetry, there may be slight variances in call counts or certain metrics. Keep this is mind as you use Call Quality Dashboard for usage-focused reporting.
Power BI reports published to the web are only accessible to authorized admins.
You can also access CQD from Teams Admin Center:
- From the menu bar, select Analysis & Reports.
- Then, choose Call Quality Dashboard.
One you've logged into CQD, you can begin to analyze data from the existing dashboards. You can find these in the dropdown menu at the top of the page. You can also use Power BI desktop to create highly customizable reports. Use the CQD Power BI template files to get started. These template files contain many of the most frequently requested call quality metrics and charts.
Working with CQD data in Power BI
Before you begin analyzing organizational call quality data, you'll need to install and learn to use Power BI desktop. To access the CQD database through Power BI, you'll need to download and install the Microsoft Call Quality connector. Make sure to install the connector in the appropriate Documents folder.
Once you've installed the connector, you'll be able to access your CQD data in Power BI.
You can get a head start by using the CQD Power BI template files. The template files are already connected to the CQD data source. You still need to have the connector installed to use the template files.
Start a report from scratch
If you choose not to use the template files, you can create a Power BI report from scratch.
- Follow the setup and building queries instructions in the CQD connector documentation.
- Select Get Data in Power BI.
- Search the connectors for Microsoft Call Quality.
You can analyze Teams data in several different ways.
- Teams Admin Center: You can find a pre-made and easy to read set of reports and insights inside Teams Admin Center. However, you can't extensively customize these reports.
- Call Quality Dashboard: Here you can filter and customize reports that provide quick answers to many frequently asked questions.
- Call Quality connector for Power BI: Using Power BI gives you the most customizable options for creating reports. Here you can use CQD data to understand user behavior, see usage patterns, and resolve individual call issues. You can use Power BI to supplement the aforementioned dashboards with answers that aren't available in the pre-made reports.
Virtual appointments data
You can also use CQD to gather and analyze data specific to Virtual Appointments.
Differentiate EHR and Bookings appointments
You can view the point of origin of a scheduled call by using the Scheduling Source App ID column. You can find this in the Fields list. Then drag and drop the slicer onto the canvas.
EHR connector appointments have the ID e97edbaf-39b2-4546-ba61-0a24e1bef890. Bookings appointments have the ID 0eaa6b95-4a35-4a5d-9919-e4fc61fb4bdb.
Scheduling Source App ID isn't one of the default slicers in the PBIT templates.