AI-Assisted Data Exploration and Reporting for Analysts
Planning & Decision-making · Inform
What it collects that can identify you
- User queries and interaction patterns within the Power BI interface, which are processed to generate responses and may be used to improve the system. The register does not detail how query logs are handled.
Also collects operational data, which is anonymized data.
- Run by
- Canadian Air Transport Security Authority (CATSA)
- Where
- No fixed location
- Kept
- Not stated by the Helpful Places.
- Shared with
- Accountable organization
- Your copy
- You cannot see the data it holds about you. What you can do
What it is for
This system enables Canadian Air Transport Security Authority (CATSA) employees to explore internal data and generate reports using natural language, without needing deep technical skills. Users type plain-language questions and the AI retrieves relevant data and produces summaries or visualizations in Power BI. It is an internal productivity tool used only by government employees and does not make decisions about members of the public.
What it collects and what happens to it
Data taken in
- Internal CATSA operational datasets stored in Power BI, queried at runtime in response to employee natural language questions. The register does not specify the exact content of these datasets.
- User queries and interaction patterns within the Power BI interface, which are processed to generate responses and may be used to improve the system. The register does not detail how query logs are handled.
Processing
- Microsoft Copilot leverages large language models for natural language understanding and generation, enabling users to query data and receive summarized findings in conversational language.
- Retrieval of relevant data from Power BI datasets in response to natural language queries, surfacing the most pertinent records and metrics for the user's question.
What it does
- The system understands natural language questions from users and retrieves relevant data from Power BI datasets, returning matches and summaries for the user to interpret and act upon.
- The AI automatically identifies relevant data sets, performs analyses, and presents findings; however, all interpretations and resulting decisions remain with the human employee.
- The system automatically generates comprehensive reports and data visualizations, presenting findings in a clear, accessible manner for human review.
Outputs
- AI-generated reports, summaries, and data visualizations produced in response to employee queries within Power BI. These outputs are intended for internal use by CATSA staff.
- Analytical findings and data-driven insights presented to employees as recommended interpretations of queried data, supporting but not replacing human judgment in decision-making.
Run by
- CATSA is the federal agency that deploys and operates this AI tool to support internal data analysis and reporting by its employees.
Built by
- Microsoft builds and licenses the Copilot AI capability embedded in Power BI, providing the underlying natural language processing and data retrieval technology.
Government of Canada AI Registry — CATSA entry, Developed by: Other
Kept for
Not stated by the Helpful Places.
Shared with
- Outputs and query logs are available to CATSA as the deploying organization. Access is restricted to authorized GC employees.
- This is an internal government tool. Members of the public have no access to the system, its outputs, or any data it processes.
Stored
Not stated by the Helpful Places.
How to read the colours
Can it identify you?
- Anonymized data
- Data about people with the link to who is broken. Stripped of identifiers, blurred, aggregated, or noised so this system can’t reasonably tie a record back to an individual.
- Pseudonymous data
- Each person’s data is tied to a token (hash, ID, template) that lets this system recognise the same person across events, but the token itself doesn’t reveal a name. Reidentification is possible with extra information.
- Identifiable data
- The data either contains a direct identifier (name, address, account name, recognisable face or voice, plate number) or carries a token this system uses to look up legal identity during processing.
Who completes the loop?
- Human decides
- This mode suggests; a person decides what to do next. The AI is always advisory — a human is in the loop on every decision. Example: a triage tool ranks cases for a clinician who chooses which to see first.
- Human executes
- This mode decides; a person carries out the result. Example: an optimizer plans the day’s trash-collection routes, and drivers run them.
- Autonomous
- This mode decides and acts on its own. No person reviews each decision or carries out the resulting action.
Definitions from the DTPR standard. Amber is about your data, violet about who decides. The fuller the shape and the deeper the colour, the more identifying the data or the less a person is involved.
- AI registerGovernment of Canada Algorithmic Impact Assessment Registry — Microsoft Copilot for Microsoft Power BI (2526-CATSA-ACSTA-006)Canadian Air Transport Security Authority, AI Register entry 2526-CATSA-ACSTA-006.
- AI registerGovernment of Canada AI Registry — CATSA entry
- AI registerGovernment of Canada AI Registry — CATSA entry, Developed by: Other
- Register entryPublished by the Helpful Places. Reference 2a968730. This disclosure was drafted with AI assistance.Schema: ai@2026-05-06-beta
What you can do
Ask about this system
Questions go to the Helpful Places, not the vendor.
Your rights
- Right to Be Informed of AI UseCATSA employees using Power BI are informed that Microsoft Copilot AI capabilities are active within the tool. As this system serves only internal government staff and does not affect members of the public, public notice obligations are limited.
- Right to Algorithmic TransparencyThe Government of Canada's public AI register discloses the existence and general function of this system. Employees may contact CATSA for further information about how the tool processes queries.
Risks and safeguards
- Societal & cultural harmAI-generated reports or summaries may contain hallucinations or misrepresentations of underlying data, leading employees to draw incorrect conclusions.Safeguard: The system is positioned as a self-serve assistant; employees are expected to verify findings and apply their own judgment before acting on AI outputs. Human oversight is retained for all consequential decisions.
- Financial & business harmErroneous AI-generated analyses could inform resource allocation or operational decisions with financial consequences for CATSA.Safeguard: Outputs are advisory only; all decisions remain with human employees who retain accountability for conclusions reached using AI-assisted reports.