Together with DV Info Ltd., our task was to design and create a completely unique, new data warehouse and a BI system (DWH) for the firms of Debrecen Asset Management Ltd. Our solution resulted in an integrated, new, and more cost-effective system.
The new data warehouse needed to be integrated, allowing users to access data from different systems. The first one was the client’s ERP system, which they set out to renew simultaneously. The BI system also needed to be fully functional when it was introduced to one of the companies in the holding. A further challenge was to create a solution that could be introduced to all the companies in the holding. This raised the question of data classification and data management: users needed to be granted access to certain information based on their permissions, especially when it came to centralized data.
Our next task was to replace an existing reporting system and create all of its reports in the new DWH. The most important aspect was that the data should be in one place and that the exact same reports from years ago should be available to the users in the new system. Last but not least, it was also a key priority to reduce the yearly operational costs of the existing BI system.
Just a couple of months after we introduced the new system, Microsoft launched their new product line, Microsoft Fabric, which integrates technologies like Azure Data Factory, Azure Synapse Analytics, and Power BI into a single unified product in the same way that we did. We feel this vindicates our innovative approach to the solution we provided for our customer. We are also confident that, by adding a personal touch, we managed to find the right solution for them in the long term.