Lorenzo Reale

Power BI Developer · Remote-first · EU and UK

Power BI developer for operational data that has to be right.

Independent Power BI developer for operational and enterprise data. Remote-first delivery across the EU and UK.

  • Power BI
  • DAX
  • Power Query
  • T-SQL
  • Azure SQL
Lorenzo Reale, Power BI developer

About

An engineer's approach to data.

I'm Lorenzo Reale, a Power BI developer with an engineer's approach to data. I trained as an aerospace engineer at the Politecnico di Milano, then spent six years in London moving into enterprise data and analytics, building reporting that operational teams and leadership could rely on.

Approach

Good reporting starts long before the dashboard.

Most reporting problems aren't reporting problems. When operational numbers don't reconcile, the cause is usually upstream, in how the data was captured, modelled and moved, long before it ever reached Power BI.

I work with operational data, where the KPIs and the figures leadership acts on have to be defensible, not just presentable. I've built reporting in demanding, high-stakes environments, so I start at the data layer, not the chart.

That means semantic models that hold their logic, DAX you can audit, and a SQL foundation that won't quietly drift. Building the dashboard is the easy part, and the last.

Services

Three layers, one dependable reporting stack.

From the SQL foundation to the dashboard and the automation around it. Taken on as one coherent piece of work, or wherever you need a gap closed.

01

Power BI, end to end

Semantic models, DAX and Power Query built to hold up in production, then deployed and governed so they stay that way.

Power BI DAX Power Query Governance
Learn more
02

Data layer engineering

The foundation under the report. T-SQL, query optimisation and clean warehouse integration, so the numbers are right before they reach the model.

T-SQL SQL Server Azure SQL Modelling
Learn more
03

Power Platform automation

Removing the manual steps around reporting. Power Automate, SharePoint and Office Scripts that turn fragile spreadsheet routines into dependable workflows.

Power Automate SharePoint Office Scripts
Learn more

Case studies

Three projects, built end to end.

Demonstration projects on synthetic data for fictional clients: complete working Power BI reports, with the full models, DAX and data generators on GitHub.

Executive overview page of the Site Inspection Performance report

Operations leadership

Site Inspection Performance

Compliance across a 42-site estate: are we inspecting enough, and is compliance where it should be?

Month-end scorecard page of the Month-End Management Pack report

Finance and leadership

Month-End Management Pack

A finance close that explains itself: budget to actual, the variance bridge, and a drillable P&L.

Morning check page of the Data Reconciliation Monitor report

Data and engineering teams

Data Reconciliation Monitor

The data team's morning check: did last night's loads land, and does the warehouse match the source?

Certifications

Verified credentials.

  • BCS Data Analytics Accelerator

    BCS, The Chartered Institute for IT

  • Google Advanced Data Analytics

    Google

  • Google Data Analytics

    Google

  • Managing Management Systems

    CQI, The Chartered Quality Institute

Get in touch

Have a reporting problem worth getting right?

If you're delivering Power BI in a regulated or operational environment, and the numbers have to stand up to scrutiny, I'd like to hear about it.

Discuss a project