Work

Projects I've built

Each one started as a manual process or an unanswered question. Documented in detail.

Power BI dashboard ranking Riga apartment listings by budget, commute time, and room match score

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.
Power BI Meta Ads dashboard showing campaign performance and unified score

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.
Power BI dashboard showing hourly electricity prices and a 10-day weather forecast with savings recommendations

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.
Payroll Forecast vs. Actuals System

Payroll Forecast vs. Actuals System

2024

Monthly reporting that used to take half a day. Now it takes 45 minutes.

Power QueryExcelSharePointAutomation
50% reduction in monthly reporting prep time at Accenture.
Cloud Infrastructure Volumetric Tracker

Cloud Infrastructure Volumetric Tracker

2024

Quarterly infrastructure review cut from a full day to under an hour.

Power QueryExcelSharePointAutomation
80% workload reduction in quarterly cloud infrastructure reporting.
HR Consultant Matching Tool

HR Consultant Matching Tool

2023

Matching available consultants to open internal roles, automated.

Power QueryExcelFuzzy MatchingHR Analytics
Automated bench-to-role matching used by HR leadership.