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 #164 Have You Built Your Audit Dimension Yet?

One of the most effective tools for managing data quality and data governance, as well as giving business users confidence in the data warehouse...

Data Warehouse Dining Experience

I worked at a company called Metaphor back in the early 1980s. As part of a startup software company introducing then-cutting-edge concepts (such as folders,...

Design Tip #128 Selecting Default Values for Nulls

Design Tip #43 Dealing with Nulls in the Dimensional Model describes two cases where null values should be avoided in a dimensional model; in...

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 #166 Potential Bridge (Table) Detours

Dimensional designs often need to accommodate multivalued dimensions. Patients can have multiple diagnoses. Students can have multiple majors. Consumers can have multiple hobbies or...

Restons connectés

13,799FansJ'aime
212SuiveursSuivre