Available for freelance · 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

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

Data Integration & Pipelines

APIs, webhooks and automated flows that pull your scattered data into one clean source feeding your reports.

API & webhook integrations
Automated data enrichment
End-to-end pipeline design
Get startedFree 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.

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

Full background & experience →

Skills

Power BIAdvancedPower QueryAdvancedDAXAdvancedExcel / VBAAdvancedMake.com / AutomationIntermediateAPIs & webhooksIntermediateSQLBeginner

Have a project in mind?

Let's get your reporting off spreadsheets.

Tell me what you're trying to measure or automate. First scoping call is free, I reply within a day.

Get in touch →eriks.rudolfs@gmail.com