LandingPageMetrics
Overview
LandingPageMetrics table contains the metrics values on the MSAI Data Platform Fundamental Core Metrics dashboard landing page (https://msit.powerbi.com/groups/me/apps/5aa6434b-5b43-4f18-ae4a-5c26249a2227/reports/96204257-2519-48ba-8b44-da34994b6f8c/ReportSectionb1e7cf7acac79aca2209?ctid=72f988bf-86f1-41af-91ab-2d7cd011db47 ).
Basic Information
Freshness: Monthly Refresh
Upstream Data Source: AurigaSentry Data, 1ES CloudMine Data, SOTEL Insights Data
Data StartTime: Half a year
Data Retention: No Expiration
Data Content: Calculated SLA,P95,Count Issue,Compliance Rate,COGS etc
Columns
| Column Name | Data Type | Description | Sample Value | IsNullable |
|---|---|---|---|---|
| MetricId | int | Auto-increment field | 9 | False |
| MetricName | nvarchar(100) | Metrics Name | (#) Count of the Customer Impacted Issues | False |
| Date | datetime | The snapshot time for the metrics value | 2021-11-01 00:00:00.000 | False |
| Value | decimal(10,2) | Specific metrics value | 0.00 | False |
Usage
Sample Scripts
Find specific data according to criteria of the LandingPageMetrics,as input or output
SELECT MetricId
,MetricName
,Date
,Value
FROM [dbo].[LandingPageMetrics]
where Date = '2021-12-01'
Sample Data
| MetricId | MetricName | Date | Value |
|---|---|---|---|
| 713 | ($) MSAI Data Platform Cosmos COGS (Storage+Processing) | 2021-12-01 00:00:00.000 | 98050.78 |
| 882 | (#) Count of the Customer Impacted Issues | 2021-12-01 00:00:00.000 | 4.00 |
| 900 | (#) Days of PullRequest Completion Duration (EE) | 2021-12-01 00:00:00.000 | 5.96 |
| 907 | (%) Compliance 1CS Security Review Completion Rate | 2021-12-01 00:00:00.000 | 100.00 |
| 915 | (%) Compliance 1CS Privacy Review Completion Rate | 2021-12-01 00:00:00.000 | 100.00 |
| 925 | (Hour) P95 of the Daily Session Data delay | 2021-12-01 00:00:00.000 | 76.84 |
| 934 | (%) Availability of the Daily Session Data within SLA 48h | 2021-12-01 00:00:00.000 | 93.55 |