Turning on and using Call Quality Dashboard in Skype for Business Online

Learn how to configure your Office 365 organization to use the Call Quality Dashboard to monitor call quality.

The Call Quality Dashboard (CQD) for Skype for Business Online allows you to gain insights into the quality of calls made using Skype for Business services. This topic describes the steps you'll need to complete to start collecting data.

Note: The CQD detailed reports are currently available as Tech Preview but available to all customers.

Latest changes and updates

Here is a list of the most recent changes to CQD that you should read more about below:

  • Detailed reports

    • Support for video, application sharing and video-based screen sharing reporting.

    • Support for reporting on real-time media reliability.

  • Building mapping data

    • Support for supernet notation to provide easier way of identifying which subnets map to which locations. This includes identifying duplicate mappings.

    • Support for comma separated value (CSV) file format.

Activate Skype Call Quality Dashboard (CQD) Summary Reports

Before you can start using the CQD, you'll need to activate it for your Office 365 organization.

  1. Sign in to your Office 365 organization using an admin account, and then select the Admin tile to open the Admin center.

  2. In the left pane, under Admin, Select Skype for Business to open the Skype for Business admin center.

  3. On the Skype for Business admin center, select tools in the left pane and then select Skype for Business Online Call Quality Dashboard.

    Skype for Business tools

  4. On the page that opens, select Login with your Global Administrator account and then provide the credentials for the account when prompted.

    CQD Login

Once you select login, once activated, the CQD will begin collecting and processing data.

Note: It may take a couple of hours to process enough data to display meaningful results in the app.

Features of the Call Quality Dashboard for Skype for Business Online

CQD Summary Reports provide a subset of the features planned for Detailed Reports. The differences between the two editions are summarized here:


Summary Reports

Detailed Reports

Application sharing metric



Customer building information support



Drill-down analysis support



Media reliability metrics



Out of the box reports



Overview reports



Per-user report set



Report set customization (add, delete, modify reports)



Video-based screen sharing metrics



Video metrics



Out of the box reports

Both editions of CQD provide an out-of-the box experience, giving you call quality metrics without the need to create any new reports. Once data is processed in the back-end, you can start seeing call quality data in the reports.

Overview reports

Both editions of the CQD provide a high-level entry point to the overall call quality information, but the way information is presented in Summary Reports is different from that of Detailed Reports.

Summary Reports provide a simplified tabbed page report view that enables users to quickly browse and understand the overall call quality status and trends.

The four tabs include:

  • Overall Call Quality - provides information about all streams, which is an aggregation of Server-Client streams and Client-Client streams, as well as separate Server-Client and Client-Client streams, in the form of monthly and daily trends.

  • Server – Client – provides additional details for the streams between Server-Client.

  • Client – Client – provides additional details for Client-Client streams.

  • Voice Quality SLA – provides information about calls that are included in the Skype for Business Online Voice Quality SLA

Overall Call Quality tab

Use the data on this tab to evaluate call quality status and trends by looking at the call counts and poor percentages. The legend in the upper right corner shows which color and visual elements represent these metrics.

CQD Data key

Call counts are classified in three groups: Good, Poor, and Unclassified. There are also calculated Poor % values that give you the ratio of streams classified as Poor to the total stream count. You can see the distribution of call stream classifications by looking at the colored areas within each bar.

Use the scale on the left to measure the call count values.

CQD data count

Use the scale on the right to measure the Poor % values.

CQD data per cent

You can also obtain the actual numerical values by hovering the mouse over a bar.

Note: The following example is from a very small sample data set and the values aren't realistic for an actual deployment.

CQD Data numeric

The overall call volume is an important factor in determining how relevant the calculated Poor percentages are. The smaller the volume of overall calls, the less reliable the reported Poor percentage values are.

Server-Client tab and Client-Client tab

These two tabs provide additional details for the streams that took place in their endpoint-to-endpoint scenarios. Both tabs have four collapsible sections, representing four scenarios under which media streams would flow.

  • Wired Inside

  • Wired Outside

  • Wifi Inside

  • Wifi Outside

Inside Test

During processing, the CQD back-end classifies a stream as Inside or Outside using Building information, if it exists. Endpoints of each stream are associated with a subnet address. If the subnet is in the list of the subnets in the uploaded Building information, then it is considered Inside. If Building information has not yet been uploaded, then Inside Test will always classify the streams as Outside. Please note that Inside Test for Server-Client scenario only considers the client endpoint. Because servers are always outside from a user's perspective isn't accounted for the in the test.

Wired vs WiFi

As the names indicate, this is a classification criteria based on the type of client connections. Again, server is always wired and it isn't included in the calculation.

Note: Given a stream, if one of the two endpoints is connected to a WiFi network, then it is classified as WiFi in CQD.

Upload Building information

The CQD Summary Reports dashboard includes a Tenant Data Upload    page, accessed by selecting the Tenant Data Upload link tag on the top right corner. This page is used for admins to upload their own information, such as mapping of IP address and geographical information, mapping each wireless AP and its MAC address, etc.

CQD Dashboard

  1. On the Tenant Data Upload page, use the drop-down menu on that page to choose a data file type for uploading. The file data type denotes the content of the file (e.g. “Building” refers to mapping of IP address and building as well as other geographical information). Currently we are only supporting the “Building” data type. A few more data types are to be added with subsequent releases.

  2. After selecting the file data type, select Browse to choose a data file.

    • The data file must be a tsv (Tab-separated values) file or a csv (Comma-separated value) file. If using a csv file, any field that contains a comman must be contain quotes or have the comma removed. For example, if your building name is NY,NY, in the csv file it should be etnered as "NY,NY".

    • The data file must be no larger than 50MB in size.

    • For each data file, each column in the file must match a predefined data type, discussed later in this topic.

  3. After selecting a data file, specify Start date and optionally Specify an end date.

  4. After selecting Start date, select Upload to upload the file to the CQD server.

    Before the file is uploaded, it is first validated. Once validated, it is stored in an Azure blob. If validation fails or the file fails to be stored in an Azure blob, an error message is displayed requesting a correction to the file. The following figure shows an error occurring when the number of columns in the data file is incorrect.

    CQD Example upload validation error
  5. If no errors occur during validation, the file upload will succeed. You can then see the uploaded data file in the My uploads table, which shows the full list of all uploaded files for the current tenant at the bottom of that page.

    Each record shows one uploaded tenant data file, with file type, last update time, time period, description, remove and a download icons. To remove a file, select the trash bin icon in the Remove? column of the table. To download a file, select the download icon in the Download column of the table.

    CQD My Uploads table

Tenant data file format and Building data file structure

The format of the data file you upload must meet the following to pass the validation check before uploading.

  • The file must be either a tsv file, which means, in each row, columns are separated by a TAB, or a csv file with each column separated by a comma.

  • The content of the data file doesn't include table headers. That means, the first line of the data file should be real data, not headers like “Network” etc.

  • For each column, the data type can only be String, Number or Bool. If it is Number, the value must be a numeric value; if it is Bool, the value must be either 0 or 1.

  • For each column, if the data type is string, the data can be empty (but still must be separated by an appropriate delimited, i.e. a tab or comma). This just assigns that field an empty string value.

  • Tthere must be 14 columns for each row, and each column must have the following data type, and the columns must be in the order listed in the following table.

Column Name

Data type


















IT Termination

























The data type for “Building” the columns in the table are selected from columns in CqdBuilding (Building Name, BuildingOfficeType, City, ZipCode, Country, State, Region, InsideCorp), CqdBuildingOwnershipType (OwnershipType), CqdBuildingType (BuildingType), CqdNetwork (Network, NetworkRange) and CqdNetworkName(NetworkName) tables in QoEArchive database. If you want to create a tenant data file, you can write a simple SQL query (select and join) on these tables and copy the query results (not including the headers) into a blank tsv file.

Important: The network range can be used to represent a supernet (combination of several subnets with a single routing prefix). All new building uploads will be checked for any overlapping ranges. If you have previously uploaded a building file, you should download the current file and re-upload it to identify any overlaps and fix the issue before uploading again. Any overlap in previously uploaded files may result in the wrong mappings of subnets to buildings in the reports.

The following sample SQL query selects all the required columns. ExpressRoute isn't in any of the existing QoE tables, it is a column that should be manually added by admin, so temporarily use 1 in the following SQL script). Make sure the use the correct database name for your environment.

SELECT  isnull(Network, '') AS Network
      ,REPLACE(REPLACE(isnull(NetworkName.NetworkName, ''), CHAR(13), ''), CHAR(10), '') AS NetworkName
      ,isnull(NetworkRange, '') AS NetworkRange
      ,isnull(Building.BuildingName, '') AS BuildingName
	  ,isnull(OwnerShipType.OwnershipTypeDesc, '') AS OwnershipTypeDesc
	  ,isnull(Building.BuildingOfficeType, '') AS BuildingOfficeType
      ,isnull(BuildingType.BuildingTypeDesc, '') AS BuildingTypeDesc
	  ,isnull(Building.CityName, '') AS City
	  ,isnull(Building.ZipCode, '') AS ZipCode
	  ,isnull(Building.CountryShortCode, '') AS Country
	  ,isnull(Building.StateProvinceCode, '') AS State
	  ,isnull(Building.Region, '') AS Region
	  ,isnull(Building.InsideCorp, 0) AS InsideCorp
        ,1 AS ExpressRoute       
  FROM [QoEArchive3].[dbo].[CqdNetwork] Network
  left join [QoEArchive3].[dbo].[CqdBuilding] Building
  on Network.BuildingKey = Building.BuildingKey
  left join  [QoEArchive3].[dbo].[CqdBuildingType] BuildingType
  on BuildingType.BuildingTypeId = Building.BuildingTypeId
  left join [QoEArchive3].[dbo].[CqdBuildingOwnerShipType] OwnerShipType
  on OwnerShipType.OwnershipTypeId = Building.OwnershipTypeId
  left join [QoEArchive3].[dbo].[CqdNetworkName] NetworkName
  on NetworkName.NetworkNameID = Network.NetworkNameID

Selecting media type in detailed reports

The detailed reports support looking at quality and media reliability for audio, video, application sharing and video based screen sharing media types. Dimensions, measures, and filters that are specific for a single media type have either “Audio”, “Video”, “AppSharing” “VBSS” as a prefix.

Call Quality Dashboard Dimensions.

If you want to view the dimensions and measures for a single media type, a use of the new MediaType dimension and filter may be required. For example, to have a report that shows the total session counts across different media types, you would include the MediaType dimension.

Call Quality Dashboard Total Stream Count.
Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!