A new reference for the supply of DWH, MS Power BI and integrations including the GEM DIS solution for the client Pivovary Staropramen

Meet the new supply reference DWH, Power BI and integration including GEM DIS for the client Pivovary Staropramen

The client's original data warehouse was designed primarily to calculate profitability based on data downloaded from the SAP system and stored in a MySQL database. This system was functional, but with the advent of the GEM DIS platform, new opportunities for innovation and improvement emerged.

The implementation of the GEM DIS platform brought about a change in technologies when there was a transition to Microsoft SQL Server (MSSQL). This step enabled the use of OLAP cubes through Microsoft Analysis Services and the deployment of the advanced reporting tool SSRS (Microsoft Reporting Services). Thanks to these changes, the client gained the ability to quickly and easily access the necessary data with just a few clicks.