Retail Controlling System
SALT Solutions GmbH
Overview
The alexa retail system for fashion and lifestyle is a modularly designed system which supports the retail process' constituent phases; from planning to implementation. Users are able to access all the modules: Retail Merchandise System, Retail Relationship System, Retail POS, Retail Planning System, and Retail Controlling System.
The Retail Controlling System supports retailers to ensure their success in the quickly changing fashion business. It is essential for retailers to have significant and reliable key figures available to them promptly. Successful in-season-controls assist in the evaluation of daily and weekly figures, while monthly and quarterly analyses ensure the future planning processes.
SALT Solutions provides both the safe planning processes and the solutions for retail controlling and key figure systems, which are adjusted to retail. These pre-defined reports help to control store chains centrally.
Stock, sales quantity, turnover, and acquisitions of the consolidated companies can also be analysed. Retailers can monitor the success of the advertisements and the point-of-sale terminals.
Our motto is "Good prognoses result from precise knowledge of background and history." Our solutions assist in making these prognoses exact by planning specific solutions for retail. Our retail planning methodology guides retailers through the entire planning process like a configurable workflow regulator.
Benefits
alexa Retail Controlling provides high transparency in all selling activities. This solution gives the answers to a wide variety of questions critical for fashion, lifestyle and shoe retailers:
- How is the turnover and the stock developing currently?
- What is the historic trend? Which are my fastest and slowest sellers?
- How big is the range of my store's stock? At what scale can the goods from the central warehouse be ordered?
- Did the last advertisement campaign have a positive impact on the sales' development?
- Do the colors and sizes fit the customers' needs? What effects do the different levels of markdowns have?
- Does the size of the sales area fit the group of goods' turnover and sales quantity?
- Am I addressing the customers on the correct level of prices and the correct type of fashion?
- What is the customers' typical regional buying behavior? How much do the customers buy and what means of payment do they employ?
- Of what quality are the brands and the contractors?
- How often are the markdowns and how high are the markdowns, granted by employees at the POS?
- Which repeating article-clusters can be found on the same sales slip?
Features
- Structured reporting, as well as ad-hoc analysis.
- Drill-through reporting for quick and easy access to the details.
- Drag-and-drop authoring.
- A variety of delivered reports for a quick start.
- Full support of the article-color-size structure of the merchandise in fashion and lifestyle.
Architecture
Any format of source data from either the merchandise management system or check box system (databases and flat files) can be connected to the alexa Retail Controlling System.
SALT Solutions has implemented an Oracle-based stage area and an ETL-framework for a high performance transformation of ERP-data to reporting structures. Four different kinds of retail cubes are built daily with IBM Cognos Transformer, using these star- and snowflake-schemas.
The reports, scorecards, and dashboards access the database data as well as the cubes. For ad-hoc reporting, Analysis Studio accesses the cubes. Both standard reports and ad-hoc reporting are provided through the Cognos Connection portal to the users.
All components use IBM Cognos 8 BI version 8.3.

Availability
For more detailed information, visit our website: www.salt-solutions.de
RSS Feeds