ISIC Global Office decided to implement a business intelligence system that would allow the organisation to unify their data sources and extract the maximum relevant data for their operative, tactical and strategic decision-making. Out of several possible solutions, Orchitech Solutions chose the open-source product JasperSoft, which is the current BI standard for mid-sized companies. The platform Talend Open Studio was then chosen as the platform to carry out the systems integration. This platform manages not only the integration of individual systems, but also extracting, transforming and loading data (so-called ETL processes).
„JasperSoft BI Suite and Talend Open Studio is one of the few combinations of globally used products where the customer pays mostly for the added value of analysis and implementation. This is made possible by the open-source model of these products, and the related flexibility, which allows the implementer to accommodate the needs of a particular customer. This exact model is closest to us as a company and these products were therefore our natural choice,” says Martin Čížek, CEO of Orchitech Solutions.
ISIC Global Office manages the data of more than 150 organisations all over the world, which means tens of millions of ISIC cards, hundreds of thousands of benefits and a multitude of other data, stored in many systems. Implementing the BI solution was therefore a relatively difficult project, but its benefits are more than proportionate to the effort spent.
„The implementation of the BI solution is yet another important step for our future development. That depends on understanding the development and operation of all ISIC territories and cannot do without the relevant data and information support, which will aid our strategic and operational decision-making on all levels of our organisation. The BI implemented by Orchitech Solutions represents such support and it has fully met our expectations,“
The main benefits of the implemented BI solutions include:
Efficient connection of various data sources:
- Central data warehouse.
- External ETL processes.
- Independence from individual systems and their data sources.
Technologically advanced reporting and analytical tools:
-Simple and user-friendly environment with plans for integration into ISIC’s Liferay portal .
- Access from anywhere via web browser.
- Overviews of business data with a few clicks.
- Dimensional data selection (drill-down)
- Report generation in many formats, including graphical outputs.
- Planning of reports and their distribution via e-mail.
- Management of user rights and roles.
Support and extensibility:
- Open-source products with large communities.
- Module-based, easy to extend solution.
- Readiness for integration with other systems and applications.