Spaces:
Running
Running
| 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. | |