Untitled

Kimball Methodology for Data Warehouse Design

Implementing small and medium data

Allows warehouses to be built in a staggered manner

Tasks of this methodology

Planning

In this process it is determined

The purpose of the DW/BI project

Your specific objectives

The scope

The main risks

Initial approach to information needs

Requirements analysis

The definition of requirements

Process of interviewing business and technical staff

It is advisable to have prior preparation

Dimensional Modeling

Dynamic and highly iterative process

Steps

Choose the business process

Establish the level of granularity

Choose the dimensions

Identify measures and factual tables

Choose the area to model

Management decision

Depends on requirements analysis

Business requirements

From current data

Team discussions

Dimension tables

Attribute set

Identify measures that arise from business processes

Physical Design

Answer questions

How can you determine how large the DW/BI system will be?

Design of the Extraction, Transformation and Loading (ETL) system

Powers the Datawarehouse

Specifying and Developing BI Applications

Include a broad spectrum of report types and analysis tools

Standard Reports

Analytical applications

Victoria Martinez Del Valle