CAREERS
    CONTACT US
    sbi_logo_positif240x240px_cropped
    Back to achievements

    A modern Data Platform to strengthen Customer Loyalty at Air Canada

    • Practice
    Data Governance Road Map Data Visualization Data Management Data Architecture
    • Team

    1 Architecte,
    1 Tech Lead,
    3 Developers,
    2 Business Analysts

    • Technical environment
    + 5,000
    Users migrated on the new platform
    + 100
    Reports available in Power BI
    + 4,000,000
    Transaction managed everyday
    CHALLENGES

    Air Canada is Canada’s largest airline and one of the world’s top 20 carriers, operating more than 1,500 scheduled flights. The company was recognized as the Best Airline in North America in 2019 by SkyTrax.

    • Air Canada integrates the subsidiary historically responsible for managing its loyalty programs.
    • While the loyalty program benefits from strong expertise and proven applications, its technical stack is no longer aligned with Air Canada’s cloud strategy (Azure, Power BI).
    • The merger creates a timely opportunity to redesign the data platform and transition to a more scalable and high-performance architecture.
    SOLUTION

    With deep expertise in both Power BI and Strategy (formerly MicroStrategy), SBI ensured a smooth and controlled migration. The team addressed the functional and UX differences between the two tools while integrating the evolution requests expressed by business users.

    A detailed architecture assessment helped define an ambitious target state and select the components best aligned with Air Canada’s IT strategic direction. The transformation included:

    • Migrating the Teradata data platform to Azure, leveraging Synapse and Snowflake
    • Transitioning Strategy and Tableau applications to Power BI
    • Implementing Microsoft Fabric and Dataiku to strengthen the analytics ecosystem
    • Automating deployments through Azure DevOps
    • Reinforcing governance with segmented, role-based access.

    Together, these steps laid the foundation for a more scalable, modern, and business-aligned data platform for Air Canada’s loyalty program.

    BENEFITS

    A comprehensive transformation plan helps ensure a smooth transition and effective adoption across both business and IT teams.

    • 50% reduction in daily processing costs
    • More reliable and consistent deployments
    • Stronger BI adoption across business departments, with new use cases defined, prioritized, and integrated into a clear implementation roadmap
    • Improved collaboration between IT and business teams, supported by a Self-Service BI strategy that increases business autonomy and distributes governance responsibilities more effectively.