NCR Report Analysis

Summary


Filter	Description


Query	Transformations
Datacair tickects table API link =https://customer-service.datacair.com/api/ticket/ticket?department=4&limit=1000000000	API Endpoint: `https://customer-service.datacair.com/api/ticket/ticket?department=4&limit=1000000000` Purpose: Retrieves comprehensive ticket information for department ID 4, including metadata and key lifecycle fields. The `limit` parameter is explicitly set to a very high value to ensure all relevant records are returned in a single call, bypassing default pagination limits.
SharePoint Tables =https://dcbiaero.sharepoint.com/sites/NCRDatabase/	Purpose: Connects to the NCR Database stored on SharePoint and retrieves all available tables and lists. Details: Uses SharePoint API version 2.0 and loads all views in the site. Enables access to structured NCR (Non-Conformance Report) data for further transformation and reporting in Power BI. Usage: This source is used to supplement other datasets with NCR-related metadata or additional ticket details not available in the primary API.


Columns	Calculation	Description