- data governance
- 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
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 …
16.12.2015 René Schwarz
How to simply display totals of stacked columns in SSRS
A SSRS approach to display stacked column totals without additional coding. Lately I have often been asked if and how it is possible to display the totals of stacked …
19.10.2015 Hilmar Buchta
Trend in times series analysis
Time series analysis is widely used to forecast logistics, production or other business processes. Usually you want to understand if there is a trend or a seasonality in …
26.09.2015 Lukas Lötters
Vergabe von Rängen in Power BI mithilfe von DAX Pt. 1
Im Juli hat Microsoft ein komplett neues, von ursprünglichen Excel-Addins unabhängiges, Power BI Produkt auf den Markt gebracht. Wir haben darüber bereits berichtet (). …
25.06.2015 Hilmar Buchta
Importing OpenStreetMap data or other large XML files with Integration Services (SSIS)
…
22.06.2015 Dirk Grote
SAP ERP as data source for Microsoft BI (Part 5)
Visual AdHoc Analysis with Microsoft Power BI on SAP Suppose you want to analyze your SAP data flexible and without having to load it into your Data Warehouse. Maybe you …
15.05.2015 Hilmar Buchta
Incremental data loads in Microsoft Power Query for Excel
Power Query is a great and flexible tool for getting and transforming data from different sources into Excel or Power Pivot. The standard procedure for Power Query is to …
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.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 …