Data Warehouse Data Model for Retail and Distribution (Retail DWH model ®) is standard industry data warehouse model applicable for retailers and wholesalers, covering traditional Business Intelligence requirements, regulatory requirements and Big Data Analytics requirements.
PI Retail DWH model ® is based on industry best practices, developed and applied during data warehouse system implementations in retailers in Europe. Also, it is open for necessary alterations and modifications required for each new customer. Data from different sources can be mapped and loaded to the same model structures for different types of business requirements.
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.
PI Retail DWH model ® is based on strong Primary Key – Foreign Key relationships that will assure consistency in the model itself and in a content of 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 with ERWin but exportable to any other standard database modelling tool formats
Based on industry best practices, developed and applied during data warehouse system implementations in retailers in Europe
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 that 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 to implement data marts & analytical applications on time and on budget
Retail DWH model
®
Details
Model customizations
Retail DWH model ® is customizable per customer specific requests. There are several types of customizations:
- Customizing of existing Entities including changing attribute properties (name, type, and description), adding new attributes, adding indexes etc.
- Creating of new Entitiesif there is a requirement for a new dimension or new aggregatio
- Adding new Subject areaswith multiple entities that will cover new business area
- Customization of physical model– defining partitions, block sizes etc.
- 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
Petrol is a company that operates in several industries; Oil and Gas, Retail and Utility. Different business requirements are challenging to fit to same reporting structures. Retail DWH model is covering most of our important business areas. It is flexible, easy to use and modify so implementation of selected Subject area is quite fast. Subject areas designed in the model are also great reference for Business Analysts when elicitating and structuring business requirements.
– Andreja Štirn, Director business intelligence
Telco DWH model has been proven to be flexible and easy to use which enabled faster time to the market of CT products and significantly easier maintenance. It did not require any changes since the implementation few years ago, besides integration with new systems, which is the best indication of its quality.
– Jovana Mihajlovac, Head of Enterprise IT solutions
We are producing and collecting anenormous amount of data. Implementation of Telco DWH model enabled us to achieve competitive advantage by allowing clean data consolidation across multiple systems, minimized our development cost and helped us transform our business requirements into solution that works best for us.
– Andrija Derežić, CIO at United Group
Download the resource
Retail DWH model
®
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. Retail DWH model is based on strong Primary Key – Foreign Key relationships that will assure consistency in the model itself and in a content of implemented Data Warehouse System. Physical model implementations can be in every standard RDBMS and also in any ODBC-compliant NoSQL environment… Download our document and learn how this solution helps your business!
Retail DWH model® is an 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 purchased the model.
The logic of the model is following NRF ARTS, as a common reference model that retailers use to describe enterprise management information systems.
Data warehouse models
Improve your decision-making process based on quality data using advanced analytics and be a part of digital transformation. Extract consumer insights to learn more about their preferences and reinvent the customer experience.
Gain insight into customer trends and historical data – optimize discounting, improve retention and segment your customer base to effectively acquire new customers. Data warehouse provides the basis for quality analysis of available data by deriving accurate information.
Make informed and data-driven decisions and transform information into meaningful actions. Turbulent times of saturated markets and new regulations, highlight the importance of the availability of the right information at the right time for the (re)insurance industry.
Retail DWH model ® is standard industry data warehouse model applicable for retailers and wholesalers, covering traditional Business Intelligence requirements, regulatory requirements and Big Data Analytics requirements.
