Week 11

Question 1

What do business intelligence systems do?

Answer 1

Summarize large data sets to understand what’s happening

Question 2

Business intelligence is the process of _________ data to put together a picture of what is going on in a business

Answer 2

collecting

Question 3

Business intelligence vs Data Analytics

Answer 3

BI describes past occurrences using data, future decisions can be made based on this

Data Analytics predicts the future

Question 4

Name this type of BI Decision:

Short-term decisions taken frequently

Answer 4

Administrative decision

Question 5

Name this type of BI Decision:

Use information to make better decisions

Answer 5

Strategic decision

Question 6

Name this type of BI Decision:

Helps identify processes to optimize

Answer 6

Operational decision

Question 7

Name the timeline/frequency of purpose of this BI decision: Strategic

Answer 7

Long-term decisions, deal with organizational growth

Question 8

Name the timeline/frequency of purpose of this BI decision: Administrative

Answer 8

Daily decisions, deal with the welfare of the employees

Question 9

Name the timeline/frequency of purpose of this BI decision: Operational

Answer 9

Not frequent, related to production and factory growth

Question 10

Name the 4 main components of BI systems:

Answer 10

1. Data warehouses
2. Business Analytics tools
3. Business performance tools
4. Visualization

Question 11

Which component of BI systems does this: manipulates and analyzes data

Answer 11

Business Analytics tools

Question 12

Which component of BI systems does this: monitors and analyzes performance

Answer 12

Business performance tools

Question 13

Which component of BI systems does this: shows portals, dashboards, scorecards

Answer 13

Visualization

Question 14

How often is a data warehouse typically updated?

Answer 14

Daily

Question 15

Name this: Pulls data from inventory, sales, etc. so that an overall picture can be created to support decision

Answer 15

Data warehouse

Question 16

ETL stands for

Answer 16

Extract, Transform, Load

Question 17

Name this ETL process: pulls data from its raw source

Answer 17

Extraction

Question 18

Name this ETL process: manipulates the data to convert it to the format you want

Answer 18

Transform

Question 19

Name this ETL process: stores the data in the final target (DW or DM)

Answer 19

Load

Question 20

What is a data mart? What is stored there?

Answer 20

A mini data warehouse. Typically 1 portion of the warehouse (sales, marketing, finance). Each department an organization has their own mart.

Question 21

A data mart is extracted from a data warehouse, what is its advantage?

Answer 21

Can store summarized data rather than raw data

Question 22

Name this: This system processes any type of transaction, it’s always running, it’s fast and maintains data integrity

Answer 22

Online Transaction Processing System (OLTP)

Question 23

Name this: This system is used to operate long-running queries, looking for patterns in data. Does data mining, business reports, etc.

Answer 23

Online Analytical Processing (OLAP)

Question 24

What type of operations does OLTP use?

Answer 24

Mostly INSERT, UPDATE, DELETE

Question 25

Is this an OLAP or OLTP query?

SELECT PASSWORD FROM ACCOUNTS
WHERE USERID = 1234;

Answer 25

OLTP

Question 26

Is this an OLAP or OLTP query?

SELECT PRODUCT, SALES
RANK() OVER (ORDER BY SALES ASC),
FROM SALES
ORDER BY SALES

Answer 26

OLAP

Question 27

T/F - Normal company staff use OLAP systems

Answer 27

False. Normal company staff use OLTP systems

Question 28

T/F - Specialized users use OLAP systems

Answer 28

True, it provides them summarized data to analyze the business

Question 29

T/F - OLAP works on current data

Answer 29

False. OLTP uses current data, OLAP uses historical