Expedia Rolls Out BI Solution to Track Advertising Performance

Overview

The Expedia Media Solutions team's sales performance data was not easily accessible by the sales team or the upper level management.
After completing a thorough requirements gathering project geared towards finding the right tools that would harness the data and relay it in a simple, straight forward manner, Expedia began evaluating the Microsoft SQL Server Analysis Services tools. Expedia decided to implement these tools with the help of Madrona Solutions Group.

Expedia discovered that they could meet their business goals faster and more cost effectively compared to a custom developed solution. Expedia also learned that the SQL Server tools used to implement the business intelligence solution were easily modified, updated, and changed without programming experience. User adoption rates are high, thanks to Microsoft SQL Server’s flexibility and intuitive design, the thoughtful requirement gathering and collective input of Expedia Media Solutions, and the ability of the Expedia team to support the technology requirements.

Project Highlights

Rapid Deployment

The first set of deliverables, including a data warehouse and custom reports, were published worldwide in less than 8 weeks.

High Employee Adoption

The increased visibility into all aspects of the business, ranging from the performance of specific advertising campaigns to overall sales and delivery metrics, enabled people from all aspects of Media Solutions to glean useful, actionable information from the implementation.

Custom Data Warehousing

A custom solution was implemented that would allow large amounts of data from different sources to be extracted, transferred, and loaded into a logical, organized data warehouse. This enabled Expedia Media Solutions to answer business questions quickly and easily. The Microsoft SQL Server Analytics toolset was able to effectively handle the data warehouse processing of more than 9 million rows of data every day.

Custom Reporting

Several Reports were built to meet the growing needs of Expedia Media Solutions. These reports ranged from operational reports to more complex scorecards. They were created to enable management and employees to monitor the business and make business decisions that would grow the company accordingly.

Solution: Business Intelligence

« Back to index