Auckland Transport - Advanced Analytics Dashboard

Auckland Transport Analytics Dashboard

You can also drag & drop a .csv or .atdash file here. Session backups (.atdash) can restore your full dashboard state.

No data loaded.

Organization Overview

Total Positions

0
Across all departments

Average FTE

0
Full-time equivalent

Vacancy Rate

0%
Unfilled positions

Departments

0
Organizational units

Tier Distribution

Employee Group Distribution

Hierarchy Analysis

Span of Control by Manager

Organization Tree Depth

Manager Analysis

Total Managers

0
All management levels

L1 Managers

0
Top level managers

L2 Managers

0
Second level managers

Avg Span of Control

0
Direct reports per manager

Top 20 Managers by Direct Reports

Management Structure Summary

Loading management insights...

Manager Details

0 managers
Manager Name Level Department Direct Reports (HC) Total Team Size Position ID

Department Metrics

Department Size Comparison

Department Tier Distribution

Workforce Analytics

Full-Time Positions

0
FTE = 1.0

Part-Time Positions

0
0 < FTE < 1.0

Vacant Positions

0
HC = 0

Fill Rate

0%
Positions filled

FTE Distribution (by Position)

Employee Group by Tier

Cost Center Analysis (Overall)

Top 15 Cost Centers by Headcount

Cost Center Count by Size (HC)

Key Insights & Recommendations

AT Reintegration Scenarios (2025-2027)

Total Staff Transition

1,804

Annual Savings

$18-22M

Target Public Trust

55%

Timeline

2027

Staff Reallocation by Function

Scenario Comparison

🎯 Alignment

Integration aligns transport with housing, climate, resilience under one LTP.

💰 Benefits

$18-22M annual savings via shared services for safety & transit.

📈 Targets

2030: Trust 55%, DSI <400, PT trips 140M, Farebox 40%.

🏗️ Plan

Phase 1 (Corp) mid-2026, Ph 2 (Ops) mid-2027; TCAMP in 2027-37 LTP.

Mayoral Expectations Analysis

LoE Dec 2023 - One Year Review

Expectations Met

3/15

Savings Target

$12M
vs $20M

Public Trust

27%

Enforcement Rev

+15%

Performance vs Mayoral Priorities

Detailed Assessment

PriorityStatusEvidenceAssessment
Listen to Akl❌ FailTrust 27%No imprv.
Fix roads❌ Fail$37M capex lowDeteriorating
$50 PT pass⚠️ PartLow uptakePrice OK
Savings ($20M)❌ Fail$12M (Y1)40% short
Enforce revenue✅ OK+15% park revSuccess
Cycling network❌ FailCancelledUnaffordable

🚨 Gov. Disconnect

AT failed "take direction". 20% success shows misalignment. Validates reintegration.

💸 Financial Non-Comp.

Missed savings by 40%, $36M surplus, $37M capex underspend. Defiance.

Timeline: 1 Year Non-Delivery

Critical Verdict

AT's failure to deliver on mayoral expectations provides compelling evidence for reintegration.

  • ✗ 3/15 expectations met
  • ✗ Trust static at crisis levels
  • ✗ Financial directives ignored

Conclusion: LoE shows arm's-length model enables defiance. Reintegration is a necessity.

Data Explorer

CSV
JSON

Position Details

0 records

Tier Cost Composition Explorer

Tier X Positions

0

Tier X FTE

0

Tier X Headcount

0

Cost Centers (Tier X)

0

Cost-Center Composition (Tier X Roles)

Cost Center ID Cost Center Text Tier X FTE Tier X Headcount Share of Total Tier X FTE

Processing...