DAA Business Intelligence Solution with Transparity

DAA, a global airport and travel retail group, needed consistent baseline reporting and analytics across Aer Rianta International. Transparity delivered a business intelligence solution aligned to their latest operational systems, enabling standardised reporting to roll out globally.

Working with DAA’s BI team, Transparity used the Microsoft BI stack—Integration Services, a central SQL Data Warehouse, and Analysis Services cubes—plus report and dashboard migration. The outcome was a core solution providing a consistent view of data and, after training, full ownership by DAA. Explore our data consultancy and Power BI consultancy.

daa logo e1692348990422 300x115 1

Built a global BI platform

with a central SQL data warehouse

Delivered standardised KPIs

and reports across all regions

Enabled scalable analytics

and dashboards with full governance

Transparity provide us with invaluable services and support. This has enabled us to continue to develop and evolve our BI Solution, which provides critical insights for our business.

Bala Baskaran
BI Technical Manager at DAA

The challenge

DAA have several BI solutions implemented around their business. As they continue to centralise and standardise the operational systems across their global retail business Aer Rianta International, they wanted to achieve a consistent baseline reporting capability and analytics associated with these systems. This meant the development of a new BI solution based on their latest systems that could be rolled out as a standard solution globally.

image alt

The Solution

Transparity worked with the DAA Business Intelligence team to help design and build a new BI Solution. This solution made full use of the Microsoft BI Stack, using Integration Services and custom-built routines for transforming data. Data was stored in a central SQL Data Warehouse and a set of Analysis Services cubes were built to support reporting and analytics. Transparity helped with the migration of reports and dashboards as required.

image alt

The Outcome

Transparity worked with the DAA Business Intelligence team to help design and build a new BI Solution. This solution made full use of the Microsoft BI Stack, using Integration Services and custom-built routines for transforming data. Data was stored in a central SQL Data Warehouse and a set of Analysis Services cubes were built to support reporting and analytics. Transparity helped with the migration of reports and dashboards as required.

image alt

About DAA

A global airport and travel retail group with businesses in 15 countries around the world. DAA’s principal activities include operating and managing Dublin and Cork airports, global airport retailing through their subsidiary Aer Rianta International, and international aviation consultancy through DAA International. The company is state-owned and headquartered at Dublin Airport.

Transparity image