Windows Store Insights — Authoring the MAU & DAU Metric Definitions Microsoft Still Uses

The problem

Microsoft's Windows Store (now Microsoft Store) is the official application distribution channel for the Windows operating system, supporting hundreds of millions of Windows users globally. Microsoft's product, marketing, and business-leadership teams needed a BI and data-warehouse platform for multidimensional analysis of Windows Store performance, developer ecosystem health, and consumer engagement. The program lacked systematic testing discipline and lacked standardized definitions for the headline product-health metrics — Monthly Active Users and Daily Active Users — that would later become industry-standard across consumer software platforms.

Transformation approach

I served in two successive leadership roles on the Windows Store Insights program.

As Test Engineering Manager (Jul 2015 – Mar 2016), I developed and implemented the program's comprehensive test strategy, introducing systematic testing disciplines that had been lacking. I designed a Traceability Matrix linking features to test cases, introduced smoke testing and bi-annual regression testing cycles, established daily production health checks, and instituted weekly management reporting on software health metrics. Within three months, the interventions measurably reduced the program's open bug count.

As Project Manager (Apr 2016 – Jun 2017), I took ownership of the full BI/DW environment, overseeing data architecture design (tabular mode on star schema), pipeline development, and KPI definition. Most significantly, I authored and drove the design and enterprise adoption of key product metrics — including Active Users, Monthly Active Users (MAU), and Daily Active Users (DAU) — metrics that became central to how Microsoft tracked and reported on the Windows Store ecosystem's health and growth.

Innovation

The MAU and DAU metric definitions driven into Microsoft's Windows Store reporting through this program were carried forward — by me — into the subsequent Microsoft Teams telemetry program (2018–2021), where the same metric framework was extended to billion-event/day scale across Microsoft's global Teams user base. The metric-design influence within Microsoft's product analytics has been continuous since.

This engagement also marked the start of a continuous, multi-year Microsoft engagement track that subsequently encompassed Azure IoT/OSVRD (2017–2018), Microsoft Teams telemetry (2018–2021), Microsoft Business Operations partner-incentive analytics (2021–2023), and the Microsoft Fast Track BI program at HCL Technologies (2023–2025).

Responsibilities

• Authored the program's comprehensive test strategy and introduced systematic testing disciplines
• Built a feature-to-test-case Traceability Matrix and introduced smoke and regression testing cycles
• Instituted daily production health checks and weekly management reporting on software quality metrics
• Designed the tabular-on-star-schema data architecture and oversaw ETL pipeline development
• Drove the design and adoption of MAU and DAU metrics that became central to Microsoft's Windows Store reporting
• Onboarded data feeds from multiple internal Microsoft sources (Asimov, Cosmos) and validated end-to-end data integrity

Impact

• Quality: Systematic testing disciplines (smoke testing, regression cycles, daily health checks, Traceability Matrix) measurably reduced WSI's open bug count within three months.
• Accountability: Traceability Matrix and weekly management reporting established visibility for platform quality that had not previously existed in the program.
• Multidimensional analysis: Tabular-on-star-schema BI/DW architecture and ETL pipelines from Asimov/Cosmos enabled multidimensional Windows Store analysis at global scale.
• Business influence: Drove design and adoption of MAU and DAU metrics — analytical measures that became foundational to how Microsoft tracked and reported on its app store ecosystem's performance and growth, and that were subsequently carried into Microsoft Teams telemetry.

Coverage

• Microsoft Store
• Microsoft Power BI