- 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
10.02.2016 Lukas Lötters
How to create relative week column in Power BI?
Time Intelligence is often a major topic of many BI implementations. Also in small self-service projects like Power BI one requirement is often to compare the devolpment of …
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 (). …
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 …
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 …
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 …
12.03.2014 Jan Köhler
Improved Waterfall Chart with SSRS
Some time ago, I have received the task to develop a Waterfall Chart with Microsoft’s Reporting Services. The requirements were very specific and required much more than …
19.01.2014 Hilmar Buchta
T-SQL 2012 Window Functions in ELT (part 3) – calculating price elasticity
…
06.10.2013 Hilmar Buchta
Power Query: How to unpivot a dynamic number of columns
A powerful function in Power Query is to unpivot a given data set which means to rotate data in columns to rows. This is useful for a lot of statistical data sets that you …