Power BI analysis of international traveller flows in Aotearoa New Zealand (P04 — BORDER MOVEMENT ANALYTICS)
Overview
Developed a Power BI analytics solution using Stats NZ International Border Movements data to explore traveller flows, trends, arrivals, departures, and movement patterns across 2022–2025.
My Role
Data Analysis • ETL • Data Modelling • DAX • Power BI
I prepared and transformed the source data, investigated data-quality issues, designed the analytical model, developed DAX measures, implemented Row-Level Security, and created interactive Power BI reporting.
The Challenge
The source data contained quality and modelling challenges, including duplicate records, conflicting movement totals, limited record-level identifiers, and multiple dimensions that needed to work together for reliable analysis.
The goal was to turn the raw border-movement data into a structured and usable BI model while maintaining transparency around data-quality limitations.
The Solution
The Power BI solution included:
- Power Query ETL and data preparation
- Data-quality investigation and exception handling
- Star-schema dimensional modelling
- DAX measures for movement and trend analysis
- Year-on-year comparisons
- Arrivals and departures analysis
- Port ranking and contribution analysis
- Row-Level Security (RLS)
- Interactive dashboard reporting
Technology
Power BI • Power Query • DAX • ETL • Data Modelling • RLS
Key Analytics
Some of the measures developed included:
Total Movements
Annual Monthly Average
Peak-to-Trough Ratio
Previous Year Movements
YoY % Change
% Non-NZ of Period
Arrivals
Departures
Net Arrivals
Port Rank
Top 3 Port Share
Security & Governance
Implemented Row-Level Security (RLS) in Power BI to demonstrate controlled access to report data based on defined user roles.
Outcome
Created an interactive BI solution that transforms large-scale border-movement data into clearer insights about traveller patterns, temporal trends, movement direction, and port activity.
Visuals
1. Main Power BI dashboard screenshot
2. RLS setup screenshot
3. Data model / star schema screenshot
