ErykaDataPro

Power BI & Excel · Polish and English

I translate numbers into visual language.

Power BI dashboards and Excel reporting for businesses drowning in spreadsheets, because life's too short for messy data.

Power BI Excel Power Query SQL Data cleaning
Prime Estate · Sales & Revenue
Sales and revenue dashboard built in Power BI

A real dashboard, built on a public dataset.

What changes

Stop rebuilding the same report every month.

Today

Three days of copy and paste.

Figures pulled from several places, pasted into a template and checked twice. By the time anyone reads it, the numbers have moved on.

After

One screen, refreshed on its own.

The same numbers, cleaned once and connected properly, answering the questions your team actually asks.

What I do

Four things, done properly.

Reports that build themselves

The monthly report that takes you three days, running in minutes instead.

Power Query · Excel · Automated refresh

Interactive dashboards that speak for themselves

One screen with answers to the questions keeping you up at night.

Power BI

Data you can trust

Getting your data ready for the decisions that matter. Cleaning, transforming and consolidating information from scattered sources.

Excel · Power Query · SQL

Every change documented

You get a full cleaning report alongside your data: what I found, what I corrected, what I flagged for your decision. If I don't know something, I ask. I never delete without your approval.

Included as standard

See one for yourself

A full cleaning report, start to finish: every issue found, every correction made, everything flagged back for the client to decide, and the validation rules that stop the same mess returning next month.

Open the sample (PDF)

Selected analysis

What the numbers turned out to be saying.

23%of kilometres earning nothing

Is your fleet costing more than it earns?

A logistics fleet covering a million kilometres a year, with 23% of them earning nothing. The fix was route planning, not more vehicles.

Watch the dashboard
Logistics Fleet · Fleet & Cost
Logistics fleet cost dashboard built in Power BI

74%OEE against a world-class 85%

Is the factory performing at its best?

74% OEE against a world-class 85%. The machines were running fine; 638 hours of downtime said the problem was elsewhere.

Watch the dashboard
Factory Floor · OEE & Machine Performance
OEE and machine performance dashboard built in Power BI

$37Mover budget, across all six categories

Profitable everywhere. Over budget everywhere.

$4.62bn in revenue across five regions, and not one cost category inside its budget. A profitable business with no cost discipline.

Watch the dashboard
Prime Estate · Finance
Construction finance dashboard built in Power BI

The method transfers to any industry. If your data doesn't look like the examples above, tell me about it.

How it works

Five steps, and you see it early.

1

We talk.

Not about tools. About what decision you're trying to make, and which question keeps coming back without a good answer.

2

I look at your data.

Whatever state it's in. I'll tell you what's there, what's missing, and whether it can answer the question you asked.

3

I clean it, and I write down what I did.

Every correction, every oddity flagged back to you. Nothing is deleted without your say-so.

4

You see a draft early.

Before it's finished, while it's still easy to change. Most of the good decisions happen here.

5

You get the finished thing, and you know how it works.

The dashboard, the cleaning report, and a walk through how to refresh it yourself.

Before you write

Questions people ask.

Does my data need to be tidy before I send it?

No. That's my job. Messy is normal, and the mess usually tells me something useful.

Do I need to buy Power BI licences?

Not necessarily. I can build in Power BI Desktop, which is free, and hand you the file. Anyone with Desktop installed on Windows can open it. You'd only need paid licences for a dashboard in a browser, on phones, refreshing on its own, or shared round a team. I'll tell you which you need before we start, not after.

How long does it take?

Usually one to two weeks from the point your data reaches me, depending on how many sources and how many pages. I'll give you a date before we start.

What do I actually get at the end?

The dashboard itself, the cleaning report showing every change I made, and a short walkthrough so your team can use it without me.

Where are you based?

It doesn't matter, and that's the point. I work in Polish and English, remotely. A Polish business in Chicago gets exactly the same as one down the road.

About

It started on a rubbish heap.

Get in touch

Tell me what you need your data to show you.

A short description is enough to start. I'll come back with what I think is going on and what it would take to fix.

I read everything myself and reply within 24 to 48 hours.