DW - Meta- & Master Data Mgt

In this Insight, we will take a closer look at how to place and use Power BI in the Power Platform. We will briefly highlight each component separately after which we will discuss some examples of integrations.

SAP BW/4HANA, the Next Generation real-time data warehouse was launched in September 2016. This article gives an overview of the solution, the key benefits and the migration paths to BW/4HANA, as opposed to the previous SAP BW releases. It will also demonstrate that Data Structures, Data Integration and User Interface are significantly simplified. The article will also elaborate on the SAP BW/4HANA High Performance capabilities.

Window functions are a special construct in the SQL language that allow you to easily calculate more complex requirements, such as year-to-date calculations, moving averages, percentiles and so on.

One of the best books around on dimensional modelling. Adamson takes you onto a tour around the different types of dimensions and fact tables and clearly explains how to design them and how to construct your ETL. At least as good as the Kimball books.