Business Intelligence Solution for Hospitality Provider

Customer: Leading Hospitality Provider

Critical Issue: Customer is having difficulty creating reports and providing timely responses to their customers based on data collected via surveys.

Reasons: Customer has a highly manual process for creating reports and relies on Microsoft Excel, Access and manual intervention to deliver their data products to management.

Vision:  Provide Customer with a data mart using a dimensional data model that allows standard reports to be automatically generated and custom reports and data analysis to be easily created.

AETEA Provided: A business intelligence and reporting solution using Microsoft SQL Server 2008, SQL Server Analysis Services and SQL Server Reporting Services.  AETEA also provided the consulting and analysis of current business processes in order to ensure that customer data was provided accurately and as needed to meet their demand.

Results: This solution has taken a highly manual process that could take as long as 2 months to create reports and provide customer’s data to a solution that provides immediate access to standard reports as data becomes available.  In addition, new metrics and additional analysis capabilities have also been utilized now that the information is more accessible and automated.