Presence Analytics for Teams (by 3SR)
oleh 3SR
Teams presence monitoring
What it does
This solution deploys an Azure Function App that periodically collects Teams presence signals through Microsoft Graph for selected Entra ID groups, stores daily aggregates in a Cosmos DB (NoSQL), and makes the resulting indicators available for reporting (Power BI).
Key benefits
-
Tenant-only deployment: data stays inside your Azure subscription and Entra ID tenant.
-
Privacy by design: anonymized aggregates by default, designed for team-level insights and trend analysis, not for employee surveillance. (Optional identifiable mode can be enabled based on your organization’s policies and local regulations.).
-
Operational visibility: understand activity trends per team/group over time (daily metrics).
-
Easy to operate: serverless components (Functions + Cosmos DB serverless) and Application Insights telemetry.
How it works (high level)
-
You choose one or more Entra ID Group IDs to monitor and define business hours.
-
The Function App retrieves presence signals via Microsoft Graph on a schedule.
-
Aggregates are stored in Cosmos DB and consumed by reporting (Power BI).
Typical use cases
-
Team / project leadership: monitor engagement trends and availability patterns.
-
Service managers: correlate operational events with availability indicators.
-
PMO / delivery: objective signals to support staffing and workload analysis.
Security & permissions
-
Uses Microsoft Graph with required permissions for presence read access (consent is performed in your tenant).
-
Function App uses Managed Identity and RBAC for Cosmos DB access.
-
Application Insights is enabled for observability.
Get started
Deploy from Azure portal, provide Entra Group IDs and business hours, then connect Power BI to the exposed dataset/endpoints.
