Project Title: Decision support system based on analytical data warehouse for «Svetogorsk» (International Paper)

The Challenge

JSC «Svetogorsk» specializes in production of office paper and packaging materials. It is one of the leading paper mills in Russia and one of the largest suppliers of office paper to corporate users in Western Europe. 1998 JSC «Svetogorsk» was acquired by International Paper - a global leader in paper and packaging products, with enterprises in more than 40 countries and sales activities in more than 120 countries.

The Customer asked Digital Design to create a unified analytical data warehouse and the system of operational reports. A Single data warehouse was required for full multiple-factor analysis of manufacturing, logistics and sale activities. Before the project began information about operations was stored in different databases. The accounting was made in SCALA, PRODIS and Transport Tracking systems. Due to lack of unified reporting system Customer service was not able to provide quick responses to customers’ requests.

The Solution

Analytical data warehouse was developed based on MS SQL Server and multidimensional database based on MS Analysis Services. Information from Scala, Prodis, and Transport Tracking was converted and transferred into the data warehouse. In order to form analytical reports, Digital Design specialists used proprietary OLAP-client, which allows

- inquiries making
- data allocation choice in columns and lines of the final table
- reporting in convenient tabular or graphic form.

Users can now form analytical reports based on the multidimensional data warehouse in the following business areas:

- sales
- production
- delivery
- transport
- warehouse

Later on, Digital Design was assigned to integrate data warehouse with the ERP-system «Magic» after its implementation at «Svetogorsk». This step involved updates of data domains «Delivery» and «Transport».

Consolidation of information from various reporting systems in analytical data warehouse allowed business users to analyze manufacturing, logistics and sales activities of the company and build reports of any complexity. Customer service could now receive full information about orders, delivery and warehouse in real-time mode and effectively track «problem» orders. This significantly increased clients’ loyalty.

Tools and Technologies

Microsoft SQL Server

Related links

Post Your Story, Tell All About Your Success!

If you want the story of your company to appear on the portal please fill out this form and send it to [email protected]. We would also like you to leave contact information (name, e-mail, phone) of a person who is responsible for filling the form to clarify any questions, which could appear.

Available Success Stories From Companies:

Disclaimer

All information contained in this Section is owned by RUSSOFT.org and its Participants and is protected by Russian and international copyright laws. Any reproduction or republication of all or part of this Section has to remain intact and include a notice on the copyright of RUSSOFT.org or the Participants, as applicable.

While the information of this Section has been presented with all due care, RUSSOFT.org does not warrant the accuracy, completeness, usefulness and truth of Section’s information, links and logos derived from third parties. RUSSOFT.org is not liable for any loss or damage occurring from the use of this Section’s materials.