Freelancer · Canton of Bern · Switzerland

Data Analyst & Power BI Specialist from Switzerland.

I turn complex raw data into interactive dashboards and share my journey from web developer to data professional out in the open.

  • Raw data
  • SQL
  • Power Query
  • Star schema
  • Decision

Services

What I bring to the table

sql

SQL & data extraction

Troubleshooting, tuning and querying relational databases, built on three years in technical support.

dax

Power BI & DAX

Fixing broken measures, time intelligence and building robust star schemas.

etl

ETL & Power Query

Automated cleaning of messy datasets.

Portfolio

Dashboards in action

Complete

Executive Financial Dashboard

A supplier grows its revenue while losing operating profit. Three dashboard pages showing where, since when and how much — including a margin bridge and a scenario simulator.

  • Power BI
  • DAX
  • Financial reporting

Read the case study →

In progress

Project 2

Title and description will follow once the project is far enough along.

  • Power BI

In progress

Project 3

Title and description will follow once the project is far enough along.

  • SQL

Planned

Project 4

In planning.

  • Power Query

More use cases and hands-on projects to follow.

Journal

From the blog

6 min

From support ticket to dashboard

Three years in support taught me more about data analysis than any course. Here is why — and the one mistake I keep finding in broken Power BI models.

  • Journey
  • Power BI
  • DAX

See all posts

Portrait of Nils Sterchi

About

Hi, I'm Nils.

I'm a 28-year-old IT specialist from the canton of Bern, and I live for clean code and numbers that add up. My path started in web design, but my real passion is giving data a structure. Whether I'm querying SQL databases on my Linux machine or writing DAX formulas, I document what I learn in public — to give something back to others and to offer clients complete transparency.

This website was built with support from Claude — both the code and the copy. Where exactly I use AI and where the line runs is set out openly on the transparency page.

Based in
Canton of Bern
Support experience
3 years
Languages
DE / EN

Contact

Show me your data chaos.

Broken measures, queries that crawl, or an Excel export nobody understands any more? Send me a short note about it and you'll get an honest assessment back.

info@codinglobe.com