Stop preparing data. Start analysing it.
Most NZ businesses spend far too much time getting data ready and not enough time using it. Power Query is built into Excel and Power BI specifically to automate that preparation — connecting to your data sources, cleaning and transforming the data, and keeping your reports refreshed automatically.
Book a free consultationData preparation problems we eliminate
The manual data work Power Query removes from your team's week.
Data from multiple systems pasted together manually every week before reporting can begin
Inconsistent column names, date formats and data types causing formula errors
Hours spent cleaning the same messy export from the same system every month
Reports that cannot refresh until someone manually runs the data preparation process
No record of what transformations were applied — just "it works, don't touch it"
Pivot tables and charts that update correctly only when data is structured perfectly
Power Query projects we have delivered
Data pipeline and transformation work for New Zealand organisations.
ERP Export Automation
Power Query connects to monthly ERP exports, applies 14 transformation steps and loads a clean, structured table — replacing 3 hours of manual preparation.
Multi-Store Sales Consolidation
Queries from six store systems, applies consistent naming and category mapping, and loads consolidated data into a pivot-ready model — refreshes with one click.
Payroll System Data Cleaner
Power Query standardises payroll exports with inconsistent formatting, merges cost centre data and produces a reconciliation-ready table for finance.
Supplier Data Feed Processor
Connects to supplier CSV feeds, applies pricing rules and availability flags, and loads into a procurement dashboard that updates daily.
How we work
From messy data sources to clean, refreshable pipelines.
Data source review
- Understand the source systems and export formats
- Identify the transformations required
- Map the output structure needed for reporting or analysis
Deliverable: Data transformation spec with connection approach and step outline.
Query build and testing
- Queries built using best practices — no hard-coded paths or fragile steps
- Tested with representative data including edge cases and blanks
- Refresh tested on your environment
Documentation and handover
- Annotated query steps for future maintenance
- Refresh instructions for your team
- Training available on editing queries for minor changes
Power Query consulting across New Zealand
We provide Power Query consulting to businesses throughout New Zealand — Auckland, Wellington, Christchurch, Hamilton, Tauranga and beyond. Power Query work is delivered entirely remotely. We work with businesses across finance, retail, logistics, manufacturing, healthcare and professional services who use Excel or Power BI for reporting and analysis.
Frequently asked questions
What is Power Query and what can it do?
Power Query is a data transformation tool built into Excel and Power BI. It connects to data sources, applies cleaning and transformation steps, and loads structured data ready for analysis. It replaces manual data preparation with a repeatable, one-click refresh process.
What data sources can Power Query connect to?
Power Query connects to Excel files, CSV files, SQL Server, Oracle, MySQL, PostgreSQL, SharePoint, OneDrive, web pages, APIs, Azure services, Salesforce and many more. If you have a data source, we can usually connect to it.
Can Power Query replace VBA for data import tasks?
For many data import and transformation tasks, yes. Power Query is often faster to build and easier to maintain than VBA for ETL-style work. We will advise on the right approach based on your specific requirements — sometimes a combination of Power Query and VBA is optimal.
Does Power Query work in our version of Excel?
Power Query is built into Excel 2016 and later, and all Microsoft 365 versions. For Excel 2010 and 2013 it can be installed as a free add-in. We confirm compatibility before starting any engagement.
How much does Power Query consulting cost in New Zealand?
A straightforward data connection and transformation project typically starts from $1,000 NZD. More complex multi-source pipelines with automated refresh and documentation are typically $2,000 to $6,000 NZD. We provide a fixed quote after reviewing your data sources.
Ready to automate your data preparation?
Tell us what data you are preparing manually and we will show you how Power Query can handle it.
Book a free consultationLet's talk about what you need
Big or small, we are happy to discuss it. Send us a message or book a free discovery call — we typically respond same business day.
What happens next
- 1
We review your enquiry and reach out to discuss your requirements — no commitment needed.
- 2
We provide a no-obligation quote and estimated delivery timeframe.
- 3
Once agreed, we build in stages and keep you updated throughout.