Investing Answers Building and Protecting Your Wealth through Education Publisher of The Next Banks That Could Fail
Investing Answers Building and Protecting Your Wealth through Education Publisher of The Next Banks That Could Fail

Data Warehousing

What it is:

Data warehousing is an electronic method of organizing information.

How it works (Example):

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 it Matters:

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.

Related Terms View All
  • Auction Market
    Though most of the trading is done via computer, auction markets can also be operated via...
  • Best Execution
    Let's assume you place an order to buy 100 shares of Company XYZ stock. The current quote...
  • Book-Entry Savings Bond
    Savings bonds are bonds issued by the U.S. government at face values ranging from $50 to...
  • Break-Even Point
    The basic idea behind break-even point is to calculate the point at which revenues begin...
  • Calendar Year
    If Company XYZ starts its fiscal year on January 1 and ends its fiscal year on December...