Sales Performance for Databricks

Name: Sales Performance for Databricks
Brand: Onibex
SKU: onibex-streamingsolutions-salesperformance-databricks

by Onibex

Provides real-time and historical visibility into invoicing data, enabling monitoring and analysis of performance across plants, sales areas, and divisions.

Reference: onibex-streamingsolutions-salesperformance-databricks Platform: Databricks Created by: Onibex

TECHNICAL SPECIFICATIONS

Streaming Method	Databricks
Streaming Time	Real time
Script Language	Pipeline SQL
Implementation Time	15 hours
Tech Layers	Data Engineering / AI Data Foundation

THIS SOLUTION CONTAINS

Invoice by Tables

x 1

Shipping Condition by Tables

x 1

Distribution Channel by Tables

x 1

Customer Sales District by Tables

x 1

Plants by Tables

x 1

Sales Office by Tables

x 1

Sales Division by Tables

x 1

Material Group by Tables

x 1

Material Hierarchy by Tables

x 1

Sales Organization by Tables

x 1

DESCRIPTION

Provides real-time and historical visibility into invoicing data, enabling users to monitor and analyze performance across plants, sales areas, and divisions. Shows comprehensive view of billed revenue and invoice volumes, helping identify sales trends, patterns, and deviations over time like who is buying more, from which plant, and within which product division. Supports strategic decision making showing information that improve commercial performance and financial outcomes.

Dependencies:

One Connect for SAP +
One Connect Stream +
Databricks and Snowflake Dynamic Tables

STREAMING SOLUTION ASSET DETAILS

DATABRICKS SCRIPTS INCLUDED:

onibex-dp-sales-s4h-salesinvoice-silver-databricks.py
onibex-dp-sales-s4h-salesperformance-gold-databricks.py

STREAMING SOLUTION SOURCE DATA PRODUCTS

CATEGORY	FUNDATIONAL DATA PRODUCT
FINANCE	INVOICE
ORGANIZATIONAL STRUCTURE	SHIPPING CONDITION
ORGANIZATIONAL STRUCTURE	SALES ORGANIZATION
ORGANIZATIONAL STRUCTURE	DISTRIBUTION CHANNEL
ORGANIZATIONAL STRUCTURE	CUSTOMER SALES DISTRICT
ORGANIZATIONAL STRUCTURE	PLANTS
ORGANIZATIONAL STRUCTURE	SALES OFFICE
ORGANIZATIONAL STRUCTURE	SALES DIVISION
ORGANIZATIONAL STRUCTURE	MATERIAL GROUP
ORGANIZATIONAL STRUCTURE	MATERIAL HIERARCHY