1 Introduction
Retail Insights offers cloud-based rich business intelligence solution to retail industry users. Retail Insights is built on top of the latest Oracle technology stack and utilizes Oracle Data Integrator (ODI) for extracting, transforming, and loading (ETL) the data and Oracle Analytics Server (OAS) for end user reporting and analysis needs.
Retail Insights architecture is designed to meet the retail industry's business intelligence needs in both program and report performance.
The main characteristics of the Retail Insights product are:
-
Rich Reporting Capabilities: Retail Insights offers report creation capabilities in two different flavors: Historical (As Was) and Current (As Is) in same environment. Packaged reports are provided as reference examples for users to create their own customized reports according to their needs.
-
Comprehensive Solution: Retail Insights includes an end-to-end solution for reporting and BI needs of the retailer by providing data integration with source applications, transforming and loading the fact and dimension data, rolling up the data for improved query performance, Web-based graphical user interface (GUI) for report creation, shell scripts for setting up the batch schedule, and an automated installer by following business intelligence best practices.
-
Performant ETL Code: Retail Insights data processing tool, ODI, offers high performance for the database batch processes on Oracle database.
-
Performant Reports: Retail Insights metadata is built using Oracle Analytics and are designed to work in complex reporting scenarios.
-
Robust Data Model: Retail Insights data model is designed for supporting a retailers' data needs in a business intelligence environment. Data model elements are designed to work with Oracle Analytics architecture.
-
Packaged Integrations: Retail Insights data model is leveraged for many down-stream applications such as the Retail AI Foundation Cloud Services with built-in integrations and data flows.
Business Intelligence and Retail Insights
This section briefly explains the fundamentals of business intelligence and data warehousing in general. It is important to understand the overall architecture and data flow for implementing Retail Insights.
Business intelligence includes the processes, methods, and technologies adopted by organizations to answer complex business questions and for building comprehensive decision support systems. These systems help organizations in maintaining secure, conformed, and highly available data for all levels of users from top executives who make decisions based on corporate level information to managers/analysts who analyze their area and take actions based on the information.
Business intelligence is built using several processes and applications that maintain these processes by adopting latest tools and technologies. One of the main components of business intelligence is a data warehouse. A data warehouse is the repository that stores the data extracted from several source systems and modelled to perform for data loading, reporting, and ad-hoc analysis needs.
Retail Insights uses sophisticated techniques to populate the data warehouse. Explained in greater detail throughout this guide, these techniques include taking the data provided by Oracle Retail Data Extractor (RDE) and then rapidly transforming that data and loading it into the data warehouse. Techniques used to load data into the warehouse vary depending upon whether the data consists of facts or dimensions.
There are several fact and dimension tables in the subject areas available in Retail Insights. Some examples of subject areas that exist in Retail Insights include Sales, Inventory Position, and Base Cost. Each subject area has its own data mart to support reporting and analytic needs. At the center of each data mart is fact data (note that fact data here corresponds to both base fact data and aggregated data). Facts are the transactions that occur in your data warehouse's source systems, such as RMS. You may want to look at sales transaction facts, inventory stock count facts at stores or warehouses, or inventory movement facts.
Facts have little meaning by themselves because they are usually just values (for example, six sales at a store, 15 items left at a warehouse, or 300 items transferred). What gives fact data true meaning is the intersection of dimensions in which facts exist. In other words, six sales on Wednesday at store B, or 15 dishwashers in stock last Monday at the Chicago warehouse, or 300 blouses transferred during the last week in February from the St. Louis warehouse to the Denver warehouse. Dimension data, therefore, exists in the data warehouse to serve as reference data to facts.
The following diagram illustrates data elements of a generic data mart and their inter-relationships:
Figure 1-1 Data Element Relationships
![Data Element Relationships Data Element Relationships](img/fact-table-dimension.jpg)