The data in the MRO system of an airline is extremely valuable to a lot of people in the organization. Usually, the data has value to a lot more people than have access to the MRO system itself. The MRO system as a source of data is so important but often not fully utilized. That is the reason why CrossConsense developed AviationDW – an enterprise data warehouse for aviation giving easy access to MRO data.

AviationDW is tailor-made for use with AMOS or other MRO backend systems. A data warehouse is a component of traditional business intelligence. It allows the user to generate key performance indicators (KPIs) and to analyze historical data.

AviationDW greatly simplifies KPI creation based on MRO system data. To this end, AviationDW provides easy-to-understand database schemas allowing business end-users to explore data without implementing complex logic. AviationDW favors the use of existing in-house reporting and visualization tools. The user connects to AviationDW with common solutions like Microsoft Power BI, Tableau, AWS QuickSight or others to directly benefit from existing in-house knowledge and capabilities.

Behind the scenes, the AviationDW data transformation jobs are running to prepare raw MRO data for easy access.

Connection to the backend MRO system is as safe as it gets. Data is exported by scripts on the customer’s side and sent to AviationDW. The full control over all data export activity stays with the customer. The database schema is well documented in a manual.

If you are interested in a personal presentation, please click the banner below.