Author:Matea Bešlin / 27. 03. 2018.

Data Warehouse Model for Retail

The newest addition to our PI DWH Models brand family is Data Warehouse Model for Retail and Distribution (PI Retail DWH model ®) which is applicable for retailers and wholesalers, covering traditional Business Intelligence requirements and Big Data Analytics requirements.


PI Retail DWH model ® is a platform-independent solution that is based on industry best practices, developed and applied during data warehouse system implementations in retailers in Europe. The logic of the model is following NRF ARTS, as a common reference model that retailers use to describe enterprise management information systems. Based on data represented in the model, all standard retail and wholesale reporting and analysis Data Marts can be delivered, and ones regularly used are already defined as Subject areas in the model.

This is our fourth PI DWH model, and so far we have developed three Data Warehouse Models, for Telecommunications, Insurance for both life and non-life and Banking. Some of the common benefits of PI models are, customization and extension of the data warehouse to fit clients requirements and needs, enhancing competitive advantage and more effective time management.

Our Data Warehouse Models will provide the basis for quality analysis of available data by deriving accurate information from data, they are business oriented and based on industry standards and implementation of best practices that are proven in real implementation projects at our clients from various industry areas. They are designed to support and adjust to different needs of our clients from regulatory operational and management reporting all the way to complex simulations and are open for all necessary modifications.

Data Warehouse Model for Retail