📋 Expected Data Format

Required Columns:

  • region: Geographic area (e.g., Riyadh, Makkah)
  • category: Job type (e.g., Nurses, Physicians)
  • count: Current workforce count
  • required: Required workforce
  • saudi_national: Number of Saudi nationals
  • expatriate: Number of expatriates

Sample Data:

region,category,count,required,saudi_national,expatriate
Riyadh,Nurses,1500,1800,1200,300
Makkah,Physicians,800,1000,600,200
Eastern Province,Technicians,1200,1400,900,300

Analysis Features:

  • 🔍 Gap Analysis: Workforce shortages by region/category
  • 🇸🇦 Saudization: Nationalization progress tracking
  • 🌍 Regional: Geographic performance comparison
  • 📊 Visualizations: Interactive charts & insights

Analysis Filters

📍 Live Regional Distribution

Adequate (>90%)
Moderate (75-90%)
Significant (60-75%)
Critical (<60%)

🔴 Live Workforce Metrics

Real-time
Total Workforce
Loading...
Calculating...
Current Gap
Loading...
Calculating...
Coverage Rate
Loading...
Calculating...
Active Regions
Loading...
13/13 covered
Critical Areas
Loading...
Monitoring
Last Updated
Loading...
Auto-refresh ON

Workforce Distribution by Category

Workforce Distribution Chart

Shows breakdown by healthcare worker category

Gap Analysis by Region

Export to Excel
REGION REQUIRED CURRENT GAP GAP % STATUS
Riyadh Region 76,230 72,456 -3,774 -4.9% Moderate Shortage
Makkah Region 65,120 63,875 -1,245 -1.9% Adequate
Eastern Province 52,450 51,230 -1,220 -2.3% Adequate
Najran Region 14,520 9,876 -4,644 -31.0% Critical Shortage

📊 Manual File Analysis Based on Your Uploaded Files

Comprehensive analysis of your uploaded CSV data with detailed insights, trends, and recommendations.

Total Files Analyzed
0
📁 Upload files to start analysis
Total Records
0
📊 Workforce entries processed
Average Gap Rate
0%
📈 Calculated from your data
Critical Regions
0
⚠️ Require immediate attention
Last Analysis
Never
🕒 Import data to analyze

📈 Your Data Analysis

🌍 Regional Analysis

Region Total Workers Required Gap Coverage % Status
📁 Upload CSV files to see regional breakdown

👥 Category Analysis

📋 Upload History

📄 No files uploaded yet

Your upload history will appear here