The logic of the model is following NRF ARTS, as a common reference model that retailers use to describe enterprise management information systems.
Our PI DWH Model for Retail and Distribution (Retail DWH Model®) is a standard industry data warehouse model applicable for retailers and wholesalers, covering traditional business intelligence, regulatory, and big data analytics requirements.
Our PI Retail DWH Model® is based on industry best practices, developed and applied during data warehouse system implementations in European retailers. It is open for necessary alterations and modifications required for each customer- data from different sources can be mapped and loaded to the same model structure for different types of business requirements.
It is based on strong Primary Key – Foreign Key relationships which ensure consistency in the model itself and in the content of an implemented Data Warehouse System. Physical model implementations can be in every standard RDBMS and also in any ODBC-compliant NoSQL environment.
Retail DWH Model
®
Highlights
Consists of more than more than 350 Entities (Tables) grouped in 31 Subject areas
Developed in ERWin but exportable to any standard database modelling tool format
Based on industry best practices, developed and applied during data warehouse system implementations in European retailers
The logic of the model is following NRF ARTS
Retail DWH Model
®
Benefits
Comprehensive set of subject areas, including a physical warehouse design
Business terminology model and analysis templates which accelerate the development of business applications
Accelerates development and lowers risks associated with enterprise data management, data warehousing, and BI application development
Helps business users and IT staff implement data marts & analytical applications on time and on budget
Retail DWH Model
®
Details
The logic of the PI Retail DWH Model® follows NRF ARTS!
NRF ARTS is 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.
Our PI Retail DWH model ® is customizable per customer specific request. There are several types of customizations:
- Customization of existing Entities, including changing attribute properties (name, type, and description), adding new attributes, and adding indexes
- Creation of new Entities if there is a requirement for a new dimension or new aggregation
- Adding new Subject Areas with multiple entities that will cover new business areas
- Customization of the physical model, defining partitions, block sizes etc.
Our PI Retail DWH Model ® is based on strong Primary Key – Foreign Key relationships that will ensure consistency in the model itself and in the content of an implemented Data Warehouse System. Physical model implementations can be in every standard RDBMS and also in any ODBC-compliant NoSQL environment.
- Basic standard areas (Businessa items; ETL execution audit; Date / Time; Location; Party)
- Customer; Contract; Customer journey; GDPR compliance
- Product; Inventory; Supplier
- Sales; Webshop; Promotions; Payments; Mobile payments; Sales performance
- Loyalty program
- Contact center
- Marketing campaign; Market share; Market basket
- Finance; Profitability; Human resources; CAPEX
- Invoicing & collection; Dunning
- Service management
- Project
Download the resource
Download our
PI
Retail DWH Model
Ebook!
Make data driven decisions and transform information into meaningful actions.
Our PI Retail DWH Model® is exclusive intellectual property of Poslovna Inteligencija. PI grants a nontransferable and nonexclusive right to use the Retail DWH model® with delivered customizations and extensions to its customers who purchase the model.
Learn more about Telco customer preferences and reinvent their user experience.
Optimize discounting, improve retention, and segment your customer base to effectively acquire new Banking customers.
Saturated markets and new regulations highlight the importance of the right information available at the right time for the Insurance industry.
Cover traditional business intelligence, regulatory, and big data analytics requirements for the Retail & Distribution industry.
