EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login
Home Data Science Data Science Tutorials Data Warehouse Tutorial Kimball Methodology
Secondary Sidebar
Data Warehouse Tutorial
  • Basic
    • What is Data Warehouse
    • Data Warehouse tools
    • Career in Data Warehousing
    • Benefits of Data Warehouse
    • Data Warehouse Architecture
    • Data Warehouse Design
    • Data Warehouse Implementation
    • Data Warehouse Features
    • Data Warehouse Modeling
    • Data Warehouse Software
    • Data Warehousing
    • Types of Data Warehouse
    • 10 Popular Data Warehouse Tools
    • Data Lake Architecture
    • Three Tier Data Warehouse Architecture
    • Data Warehouse Process
    • Database Parallelism
    • What is OLTP
    • What is OLAP
    • OLAP Tools
    • Types of OLAP
    • Operations in OLAP
    • MOLAP
    • HOLAP
    • Data Warehouse Schema
    • Data Warehouse Components
    • Snowflake Schema
    • Snowflake Architecture
    • What is Star Schema
    • Galaxy Schema
    • What is Fact Table
    • Kimball Methodology
    • Data Warehouse Testing
    • Operational Data Stores
  • ETL
    • What is Data Mart
    • What is Data Cube
    • What is a Data Lake
    • What is Data Integration
    • What is ETL
    • What is ETL Testing
    • ETL Testing Tools
    • ETL architecture
    • Dimension Table
    • Multidimensional Data Model
    • Fact Constellation Schema
    • ETL Process
  • Interview Questions
    • Data Warehouse Interview Questions
    • ETL Interview Questions
    • ETL Testing Interview Questions
    • Data Warehousing Interview Questions

Related Courses

Business Intelligence Course

All in One Data Science Course

Data Visualization Certification Courses

Kimball Methodology

By Priya PedamkarPriya Pedamkar

kimball methodology

Introduction to Kimball Methodology

Kimball Methodology is nothing but a bunch of pre-defined processes and practices used for developing, designing & maintaining a data warehouse by applying the bottom-up approach for these processing. The most recognized benefits of using the Kimball methodology are the database design, development & build can be completed faster compared to other methods, cost for implementation & maintenance is lower, takes lesser time to develop as it is a pre-planned practice, etc.

What is Kimball Methodology?

Kimball is a set of defined methods, processes and techniques that are used to design and develop a data warehouse It is also referred with different names such as bottom-up approach, Kimball’s dimensional modeling and data warehouse life cycle model by Kimball.

Before we proceed further let us understand a few terms:

All in One Data Science Bundle(360+ Courses, 50+ projects)
Python TutorialMachine LearningAWSArtificial Intelligence
TableauR ProgrammingPowerBIDeep Learning
Price
View Courses
360+ Online Courses | 50+ projects | 1500+ Hours | Verifiable Certificates | Lifetime Access
4.7 (86,584 ratings)

Data Mart: It is a specific repository of data that was designed to answer specific questions. Multiple data marts exist in different field areas.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

Data Warehouse: It is an enterprise-wide repository that contains the information of the entire organization.

Kimball follows a different approach in which dimensional data marts are created first. The data sources are then identified and fetched from various sources and loaded. The star schema is the indispensable factor of dimensional modeling. Multiple such schemas can exist in a single model. To organize data in an integrated manner, Kimball recommends that the dimension table must be shared with different tables within various data marts. This helps us to comprehend that a single piece of data can be used in a similar manner throughout all the facts.

How does the Kimball Methodology Work?

The focus of the Kimball approach is on identifying the key business process and the subsequent business solutions that we need to provide with the data warehouse. The Kimball approach utilizes dimensional models such as star and snowflake schema to organize the data into various business classified data, in order to quickly enable business processes. Now from an architectural perspective, Kimball proposes that it isn’t necessary to separate the data marts from the existing dimensional data warehouse.

Finally, Kimball focuses on providing analytical systems that can be directly accessed from the data warehouse. In other words, Kimball proposes an architecture where an analytical system can directly consume data from the data warehouse. It takes relatively less time to implement Kimball data warehouse architecture. Since the abstraction is a higher level of abstraction, we only consider the data warehouse design using a star or snowflake schema.

While in the case of Kimball based design, maintenance is difficult because there can be redundant data and revisions require additional tasks. Kimball incurs low initial cost because we only need to plan the data warehouse and the cost remains the same for the subsequent phases. It requires a general team to implement. The resources involved need to know how to work with ER modeling, without the need to decouple them into various data marts. Also with Kimball based data warehouse, the data integration requirement is focused on the individual business area. Kimball-based design, maintenance is difficult because there can be redundant data.

Advantages of Kimball Methodology

  1. It takes a relatively lesser amount of time to implement the Kimball data warehouse architecture since the abstraction is at a higher level.
  2. Kimball incurs low initial cost because we only need to plan the data warehouse and the cost remains the same for the subsequent phases.
  3. Kimball-based data warehouses can be set up quickly.
  4. Kimball requires a generalist team to implement.
  5. In Kimball methodology, the data integration requirement is focused on the individual business area.

Conclusion

Kimball architecture requires data sources, data staging, ETL capabilities, and data marts. Business requirements need to be captured and they both require time attribute for data to facilitate historical data. Kimball happens to be process-oriented since the focus is on business processes. Kimball prefers the denormalized data model, and as such, we find redundant data model present in the Kimball architecture. Kimball based data warehouses are easier to design and implement. We have to adapt to the changes and the data warehouse level. With Kimball, we get one data warehouse storage that we need to utilize logically depending on the business process.

Recommended Articles

This is a guide to the Kimball Methodology. Here we discuss the Introduction to Kimball Methodology, Kimball Approach along with the Advantages. You can also go through our suggested articles to learn more –

  1. Introduction to Benefits of Data Warehouse
  2. Types of Data Warehouse
  3. Data Warehouse vs Data Mart | Top 8 Comparisons
  4. Data Warehouse tools with Features
Popular Course in this category
All in One Data Science Bundle (360+ Courses, 50+ projects)
  360+ Online Courses |  1500+ Hours |  Verifiable Certificates |  Lifetime Access
4.7
Price

View Course

Related Courses

Business Intelligence Training (12 Courses, 6+ Projects)4.9
Data Visualization Training (15 Courses, 5+ Projects)4.8
3 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Data Science Course

SPSS, Data visualization with Python, Matplotlib Library, Seaborn Package

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more