Back to home

    Operations Automation

    Flight Data Processing and Strategic Reporting

    Affic AI automated the extraction, reporting, and QA loop for daily flight data so leadership could review accurate reports without waiting on manual spreadsheet work.

    ACV, Vietnam Airports Corporation

    Affic AI automated the extraction, reporting, and QA loop for daily flight data so leadership could review accurate reports without waiting on manual spreadsheet work.

    Challenge

    ACV handles high-volume domestic and international flight traffic. Analysts were manually consolidating flight records, validating the numbers, and preparing Excel-based leadership reports with almost no room for error.

    Solution

    We built an agentic workflow that pulls operational data, structures the report, checks the output against source files, and retries exceptions before handing off the final version. The team controls the flow through a lightweight conversational interface instead of custom scripts.

    Outcome

    The reporting cycle moved from a manual, analyst-driven process to a largely autonomous workflow that can run daily with consistent QA.

    • Handles 100 to 200 flights per day
    • Automates extraction, reporting, and QA
    • Reduces dependency on repeated spreadsheet work
    Back to all case studies