Data Warehousing

Written by:
Image
Paul Tracy

Paul has been a respected figure in the financial markets for more than two decades.

Prior to starting InvestingAnswers, Paul founded and managed one of the most influential investment research firms in America, with more than 2 million monthly readers. While there, Paul authored and edited thousands of financial research briefs, was published on Nasdaq. com, Yahoo Finance, and dozens of other prominent media outlets, and appeared as a guest expert at prominent radio shows and i...

View all posts
Updated November 3, 2020

What is Data Warehousing?

Data warehousing is an electronic method of organizing information.

How Does Data Warehousing Work?

A data warehouse essentially combines information from several sources into one comprehensive database. For example, in the business world, a data warehouse might incorporate customer information from a company's point-of-sale systems (the cash registers), its website, its mailing lists and its comment cards. Alternatively, it might incorporate all the information about employees, including time cards, demographic data, salary information, etc.

By combining all of this information in one place, a company can analyze its customers in a more holistic way, ensuring that it has considered all the information available. Data warehousing also makes data mining possible, which is the task of looking for patterns in the data that could lead to higher sales and profits.

There are different ways to establish a data warehouse and many pieces of software that help different systems "upload" their data to a data warehouse for analysis. However, the basic idea is to first extract data from all the individual sources (cash registers, time clocks, office computers), remove redundant data and organize the data into a consistent format that can be queried.

Why Does Data Warehousing Matter?

Companies with data warehouses can have an advantage in product development, marketing, pricing strategy, production time, historical analysis, forecasting and customer satisfaction. However, data warehouses also can be very expensive to design and implement, and sometimes their construction makes them unwieldy.

Ask an Expert about Data Warehousing
At InvestingAnswers, all of our content is verified for accuracy by Paul Tracy and our team of certified financial experts. We pride ourselves on quality, research, and transparency, and we value your feedback. Below you'll find answers to some of the most common reader questions about Data Warehousing.
Be the first to ask a question

If you have a question about Data Warehousing, then please ask Paul.

Ask a question

Paul has been a respected figure in the financial markets for more than two decades. Prior to starting InvestingAnswers, Paul founded and managed one of the most influential investment research firms in America, with more than 2 million monthly readers.

If you have a question about Data Warehousing, then please ask Paul.

Ask a question Read more from Paul

Read this next

Paul Tracy - profile
Ask an Expert about Data Warehousing

By submitting this form you agree with our Privacy Policy

Share
close
Don't Know a Financial Term?
Search our library of 4,000+ terms