DAA have several BI solutions implemented around their business

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. 

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. 

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. 

The outcome

DAA now have a core solution that can be rolled out with minimal changes to core functionality, allowing them to offer a consistent view of data across the whole business. Following training from Transparity, DAA have taken ownership of the solution, and will continue to evolve it as the demand for further insight comes from the business.