SfB Video Broadcast – Advanced Analytics EP34 Summary

Jamie Stark and Sean Wilson talking in SfB Broadcast Advanced Analytics Episode 34 talking about Call Quality and Advanced Analytics in SfB Online. The broadcast went out last friday 27th Jan 2017. Just watched today as i chose to join the msuc.chat group meetings which was on at the same time msuc.chat was great so recommend checking that out as well. Link here.

You can view the broadcast here

Below is a summary from the video broadcast, hope you find this useful, the helpdesk analytics is great and coming to preview soon and CQD location-enhanced reporting is GA now !

Super important to provide media quality information and reports especially with Cloud PBX.

On premise SfB Server already has Monitoring Role and Call Quality Dashboard (CQD) server report where you can build reports and analysis data you also have the Monitoring role with CDR and QoE databases and monitoring reports which you can analyse. CDR give us the call detail records who called who and durations. QoE bring media quality, network, drivers, headsets information and MOSS scores. ALOT of data to be able to work with and analysis but Custom reporting used to take extensive SQL knowledge to create reports so the data is there but you had to take the time to build reports.

CQD is in SfB Online so you can have assess to information regarding online users. CQD allows you already to dive in and build custom reports for locations, subnet level and radios, band and channels a lot of data to help identify issues but you had to build the reports yourself. Microsoft themselves used CQD to view and resolve issues in buildings to provide info to network teams.

In house Microsoft and SfB Media team used CQD to help resolves issues as more and more users are using and adopting WiFi over wired connections. Buildings not designed with wireless and data. Placing WiFi access points is key! So viewing where the issue were and drilling down into the data was key.

CQD drill down to building specific info, wired vs wireless in buildings and subnets. Key to find ways to improve the services could be network, headsets etc. You can focus on key areas and save time.

Challenges with CQD was having to build custom reports and you can upload subnet information online and on premise

Why is it important to take my network topology into online ?

When you have a call i SfB online the call be flagged inside or outside the network ? By default all calls are tagged as external “outside the network” otherwise you would have to be inside Microsoft datacentre which no one is.

QoE based on premises you classed inside and outside network, on premise you would add your subnets and site names to improve the reporting information to included locations names and identity internal subnets as internal and other traffic as external.

CQD can now map data to buildings after you uploaded your network information. Remember to upload your building information!!! This will flag data as inside the network which is a great move. Previously you had to build these reports.

MSFT IT works with media team to build location enhanced reporting.

THIS IS PRODUCTION TODAY on your tenant !!! So go check them out.


This is key to operations and important to upload your subnets to map the data correctly. Always looking to improve to ensure they have great call quality

DEMO TIME from Sean

Seans walks over CQD at high level


Top overall Call Quality

  • Overall Call Quality
  • Server – client – Any conference call from client to Server AV MCU for meetings. Best way to identify call quality in Building as server is accurate. Client to server is make we can rely on as the server is managed endpoint.
  • Client – Client – peer to peer

This is the best way to identify in a building

With network building information uploaded you can see Wired Inside is your building information not Microsoft DC.


Questions if you have same subnet on home network ?

Most enterprises should have different subnets to common home network but if your company does use a common home subnet then it may class the home data as a building. This is similar with on premise.

Drill down by subnets



Check buildings by best call quality

View by WiFi and wired subnets




Second Building Name can be confusing !

First building is Office 365 datacentre!!! as its server-Client

So make sure to select second building from drop down list


View building by network and review over time to review any changes being made.

View Wi-Fi Bands, Radio Types, Days of week, Days of Month, Hours per day even desktop client Wi-Fi driver adapters !



Can review quality against Wi-Fi Channels


Desktop Client Versions


Client Audio Devices



Troubleshooting end users – In comes Troy from Engineering team to talk about call Analytics and helpdesk scenarios.

Troubleshooting issues usually takes time and the person investigation from helpdesk isn’t the person with the issue.

Help helpdesk admins dive into calls and see what happens could be using on-board speakers and mic or could be network connected on such as Wi-Fi. Issue with me or someone else.

Visualise information for helpdesk to solve issues faster !

Demo to show helpdesk function that will come out in preview soon!!! not available today.

Sign up for preview shortly. First scenario will be helpdesk scenario as its a pain point for helpdesks. Sign in on Skype preview here


Helpdesk role and search by user, type name


Drill down into a call

details for calls, other parties names are flagged as internal user (can be displayed or hidden based on roles and permissions)


View device, system, network by user !

View the other parties call quality information as well. Media is being sent and received by both parties so you can look at this as well which is great.


Flags orange on other user device and network

help identify remediation actions which is great !

This bring drilling down on information to user level.

Great for Tier 1. Tier 3 you can expose names on calls based on permissions.

First phase in preview programme, integrating more reports in meetings for GA. Rollout to small set of customers over next few month.

GA later this year! focus to help helpdesk.

Move to cloud and take advantage of big data, Microsoft working on getting this information to the dashboard as soon as possible. Collect environment data right after call and available after a few minutes !


Way to show poor stats and call failure rates per location??

Only exposes QoE not CDR information with failure codes. Expanding on call analytics and call failure rates are in the future with specific failure codes.

Next SfB Video Broadcast session

APP SDK 10th February !


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.