All projects

Data projects

NordHome Retail Analytics: cover with the Executive Overview and Sales & Product Performance dashboards

01 — From raw data to BI NordHome Retail Analytics

Data warehouse built on Kimball, ETL in PostgreSQL and a Power BI report for the H1 2024 review.

PostgreSQLSQLPythonPower BI

AlpenTech Controlling: Power BI finance reporting cover with the Management Cockpit

02 — From data to business decisions AlpenTech Controlling – Power BI Finance Reporting

Five-page controlling report: plan-vs-actual forecast, cash flow and scenario analysis for a fictional industrial B2B manufacturer.

Power BIDAXPower Query

Cloud Data Platform on Azure: batch pipeline from WooCommerce and GA4 through Azure Functions, Data Lake, Data Factory and Azure SQL to Power BI

03 — From business systems to analytics Cloud Data Platform on Azure

Batch pipeline: WooCommerce & GA4 pulled via API into the cloud, transformed in Azure SQL, Power BI as the endpoint.

Azure SQLAPIPower BIIn progress

Retail Sales Data Modeling: a star schema next to a Data Vault model for e-commerce sales analysis

Data modeling · Market-basket analysis Star Schema vs. Data Vault 2.0

Comparing both modeling approaches on a market-basket analysis built from receipt data.

Star SchemaData Vault 2.0Kimball

Other projects

Real-world business experience Luandla – Online Shop

Co-founded and built a fully functional online shop from the ground up — from business strategy and e-commerce operations to SEO, marketing and analytics. Home fragrance, kitchen & table and living décor.

E-commerceSEODigital marketingAnalytics

Knowledge system · Notion The Data Thinking Project

A personal knowledge system in Notion for five years of learning: applying, reflecting, connecting, teaching.

NotionIn progress