Data visualisation Archives | Scottish Enterprise Design blog

15 April 202417 April 2024

Go with the flow

Reading Time: 4 minutes

I’ve been working on a project lately with a small team and a similarly select group of Scottish Enterprise account managers to create a slicker way of bringing businesses into their portfolio.

It’s a bit of a pathfinder project, to figure out how we might use Microsoft Power Platform technologies to deliver new services at scale and at speed.

So we settled on this one aspect of our High Growth account managers’ service to start with: getting new clients onto their portfolio.

The solution we’ve developed involves Power Pages (client-facing) and Power Apps (backend) developments, both reading from and writing to the same database, and all of this data is ultimately available in our CRM system.

All of which is fine. But, as a Service Designer, I instinctively want to be open and transparent about the data we gather. And the Digital Service Standard kinda demands that we are.

I struggled with this for a while. I wrestled in the swamps of the Dataverse against PowerBI, and the best I could come up with was this:

Figure 1: screenshot of a Power Bi dashboard taken on 4 April 2024

(Actual people’s actual names have been scrubbed out in this screenshot because they’re actual people. But all the data is real, and right now.)

14 December 202314 December 2023

Joining the dots from intent to outcome

An intent to outcome diagram for the findbusinesssupport.gov.scot

Reading Time: 3 minutes

As a service designer, a large part of my job is making sure everyone on the project sees and understands the same picture.

We all need to have a shared understanding of:

why we’re here
what we’re trying to do
the outcomes (changes in the real world) we want to see

That sounds easy, but in reality it’s not. Everyone has their own perspective: designers, developers, content designers, architects, security people, product owners … everybody comes at the problem with their own priorities and experiences, their own preferences, language, biases and assumptions.

We can have hours of discussions and endless workshops to thrash these conflicting worldviews and languages out. Thousands of unmourned post-its may be lost in the process.

So one day, back in 2019, when I was working on the very early days of findbusinesssupport.gov.scot I decided we needed an authoritative way to describe and demonstrate our purpose.

In my experience at that time, it really helps to have a big reminder of “this is why you’re here” every time you enter the workplace. (It was ‘real’ then, it’s (mostly) virtual now.)

So I came up with this:

19 October 202320 October 2023

Operating in the open

Reading Time: < 1 minute

I’m not actively involved with the findbusinesssupport.gov.scot team any more. But it’s still a service close to my heart.

I was part of the team that designed and built it in the midst of a global pandemic. And which suddenly learned, unwarned, that we would be the primary vehicle for the Scottish Government’s response to the emergency for businesses.

We were still in Beta in March 2020, so we were just routinely publishing all the data we had about usage. But, as we – de facto, if not officially – became a production service due to necessity, we just continued to do so.

Screenshot of search and filter data from findbusinesssupport.gov.scot from Sep-Oct 2023. — Screenshot of search and filter data from findbusinesssupport.gov.scot from Sep-Oct 2023

2 August 202225 January 2024

Service landscape maps: seeing the bigger picture

Reading Time: 3 minutes

This is a service landscape map.

A service landscape map -click the link for full-size version. — Service landscape maps depict the different stages users go through when accessing a service as connected blobs, with the activities they do as circles within those blobs. It also captures who the external users are – the end users of the service and those who act in their support – the things users do to achieve their goals, the teams of people who deliver the service and are granted some power or authority within the system, and supporting organisations that also have a role to play in meeting user needs.

Services rarely, if ever, exist in a void. They exist within a context. A landscape.

Service landscape maps capture and illustrate that wider context and allow us to see the complexity at play, and to develop a better understanding of the user’s whole experience.

7 June 20229 April 2024

Measuring our carbon output

Screenshot of our website carbon calculator

Reading Time: 2 minutes

The carbon costs of “digital” are not well understood.

How many emails have you received with “Consider the environment before printing this email” in the signature?

How many have you received with “Consider the environment before hitting Reply All to 26 random people” and adding “Thanks”?

For many people, “virtual” means “not real”.

As in, almost literally, non-existent.

Terms like “cloud” don’t help.

The reality is, the internet is the biggest machine humanity has ever built. It circles the entire planet.