- 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
03.05.2014 Hilmar Buchta
Practical Clustered Columnstore Index on Parallel Data Warehouse (part 1)
…
09.02.2014 Hilmar Buchta
Removing duplicate rows in large tables
Removing duplicate rows in large tables can be a challenging operation. As long as the table does not contain too many rows, several approaches will lead to the desired …
06.10.2013 Hilmar Buchta
Power Query: How to unpivot a dynamic number of columns
A powerful function in Power Query is to unpivot a given data set which means to rotate data in columns to rows. This is useful for a lot of statistical data sets that you …
03.08.2013 Hilmar Buchta
A duplicate attribute key has been found during processing (revisited)
This post is about a common error message during dimension processing I’ve been asked about quite a few times so I thought it would be worth posting about it. The error …