DW - Data Warehousing & Modeling
In Business Analytics is ervaring belangrijk. Door hun senioriteit zijn onze consultants goed geplaatst om trainings te given in verschillende technologisch & methode topics in Business Analytics.
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.