Available · Riga, Latvia

Power BI dashboards & reporting automation that replace manual data work.

I'm a data analyst building Power BI dashboards and data analytics systems that hand your team answers instead of raw numbers, so nobody has to live in spreadsheets.

Eriks Skeranskis
Eriks · Riga, LV
  • Fixed quote, no surprisesScoped price agreed before work starts.
  • Reply within a dayYou talk to the person building it.
  • You own everythingFiles, model and docs are yours to keep.
  • Fits your current setupPower BI, Excel, SharePoint, SQL.

Selected work

Things I've built recently

All projects →
Riga Rental Intelligence Dashboard

Riga Rental Intelligence Dashboard

May 2025

End-to-end apartment ranking: from web scraping to weighted Power BI scores.

Power BIMake.comApifyGoogle Maps APIDAXPower Query
✦ End-to-end working prototype. Every component built from scratch.
Meta Ads Dashboard

Meta Ads Dashboard

2025

One score to cut through the noise: which campaigns to trust, which to question.

Power BIMeta AdsDAXMarketing Analytics
✦ Full Meta Ads KPI overview with a normalised performance score for fair campaign comparison.
Weather & Electricity Price Dashboard

Weather & Electricity Price Dashboard

August 2025

"Run your washing machine from 2–4 PM and save 22%." A dashboard that tells you exactly that.

Power BIDAXENTSO-E APIWeather API
✦ Live data integration turning raw hourly price feeds into plain household decisions.

What I can build for you

Services

Every engagement starts with a free intro call, then a fixed quote scoped to the work. No surprises.

● 1 project spot open this month

Reporting Automation

Power Query pipelines and Excel automation that retire the manual copy-paste reporting eating your team's time.

✓Power Query / SharePoint pipelines
✓Scheduled, self-refreshing reports
✓Forecast vs. actuals tracking
Get startedFree call
Most requested

Power BI Dashboard Development

Custom data models, DAX measures and interactive reports built around the decisions you actually need to make.

✓Data modelling & relationships
✓Custom DAX measures
✓Interactive, drill-down reports
Get startedFree call

How it works

From first call to a report that runs itself

Four steps, and you know the price before any work starts.

  1. Free intro call

    30 minutes on the reports you have today and the decisions you need them to support.

  2. Fixed quote

    A written scope, timeline and fixed price. No hourly meter running in the background.

  3. Build with check-ins

    Regular progress you can click through yourself, not a big reveal at the end.

  4. Handover

    Documentation and a walkthrough, so your team can run and extend it without me.

The short version

I don't build flashy dashboards. I build ones that replace a manual process.

Book a free intro call →

About

Eriks Skeranskis

Riga, Latvia
Data analyst
@ Claviz

I'm a data analyst and reporting-automation specialist. I spent 3+ years at Accenture Baltics building Power Query pipelines, Excel automation, and financial reporting tools for large enterprise clients.

Today I work at Claviz on advanced Power BI for enterprise clients. Complex data models, custom DAX measures, and multi-report migrations.

Full background & experience →

Skills

Power BIAdvancedPower QueryAdvancedDAXAdvancedExcel / VBAAdvancedMake.com / AutomationIntermediateAPIs & webhooksIntermediateSQLBeginner

Have a project in mind?

Let's get your reporting off spreadsheets.

Tick what fits and I'll come back with first thoughts and a time for a free 30-minute call.

Eriks Skeranskis

Eriks Skeranskis

You'll talk to me, not an account manager.

eriks.rudolfs@gmail.com
What do you need?
Where does your data live?
Timeline

Protected by Web3Forms · no spam, ever.