Data Input Configuration
Required Files
  • BIG-Checkins: Excel file with check-in records
  • BIG-Fitpass: Excel file with customer filter data
  • Fitpass-Checkins: CSV file with Fitpass records
Contains: Name, Check-in Zeit, Customer details
Contains: Customer filter list (Vorname, Nachname)
Contains: Datum, Member Name, PLZ Ort
Date Range Configuration
Quick presets:
Processing Status & Information
Processing Pipeline Overview
  • Step 1: Load and validate input files
  • Step 2: Filter BIG-Checkins by BIG-Fitpass customers
  • Step 3: Apply date range filtering
  • Step 4: Remove duplicates and compare datasets
  • Step 5: Generate reports and statistics
Key Features
  • Case-insensitive name matching
  • Cross-system data validation
  • Automated duplicate detection
  • Comprehensive statistical analysis
  • Detailed discrepancy reporting
Output Files
  • BIG-Filtered.csv: Filtered BIG check-in records
  • Fitpass-Filtered.csv: Filtered Fitpass records
  • Comparison-Report.txt: Detailed analysis report