Chapter 1 - DataWarehousing Basics

Question 1

Data - warehousing

Answer 1

collection objects that transform data in to useful information

Question 2

8 stage process of BL Life cycle

Answer 2

1. Interview and identify data
2. plan the BI solution
3. Create data warehouse
4. create ETL process
5. cube creation
6. create reports
7. test, tune the solution
8. go live

Question 3

4 main components of data warehouse

Answer 3

• Operational source system
• Data staging area
• Data presentation
• Data access tools

Question 4

Operational source system

Answer 4

• capture the transaction of the business (OLTP)

* should be outside the data warehouse as we’ve no control over the content & format of the data

Question 5

Data staging area

Answer 5

Storage area and set of procedures commonly known as ETL.

Off-limits to the business users

Question 6

The in-between layer of operational staging area and data presentation area is ?

Answer 6

Data staging area

Question 7

Data presentation area

Answer 7

The area is organized, stored and made available for query by users and analytical apps.

Question 8

What’s the layer business users and data access tools operate on ?

Answer 8

Data presentation area

Question 9

Data access tools

Answer 9

can be a simple ad hoc query an a sophisticated data mining or modeling application

Question 10

Who use data warehouse ?

Answer 10

executives, senior managers, and business analysts in making complex business decisions

Question 11

Why do we need data warehouse ?

Answer 11

1. perform querying and reporting on servers/disks not used by transaction processing systems
2. use data models and/or server technologies that speed up querying and reporting that are
   not appropriate for transaction processing
3. easier to query and report data from multiple transaction processing systems and/or from external data sources and/or from data
4. contains data from a longer span of time
5. prevent persons who only need to query and report transaction processing system data
   from having any access to transaction processing system databases