BI & Big Data Blog

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 …

26.01.2015 Hilmar Buchta

T-SQL Last Non Empty