- 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
28.07.2013 Hilmar Buchta
Round function in MDX
In most cases you will want to perform a round-operation of your MDX query results by applying a format string. Alternatively, you may want to use client functionality (for …
28.04.2013 Hilmar Buchta
Distributed or replicated table? And what is important when choosing the distribution key?
…
02.03.2013 Hilmar Buchta
DAX vs. MDX: An example
I’m often asked about the key differences between DAX and MDX or in more general, the difference between the tabular and the multidimensional model. From my presentation …
27.12.2012 Hilmar Buchta
7 reasons why you should prefer SCD 1 over SCD 2+
When it comes to dimension design a common question is about dealing with attributes that are changing over time. A frequently used pattern for such attributes was …
05.08.2012 Hilmar Buchta
Semi Additive Measures in SQL Server Standard Edition
A few years ago, Alex Whittles wrote a very detailed explanation about semi additive measures in a SQL Server Standard Edition. For my post today I’m concentrating on …