Power BI · Automation · Windows software · Microsoft Excel
Creating time and making money for busy people and businesses.
By the numbers
I still build the best spreadsheet in the room. But most of what clients now ask for outgrew a workbook years ago: dashboards that refresh themselves overnight, pipelines that pull from ten vendor clouds without anyone touching a file, and desktop applications that a lab technician opens every morning.
Same person, same obsession with getting the numbers right. Bigger machinery behind it.
What I build
Semantic models built properly: star schema, DAX that survives contact with real data, row-level security, and refresh that does not break at 6am. Report design that answers the question on page one instead of burying it on page nine.
The unglamorous layer that makes the dashboard possible. Vendor APIs reverse-engineered and wrapped, orchestration that retries and alerts instead of failing silently, and a warehouse the reports can actually trust.
When a dashboard is not enough and enterprise software is too much: installable Windows applications with a real database behind them, multi-user over the network, versioned releases and a backup story.
Still here, still the fastest route to value for the right problem. Quoting tools, cash-flow models, schedulers and costing engines, built to be handed over rather than to depend on me.
Selected work
Most engagements sit under NDA, so these are described by shape rather than name. Named references available on request.
Six years as the reporting arm of a global telematics provider. Driver-behaviour, event and utilisation models delivered to end clients in oil & gas, industrial gas, utilities and logistics across the Middle East, Europe and Africa, plus a multi-organisation communications-alarm dashboard and a series of controlled vehicle test programmes.
Ten inverter and battery vendor clouds, each with its own auth scheme, rate limits and undocumented quirks, normalised into one warehouse and one reporting layer. Automated month-end client reporting, generation and yield tracking, tariff arbitrage analysis, and alarm digests that flag a dead site before the client notices.
Temperature mapping, calibration and cold-chain qualification data turned into review-ready reporting for a regulated-industry service provider and its pharmaceutical clients. Sensor exports to statistical summary to signed evidence, across twenty-plus validation programmes.
A packaged Windows application replacing a fragile shared workbook: assay quality-control tracking with Levey-Jennings charting, multi-analyst access over the network, local database, versioned releases and automated backups. Later forked into a second variant for an adjacent assay group.
Thousands of informal-trader survey responses for a multinational food brand, cleaned, modelled and interrogated, then translated from a Power BI model into a board-ready presentation. The hard part was not the charting; it was establishing which population each number actually described.
Portfolio and deal-flow reporting for an investment firm, and separately a daily deal-tracking and operations dashboard for a precious-metals trader. Both cases: replace a manual month-end scramble with a model that reconciles and a report that is already correct when it opens.
Portfolio
Client dashboards mostly live behind an NDA. These do not: public data, my own questions, and a few builds cleared for showing.
Also built
Sectors
Seventy-eight engagements, weighted heavily toward regulated and asset-heavy industries where getting the number wrong has consequences.
Cold chain, calibration, laboratory QC, GxP-adjacent validation reporting and clinical logistics.
Solar PV and battery storage portfolios: generation, yield, availability, tariff arbitrage and client reporting.
Fleet telematics, driver behaviour, vendor onboarding, vehicle validation and courier operations.
Market research, route-to-market studies, supplier cost comparison and margin analysis.
Portfolio operations, maintenance tracking, utilities and metering reporting.
Investment reporting, deal tracking, cash flow and practice management tooling.
Farm operations management, punch tracking and seasonal yield reporting.
Survey analysis, membership databases and funder reporting for policy and education bodies.
Not here? The shape of the problem is usually the same. Let's talk.
How it runs
Every engagement follows the same sequence, whether it ends as a dashboard, a pipeline or an installer.
What decision are you trying to make, and what is stopping you? Free, and often the point where the brief changes shape.
I go to the actual source, whether that is the export, the API or the system, before quoting. Most scoping failures are provenance failures.
Fixed scope, working versions you see early, and one change at a time on anything already in production.
Documentation, a walkthrough, and your team trained to own it. Ongoing support is an option, not a dependency.
Enablement
The best outcome is that you stop needing me. Every build ships with a handover: how the model is structured, where the data comes from, what breaks it and how to fix it.
Where a team wants to go further, I run focused sessions on the thing they will actually maintain, not a generic course.
About
She is not wrong. I love Power BI, pipelines, spreadsheets and numbers, and using them to solve problems for businesses, freelancers, consultants, NGOs, SMEs and everyone in between.
I came to this from a laboratory. Biochemistry masters, then nine years as a pharmaceutical validation consultant in cold chain and temperature management, an industry where you do not get to be approximately right, and where every number has to be defensible to an auditor. That is still how I build.
Together we will connect the data dots to tell a story that makes complicated findings memorable, and automate enough of the execution that you get to spend your time thinking instead.
In their words
Through his one-on-one training, The Excel Unicorn helped me master Excel dashboards.Ilana
He took that info and turned it into a functional dashboard that was a work of art.Darryl
Of all the consultants I have worked with, this was by far the best and most rewarding I have ever experienced.Jerome · Chief Financial Officer
Ari is a great teacher, the best I have encountered in the last ten years.Diane
Contact
Have a burning question? Got a problem you want solved? Not quite sure how I can help you grow your business, but you're sure that things could be more effective and efficient? Let's have a conversation and take it from there.
Start a conversation →
