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.
DW - Data Warehousing & Modeling
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.
The BI program at Isabel consist of a number of main project iterations. The first two increments concerned mainly the actual platform usage & the expected product usage by customers, next to delivering a detailed insight on the customers of Isabel in terms of various segmentations based on a complexity of business rules within a challenging context. For obvious reasons the BI program and corresponding roadmap is reviewed and thereby re-defined on a frequent basis. Other important information domains and projects delivered are: product integration, a corporate objectives dashboard, an integrated churn & value based model, service calls, various Zoomit related domains and several divisional dashboards. At the same time a BICC was defined and set up.
element61 has been involved -following a BA roadmap- in assisting iMinds with building a data warehouse (based on timeXtender/SQL Server 2012) -and delivering associated Performance Dashboards- that brings together the different business domains including CRM, Finance, Project Monitoring, Human Resources and Publications.