An agile sprint for financial data

How Iris helped a mega sportswear brand’s global operations and financial reports go flexible, agile, and analytical.

Among the world’s largest manufacturers of sportswear, the client sells its products in 120+ countries and employs more than 13,000 people
To significantly reduce turnaround time and ease associated with report creation
Tools and Technologies
Microsoft SQL Server’s Analysis Services (SSAS), Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Boomi AtomSphere, and Power BI
Business Challenge

The client’s finance department was using standard SAP reports which limited the flexibility to slice and dice data or add fields to reports. Modifying or creating new reports was either difficult or expensive. Top management, including the CFO and financial controllers, were finding it difficult to create a high-level, integrated view of the company’s finances. The existing process required data transposition between various systems, including the SAP and Oracle systems. Much of this data was extracted and consolidated manually, which was time-consuming, and took around a week.


Iris executed a distributed Agile framework for the client’s global delivery model. Our solution pulled data out of the client’s SAP ERP system using Dell Boomi adapters, and leveraged SSIS (SQL server integration services) to transform it into enriched data. This data was mapped and made actionable through interactive PowerBI Tableau dashboards. With the help of a custom-made finance data model, a data warehouse was created. The easily shareable data cubes not only replaced all legacy reports, but also reduced the number of SAP user licenses.


With the availability of Power BI dashboards and the capability to slice and dice financial data, client managers now have a better view of operations and accounting flows. The data consolidation allows users to create need-based reports without additional licenses. The automation of the entire process from data extraction and transformation to publishing of analytical cubes has enabled the client teams to significantly reduce time required to produce reports – from days to a few minutes. They have been able to achieve a 95% reduction in time and effort.


Our experts can help you find the right solutions to meet your needs.

Get in touch
Explore the world with Iris. Follow us on social media today.
Copyright © 2024 Iris Software, Inc. All rights reserved