About This Project
The Idea
I am Salih Ugur Kimilli, a data engineer who loves turning raw data into insights. I wanted to build a real end-to-end data engineering project using only free, open-source tools — no vendor lock-in, no cloud bills. Around the same time, I had recently moved to Denmark and realised I knew very little about Danish football.
The two things clicked together: why not build an analytics product for Superligaen, the Danish Premier Football League? Something I could actually use myself, and that anyone curious about Danish football could benefit from too.
That's how this project was born.
What Was Built
A fully automated data pipeline that:
- Ingests live match data from Sportmonks into a MotherDuck cloud data warehouse
- Transforms raw JSON through Bronze → Silver → Gold layers using dbt
- Serves analytics via this Evidence.dev dashboard, deployed on Vercel
- Runs nightly via GitHub Actions
Source Code
Everything — the ingestion scripts, dbt models, and this Evidence dashboard — is open source.
Get the Data
Prefer SQL over dashboards? The full gold layer behind this site — all leagues, refreshed nightly — is available as a free read-only MotherDuck share you can query straight from DuckDB. You'll need a free MotherDuck account; request access below and I'll grant it to your account.
The Full Journey
The complete story — every decision, every mistake, every fix — is documented in the blog:
Support This Project
This dashboard is free to use and updated every day. If you find it useful, consider buying me a coffee.
Share an Idea
Have a suggestion for the dashboard? Open an issue on GitHub — no account needed beyond a free sign-up.
Part of Krogvad Analytics Hub
This dashboard is one of several data products under the Krogvad Analytics Hub.
Connect
Happy to chat about the project, data behind it, or the design choices along the way. Let's connect!