View source for NCR Report Analysis

== Summary ==


== Filters ==
{| class="wikitable"
|+
!Filter
!Description
|-
|
|
|}

== Data Transformation Applied ==
{| class="wikitable"
|+
!Query
!Transformations
|-
|Datacair tickects table API link =<nowiki>https://customer-service.datacair.com/api/ticket/ticket?department=4&limit=1000000000</nowiki>
|
* '''API Endpoint''': <code><nowiki>https://customer-service.datacair.com/api/ticket/ticket?department=4&limit=1000000000</nowiki></code>

* '''Purpose''': Retrieves comprehensive ticket information for department ID '''4''', including metadata and key lifecycle fields. The <code>limit</code> 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 =<nowiki>https://dcbiaero.sharepoint.com/sites/NCRDatabase/</nowiki>
|'''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.
|}

== Calculations ==
[[File:Report-ncrpage-reportanalysis.png|none|thumb|800x800px]]
{| class="wikitable"
|+
!Columns
!Calculation
!Description
|-
|
|
|
|}