Updated enterprise data warehouse supports analytics for sales and marketing

At a glance

Our client's IT team was providing the business with critical data to generate insights regarding sales and external market conditions, but their existing enterprise data warehouse (EDW) was unable to keep pace with the rapid growth of the organization. Logic20/20 helped them improve data warehouse reliability and scalability, speed up data processing times, and gain visibility into the data processing cycle.

Customer challenge

As the organization continued its rapid expansion, the original EDW design would continue to face challenges due to data load performance issues, a data transfer design that was no longer supporting the company needs, and inability to scale operational support due to a lack of process documentation.

Approach and solution

Logic20/20’s system architects provided tactical support to deliver immediate results and put best practices in place. Our team

• Investigated changes to data transfer connections and protocols that would speed up data transfer rates and improve reliability
• Restructured the SSIS packages to improve load performance
• Redesigned the ETL package
• Provided technical documentation for the end-to-end environment, including data processing, warehousing, and architecture

Value and benefits—“the wins”

The Logic20/20 technology consulting team designed and implemented a new enterprise data warehouse, and now IT can continue delivering sales and marketing insights—promptly and reliably—to the greater organization as it expands. Other outcomes include

• Streamlined data loading
• Faster data processing times
• Better visibility into the end-to-end data processing cycle to enable continuous improvement
• Improved stability and scalability to support the organization's continued growth