Data models & architecture
Dimensional models and data warehouse design that make analytics reliable.
- Requirements & data analysis
- Star schema, facts & dimensions
- Entity models & harmonization
From source to dashboard: data models, ETL/ELT pipelines and analytics, end to end. Solutions architect and developer for business intelligence, 20+ years in IT.
Business Intelligence Query Solutions
BIQS stands for exactly that: targeted queries that turn business data into a solid basis for decisions.
From requirements analysis through data model and data pipelines to reports and dashboards.
Dimensional models and data warehouse design that make analytics reliable.
Integration and preparation from many source systems — documented and reusable.
OLAP cubes, metrics and dashboards — up to customer insights and customer value.
Every project follows one schema: Context, Task, Result — plus the stack used.
Specialized in the Microsoft BI platform, complemented by proven ETL and OLAP tools — plus AI-assisted development.
Transact-SQL — Microsoft SQL Server's SQL dialect for querying and programming.
Procedural Language/SQL — Oracle's procedural SQL extension.
Data Analysis Expressions — formula language for Power BI, Power Pivot and SSAS Tabular.
Multidimensional Expressions — query language for multidimensional OLAP cubes.
Versatile programming language for data preparation, automation and analytics.
Automated, visual workflows that orchestrate data engineering tasks.
Web-based, interactive development environments for processing and analyzing large datasets.
Modern orchestrator for data pipelines (Python).
ETL tool (CloverDX) for data integration and transformation.
Visual platform for data analytics, ETL and data science.
M-based ETL tool in Excel and Power BI for loading and transforming data.
Lean transformation and data engineering solution for data integration.
SQL Server Integration Services — Microsoft's ETL platform.
Microsoft SQL Server (versions 2008 to 2022) — relational database management system.
Managed SQL Server database service on Microsoft Azure (PaaS).
Microsoft Fabric — integrated SaaS analytics platform (warehouse, lakehouse, Power BI).
Oracle Database — relational database management system.
SQL Server Analysis Services — OLAP / tabular models for analytics.
Microsoft's platform for interactive reports and dashboards.
SQL Server Reporting Services — pixel-perfect, paginated reporting.
Excel-based analysis and reporting tool for OLAP cubes (now FluenceXL).
In-memory data modeling with DAX in Excel.
Microsoft's cloud platform for compute, databases and analytics.
Platform for version control, CI/CD and project boards.
Version control with Git; Bitbucket for repository hosting.
Atlassian tools for task/project management (JIRA) and documentation (Confluence).
Anthropic's AI language model for complex reasoning and coding.
Anthropic's agentic AI coding tool for terminal and IDE.
Multimodal AI model family by Google DeepMind.
Agentic development platform (AI IDE) by Google, built on Gemini.

As a freelance data engineer and BI developer I build business intelligence applications across the full BI spectrum — from data pipelines to reports and dashboards.
For over 20 years I have implemented and maintained IT systems as a developer, business analyst and project lead. My focus is using IT to support the business — especially where data turns into insight for steering and optimization.
