Breadcrumbs

Analytics

In Analytics you can get visibility into prices and margins or customer behavior. It gives you the ability to forecast trends or understand and improve business performance.

With the provision of transactional data to the calculation and simulation of product prices and margins, Analytics supports the definition and execution of the pricing strategy. In reverse direction it allows the analysis of actual and simulated pricing methods supporting the modeling of the enterprise performance and profitability. Analytics also provides an easy and tight (meta level) integration with MS-Excel.

Analytics keeps track of historical data, so that out-dated or phased out products or inactive customers still contribute in reporting (while in Price Setting you want to have only currently offered products or active customers).

image-20250916-074541.png

Data Sources and Data Flow

Pricefx structures analytics data through a clear flow:

  1. Data Feeds: Raw input (e.g., transactions, competitor prices).

  2. Data Loads: Cleansing/enrichment processes to prepare data.

  3. Data Sources: Structured repositories of cleansed data, organized by type (customers, products, transactions).

  4. Datamarts: Consolidated collections from multiple sources for advanced analytics.

AnalyticsDiagram.drawio.png

Chart Types

Pricefx Analytics supports a wide selection of chart types:

  • Bar & Line → Compare two related values (e.g., Gross Margin vs. Base Price).

  • Box Plot → Visualize data distribution and outliers.

  • Bubble → Display three dimensions of data for segmentation analysis.

  • Heatmap → Highlight underperforming areas with color-coded matrices.

  • Histogram → Analyze continuous data distributions (e.g., margin spread).

  • Pie → Show proportional distributions (e.g., Invoice Price by Country).

  • Scatter → Identify correlations and outliers.

  • Time Series → Track performance over time, highlight seasonality.

  • Waterfall → Illustrate sequential price build-up and margin leakage.

  • Waterfall Comparison → Benchmark by customer, product, or year.

info These visualization tools help you uncover insights quickly and intuitively.

Out-of-the-Box Analytics Scenarios

1. Running a Pricing Simulation

  1. Open the Analytics capability.

  2. Select a Datamart with relevant product and transactional data.

  3. Choose a chart type (e.g., Scatter or Time Series).

  4. Apply simulation rules (e.g., increase base price by 3%).

  5. Review the projected impact on margin and customer segments.



2. Creating a New Datamart

  1. Upload raw inputs via Data Feeds.

  2. Cleanse and enrich data with Data Loads.

  3. Define and map structured Data Sources.

  4. Build a Datamart combining multiple sources.

  5. Deploy for reporting and dashboards.



3. Performing Margin Leakage Review

  1. Open Datamart Viewer and select margin-related data.

  2. Apply a Waterfall chart to visualize price build-up.

  3. Use Waterfall Comparison to benchmark products/customers/years.

  4. Drill deeper with Heatmaps or Scatter plots.

  5. Recommend corrective actions such as discount limits or pricing adjustments.

image-20250916-080729.png
image-20250916-080423.png
image-20250916-080322.png



The following areas can be managed in the Analytics module:

See Also