Auckland, New Zealand · Available for select projects
I’m Arezou Osouli, a business intelligence developer specialising in Power BI, SQL, Python, and Excel — building the pipeline from raw data to a decision someone is confident enough to act on.
Methodology
Every dashboard I ship follows the same disciplined path — from a vague business question to a decision someone is confident enough to act on. Here's the full pipeline.
STEP 01
Sit with stakeholders before touching a single table — what decision are we actually trying to improve?
Define the business question, success metric, and audience. No dashboard gets built until the decision it supports is clear.
STEP 02
Map every source of truth — SQL databases, APIs, spreadsheets, exports — and pull it into one place.
Inventory sources, assess data quality and access, and set up reliable extraction (SQL, Python, connectors).
STEP 03
Fix the nulls, standardise the formats, resolve the duplicates — the unglamorous work that makes everything after it trustworthy.
Data validation, type correction, deduplication, and transformation logic in SQL / Python / Power Query.
STEP 04
Design a schema that answers questions fast — star schemas, relationships, and DAX measures that hold up under scrutiny.
Star-schema modelling, relationships, calculated columns and measures (DAX), documented business logic.
STEP 05
Design interfaces that surface the answer in seconds, not spreadsheets that require a tour.
Power BI / interactive dashboards with clear visual hierarchy, drill-throughs, and role-based views.
STEP 06
Go beyond the chart — explain what changed, why it matters, and what's likely to happen next.
Trend analysis, anomaly detection, and plain-language narratives that sit alongside the numbers.
STEP 07
Hand over a recommendation, not just a report — and stay close enough to see it actually get used.
Present to stakeholders, tie insights to concrete actions, and track whether the decision moved the metric.
Currently
Business Intelligence Developer @ Skills Consulting Group
About me
I’m a business intelligence developer who works at the intersection of engineering and storytelling — comfortable writing the SQL that fixes a broken data model, and just as comfortable in the room explaining to a manager why a metric moved.
My background spans Power BI report development, Databricks and Unity Catalog data engineering, Microsoft Fabric, Azure cloud services, and hands-on Python and Spark analysis. I care about getting the plumbing right — clean models, documented logic, reliable refreshes — because that’s what makes a dashboard something people actually trust.
Toolkit
The stack I reach for at each stage of the BI process — from raw source to a polished, trusted dashboard.
Turning models into interfaces people trust and use daily.
Getting to clean, reliable data as fast as possible.
Where automation and statistical rigour take over from spreadsheets.
The plumbing that keeps dashboards live and data flowing.
Selected work
Each one follows the same pipeline — a real business problem, a data solution, and a measurable outcome. Replace these with your own case studies in content/projects.ts.
Turning enrolment data into actionable employer intelligence.
A star-schema funnel report bridging CRM leads and LMS enrolments, giving marketing and admissions a single source of truth from first contact to enrolled learner.
A governed Spark SQL view layer over raw learner records, fixing date-handling and type issues so compliance reports could be trusted without manual patching.
Reverse-engineered an undocumented ADF-to-Databricks ingestion pipeline using history and lineage tooling, then replicated it safely in a dev environment.
Career
Where the process above has actually been put to work.
2023 — Present · Auckland, NZ
2021 — 2023 · Auckland, NZ
Credentials
Formal training that backs up the day-to-day work.
Foundation
PNU University
Focus on databases, statistics, and information systems design.
Word of mouth
“She didn't just hand us a dashboard — she sat with our team until we understood what the numbers meant for how we run campuses. That's rare.”
Jordan Miller
Regional Operations Manager, Skills Institute
Get in touch
Have a dashboard that nobody trusts, or a question no one can answer with the data you have? I'd like to hear about it.