GENERAL ARCHITECTURE

INFO_MART has been created using the Data Warehouse concept and best practices for Business Intelligence (BI) designed to deliver accurate, timely data. The architecture is illustrated below:

click to enlarge

The left side of the diagram shows the company’s operating environment. The environment includes operating systems such as ERPs, CRM, the inventory control system, finances, point of sale, etc. All operating environment data are stored in the INFO_MART base system, and from there are delivered to the business analyst through INFO_MART analytical modules developed in a decision support format that contributes to improving business margins and benefits on the basis of a better decision-making system.

INFO_MART analytical modules have been created on the basis of 20 years of Retail experience, and provide the major benefit of a set of Retail-specific key performance indicators, as well as industry-based reporting. All this is organized into analytical modules, such as:

• Sales performance



• Purchasing performance



• Returns, transfers and shrinkage



• Price history and elasticity analysis



• Supply chain optimization



• Inventory



• Budgeting



• Supplier efficiency



• Markdown effectiveness



• Ticket analysis