MM Guide’s data warehouse solution has reduced processing time from 16 days to 3 days. Also, a team maintains the data warehouse and provides support to the users under an SLA.
An Azure Data Factory, Azure Data Bricks, and Analysis Services were chosen for this cloud solution.
A dedicated MM Guide team provided:
- The analysis of the old VB.NET code and its functionality
- The design of a new architecture, data model, and front-end
- The development, testing and, hand-over of the software
- An SLA under which support is provided to the users
The new system is up-to-date, scalable, maintainable, secure and has been migrated without loss of functionality. Of course, the delivery was on time and on budget.
BI in the SME segment
The company collects, produces, and purchases data and stores it in various Excel files which they misuse as a database. The company is growing and has now reached the point where this solution is no longer scalable, secure, and efficient.
The users make daily operational decisions based on analyses from these Excel files. This means that the reports have to be rebuilt daily. Their wish is to automate and visualize the reports, which saves them time to focus on the core business of the company.
.Pro – Geo Based Intelligence
MM Guide established a data platform that combines and analyzes all kinds of longitude and latitude data sets in a web application. The software complies with these three main features: data uploading, data analyzing, data visualization.
The hiring department of a financial institute was looking to shift from their current external workforce software to a new industry leading external workforce software platform.
Providing management information
During the time of this project (over 15 years ago) the Rabobank Netherlands consisted of approximately 200 local banks, these banks had multiple offices. Of these 200 banks, 60 of them had access to ORS of which 12 banks made daily use of the tool.
To cut down cost, multiple local banks had one LAC (Local Administrative Center). LAC was responsible for management of the financial services and the financial reporting of the local bank and its offices.
To handle the financial reporting the LAC wanted to develop a tool to support the creation of reports. The data in the reports would be used on different levels of management to make sure the SLAs (Service Level Agreement) were met.
We built an Access forms application to support the LAC in their work process flow. The application stored data and created a multitude of reports on that data. ORS allowed for multiple roles and was built to be a multi-user tool, something that was not common in those days.