- 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
17.03.2015 Daniel Piatkowski
Data Vault – Link Loads explained – Part One
The Data Vault Model is known for its flexibility and its ability to scale out. One of the reasons which makes the model so scalable is the way relationships are realized. …
17.02.2015 Hilmar Buchta
Querying Hadoop from SQL Server
Microsoft’s Analytics Platform System (APS) offers built in transparent access to Hadoop data sources through the Polybase technology. This includes bidirectional access …
03.02.2015 Hilmar Buchta
Geo spatial data support for Hive
Apache Hive doesn’t have support for geo spatial functions out of the box. However, it’s easy to extend the functionality by using external libraries, that can be …
17.11.2014 Hilmar Buchta
Combining multiple tables with valid from/to date ranges into a single dimension
Tracking historical changes within a dimension is a common task in data warehousing and well covered by Ralph Kimball’s slowly changing dimension (SCD) methods. In short, …
10.08.2014 Hilmar Buchta
The ‚KeyColumns‘ #0 has NullProcessing set to ‚UnknownMember‘, but the dimension doesn’t have UnknownMember set to ‚Visible‘ or ‚Hidden‘
By default, SSAS provides an automatically created member with the name ‘unknown’ for each dimension. This member is intended to be the home for all facts that don’t …
13.05.2014 André Kienitz
Using Group By and Row Number in SQL statements
In this article I want to show some features about the Group By clause and the Row Number window function that you can use in SQL statements. …
11.05.2014 Hilmar Buchta
Practical Clustered Columnstore Index on Parallel Data Warehouse (part 2)
…