- 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.12.2020 Christoph Epping
Continuous Deployment: So vermeiden Sie Datenverluste
„Continuous Deployment“ hat in den vergangenen Jahren die Entwicklung von Anwendungen und Datenbanken massiv beschleunigt. Änderungen werden laufend nach festen …
15.04.2020 Lukas Lötters
KI in der Energiebranche: Wie Sie mehr Kunden mit maßgeschneiderten Angeboten gewinnen
Die „Individuelle Kundenansprache“ hat sich zum geflügelten Wort für Unternehmen entwickelt. Gleichzeitig handelt es sich um eine der größten Herausforderungen. …
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 …
11.01.2016 Hilmar Buchta
Fill down table in T-SQL (last-non-empty value)
A common task in data processing is to fill null values in a table with the latest existing value. For example, look at the following inventory table …
09.05.2015 André Kienitz
How to delete an unnamed default constraint in an sql server table
A default constraint in a table defines a value for a column where no value is specified. You can name a default constraint as in the example given: create table …
29.04.2015 Ralf Glöckner
Analyzing Flat File data with Regular Expressions
In this article I want to talk about some basic usage of regular expressions when searching for erroneous data in structured text files, like csv. This comes in handy if …
13.04.2015 Hilmar Buchta
Importing data from SAP using the SAP BW Delta Queue and Theobald Software Xtract IS
Importing data from SAP is a common task in many BI projects. Since Integration Services (SSIS) doesn’t have out of the box support for dealing with SAP as a data source, …
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 …