{"id":2202,"date":"2022-10-19T11:51:22","date_gmt":"2022-10-19T08:51:22","guid":{"rendered":"https:\/\/etlia.fi\/?post_type=cases&p=2202"},"modified":"2026-02-17T16:49:05","modified_gmt":"2026-02-17T14:49:05","slug":"ahlstrom","status":"publish","type":"cases","link":"https:\/\/etlia.fi\/en\/referenssit\/ahlstrom\/","title":{"rendered":"Case Ahlstrom"},"content":{"rendered":"\n

Data driven decision making boosts Ahlstrom\u2019s global business<\/h2>\n\n\n\n

Images: Copyright \u00a9 Ahlstrom<\/sub><\/mark><\/em><\/p>\n\n\n\n

Ahlstrom is one of the leading operators in sustainable and innovative fiber-based solutions. Creating and executing a coherent SAP-based architecture for a large group’s financial and sales reporting was a years-long project. Etlia was responsible for the solution’s data architecture and operated as the project manager.<\/strong><\/p>\n\n\n\n\n\n\n\n

Ahlstrom<\/a> has tens of factories and approximately 8000 employees worldwide. Tuukka-Juhana Ukkonen<\/strong> oversees maintaining and developing the group\u2019s data analytics. The Data & Analytics team involves six people. External consultants and partners are used in development projects when needed.<\/p>\n\n\n\n

SAP-analytics solution was built step-by-step<\/h3>\n\n\n\n

The project of unifying the financial and sales reporting started in 2018 and lasted for about four years. The goal was to harmonize and simplify the processes in the areas of financial, sales, stock and purchasing reporting. In addition to creating a unified data architecture, the data collection and integration were automized in a strong association with the Controlling organization.<\/p>\n\n\n\n

\n
\n
\n
\n

\u201cAn efficient, comparable, and up-to-date financial reporting is a must-have in business. A harmonized reporting model built on SAP and developed with Etlia\u2019s support, is trustworthy, works nearly in real-time, and doesn\u2019t require much manual work.\u201d<\/p>\n \n <\/blockquote> \n

\n Tuukka-Juhana Ukkonen<\/span>\n Head of Data And Analytics Strategy & Solutions<\/span>\n <\/p>\n <\/div>\n <\/div>\n<\/div>\n\n\n\n

Such a project involves several data sources since the units in different parts of the world use various financial management and ERP systems. There\u2019s also constant evolution: new businesses and factories are being bought as the project goes on and others may be sold or run down.<\/p>\n\n\n\n

The harmonizing project was conducted in several phases:<\/h4>\n\n\n\n
    \n
  1. Form a unified data architecture based on a general architecture design<\/li>\n\n\n\n
  2. Define business requirements for data warehousing<\/li>\n\n\n\n
  3. Integrate systems one by one to the SAP data warehouse<\/li>\n\n\n\n
  4. Test and implement integrations and ramp down old systems<\/li>\n<\/ol>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    The first phase was to set the foundation for a unified reporting model and data architecture: what data does business reporting need and in which form is data available from different sources. Based on the requirements from Ahlstrom Controlling, Etlia designed a data warehousing solution on top of SAP and oversaw the execution in the roles of the product owner and project manager, meaning that Etlia was responsible for the whole project. <\/p>\n\n\n\n

    After the data-architecture solution was validated by the Controlling team, systems producing financial, and sales information were integrated into SAP one by one. In total there were seven systems to integrate.<\/p>\n\n\n\n

    The technical execution and maintenance of the solution took place in a multi-vendor-environment with Etlia, Bilot and Tech Mahindra, the outsourcing partner of Ahlstrom.<\/p>\n\n\n\n

    The end result was approximately 25 prioritized and near real-time financial reports in SAP, with the help of automized data collection and integration.<\/p>\n\n\n\n

    <\/div>\n\n\n\n
    \n
    Get to know our services<\/a><\/div>\n<\/div>\n\n\n\n
    <\/div>\n\n\n\n

    The solution-oriented approach in a multi-vendor-environment<\/h3>\n\n\n\n

    Tuukka says that the role of the lead consultant in different data and analytics projects is essential. Choosing a consultant for an SAP technology project naturally depends on the experience and competence to execute such ventures.<\/p>\n\n\n\n

    Understanding the customer\u2019s operating environment and the technology in use is a big plus. The timing and pricing of the consulting must also match the timeframe and budget of the project.<\/p>\n\n\n\n

    \n
    \n
    \n \"Tuukka-Juhana <\/figure>\n
    \n
    \n

    \u201cEtlia has a well<\/span>-organized way of working. Having good communication skills in a multi-vendor environment involving various parties made it easier to progress<\/span>. We also value Etlia\u2019s competence to operate in an international environment, and especially to take the full picture into account. The capability to solve problems in a solution-oriented way and to foresee the future has brought us the additional value we looked for.\u201d<\/p>\n \n <\/blockquote> \n

    \n Tuukka-Juhana Ukkonen<\/span>\n Head of Data And Analytics Strategy & Solutions<\/span>\n <\/p>\n <\/div>\n <\/div>\n<\/div>\n\n\n\n

    When a project that lasts for years involves multiple internal and external parties, managing the whole is essential to proceed and in terms of the result. Etlia\u2019s way of bringing up and constructively questioning decisions if needed helps the customer to make functional decisions in the long term. <\/p>\n\n\n\n

    \n
    \n
    \n
    \n

    \u201cOn top of the SAP specific technology know-how, we got more than we could ask for: views and suggestions regarding the future of the systems are a valuable addition, which also strengthens our vision.\u201d<\/p>\n \n <\/blockquote> \n

    \n Tuukka-Juhana Ukkonen<\/span>\n Head of Data And Analytics Strategy & Solutions<\/span>\n <\/p>\n <\/div>\n <\/div>\n<\/div>\n\n\n\n

    Tuukka also finds it important that Etlia ensured the solution would work in the future. In practice, this meant carefully familiarizing the system to the partner in charge of the maintenance and development. <\/p>\n\n\n\n

    Etlia has an in-depth understanding of SAP-integrations<\/h3>\n\n\n\n

    Etlia has also been a part of another smaller project. Ahlstrom needed expertise in integrating AecorSoft software with SAP and Azure. Etlia could provide the needed solution-oriented know-how also to this project.<\/p>\n\n\n\n

    \n
    \n
    \n
    \n

    \u201cWe looked for a suitable solution from various places. Etlia had the best understanding of our needs and provided us with a suitable timetable at a competitive price. Our previous experience with Etlia and the Proof of Concept convinced us. Etlia is a useful and trustworthy partner in Data Warehousing and Cloud Solution<\/span> projects.\u201d<\/p>\n \n <\/blockquote> \n

    \n Tuukka-Juhana Ukkonen<\/span>\n Head of Data And Analytics Strategy & Solutions<\/span>\n <\/p>\n <\/div>\n <\/div>\n<\/div>\n\n\n\n

    \n

    Our customers<\/h2>\n\n\n\n
    \n
    \n
    \"\"<\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    \"\"<\/figure>\n<\/div>\n<\/div><\/div>\n<\/div><\/div>\n\n\n\n
    <\/div>\n\n\n\n
    <\/div>\n\n\n\n
    \n \n\t
    \n
    \n
    \n
    \n \"\"\n <\/div>\n
    \n

    Contact us<\/h2>\n

    \n Have questions or want to know more about our company? Please get in touch! <\/p>\n

    \n

    \n Juuso Maijala, <\/span>Analytics Expert <\/p>\n <\/div>\n\t\t\t\t\t

    \n\t\t\t\t\t\t\n\t\t\t\t\t\t