Assignment: Data Warehouses and Business Intelligence

Anonymous
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

Proff_White
School: Carnegie Mellon University

Attached.

Surname 1

Student’s name:
Institution:
Course:
Date:
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
warehous...

flag Report DMCA
Review

Anonymous
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