Introduction
From the discovery face, to the requirements gathering to the architecture design and the product implementation. Xourse will provide a high performant development process. No bureaucracy and no red tape. You handle your business and we’ll handle your tech. Our strongest commitment is to deliver on time with a vision towards innovation.
Business Case: Business Intelligence Solution for a Financial Institution in Honduras
Problem
A new innovation cycle kicked-off for the entire corporation. Innovation and performance was the target. The executives needed a more powerful and modern data management platform. One that could be powerful enough to deliver very specific needs but that could also be automated to increase the development teams productivity and provide fast delivery response to new data reports requests.
Solution
A mix of Microsoft, Open Source and custom code was used to design a system which delivered the performance in processing and the aesthetics in the user interface. The data was extracted from the financial core system as CSV flat files then processed by SQL Server Integration Services and injected to a SQL Server data warehouse. From there the data was transformed to dimensions and cubes which enabled cross-matching and summarisation with SQL Server Analysis Services Tabular. For the presentation layer there were several technologies used. Open source libraries like Charts.js and D3.js, Reporting Services, Excel Services and PowerView on SharePoint integrated with a custom .Net application using jQuery and Bootstrap to handle the content on the front end.
What made this solution special was the fact that pages, labels, reports lists, banners and almost every other element in the user interface was controlled through a metadata repository. So coding was the last resort when a modification had to be made.
Results
The platform provided a beautiful portal oriented to minimalism. Users could go from the starting page to the specific report they wanted in just 3 clicks. Full text search was enabled across the entire site and its content. The application was managed from the metadata repository. The user authorisation was handled from there as well. When new requests for data reports were made the process was simple. If the data was already in the Datawarehouse then the report would be ready in couple of hours. If it wasn’t sensible data then the user might even receive a whole data mark so he could slice and dice it how ever he wanted. If needed an Extract-Transform-Load (ETL) package was created in Integration Services but this would serve for all future request related to such data. It was engineering and art combined.