1.1 Définition du projet

La définition du projet BI est la première étape et la plus cruciale de la gestion de projet BI. Elle permet d'évaluer l'aptitude et...

1.2 Planification et gestion du projet/Programme BI

La planification de projet BI permet avant tout de donner une identité au projet BI, un nom qui sera vehiculé dans toute l'entreprise. On...

1.3 Définition des besoins BI

Il est essentiel de bien comprendre les utilisateurs et leurs besoins, sinon l’entrepôt deviendra rapidement un exercice vain de la part de l’équipe des...

Livres BI

Kimball design Tips

Design Tip #176 Dimensional Models – Logical or Physical?

Dimensional data models have been around for a very long time, almost certainly tracing their lineage back to the original Data Cube project between...

Design Tip #107 Using the SQL MERGE Statement for Slowly Changing...

Most ETL tools provide some functionality for handling slowly changing dimensions. Every so often, when the tool isn’t performing as needed, the ETL developer will...

Design Tip #167 Complementary Fact Table Types

There are three fundamental types of fact tables in the data warehouse presentation area: transaction fact tables, periodic snapshot fact tables, and accumulating snapshot...

Design Tip #120 Design Review Dos and Don’ts

Over the years, we’ve described common dimensional modeling mistakes, such as our October ’03 “Fistful of Flaws” article in Intelligent Enterprise magazine. And we’ve...

Design Tip #173 Risky Project Resources are Risky Business

Over the years, we’ve worked with countless exemplary DW/BI project team members: smart, skilled, dedicated, and motivated, coupled with a healthy dose of mutual...

Restons connectés

13,545FansJ'aime
213SuiveursSuivre