metadata

title: SAP Sales KPI Dashboard
emoji: 📊
colorFrom: blue
colorTo: purple
sdk: streamlit
sdk_version: 1.28.1
app_file: app.py
pinned: false
license: mit

SAP Sales KPI Dashboard

Overview

A comprehensive Streamlit dashboard analyzing real SAP ERP data from Kaggle, focusing on sales performance KPIs.

Data Source

Dataset: mustafakeser4/sap-dataset-bigquery-dataset
Tables Used: VBAK, VBAP, KNA1, VBRK, VBRP, MAKT, and supporting tables
Records: Thousands of real SAP transactions

Key Features

🎯 Sales KPIs

Customer Analysis: Top 10 customers by revenue with customer concentration metrics
Regional Performance: Country-wise sales breakdown and geographic insights
Sales Organizations: Performance by SAP sales organization and distribution channels
Product Analysis: Top 10 products by revenue with material descriptions

📊 Analytics Modules

👥 Customer Analysis

Revenue ranking of top customers
Customer concentration analysis
Customer master data integration (KNA1)

🌍 Regional Performance

Country-wise revenue distribution
Geographic performance insights
Regional market analysis

📈 Sales Organization Analysis

Sales organization (VKORG) performance
Distribution channel (VTWEG) effectiveness
Organizational structure insights

🛍️ Product Performance

Top-performing materials by revenue
Product descriptions from MAKT table
Material master data integration

📊 Data Quality Overview

Dataset completeness metrics
Revenue distribution analysis
Sample data exploration

Technical Implementation

Data Processing

Real-time Kaggle Integration: Uses kagglehub to download latest dataset
SAP Table Joins: Combines VBAK (sales orders) with VBAP (line items)
Master Data Integration: Enriches with customer (KNA1) and material (MAKT) data
Data Quality Handling: Manages missing values and data type conversions

Performance Optimization

Selective Loading: Loads only essential columns and limits record count
Caching: Streamlit caching for improved performance
Error Handling: Graceful degradation when tables are unavailable

SAP Tables Used

Table	Description	Usage
VBAK	Sales Document Header	Main sales orders
VBAP	Sales Document Items	Line item details
KNA1	Customer Master	Customer information
MAKT	Material Descriptions	Product names
VBRK	Billing Header	Invoice data
VBRP	Billing Items	Invoice line items

Interactive Features

Organization Filtering: Focus on specific sales organizations
Real-time Calculations: Dynamic KPI updates based on filters
Export Capabilities: Download processed data as CSV
Responsive Design: Optimized for various screen sizes

Deployment

Deployed on Hugging Face Spaces with automatic Kaggle dataset synchronization.

Perfect for SAP analysts, sales managers, and business intelligence teams needing quick insights from real ERP data.