Challenge

A global financial services firm needed the ability to perform comprehensive analysis of its customer base in order to understand precisely why their customers were buying, and what would drive them to purchase in the future. This would help the company solve for customer needs more effectively, improve their marketing strategy, and increase sales. They wanted an analytical data warehouse that would bring enterprise data together in a format conducive to cause-and-effect analysis.

Results
  • Campaigns are more precisely targeted to customer needs, preferences and behaviors
  • Modeled data warehouse on SQL Server that supports more than 150 end users
  • 30+ dashboards with custom capabilities that allow for faster, more powerful and more accurate data analysis
  • Eliminated the need to pull reports from multiple systems and manually align the results
  • Architecture is expected to make enterprise data more consistent, reduce risks caused by changes and centralize metadata and security
  • Reduced campaign-selection process from 200 hours to eight hours

25x

Reduction in Campaign Selection Process Time

Working side-by-side with business owners and end users, we applied a multi-phased approach to deliver a denormalized data warehouse and a series of analytical dashboards. Partnering with our client we built a system that combined data from more than 15 sources, both internal and external to the organization. The phased approach allowed the team to deliver functionality quickly and efficiently throughout the project.