From 2 hours to 2 minutes: Daugherty Delivers Staggering Performance Gains

Challenge

This cellular phone company had grown significantly by acquisition. Subsequently there was no single source for client data. Reports required queries to be run against huge amounts of data from six separate territorial regions. The process was very manual and time consuming. With a goal to improve their entire Customer Relationship Management processes and technologies, the company began to consider building an Operational Data Store (ODS) to support infrastructure needs and that provided near real-time access to customer account data

Solution

Daugherty helped the client with an RFP process to make sure the right business intelligence technologies and tools were selected. For implementation, the client was considering building the ODS in-house, but ultimately selected Daugherty to do the work, based on Daugherty’s proven BI methodology, price point and ability to deliver. Daugherty consultants were responsible for software and hardware technology decisions, Infrastructure and Data Architecture and ODS Best Practices. Upon project completion, the client had a single source data warehouse that provides users critical business information in near- real time.

“This performance is absolutely phenomenal!”

– CTO

Results

  • Tremendous performance gains
    • Reports that once took 2 hours, now take under 2 minutes.
  • Project completed ahead of schedule
    • 6 month lifecycle using Daugherty BI Methodology vs. a projected 12+ month lifecycle if completed in-house.
  • Substantial cost savings
    • Estimated cost savings of $1.5 million to the client.
  • Improved data access
    • Business now has access to data in near-real time
  • Enhanced reporting
    • The company now has a secure, consolidated reporting infrastructure for the enterprise and is poised to leverage the performance gains in key business functions. Future phase will allow customer usage analysis in order to provide more targeted marketing initiatives to be launched and tracked.