Building a Data Platform in the Cloud

The company: Pistor AG

Pistor AG is the leading independent trading and service company for the bakery and confectionery industries, as well as the catering and care sectors. Pistor supplies locations throughout Switzerland and has an efficient logistics system with a comprehensive and specialised range of over 23,000 articles. In addition, Pistor offers its customers individual services such as ordering and accounting support.

The project: Cloud Data Platform

Together with Pistor, Banian developed a concept for a new BI platform and architecture that could grow with requirements. Accordingly, the goal was defined that the platform should grow with the requirements of the business users and therefore be flexible, scalable and agile. Within the framework of a pilot project, Banian was able to support the project team in defining the target architecture, its structure and configuration, as well as the implementation of the business requirements. 

Within four months - with a commitment of about 1-2 days per week - we were able to achieve usable results for the department. Based on the model-based DWH automation process developed by Banian, the requirements of the departments could be modelled and documented as business object models.

The challenges: Performance and scalability
The BI architecture was heavily influenced by the company's ERP system. Over the years, various analytical functions were implemented and made available. As the demands on data availability grew, performance and scalability became increasingly difficult.

The solution: Flexibility | Scalability | Agility
Based on the model-based DWH automation process, the technically necessary objects could then be automatically derived. The use of the Data Vault modelling technique allows the logical model to be extended iteratively, thus remaining agile and flexible. Thanks to the use of the Snowflake Cloud Data Platform, the solution can grow quickly and easily with the volume of data and the number of users.

Goals achieved: Successful pilot | Data Platform

• Successful pilot as a basis for the data platform
• Developed a completely new data platform specifically for analytical applications
• Ability to integrate structured and semi-structured data
• Easy scalability
• Iterative growth

Kunde

Bereich

• Enterprise Data Platform
• Data Vault 2.0
• DWH Automatisierung
• Reporting & IBCS