Bridge Communications

Saturday, October 1, 2016

Using Power BI to Measure Skype for Business QoEMetrics Part IV

This week we will continue to build our Power Bi dashboard to view Skype for Business QoeMetrics.  Today we will focus on video calls, and build 3 visuals.

So on a Saturday morning I start a video call to make sure I have some data.  We are going to record the send and receive frame rate, video loss rate, and low rate percent.  Our data query will be this;

 select top 10000 convert(date,ConferenceDateTime) as [Date], avg (SendFrameRateAverage) as [Send Frame Rate], avg(RecvFrameRateAverage) as [Receive Frame Rate], avg(VideoPacketLossRate) as [Video Loss Rate], avg(LowFrameRateCallPercent) as [Low Rate Percent] from QoEReportsVideoUserAgentView group by convert(date,ConferenceDateTime) order by convert(date,ConferenceDateTime)

From here we can add our 3 visuals.  The first visual I add the date as the axis then the send and receive and values, and I used a multi-column bar visual

For the other 2 visuals I use and area chart with date as the axis and the value of each as the value field.  You can see with the improvements of Skype for Business over time our percent of low frames and packet loss has dropped to almost nothing.

Doug Routledge, C# Lync, Skype for Business, SQL, Exchange, UC, Full Stack Developer  BridgeOC
Twitter - @droutledge @ndbridge