challenge
Our customer is a consulting company and is one of the world's Big4. On the one hand, the analysis of employee data was very complex in terms of data consolidation and preparation and, on the other hand, employees did not have a suitable analysis platform available. The aim was to automate manual processes with the help of a modern analytics platform (Microsoft Azure) and to enable the development and deployment of machine learning algorithms.
solution
- Data warehouse design for an Azure SQL DWH (data model, ER diagram, ETL routes)
- Development of a solution architecture
- Training & coaching on issues relating to data analysis and machine learning related to Azure/R
Business benefits
- Manual activities in data preparation were minimized
- A central, Azure-based analytics platform was provided
- Employees are able to provide analyses quickly and develop machine learning models themselves
