---
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](https://www.kaggle.com/datasets/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.