- data governance
- Advanced Analytics
- Azure
- Big Data
- Business Intelligence
- Data Analytics
- Data Lake
- Data Warehouse
- Databricks
- DAX
- DWH Automation
- Information Design
- Internet of Things (IoT)
- Künstliche Intelligenz
- Power BI
- Process Mining
- Reporting
- SAP
- Self-Service BI
- SQL Server
- Agiles Projektmanagement
- Azure Synapse Analytics
- Cloud
- Dashboard
- Data Driven Company
- Data Science
- Datenintegration
- Datenmanagement
- Datenqualität
- Digitalisierung
- Echtzeitanalyse
- Machine Learning
- Robotic Process Automation (RPA)
- Modern Data Warehouse
- (Near-)Realtime
- Data Analytics Platform
- Power Platform
- Data Mesh
- Data Sustainability
- Datenstrategie
23.12.2016 Lukas Lötters
Use Regular Expressions in Power BI
Hello All, in this blog post I’ll show you how you can use regular expressions in Power BI by using the R transformation steps. Power BI itself is not capable to filter …
14.12.2016 Lukas Lötters
Show Top N and Rest in Power BI
Hello Everybody, today I would like to show you how you can create a dynamic Top N selection in Power BI which shows you the rest of the data (the data that is not in the …
08.11.2016 Lukas Lötters
How to use Power BI as data source in SSIS
Power BI is a fascinating tool. Built for self service BI in the last year it has grown to a full BI and analytical platform. The huge wave of new features and updates …
17.10.2016 Alexander Förster
Bewegliche Feiertage berechnen
Beim Aufbau eines Data Warehouse gehören Datumsdimensionen zum Standard. Im Regelfall sollen hierbei auch die Feiertage mit einfließen – eine einfache Anforderung, so …
07.09.2016 René Schwarz
Parallel execution of SSIS Packages
In BI Projects, sooner or later you will face the challenge to load and process vast amounts of data via SSIS packages, which would usually require numerous days or even …
04.07.2016 Jörn Ebbers
Data Vault Satellite Loads explained
With this blog post i want to continue the series on explaining Data Vault Loads. Today i want to describe the load pattern for Data Vault Satellite. In a Data Vault model …
28.06.2016 Thomas Rahier
Check table usage in SSIS packages with Powershell
In BI projects you sometimes want to rename a database table or move a database table to a different database schema. There are several reasons why you might want to do …
18.05.2016 Lukas Lötters
Monte Carlo Simulation with DAX and Power Query
In this blog post I show you how to do a simple Monte Carlo Simulation by using DAX or Power Query. I will compare both approaches and evalute the pros and cons. Last month …
10.02.2016 Lukas Lötters
How to create relative week column in Power BI?
Time Intelligence is often a major topic of many BI implementations. Also in small self-service projects like Power BI one requirement is often to compare the devolpment of …