IntakeProject SetupData ReadinessPopulation & Job MappingMarket PricingPay DiagnosticsSalary Structure DesignGeo Pay StrategyCost ScenariosMerit PlanningGovernanceRecommendationsDeliverables
Compensation Advisory Studio

Data Quality Command Center

Upload, validate, map, and score your compensation data before analysis. High-quality data drives trusted insights.

What This Analysis Does

Validates, maps, and scores your data across key domains to ensure accuracy, completeness, and alignment for compensation analysis.

Required Data
  • Employee census (CSV/XLSX)
  • Market data & benchmark matches
  • Salary structure & performance ratings
  • Bonus & equity data (optional but recommended)
Key Outputs
  • Data Readiness Score (0–100)
  • Identity completeness & benchmark coverage
  • Issue diagnostics by severity & impact
  • Confidence score & proceed recommendation
Next Recommended Action

Resolve 15 blocking issues to improve Data Readiness and proceed to Population & Mapping.

Data Readiness Score
86/100
Good · Within range to proceed with minor issues.
86
Identity Completeness
94%
All employee IDs unique and populated; allocations and currencies present.
Benchmark Coverage
78%
48 employees lack approved benchmark matches across L5 and Product L4.
Quality Confidence
72%
Confidence in analysis outcomes based on current data quality.
Source Files
  • Employee censusUploaded
    15,248 rows
  • Market dataUploaded
    1,248 rows
  • Salary structureUploaded
    612 rows
  • Performance ratingsUploaded
    1,248 rows
  • Bonus dataUploaded
    1,248 rows
  • Equity dataOptional
Data Mapping

Field Mapping Preview

MappedIssue
  1. Employee ID
    Employee_ID✓
  2. Job code
    Job_Code✓
  3. Job title
    Job_Title4 nulls
  4. Job family
    Job_Family✓
  5. Career stream / Level
    Career_Stream_Level19 missing
  6. Business unit
    Business_Unit✓
  7. Department
    Department✓
  8. Manager ID
    Manager_ID✓
Validation Summary
110 total issues ·
  • Critical
    Must fix to proceed
    15
  • High
    High impact on results
    34
  • Moderate
    Important to address
    42
  • Low
    Nice to have
    19
Quality Surface

Issues by Data Domain

CriticalHighModerateLow
Critical
High
Moderate
Low
Employee Census
7
12
8
6
Job & Organization
4
11
12
8
Compensation
2
7
15
9
Performance
1
3
4
7
Market Matches
1
1
3
2
Equity & Bonus
0
0
0
1
Proceed / Remediate Decision Guide
86%
readiness
Proceed If:
  • No critical issues remain
  • High issues ≤ 10
  • Benchmark coverage ≥ 70%
  • Identity completeness ≥ 90%
Current Status
  • 15 critical issues remaining
  • 34 high issues remaining
  • Benchmark coverage: 78%
  • Identity completeness: 94%
Impact If Proceeding Now

Minor gaps may affect market matches and accuracy in pricing for ~48 employees.

Recommendation

Remediate critical and high issues to improve readiness to 90+.

Estimated time to address: 1–2 hours.

AI Advisor
BETA

Your data is nearly ready. Resolve the blocking issues to proceed with confidence.

Readiness Verdict
Almost Ready

Resolve 15 blocking issues to proceed with confidence.

Top Blocking Issues
  • 19 records missing job codes
  • 4 records missing job titles
  • 19 records missing levels
  • 48 employees lack approved benchmark matches
  • 12 Canadian records flagged in USD; needs CAD/USD conversion
Recommended Next Action

Resolve critical & high issues (49 total) to improve readiness to 90+ and proceed.

Last data refresh: May 18, 2025 10:42 AM
Or proceed with current dataProceed Anyway
CRITICAL HIGH MODERATE LOW