The Business Problem

• The cubes they purchased took too long to update and could only be updated once a day.
• The originally purchased cubes could not be modified.
• The business rules about average drop sizes could not be applied to the data.

The Business Impact solution

• Prototyped a solution for Single Source in a matter of hours to prove that updates could be run as often as needed.
• Added the business rules needed for product drop and drop sizes in the data warehouses so that all reports contained the same business logic.
• Added new functionality which allowed for broader use of the system.

Return On Investment

• The solution was implemented within the scope that was defined.
• Single Source now has a consistent data source for all reporting.
• The sales organization now has data in as real-time as they need.

...



Single Source Inc. is a privately owned company that began operations in 1990 providing food distribution services to privatized correctional and educational facilities in 38 states. Using state-of-the-art distribution methods and proprietary forecasting and robotic ordering tools, Single Source guarantees that it can provide customers with the lowest-cost solution possible and timely deliveries. Updating delivery information on a timely basis is critical for Single Source, which is why its business intelligence system required near real-time feedback as well as analytic capabilities.