Skip to content
← Back to projects

Microsoft product

Power Platform

Licensing & Usage

A tenant-scale reporting experience that transforms high-volume telemetry into clear, actionable licensing insights for Power Platform administrators.

Product documentation ↗

The product

Turn license consumption into decisions

The report helps administrators see who is consuming each license, find users and flows exceeding daily capacity, understand usage trends, and move directly from a tenant-wide summary into detailed action.

Power Platform admin center licensing overview

Architecture

From raw telemetry to an administrator-ready report

01 · Ingest

Apache Spark pipelines

Contributed to Spark-based pipelines that ingest raw product telemetry and prepare it for analytics processing.

02 · Transform

Synapse data modeling

Flattened and transformed large datasets into reporting-friendly structures inside Azure Synapse.

03 · Aggregate

Big Data SQL

Wrote large-scale SQL queries and designed pre-aggregations that made tenant and user-level analysis responsive.

04 · Serve

API contracts

Designed and implemented the API layer and contracts that translate analytical data into stable frontend capabilities.

Progressive detail

Move from capacity signals to the exact flows driving usage

Administrators can drill into a user, compare consumption across license contexts, identify the environments and flows creating demand, and export the underlying report for further analysis.

Power Platform licensing report with user-level usage trends and flow details

My contribution

Technical leadership across the complete product stack

~$10M

Revenue opportunity

Delivered foundational licensing-enforcement and consumption-reporting work that created an opportunity for approximately $10 million in additional product revenue.

Frontend

Architecture and team leadership

Designed the frontend architecture, partnered with Product and Design, and led a team of early-in-career engineers through implementation.

API

Service and contract design

Designed and implemented the API layer and durable contracts connecting the reporting experience to its analytical data.

Data

Large-scale analytics engineering

Built Synapse SQL aggregation and pre-aggregation strategies, transformed flattened datasets, and contributed to Spark ingestion from raw telemetry.

Designed and built by Phil Daniels · Powered by Astro · 2026