Announcing Call Record Insights for Microsoft Teams
Published Apr 08 2024 08:00 AM 13.8K Views

In an era where Microsoft Teams is central to communication and collaboration, the treasure trove of data within call records has remained largely untapped due to the complexity and technical challenges of accessing and analyzing it. Call Record Insights simply and efficiently enables organizations to understand and act on call data.

The Challenge: Navigating the Data Maze

Organizations have long grappled with two major hurdles in leveraging Teams call records:

  • The Need for Custom Solutions: Accessing and managing call record data traditionally required bespoke development, a significant barrier that deterred many from utilizing the Call Records API effectively.
  • Complex Data Structures: The breadth and depth of data made available via the raw call record is immense and deeply layered. Making this data ready for analysis or reporting could be challenging. Call Record Insights flattens the call record into a well-structured format, reducing effort, and providing you with greater customization for accessing and rendering your data.


The Solution: Call Record Insights Unveiled

Call Record Insights elegantly addresses these challenges, transforming the way organizations interact with their Teams call data:

  • Automated Retrieval: With automatic fetching of call records upon their availability, the application streamlines the initial step of data collection, utilizing a Graph API subscription to simplify the initial data gathering phase.
  • Simplified Data Transformation: It converts the intricate JSON data structures into a clear, manageable format, ready for in-depth analysis.

Example of how the transformed call records look in Azure Data ExplorerExample of how the transformed call records look in Azure Data Explorer


  • Secure and Efficient Storage: The application securely stores the transformed data in Azure Cosmos DB and Kusto (Azure Data Explorer), ensuring both safety and accessibility.
  • Code-Free Deployment: Organizations can deploy this solution swiftly, without the need to delve into custom coding.
  • Quick and Powerful Data Analytics using KQL: Leverage Kusto Query Language (KQL) for immediate insights, such as call duration and type by user.

Example Query Showing Average Call Duration By User using Call Record DataExample Query Showing Average Call Duration By User using Call Record Data


  • Enabling Powerful At-A-Glance Views with Kusto Dashboards: Explore the possibilities with custom dashboards tailored for insightful analytics.

Example Dashboard from Kusto Dashboards using Call Record DataExample Dashboard from Kusto Dashboards using Call Record Data


  • Simplifying Complex Reporting Challenges: Utilize Azure Data Explorer's capabilities for advanced scenarios like anomaly detection.

Example of Kusto Anomaly Detection using Call Record DataExample of Kusto Anomaly Detection using Call Record Data


  • Connect directly with PowerBI and Generate custom views, including your own custom DAX measures and columns:

get data.png

call records.png


  • Built for Scale and Resilience: By leveraging Azure's robust infrastructure components such as Azure Event Hub, Azure Functions, Cosmos DB, and Kusto, the application is both scalable and resilient.
  • Seamless Data Augmentation: Thanks to Kusto’s extensive built-in connectors, enhancing call record data with additional information is straightforward, further enriching the insights you can derive. Examples include adding location and ISP mapping, as seen in the dashboard examples above.


The Benefits: Empowering Your Organization

Deploying Call Record Insights brings a host of advantages:

  • Complete Data Ownership and Control: Enjoy full sovereignty over your data, including End User Identifiable Information, with all storage and processing happening within your Azure subscription.
  • Scalable to Your Needs: Tailor the solution to fit any organizational size, from small teams to large enterprises.
  • Customizable Query Performance: Adapt the query performance to suit your specific requirements, optimizing for speed and efficiency.

Call Record Insights is not just a solution; it's a gateway to unlocking the full potential of Teams call records. By simplifying data access and analysis, it empowers organizations to make informed decisions, enhance operational efficiencies, and uncover new opportunities. Start your journey towards data mastery today and leverage the rich insights waiting within your Teams call records.



High-Level Architecture

Here is a glimpse into the solution's architecture, showcasing how it seamlessly integrates with Azure services to deliver its capabilities.



Embarking on Your Data Journey

Call Record Insights stands ready to transform your approach to Teams call data, promising a journey of discovery, efficiency, and strategic insight. Deploy it with ease and take the first step towards harnessing the full potential of your communications data.

Unlock the valuable insights Call Record Insights provides, deploy it today!


Deployment Guide:


For further information, including deployment guidance, code, and documentation, visit our GitHub Repository. Join our community today and start exploring myriad possibilities with Call Record Insights.

Version history
Last update:
‎Apr 18 2024 06:59 AM
Updated by: