Data & Intelligence
Modelling, DAX and dashboards built for people who have ten minutes, not ten tabs. Row-level security so every subsidiary sees exactly its own numbers.
- Power BI
- DAX
- Data modelling
- RLS
- Geospatial analysis
- Excel
Wellington, New Zealand
Nicholas Holt.
SYSTEMS ANALYST, DATA STORYTELLER, PROCESS BUILDER, DEVELOPER, LOCALHOST ENTHUSIAST
I turn messy operational data into reporting that executives actually act on.
Systems analyst working across insights, analytics and process development — building the reporting, documentation and platforms that let people make evidence-based decisions.
- subsidiaries reported on
- 17subsidiaries reported on
- page enterprise BI suite
- 77page enterprise BI suite
- employees using my docs
- 1,000+employees using my docs
- years across data & systems
- 5years across data & systems
Tools I work with: Power BI, DAX, SQL, Excel, SharePoint, Microsoft 365, Azure, TypeScript, React, Next.js, Power Automate, Jira, JSON, HTML / CSS.
01What I do
Between the data
and the decision
Most of my work lives in the gap between a system that holds the numbers and a person who has to make a call. I build the models, dashboards, documentation and processes that close it — then make sure they keep running without me.
Systems & Platforms
Administering the Microsoft stack end to end — tenancy, intranet, permissions — including the cybersecurity audits nobody volunteers for.
- Microsoft 365
- SharePoint
- Azure
- Security audits
- SAP S/4HANA
Process & Delivery
Turning a quarterly scramble into a repeatable pipeline: process maps, technical documentation and automated distribution to the people who need it.
- Process mapping
- Documentation
- Automation
- Stakeholder reporting
Web & Code
The newest thread, and the one I chase in my own time — building interfaces on a modern React stack, this site included.
- TypeScript
- React
- Next.js
- Tailwind CSS
- GSAP
- JSON
02Experience
Six roles, one through-line
Hospitality to logistics to government to enterprise analytics. Every step added a system to understand and someone who needed the answer faster than the system gave it.
- Nov 2023 — Present
Systems Analyst
The Colonial Motor Company
A publicly listed automotive holdings company running a network of 19 vehicle dealerships across New Zealand.
77-pageBI suite, 17 subsidiaries
- Designed and delivered a 77-page enterprise Power BI reporting suite for 17 subsidiaries, including full data modelling, calculated tables, and RLS-secured dashboards.
- Automated quarterly production and extranet distribution of the reporting suite, presenting insights to CEOs, CFOs, and Dealer Principals.
- Sole developer of a quarterly operational performance reporting process, consolidating monthly submissions from 17 subsidiaries.
- Built geospatial dashboards combining external registration data with internal sales data to identify PMA-based sales trends.
- Authored technical documentation, process maps, and user guides used by over 1,000 employees.
- Managed SharePoint intranet platforms and Microsoft 365 administration, conducting cybersecurity audits.
- Power BI
- DAX
- Excel
- SharePoint
- Microsoft 365
- Azure
- HTML
- CSS
- JSON
- Oct 2022 — Nov 2023
IT / Digital Candidate Manager
Find IT Recruitment
A Wellington, Auckland and Christchurch recruiter specialising in corporate, finance, technology and digital roles.
~$150kestimated fees across 14 hires
- Placed 14 hires — 9 permanent and 5 contract — worth an estimated $150,000 in placement fees, based on standard rates at the time rather than any client figures.
- Sourced candidates across job boards, referrals and professional networks, building a pipeline for corporate, finance and technology roles.
- Partnered with recruitment consultants to understand client needs and candidate requirements for precise matches.
- Conducted in-depth interviews to evaluate fit and prepared detailed candidate profiles and reports.
- Managed and updated candidate databases accurately, ensuring data integrity.
- Provided technical support to colleagues for hardware and software issues.
- JobAdder
- Microsoft 365
- LinkedIn Talent Solutions
- SAP SuccessFactors
- Feb 2022 — Oct 2022
Administrator
Dept. of Corrections / NZ Parole Board
The independent body responsible for deciding the parole of individuals in Corrections care.
- Served as the primary point of contact for the New Zealand Parole Board, maintaining relationships with stakeholders.
- Utilised Department-based platforms and M365 applications to support daily operations.
- Demonstrated excellent judgment and discretion in handling highly confidential information.
- Provided technical support to internal staff and Parole Board members.
- Processed and paid vendor invoices, ensuring timely and accurate financial transactions.
- IOMS
- SAP S/4HANA
- Citrix ShareFile
- Jul 2021 — Feb 2022
Logistics Administrator
FUJIFILM Business Innovations
Contributed to the Wellington City Council Archive Digitalisation Project, digitising 200 years of archival files.
200 yrsof archives digitised
- Managed and maintained office-wide IT systems to ensure efficient use by all staff.
- Identified and resolved errors in archiving operations to maintain data accuracy.
- Stepped up to lead a team of eight Imaging and Archival Specialists during a transitional period.
- Generated database reports for internal stakeholders to track project progress.
- Jira
- FXNZ Internal Tools
- Microsoft 365
- Jul 2020 — Jul 2021
Bartender
ABV Rooftop Bar / The Grand
- Designed eye-catching marketing material for events using Adobe Creative Cloud.
- Maintained strict adherence to health and safety regulations.
- Developed excellent communication skills engaging with diverse patrons.
- Adobe Photoshop
- Illustrator
Retail Assistant
PAK'nSAVE New Plymouth · Mar 2015 — Jul 2020
03Selected work
Things I build after hours
Things I build in my own time, usually because a question got stuck in my head and building the answer was the only way out. Open either one for the write-up.
NZ Vehicle Registration Analytics
Small questions about a very large file.
A static site over NZTA's open vehicle register. The heavy lifting happens once a month in a build job, so the browser can answer questions like "how fast did EVs actually grow" straight away, without ever going near the raw data.
- Python
- DuckDB
- Astro
- React
- TypeScript
- Observable Plot
- GitHub Actions
Personal project4AmbientGen Wall Studio
Shaders for the wall, not the demo reel.
A studio for making generative visuals for large LED walls — writing real-time scenes, presenting them across two screens, and pushing them out to the displays that run them.
- React 19
- Three.js
- GLSL
- TypeScript
- Express
- Prisma
- PostgreSQL
- MQTT
- Tauri
04Colophon
The small print, for once worth reading
One continuous page rather than a set of them: structure from rhythm and typography instead of dividers, and motion that takes the hint the moment it is not wanted.
Onepage,onesetoftokens,andnothingonitIcouldnottakeapartandexplain.
What follows is the rest of it: what the site is made of, and what each piece is actually earning its place for.
- Framework
- Next.js 16App Router, rendered on the server wherever it can be, and a build that fails loudly when I have got something wrong. It gets plenty of practice.
- Language
- TypeScriptStrict. The errors are the feature — most of what I know about this stack, I learned from being told no.
- Styling
- Tailwind CSS v4One set of custom properties per theme. Light and dark cannot drift apart because there is only one place left to get them wrong.
- Motion
- GSAP · ScrollTrigger · LenisScroll-linked timelines and smoothing, all of it behind a prefers-reduced-motion guard. If you would rather it held still, it holds still.
- Tooling
- AI assistanceOne of the tools on the desk, and about as remarkable as the rest of them.
- Typefaces
- Inter · Instrument Serif · JetBrains MonoA workhorse for reading, one italic for the word that matters, and a monospace for anything you might want to count.
05Contact
Let's build something useful.
Whether it's insights, analytics, process work, or you just want to compare notes on Power BI and React — the inbox is open.