Lightning-fast analytics platform
To solve this challenge, Conestoga selected IBM PureData® System for Analytics—a high-performance analytics appliance designed to optimize the performance of data warehouses.
“Our IBM Premier Business Partner Micro Strategies demonstrated the tangible benefits of the IBM PureData solution through a compelling—and astonishingly quick—proof-of-concept exercise,” recalls David Mosher. “In just one week, the Micro Strategies team showed us how processes that currently took hours could be completed in just minutes or even seconds.”
Conestoga, working with Micro Strategies, replaced its IBM i platform with IBM PureData System for Analytics. Fully integrated into the company’s back-end systems for manufacturing and sales using IBM InfoSphere® Change Data Delivery, the solution means that reporting bottlenecks are now a thing of the past.
Mosher comments: “We had a batch of reports that would take over an hour to complete every day. Now it is consistently done in a minute. I look at that process every day and still struggle to believe it because I know how much is going on behind the scenes. After years and years of data management, seeing a solution like this at work is simply incredible.”
Conestoga is now experiencing analytics performance improvements across the board. Generating audit reports can now be completed in as little as five seconds, more than 790 times faster than before.
Similarly, reports on open customer orders can be completed up to 256 times faster. With this enhanced analytics performance, the company has gained the all-important headroom it needs to build deep predictive analytics capabilities.
Predictive analytics to capture customer demand
With IBM PureData System for Analytics driving its reporting processes, Conestoga can use more than five years of historical sales data to perform sophisticated forecasting and prediction.
By equipping its decision-makers with rapid insights, Conestoga can determine which combinations of its product attributes are likely to be popular in the coming business cycle, and optimize its inventory levels accordingly.
Karen Loose, Business Process Manager at Conestoga Wood Specialties, says: “Our IBM Analytics solution enables us to utilize our data and expertise in an aggressive, proactive and analytical way. With our IBM platform, we can forecast future trends and seasonal demand more accurately based on past patterns.”
Conestoga is now in a stronger position than ever to feed the ever-growing appetite for analytics within the business. Mosher adds: “Our IBM Analytics solution is helping us to distribute key reports rapidly, which in turn improves the way we do business.”
Loose concludes: “IBM has truly transformed our analytical capabilities. Today, we can align our manufacturing schedules and sales forecasts more closely, which enables us to better optimize our inventory levels and labor commitments.”