DWH/DATA LAKE DESIGN AND IMPLEMENTATION
Problem
The overall problem we were focused on solving was the need for an analytical solution in organizations. By Analytical solution, we don’t mean only the solutions presenting the latest version of the truth for each file/document.
The challenge was to create complex systems that can calculate the truth by integrating several documents/files such as profitability, targets, budgeting, performance, etc.
Solution
We used Data Vault Methodology as a solution for properly storing the data. After using the Kimball Methodology, we created an Analytical Layer used by the end-users in Self Service Analytics.
The main target for this type of implementation was not only the regulatory departments. We are most experienced with sales and marketing (sectors that weren’t the main focus with the initial DWH implementations).
Results
We have successfully completed six implementations of this solution in various sectors such as Retail, Telco, and Banking.
