SOLVED
Home

PowerBI / Detailed PSTN Info for Call Queues / Auto Attendants in Teams

%3CLINGO-SUB%20id%3D%22lingo-sub-299822%22%20slang%3D%22en-US%22%3EPowerBI%20%2F%20Detailed%20PSTN%20Info%20for%20Call%20Queues%20%2F%20Auto%20Attendants%20in%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-299822%22%20slang%3D%22en-US%22%3E%3CP%3EFor%20any%20business%2C%20data%20is%20key.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMicrosoft%20Teams%2FSkype%20for%20Business%20is%20a%20complete%20let%20down%20when%20it%20comes%20to%20analytical%20data.%20Our%20PBX%20is%20completely%20cloud%20based%2C%20yet%20I%20cannot%20access%20simple%20reports%20like%20%22Who's%20on%20the%20phone%20now%22%20or%20%22How%20many%20calls%20is%20the%20Sales%20department%20answering%3F%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESkype%20for%20Business%2FTeams%20has%20a%20very%20basic%20PSTN%20report.%20But%20it%20does%20not%20give%20information%20for%20calls%20that%20are%20incoming%20from%20a%20Call%20Queue%20-%20for%20example%2C%20%22Who%20answered%20the%20phone%3F%22%20%22How%20long%20did%20it%20take%20to%20answer%20that%20call%20from%20the%20Sales%20Queue%3F%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWithout%20this%20basic%20call%20information%20from%20any%20reporting%20solution%2C%20we%20cannot%20improve%20our%20service.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20question%20is%2C%20what%20is%20Microsoft%20doing%20in%20terms%20of%20reporting%20for%20Teams%2FSkype%20for%20Business%20-%20Can%20we%20expect%20any%20meaningful%20PowerBI%20integration%20anytime%20soon%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F62585iEDEDAB99199A9DC8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture.JPG%22%20title%3D%22Capture.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-299822%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EActivity%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAdministrator%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAnalytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-299909%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20PowerBI%20%2F%20Detailed%20PSTN%20Info%20for%20Call%20Queues%20%2F%20Auto%20Attendants%20in%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-299909%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F36630%22%20target%3D%22_blank%22%3E%40Krishnan%20Raghupathi%3C%2FA%3E%26nbsp%3BThank%20you%20for%20your%20reply.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20no%20PowerBI%20integration%20is%20in%20the%20spotlight%2C%20please%20can%20you%20look%20at%20enabling%20the%20PowerShell%20CMDlet%20that%20was%20disabled%20by%20Microsoft%20for%20auto%20exporting%20the%20PSTN%20reports.%20All%20of%20our%20services%20run%20through%20Office%20365%20and%20Dynamics%2C%20and%20we'd%20really%20like%20to%20pull%20data%20from%20the%20services%20we%20are%20using.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20news%20to%20hear%20that%20statistics%20are%20being%20looked%20at.%20And%20I%20implore%20you%20to%20contact%20me%20further%20should%20you%20require%20any%20feedback.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks!%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-299828%22%20slang%3D%22en-US%22%3ERE%3A%20PowerBI%20%2F%20Detailed%20PSTN%20Info%20for%20Call%20Queues%20%2F%20Auto%20Attendants%20in%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-299828%22%20slang%3D%22en-US%22%3EHi%20James!%20This%20is%20something%20we%20hear%20quite%20a%20bit%20-%20we%20are%20looking%20into%20a%20round%20of%20improvements%20to%20Call%20Queues%2F%20Auto%20Attendant%20-%20including%20surfacing%20some%20simple%20statistics%20from%20the%20Call%20Queue%20for%20queue%20members.%20We%20don't%20currently%20plan%20to%20hook%20this%20up%20to%20Power%20BI%20as%20yet%20though.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-456076%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20PowerBI%20%2F%20Detailed%20PSTN%20Info%20for%20Call%20Queues%20%2F%20Auto%20Attendants%20in%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-456076%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F36630%22%20target%3D%22_blank%22%3E%40Krishnan%20Raghupathi%3C%2FA%3Efollowing%20for%20necessary%20update%20on%20simple%20statistics.%26nbsp%3B%20Abandon%20Rate%2C%20ASA%2C%20etc.%20by%20agent%20and%20by%20queue.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
James Lovegrove
Occasional Contributor

For any business, data is key.

 

Microsoft Teams/Skype for Business is a complete let down when it comes to analytical data. Our PBX is completely cloud based, yet I cannot access simple reports like "Who's on the phone now" or "How many calls is the Sales department answering?".

 

Skype for Business/Teams has a very basic PSTN report. But it does not give information for calls that are incoming from a Call Queue - for example, "Who answered the phone?" "How long did it take to answer that call from the Sales Queue?"

 

Without this basic call information from any reporting solution, we cannot improve our service.

 

My question is, what is Microsoft doing in terms of reporting for Teams/Skype for Business - Can we expect any meaningful PowerBI integration anytime soon

Capture.JPG

3 Replies
Highlighted
Solution
Hi James! This is something we hear quite a bit - we are looking into a round of improvements to Call Queues/ Auto Attendant - including surfacing some simple statistics from the Call Queue for queue members. We don't currently plan to hook this up to Power BI as yet though.
Highlighted

@Krishnan Raghupathi Thank you for your reply.

 

If no PowerBI integration is in the spotlight, please can you look at enabling the PowerShell CMDlet that was disabled by Microsoft for auto exporting the PSTN reports. All of our services run through Office 365 and Dynamics, and we'd really like to pull data from the services we are using.

 

Good news to hear that statistics are being looked at. And I implore you to contact me further should you require any feedback.

 

Many thanks! :)

Highlighted

@Krishnan Raghupathifollowing for necessary update on simple statistics.  Abandon Rate, ASA, etc. by agent and by queue.

Related Conversations