- 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
12.03.2014 Jan Köhler
Improved Waterfall Chart with SSRS
Some time ago, I have received the task to develop a Waterfall Chart with Microsoft’s Reporting Services. The requirements were very specific and required much more than …
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 …
28.01.2014 Jens Heidrich
Implementierung einer phonetischen Suche nach dem Kölner Algorithmus
Ein regelmäßig auftretendes Problem in großen Datenmengen ist es, mögliche redundante Daten aufzuspüren und zu eliminieren. Man denke hier z.B. an Dubletten im …
19.01.2014 Hilmar Buchta
T-SQL 2012 Window Functions in ELT (part 3) – calculating price elasticity
…
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 …