Work

Each engagement is described by the decision the client can now make and what it replaced. The technology is listed last, because it's the means, not the result.

5 days to 3 hoursBoard reporting for a SaaS company.
50 hotels, one platformRooms and dining, owners, lenders and investors, one model.
From how much to whereCompliance reporting that directs effort.
Activity to outcomesPublic data joined to evaluate interventions.

Hotel portfolio: one reporting platform across 50 hotels

Australia · February 2026 to present · Phased delivery, sign-off at each milestone
Hospitality · Microsoft Fabric

What it replaced

Property workbooks that could not feed Power BI at all. Benchmarking across dozens of sheets, debt schedules and budgets across dozens more, investment summaries with duplicate and missing codes. No group-level view, no fair comparison, and a week of assembly every time a lender asked a question.

How

Each property's files land automatically from SharePoint into Fabric, are standardised so every hotel's data means the same thing, and feed one governed model published across dev, test and production. Size-adjusted benchmarking. Tie-out reporting against the ledger. Delivered lean: the first properties were reporting from the new model within weeks, each phase in use and signed off before the next began. In delivery now: brand compliance, row-level security, governance and training.

What they can do now

Compare every hotel on equal terms regardless of size. See profit by property and by revenue line, rooms and dining. Produce the reporting lenders and investors ask for on demand, with every figure proved back to the accounting system. Five audiences report from the same numbers and cannot contradict each other.

Microsoft Fabric Lakehouse PySpark Medallion Kimball DAX Row-level security Deployment pipelines Microsoft Graph API

City of Melbourne laneway audit: compliance reporting as evidence

Engaged via Waste Audit and Consultancy Services · June 2025 to present · Ongoing support
Local government · Power BI

What it replaced

Audit records and contractor feeds on different daily, weekly and monthly cycles, tracked by hand in Excel. Problems visible weeks after they occurred, with no way to see where they clustered.

How

Internal audit and contractor sources integrated into one governed star-schema model handling three refresh cadences via SharePoint. Governed datasets published in Power BI Service with metadata documentation and ongoing support.

Why it matters beyond waste. Regulators and public programs don't want more numbers; they want to know where to look first. Moving a program from volume to concentration is the shift risk-based regulation depends on, and it's the approach we bring to any compliance or audit brief.

What they can do now

Direct limited inspection effort to where non-compliance actually concentrates, instead of reporting how much exists city-wide. Drill from the whole CBD to a single laneway or hub. Monthly program reporting runs itself, returning more than twenty hours a month that used to go into manual assembly.

Power BI DAX Star schema SharePoint Automated refresh Governed datasets

Public data and community outcomes: from crisis response to what happened next

United States · September to October 2025 · Strategy-facing
Public data · Analysis

What it replaced

Three public datasets in three shapes, with no way to follow a crisis response through to its outcome and no shared picture anyone could plan from.

How

Started with process mapping in Miro to agree the questions the report had to answer and how a response flows through the system. Planned the integration around those questions, then used Python to pull, clean and join the 911 dispatch, health service and community resource datasets into one star-schema model built for relationship analysis. Built an executive view that answers each agreed question directly, so the report reads as a set of decisions rather than a set of charts.

What they can do now

See whether mental-health crisis interventions changed outcomes, not just how many happened. Compare response times and results by district. Put an evidence-based community-benefit picture in front of the people deciding where the next dollar of intervention funding goes: which programs are working, where the gaps are, and where to invest next.

Python Power BI DAX Star schema Miro Multi-source integration

Board reporting from five days to three hours

Fast-growing SaaS company
SaaS · Finance

What it replaced

Five days of manual consolidation every month, producing numbers that were stale before anyone read them.

How

Power BI automation and DAX optimisation over the existing finance sources, with a model built around the metrics the board actually asks for.

What they can do now

The board sees cash position while there's still time to act on it. Month-end board reporting takes three hours instead of five days and describes the month that's happening, not the one that's over.

Power BI DAX optimisation Financial modelling

Accounting system to Fabric: automated finance pipeline

SME and SaaS clients
Finance · Productised

What it replaced

Manual exports, scattered spreadsheets, no visibility of overdue invoices, and monthly reports assembled from figures already out of date.

How

Accounting API into Fabric with daily unattended refresh and OAuth token management, landing to Delta Lake tables and surfacing in Power BI. Receivables and payables ageing, budget tracking, forecasting and scenario analysis.

What they can do now

Answer the questions owners actually ask, every morning, without exporting anything: how much are we owed, who owes the most, what's overdue, are we cash positive, how are we tracking to budget.

Microsoft Fabric Delta Lake Xero API OAuth 2.0 Python Power BI

When a workbook is the right answer

Not every problem needs a platform. Some need one workbook that finally behaves, built with the same discipline: validation, error handling, a design the client can maintain.

Construction job costingMargin tracked at job level against QuickBooks Online, not only at company level.
Payroll and reporting automationExcel VBA and Power Query. More than ten hours a week of manual effort removed, entry errors caught at source.
Compliance review automationA manual review process turned into a structured document workflow. Repeat engagement.
Retail KPI dashboardReporting for a multi-store operation that had been assembled by hand, now automated. Fixed scope.
Accounting automation in Google SheetsManual entry and reconciliation steps automated for a client who needed to stay in Sheets.
Investment portfolio modelGrowth projection and scenario comparison, built alongside the accounting pipeline work.

How we work: engineering discipline for BI

This is the part a client's IT team reads to decide whether we're safe to let into their tenant.

Version control and CI/CD

Reports live in the pbip project format under Git, so every change is tracked, reviewable and reversible. Pipelines and reports deploy through Azure DevOps or GitHub across dev, test and production.

Lineage and governance

Microsoft Purview for lineage and classification, so anyone can trace a number on a dashboard back to the file or system it came from, and see who can access what.

Tested before it's near your data

New platform features are built and tested on our own accounts first. An end-to-end API pipeline in Fabric runs unattended daily with error handling. We publish what we find.

Read the field notes

What clients say

Rated 5.0 across independent client reviews.

"Zohal has been a reliable resource for us, always very pleasant to deal with, clear in her communications, and extremely precise with her analysis of client data. Critically, when our requirements changed, she was able to adapt quickly to ensure there were no gaps in service or unfulfilled expectations. I recommend her extremely highly."

Waste Audit and Consultancy Services
Peter HoskingWaste Audit and Consultancy Services, City of Melbourne laneway audit program

"Phenomenal work. Seamless execution."

Business ownerAccounting automation

"Ultra fast, professional, and identified my needs without much explanation. A real pleasure to collaborate with."

Operations leadSupplier price analysis system

"Excellent work, with professionalism and great responsiveness. Turnaround time is very good and the quality is exactly as requested."

Supply chain managerSupply chain reporting dashboard

Recognise your own reporting in any of these?

Book a free 30-minute call. Tell us which systems you run and how reporting gets produced now, and we'll give you a clear read on what's causing the gap and what closing it would involve.

Book a fit call30 minutes. Reply within two business days