Data Quality

Completeness, validity, consistency and privacy controls

Primary measureWorkbook not suppliedOperational status8 quality dimensionsWorkbook coverageSensitive fields masked

Workbook Records

Issue	Domain	Severity	Worksheet	Source row	Status	Recommended action
Inconsistent Touch ’n Go year	TNG	High	Pool Vehicle TNG	Title/heading	Open	Validate 2025 versus 2026
Mixed date representations	All domains	Medium	Multiple	Multiple	Open	Normalize dates on import
Missing StaffID	Requests	Medium	All request sheets	83 records	Open	Integrate employee master data
Hotel cost unavailable	Hotel	Medium	Hotel Request	46 records	Open	Capture booking cost
Travel cost unavailable	Travel	Medium	Flight Request	21 records	Open	Capture ticket cost
Mileage unavailable	Fuel	Medium	Fuel sheets	38 records	Open	Capture mileage for efficiency metrics

Nordin – Smart Assistant● Online · Administration grounded

Your smart assistant for executive insights, analysis and decision support.

Currently viewing: data-qualityAdmin Dataset.xlsxSAP Budget ExtractJRMS

Dashboard-grounded modeAnswers use only connected Administration, SAP budget and JRMS operational datasets. Unsupported questions are not inferred.

EXECUTIVE BRIEFINGNordin's AssessmentConfidence: High · Overall attention: High

Administration has utilised RM 5.48M or 34.0% of its RM 16.13M 2026 SAP budget. Kebersihan / Pokok is the highest monitored budget item at 76.0%. Operationally, 13 requests remain pending, while incomplete contract fields and the TNG reporting-period conflict require follow-up.

watchReview high-utilisation budget items

Kebersihan / Pokok leads monitored items at 76.0% utilisation.

SAP Budget Extract · Fund Center 1001061

Open Administration Budget →

highClear pending approvals

13 requests require approval or confirmation.

6 Hotel · 5 Vehicle · 2 Travel · 15.7% of requests

Start Review →

mediumComplete contract fields

Incomplete PR and PO fields reduce renewal visibility.

11 missing PR dates · 2 missing PO numbers

Open Records →

data-qualityResolve reporting-period conflict

Touch ’n Go worksheet and reporting columns use different years.

1 reporting-period conflict

Review Issue →

mediumCapture vehicle mileage

Mileage is required before fuel efficiency or cost/km can be calculated.

Mileage unavailable

Next Best Actions

Review high-utilisation budget itemsKebersihan / Pokok 76.0% · SAP BudgetOpen Budget →
Clear pending approvals6 Hotel · 5 Vehicle · 2 TravelStart Review →
Complete contract fields11 missing PR dates · 2 missing PO numbersOpen Records →
Resolve reporting-period conflict1 reporting-period conflictReview Issue →
Capture vehicle mileageMileage unavailable

Ask Nordin About This Brief