
Del Papa Distributing Company
Data Warehouse Initiative
The daily demands of a distribution company - such as ensuring that vehicles are ready to roll; fuel is purchased at the best price; inventory is available to fulfill orders; drivers arrive at the customers on-time with the complete order; targeted customer profiles for new markets are identified, etc. - require immediate access to information.
For Del Papa Distributing Company, a state-of-the-art wholesaler of Anheuser-Busch products, information was available from many different sources, systems and data stores. However, the data's integrity was often questionable and the level of effort to prepare specific company reports was significant. Moreover, Del Papa's historical data only reflected a two-year period; which was insufficient for many business areas.
RSA Responds
RSA worked hand-in-hand with Del Papa's management to help them understand how a data warehouse would improve business decision-making. By integrating relevant information, the data warehouse would provide consistent and accurate information that could be used to improve employee productivity.
RSA subsequently helped define data warehouse scope, database schema, integration processes, and other business intelligence components. As part of the operational deployment, RSA trained end-users and on-site support as well as developed standard processes and company reports. RSA consultants, and the Data Warehouse itself, exceeded Del Papa's expectations. RSA continues to prove services to implement additional functions and components of the data warehouse.
RSA Results
Before Del Papa's data warehouse, business managers requested data and assistance to make effective business decisions – sometimes requesting the same information multiple times. By successfully implementing the Data Warehouse, business managers now have direct access to detailed information on a daily basis. The Data Warehouse maintains four years of historical data, providing improved trending reports and data analysis. These efficiencies have led to increased margins and improved customer service levels.
To read more RSA Success Stories, click here.
|