Sales Module

This module allows you to analyze a company's sales by taking into account variables such as: products, customers, geography, time, and more. With the aggregation of data previously performed by the Sales Summary cube, analyses are provided more quickly.

The Sales Forecasting module allows the different sales department representatives to collaborate in order to produce accurate statistics and then analyze the company's performance.

In the following sections we will take a detailed look at each data model and how it works.

Sales Details

This data model lists all business-related transactions in detail: invoices, credits, deliveries and returns with their corresponding document numbers. This information comes from the Sales Staging cube, which loads the details of all sales transactions present in the ERP system.

Sales Invoice Analysis

This data model retrieves the information present in the Sales Staging cube and aggregates the information to optimize data retrieval performance. The information in the Sales Invoice Analysis data model is pre-calculated by calendar period (per month) as well as by a large number of Dimensions such as Product, Customer, and Geography.

Note

Dimensions that are used in the Sales Invoice Analysis data models are listed in this file if you want more details.

By combining Measures with Dimensions, you can compare current sales data with previous periods to analyze their evolution and performance.

To illustrate this, we will use the Sales Summarized view.

Using the measures Invoiced Amount, Invoice Amount M to M Growth in % and the Product Stat Group Code dimensions , we can quickly analyze the sales performance by product type. For more details regarding the origin of the Dimensions by ERP, please refer to the specific section on source systems in the Sales module.