Question

The Kimball Lifecycle has a number of characteristics. One is the three concurrent Technology Tracks. Discuss the three technology tracks

Answer 1

Technical tracking is a specific data store created to answer specific questions.

1. Technical track:-

Technical architecture design The purpose here is to complete the architectural framework and overview. We do this according to business requirements, current technical environment and strategic technical direction of the organization.

Rate and select

Products that provide the skills you need

Hardware platform

ETL (Database Management System Extract) upload tool query reporting tool should be evaluated.

2. Data track -Dimensional Modeling

The overview of the schematic data is about the design of the dimensional model. Dimensional modeling is an extensive field of research that consists of methods, suggestions, and best practices. Here a detailed analysis of a single business process data is performed in the event table to identify the validity of the associated dimension and attribute and numeric events.

In dimensional modeling, two important forms of design are the asterisk and the eye.

Star charts have side tables that relate directly to dimension diagrams. The snowflake scheme is a variation of the star scheme used in data warehouses.

* Design and Development of ETL

It is the most important stage of the life cycle and to achieve it requires 70% effort. In this step, you perform source data extraction, transformation, and loading (ETL) on the target model. Raw data is extracted from the source operating system and becomes important company information.

application path.

3. BI application track :-

The goal is to provide business awareness skills to make and improve decisions.

First, identify candidate BI applications and the appropriate navigation interface to meet your needs. This gives the specification of the tool you need. Later, you compile the business metadata and tools infrastructure.