element61 hosts trainings for your teams in Business Analytics
DW - Data Warehousing & Modeling
The goal of the project was to replace the existing data warehouse with a more future proof, reliable and state of the art enterprise data warehouse built upon the latest SOL Server technologies.
Ardo decided to embark mid-2016 to implement a comprehensive Business Intelligence program.
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.
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.
This book is a very detailed introduction to DAX, the powerful language behind Power Pivot and Power BI. Due to it's clear writing style, the book is an excellent starting point for beginners. However, even DAX pros will get value out of this book.