- 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
19.11.2014 Thomas Rahier
Start SSIS 2012 packages from a different SSIS project, part 1
If you decide to upgrade from SSIS 2008 to SSIS 2012 you might decide to use the Project Deployment Model and deploy your SSIS packages to the SSISDB instead of using the …
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)
…
09.05.2014 Daniel Piatkowski
Data Vault – Hub Loads explained
In a Data Vault Model, Business Keys are used to integrate data. A Hub Table contains a distinct list of Business Keys for one entity. This makes the Hub Table the „Key …
03.05.2014 Hilmar Buchta
Practical Clustered Columnstore Index on Parallel Data Warehouse (part 1)
…