I thought data analysis would be clean. It’s not.

When I started learning data analysis, I thought most of the work would be… data.

Cleaning it.

Analysing it.

Building something on top of it.

That’s what you see in courses.

That’s what you practise in projects.

And it makes sense.

Where that idea breaks

But the first time you try to apply that thinking to something closer to a real business situation, it quickly changes.

Because the problem doesn’t start with data.

It starts somewhere else.

A situation I keep coming back to

Let’s say someone asks for a performance report.

On paper, it sounds simple.

You define the metrics.

You pull the data.

You build the report.

Done.

But in reality, that request usually comes from something else.

Something isn’t working.Results don’t look right.Someone needs to explain it to someone else.

And suddenly the question is no longer:

“Can you build a report?”

It becomes:

“What is actually going on?”

Where the real work begins

At that point, the technical part is only one piece.

You still need to figure out:

• what the real problem is

• what context matters

• what should be included and what is just noise

• what will actually help someone make a decision

  
  

And none of that is fully defined at the start.

What surprised me

Before moving into data, I worked in roles where performance and targets mattered.

When something wasn’t working, you didn’t wait for a perfect dataset.

You tried to understand the situation and act.

Looking at analysis now, I see the same pattern.

The value is not in producing a report.

It’s in helping someone move from confusion to clarity.

So what is data analysis really about?

It’s not just about working with data.

It’s about working with situations that are:

• unclear

• incomplete

• sometimes uncomfortable

  
  

And using data as a tool to make sense of them.

Final thought

I thought data analysis would start with data.

But in most cases, it starts with a problem that is not clearly defined yet.

And that’s where the real work is.