burningsuit

Carbon reporting for a UK university's sustainability team

A UK university's sustainability team had the method behind their carbon reporting, and the corrections it needed, spread across spreadsheets. I built one model that does the sums their way and keeps its workings. We checked it together against their own totals, and I handed it over with the steps practised and written down.

Format
Power BI consultancy
Who
A UK university's sustainability team
Length
Three months
Material
Their own carbon reporting method and totals

Where they started

The team's method, and the corrections it relied on, were spread across several spreadsheets. Each report drew on that method, so a dashboard on its own would have left the method exactly where it was.

The useful thing to build was one model that holds the method in one place, with several reports drawing on it. That's what I built.

Workings you can follow

I didn't bring a method of my own. I took the one the team already used and wrote it into the model step by step.

The model keeps its intermediate workings, so the team can see how a figure was reached as well as the total. Each year is worked out with that year's own factors (the numbers that turn spending and travel into carbon). And the model keeps the team's manual overrides, so the corrections they make by hand still count.

Checking it together

The people who know a method best are the ones who can tell when a model has it wrong, so we checked it together.

We compared the model's totals with the team's source totals. When one figure differed, I paused changes to the model while the team checked their side.

Later, during handover, the team spotted that the model was using calendar years where the university works in academic years. I fixed it before the next session.

Handing it over

Handover meant the team practising the steps themselves: refreshing the data and building reports from the model.

They also have documentation of how the model is designed, how the calculations work and what it needs each year to stay up to date.

This shows how the work ran and what I handed over. It doesn't show how the team has used the model since.

Does your reporting live in spreadsheets?

Bring reporting like this to a free 30-minute call. We'll look at what would be useful to build, and I'll tell you if it isn't something I can help with.

Book a free 30-minute call

More about Power BI consultancy