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 #81 Fact Table Surrogate Key

Meaningless integer keys, otherwise known as surrogate keys, are commonly used as primary keys for dimension tables in data warehouse designs. Our students frequently ask...

Design Tip #168 What’s in a Name?

It seems like a small thing, but names are important. Good names for tables and columns are particularly important for ad hoc users of...

Fistful of Flaws

People often engage us to conduct dimensional model design reviews. In this column, I’ll provide a laundry list of common design flaws to scout...

Design Tip #174 Does Your Organization Need an Analytic Sandbox?

Countless organizations have created mature dimensional data warehouses that are considered tremendous successes within their organizations. These data warehouse environments support key reporting and...

Design Tip #80 Adding a Row Change Reason Attribute

We are firm believers in the principle that business requirements drive the data model. Occasionally, we’ll work with an organization that needs to analyze Type...

Restons connectés

13,802FansJ'aime
212SuiveursSuivre