Cargus contracted New Business Dimensions, wanting a partner with relevant expertise and experience in complex analytics and reporting solutions. At the same time, the Cargus team had positive experience with PowerBI and wanted to integrate Microsoft's Azure Cloud technology for data analysis and visualization into the new system.
"New Business Dimensions has convinced us both with its considerable experience in reporting solutions for financial banking organizations and as a Microsoft Gold Partner to establish a first collaboration. It was exactly the combination of skills we wanted for the implementation of this project, a complex one both in terms of technology and especially in terms of business impact", adds Belgin Bactali.
New Business Dimensions presented a Proof of Concept on a set of relevant management reports to demonstrate the effectiveness of a reporting solution based on a cloud-based Data Warehouse and complemented by a reporting tool such as PowerBI. The results exceeded the expectations of the Cargus partners and the proposal was approved for implementation.
The project included a business analysis and discussions to understand the business requirements and data sets desired to be processed in the reporting, as well as a technical analysis to identify the data sources, their relationships and how to obtain them.
After identifying the reporting requirements with existing data sets, New Business Dimensions modelled and developed the Data Warehouse component, according to a cloud service-based architecture (mechanisms and processes for data extraction, unification, cleansing, sizing and analysis) and physical (connectors, storage and archiving facilities, access). Subsequently, the system allows easy addition of other data sources (operational systems, web services, etc.).
The solution implemented by New Business Dimensions for Cargus has two major components and is based entirely on MS Azure cloud services:
- Data Warehouse to consolidate data from all existing sources;
- PowerBI for assembling data into reports and delivering them to beneficiaries in a dynamic, user-friendly format;
For generating reports, the implemented system uses the Microsoft Power BI service. The reports implemented are dynamic, intuitive and visually appealing, with both standard and role-specific versions defined in the organisation. Moreover, the reports allow for additional drill-down or drill-through investigations.
The platform runs 100% in the cloud (Microsoft Azure), with strong infrastructure and security components through integration with Active Directory, Multi Factor Authentication, granular resource access rights. Thanks to Microsoft Azure's scalability, processing time is short, even when running reports that require processing large volumes of data. In addition, the level of availability and security is very high, without the beneficiary having to invest extra in these aspects.