📅 Filter by year:

Audit & Inspection Progress · MNT

By status

Audit vs Inspection · closed vs in-progress

Report Progress

MCAR · Internal Audit Findings

AMO ECAR · Authority Findings

Open Reports — In Progress

—

🔍

Report No ↕	Form ↕	Status ↕	Owner ↕	Raised Date ↕	Target Date ↕	Days to Due ↕	CAT ↕	Finding Level	Repetitive	Audit Title

—

CAT I · ≤ 30 days

—

All forms

CAT II · 30–60 days

—

All forms

CAT III · > 60 days

—

All forms

By CAT

By Form Type

Overdue Detail — All forms

—

Report No ↕	Form ↕	Raised Date ↕	Target Date ↕	Days to Due ↕	CAT ↕	Finding Level	Audit Title

—

KPI Charts Year:

Total Findings

—

Open

—

Overdue

—

On-time Rate

—

CAT III

—

Audits

—

KPI 2 — Early Detection (Internal vs Authority)

MCAR vs AMO-ECAR theo Nature of finding (nhóm cha) — bức tranh khối lượng phát hiện

—

KPI QC — (CMR-CAR gán cờ QC + QC Spot Check) vs ECAR theo ATA

Tử = CMR-CAR + QC Spot Check tháng N−1 · Mẫu = ECAR tháng N

QC (CMR-CAR gán cờ + QC Spot Check) · tháng N−1 ECAR (authority) · tháng N

ATA Chapter	Internal (N−1)	ECAR (N)	Ratio	Assessment

Early-detection rate

—

AMO-ECAR phát hiện sớm ÷ tổng AMO-ECAR × 100%

AMO-ECAR đã phát hiện sớm (MCAR sớm hơn, cùng Nature/nội dung)

—

AMO-ECAR (authority) findings

—

Early detection — MCAR vs AMO-ECAR by group

—

Group by

Group	Phát hiện sớm	AMO-ECAR (tổng)	Rate %

All Forms Detail

—

🔍

—

PAVOI Detail

—

🔍

Report No ↕	Status ↕	Raised Date ↕	Target Date ↕	Days to Due ↕	Report Ref	Request For Verification	Verification Result	Department	RFI	Audit Ref (MNT)	Audit Title

—

CMR-CAR Findings

—

🔍

Report No ↕	Aircraft ↕	Status ↕	Findings ↕	Department	Raised Date ↕	Target Date ↕	Days to Due ↕

—

ECAR Findings

—

🔍

Report No ↕	Aircraft ↕	Status ↕	Finding Description	Raised Date ↕	Target Date ↕	Days to Due ↕	Detail

—

AMO-ECAR — Authority Findings (issued to AMO)

Total

—

Open

—

Overdue

—

Closed

—

AMO-ECAR — Authority Findings (issued to AMO)

—

Report No ↕	Status ↕	Raised ↕	Target ↕	Days to Due ↕	CAT ↕	Audit Title	Finding Description

—

MCAR — Internal Audit Findings

Total

—

Open

—

Overdue

—

Closed

—

MCAR — Internal Audit Findings

—

Report No ↕	Status ↕	Raised ↕	Raised by ↕	Target ↕	⚠ Deadline	Days to Due ↕	CAT ↕	Audit Title

—

SPI — Safety Performance Indicators

Target: Vietjet AMO's SPI must meet or better than the SPT (ALOS) approved by CAAV

📊 Bottleneck Analysis — Stage Status Aggregate

Loading data…

Audit Plan — QA AMO

—

🔍

Audit No ↕	Title ↕	Type ↕	Status ↕	Scheduled ↕	Lead	Location ↕	Findings ↕	Open	Overdue	Pipeline	Workflow

—

Doc No	Title	Document Type	Rev	Status	Owner	Review date	Distributed

Filter by

Year

Month

Form Type

All forms ▼

VietJet Air · Quality Assurance AMO

QA AMO — Summary Report

—

Exported: —

Total: —

KPI Summary

Charts

By status

Top Form Types

Findings by Month

Overdue Analysis

CAT	Count	Rate	Description

Summary by Form

Form	Open	Overdue	On-time	Lately	Closed	Total	%

Detail

Report No	Form	Status	Raised	Target	Days	CAT	Audit

VietJet Air · Quality Assurance AMO

User Guide

QA AMO Dashboard · Full documentation

Contents

📅

Bộ lọc năm (mới) — chọn 1 năm, 2 năm hoặc tất cả

Tất cả bộ lọc năm trên mọi trang giờ là một menu chọn nhiều năm. Bấm vào nút 📅 để mở danh sách: tích "All years" để xem toàn bộ, hoặc tích từng năm để so sánh (ví dụ chọn 2024 và 2025 cùng lúc). Nhãn nút hiển thị các năm đang chọn (vd "2025, 2024") — bảng và biểu đồ cập nhật ngay. Trang Overview, KPI Charts và SPI mặc định chọn năm hiện tại.

📖

Definitions & Terminology

Report Status

Open

Report is being processed, not yet due or has no target date. The assignee must carry out corrective action.

Overdue

Report has passed its target date but has not been closed. Must be prioritised immediately. Further classified by CAT I/II/III.

On-time Closed

Report closed on or before its target date. Applies only to forms that have a target date (CAR, MCAR, PAVOI…).

Lately Closed

Report was closed after its target date. Root-cause analysis is recommended to improve the on-time rate.

Closed

Report closed with no target date (Surveillance Report, Aircraft Inspection…). Not counted in the on-time rate.

Overdue Category (CAT)

CAT I

Overdue ≤ 30 days — Monitor closely and follow up within the week.

CAT II

Overdue 30–60 days — Escalate to senior management and request a corrective action plan.

CAT III

Overdue > 60 days — Critical. Report immediately to senior leadership and take urgent action.

QA AMO Form Types

Surveillance Report (SR)

Periodic surveillance report. No target date. Generated from Inspection activities.

Aircraft Inspection/Spot Check (AISC)

Random or scheduled aircraft inspection at the ramp.

MCAR

Mandatory Corrective Action Report — Mandatory corrective action report from internal audits.

PAVOI

Post Audit Verification of Implementation — Tracks implementation of corrective actions.

CAR

Corrective Action Report — Corrective action report from external audits or CAAV.

MOR

Mandatory Occurrence Report — Mandatory occurrence report as required by CAAV regulations.

AMO ECAR

Internal AMO Electronic Corrective Action Report.

Battery Workshop Inspection (BWI)

Periodic battery maintenance workshop inspection — once per month.

KPI Definitions

On-time Rate

= On-time Closed ÷ (On-time Closed + Lately Closed) × 100%. Calculated only on forms with a target date. Target: ≥ 70%.

Repetitive Rate

= Number of repeated findings ÷ Total findings × 100%. Findings marked "Repetitive = Yes" in the form. Target: ≤ 10%.

Days to Due

Days remaining until the target date (positive = within deadline, negative = overdue). Calculated from today.

📊

Page Guide

📊Overview

Full QA AMO summary dashboard. The Year filter at the top lets you view data by year (defaults to current year).
• 6 KPI cards: Total / Open / Overdue / On-time / Lately / Closed
• Donut chart: Distribution by status
• Findings by Month: Monthly trend — filter further by year using the dropdown in the top-right corner
• Top Forms: Forms with the most findings — filter by All/Open/Overdue
• Form table: Open/Overdue/Closed totals per form type
• 4 metric cards: Open+Overdue / On-time Rate / CAT III / Repetitive

📋Open Reports

List of all reports currently in Open or Overdue status.
• Filter by Status (All/Open/Overdue), Form Type, Year, or free-text search
• Days to Due column: green = plenty of time, orange = approaching deadline, red = overdue
• Click any column header to sort ascending/descending
• ⚠ Yes in the Repetitive column = this finding has occurred before

⚠️Overdue

Shows only overdue reports, analysed by CAT level.
• 3 KPI cards: CAT I / CAT II / CAT III with exact counts
• By CAT chart: Overdue distribution by severity
• By Form chart: Which forms have the most overdue items
• Filter by Form Type and CAT level

📈KPI Charts

KPI trend analysis over time.
• On-time Rate by Month: 70% target line — track which months pass or fail
• Repetitive Rate by Month: Trend of repeated findings
• Cumulative YTD: Year-to-date cumulative finding count
• On-time Rate by Year: Year-on-year performance comparison
• Repetitive Rate by Year: Year-on-year repetitive finding trend

📄All Forms

Complete list of all QA AMO reports across every status.
• Filter by Status, Form Type, Year, or search
• MNT No column: Audit number that this report belongs to
• Audit Ref column: Audit reference number (Audit Ref. No)
• Audit Title column: Name of the audit — click the column header to sort

🔍PAVOI Detail

Shows only PAVOI forms with full verification details.
• Request For Verification: Content of the verification request for implementation
• Report Reference: Original report number that the PAVOI is tracking (e.g. MCAR-0086)
• Verification Result: Satisfactory = passed / Not Satisfactory = not yet passed
• Department: Department responsible for implementation

📅Audit Plan

QA AMO audit schedule and history from Galileo Planner.
• 6 KPI cards: Total / Internal Audit / Inspection / Closed / In Progress / Scheduled
• Filter by Type (📋 Internal Audit / 🔍 Inspection), Status, Year
• Findings column: Number of reports generated from that audit
• Open/Overdue column: Open/overdue finding count for that audit
• Scheduled audits = not yet started (future plans)

📄

Export Reports

🔑 Admin Only

Mọi chức năng xuất báo cáo (PDF/Excel ở trang Export Reports, cũng như các nút ⬇ PDF/Excel trên CMR-CAR, ECAR, Audit Plan, Query Builder…) chỉ hiển thị và hoạt động với tài khoản Admin. Người dùng thường (Viewer) sẽ không thấy các nút này.

📄 Export PDF

Export report as a PDF for printing or emailing.

PDF contents include:
• VietJet red header with report title
• 6 KPI cards
• 3 charts (Status, Top Forms, Monthly)
• Overdue by CAT analysis table
• Summary table by Form type
• Finding details (up to 200 records)

PDF is automatically paginated to A4.

📊 Export Excel

Export a .xlsx file for further analysis in Excel.

Excel file has 3 sheets:
• Sheet 1 — KPI Summary: KPI totals and Overdue CAT breakdown
• Sheet 2 — Form Summary: Open/Overdue/On-time/Lately/Closed per form type
• Sheet 3 — Detail Data: All findings with full field data

Filename is auto-generated with the report title and export date.

🔧 How to use the Export page:

Step 1: Open Export Reports from the left sidebar
Step 2: Choose a filter type from the "Filter by" dropdown:
  • By Month/Year → select a specific Year and Month
  • By Quarter/Year → select a Year and Quarter (Q1–Q4)
  • By Form Type → select a specific form (MCAR, PAVOI…)
  • All → no filter, loads all data
Step 3: Review the report preview on the page
Step 4: Click 📄 PDF or 📊 Excel to download

💡

Frequently Asked Questions

❓ Why does the total report count exceed 3,000?

The dashboard loads the full QA AMO history since the Galileo system went live. Use the Year filter on the Overview page to view data for a specific year.

❓ What does an on-time rate of 12% mean?

Only 12% of forms with a target date were closed on time. This figure is calculated only on forms that have a target date (CAR, MCAR, PAVOI). Forms without a target date (Surveillance, AISC) are excluded from the on-time rate.

❓ Why is the Repetitive count 0?

The "Repetitive" field in Galileo must be set to "Yes" when creating a finding. If it is left blank, the dashboard cannot detect it. Auditors should be reminded to fill in this field.

❓ When is the data updated?

Click the "↻ Refresh" button on the topbar to reload the latest data from Galileo at any time. The dashboard also auto-refreshes its data every 12 hours (for LED / kiosk screens) without reloading the page or logging you out. Loading takes approximately 30–60 seconds.

❓ Why does Audit Plan show 963 records?

The dashboard loads all audits for QA AMO auditors (Vo Vinh Hien, Le Hong Chuong, Thai Ba Hoa…) from past to present, including future Scheduled audits. Use the Year filter to view a specific year's plan.

❓ How do I add a new user?

The user self-registers on the login page → Admin goes to "User Management" → Approve the account. Admins can Approve/Reject/grant Admin rights to other users.

QA AMO Dashboard · VietJet Air · Data from Galileo GRC · Developed by QA AMO Team

User Management

—

Full Name	Username	Role	Registered	Actions

🔬 Query Builder

Tự truy vấn dữ liệu Galileo — không cần code. 4 bước: ① chọn bảng → ② tích cột → ③ thêm điều kiện lọc → ④ bấm Run Query

Bước 1 · Bảng chính (Primary Table)

Chọn bảng dữ liệu nguồn, rồi tích những cột muốn hiển thị.

Fields to display:

|

Select a table first

Bước 2 · Ghép bảng (Join) — tùy chọn

Bỏ qua nếu chỉ cần 1 bảng. Ghép thêm bảng liên quan khi cần đối chiếu.

Bước 3 · Điều kiện lọc (Filter) — tùy chọn

Thêm điều kiện để thu hẹp kết quả (vd: năm = 2025, trạng thái = Open).

OData nodes0 / 100

Bước 4 · Sắp xếp & giới hạn (Sort & limit)

Chọn cột sắp xếp và số dòng tối đa, rồi bấm Run Query bên dưới.

Row limit

Pick a table and run a query to see results

🔬

Pick a table → check fields → add filters → Run Query

My Dashboard 🔑 Admin Only

Các widget bạn đã ghim từ Query Builder. Mở Query Builder → chạy truy vấn → bấm 📌 Pin để thêm widget vào đây.