Assignment: Data Warehouses and Business Intelligence

timer Asked: Jul 6th, 2018
account_balance_wallet $25

Question description

Big data, business intelligence, online analytical processing, data mining, business analytics all have one thing in common; they often rely on a data warehouse to store information. Data warehouses store very large amounts of data. This raw data is of little value unless it can be transformed into meaningful and useful information.

In this application, you will use the text and other resources to examine data warehousing. You will submit a 3-4 page paper that addresses the following topics:

  • What is a data warehouse?
  • What are the primary similarities and differences between a data warehouse and a transactional database?
  • When should an organization consider developing a data warehouse?
  • How are data warehouses structured?
  • Describe at least two real-world examples of how a data warehouse is used to provide “business intelligence” that can give an organization a competitive advantage.

Include at least two additional interesting facts you discovered in your research on data warehouses and business intelligence.

Tutor Answer

School: Carnegie Mellon University


Surname 1

Student’s name:
Data warehouse
Data warehousing involves electronic storage of large amount of information by business
enterprises. Data warehousing is a concept that was introduced by the IBM researchers in 1988.
The researchers included Paul Murphy and Barry Devlin. One of the reasons as to why these
researchers came up with the data warehousing concept was due to increase in amounts of data.
This made it hard for the computer systems to handle all the data. Inmon Bill is considered as the
father of data warehouse since he wrote about usage, building as well as the maintenance of data
warehouse. A data warehouse receives information from one or more sources. The date stored
can be unstructured, structured or semi-structured. A data warehouse is more organized since all
the information is merged together. According to 1 (Biere 32), all the data is transformed,
processed and then ingested so that the processed data can be accessed through the business
intelligence tools, spreadsheets and SQL clients. A data warehouse must have four components.
Load manager/front component is involved with the extraction and data loading into the

flag Report DMCA

Outstanding Job!!!!

Similar Questions
Hot Questions
Related Tags

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors