adesso.Matrix42.PowerBI

Power BI analytics for Matrix42 — ticket operations and demand management reporting.

                    ┌─────────────┐
                    │  Matrix42   │
                    │  (Source)   │
                    └──────┬──────┘
                           │ Data Queries + Data View Sets
                           ▼
                    ┌─────────────┐
                    │  Power BI   │
                    │  (Reports)  │
                    └─────────────┘

Quick Start

# 1. This repo uses Git LFS for .pbix files
git lfs install

# 2. Clone
git clone https://dev.azure.com/.../adesso.Matrix42.PowerBI

What's Inside

powerbi/
├── demands/                    5 Power Query files for Demand Management
├── ticketing/analytics/        Ticket analytics: PQ source, DAX table, 14 calculated columns
├── fxGetAuthHeader.pq          Shared: authentication helper
├── fxGetDataQuery.pq           Shared: Data Query API wrapper
└── fxGetDataViewSet.pq         Shared: Data View Set API wrapper

matrix42/packages/              Matrix42 configuration packages (Data Queries, Data Views)

docs/                           Detailed documentation

Documentation

Guide	What You'll Learn
Semantic Models	How the Tickets and Demands Power BI models are built — tables, columns, deduplication, incremental refresh
Data Sources	How data is pulled from Matrix42 — Data Queries, Data View Sets, ASQL vs raw SQL, column definitions
Data Flow	End-to-end: Matrix42 schema → queries → Power Query → DAX → visuals

Reports

Report (.pbix)	Board	Data
adesso_se_matrix42_analytics	Ticketing Analytics	Ticket history, SLA compliance, escalations, turnaround times
adesso_se_matrix42_demand_management_v4	Demand Management	Demand requests, ratings, suppliers, service requests