Copyright

What is Data Consolidation? - Definition & Overview

An error occurred trying to load this video.

Try refreshing the page, or contact customer support.

Coming up next: What Is Memory Management? - Requirements, Errors & Techniques

You're on a roll. Keep up the good work!

Take Quiz Watch Next Lesson
 Replay
Your next lesson will play in 10 seconds
  • 0:01 What Is Data Consolidation?
  • 1:10 The Data Consolidation Process
  • 2:15 Extract, Transform, and Load
  • 3:05 Extract, Load, and Transform
  • 4:06 Lesson Summary
Save Save Save

Want to watch this again later?

Log in or sign up to add this lesson to a Custom Course.

Log in or Sign up

Timeline
Autoplay
Autoplay
Speed Speed

Recommended Lessons and Courses for You

Lesson Transcript
Instructor: Kent Beckert

Kent is an adjunct faculty member for the College of Business at Embry-Riddle Aeronautical University and has a Master's degree in Technical Management.

In this lesson, we define data consolidation as the process of combining large amounts of data, creating usable portions of information for database storage. Read on to explore data propagation and federation as well as ETL and ELT.

What Is Data Consolidation?

A large majority of us are familiar with news broadcasts, weather announcements, presidential speeches, and even military briefings given to senior commanders. In each case, the data used to create these informational sessions are a result of effective data consolidation. There are thousands of news stories published every minute, weather patterns are constantly changing, and business and military briefings are presented on a regular basis.

Material used to create each presentation, regardless of the audience, must be combined, analyzed, and controlled. By organizing the information into a usable and manageable amount, responsible individuals are able to consolidate the information and organize it into a single source. Then through analysis, they can extract the most critical components for delivery.

We can define the term data consolidation as a process during which a vast amount of information is gathered, stored, and combined into a single manipulative file, typically within a database. Usually, consolidation is accomplished by using a computer with special software applications, such as a spreadsheet or a database program, designed to gather, organize and store data.

The Data Consolidation Process

Data consolidation involves the collection of a vast amount of data or information from several networked servers, usually belonging to a company, organization or enterprise. Data consolidation is actually one of three data integration techniques in use today. The other techniques are data propagation, which includes data replication, and data federation which enables the viewing of consolidated files. The third data integration technique, data consolidation, consists of two technologies: Extract, Transform and Load (ETL) and Extract, Load and Transform (ELT), which will be discussed later in this lesson.

Storage such as databases, data stores, and associated software applications must allow and enable data consolidation from multiple applications. The objective is to make the extracted data readily available and usable, allowing for detailed reporting and analysis. Let's take a more detailed look at ETL and ELT as the two technologies used by experts to set up and perform data consolidation.

Extract, Transform, and Load

Extract, Transform, and Load (ETL) was the first technology used to load and store data retrieved from an extraction process. As the first, it became the standard for uploading data to data warehouses and other storage facilities. With ETL, data are relocated from variable data sources, and the transformations are applied in the data stream and uploaded to its designated storage container.

To unlock this lesson you must be a Study.com Member.
Create your account

Register to view this lesson

Are you a student or a teacher?

Unlock Your Education

See for yourself why 30 million people use Study.com

Become a Study.com member and start learning now.
Become a Member  Back
What teachers are saying about Study.com
Try it risk-free for 30 days

Earning College Credit

Did you know… We have over 200 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.

Create an account to start this course today
Try it risk-free for 30 days!
Create an account
Support