Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Accounting 503 > Chapter 3 - Business Intelligence and Data Warehousing > Flashcards

Chapter 3 - Business Intelligence and Data Warehousing Flashcards

1
Q

What are the 9 fundamental characteristics of Data Warehousing? (1-4)

A

Subject oriented
Integrated
Time variant (time series)
Nonvolatile

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What are the 9 fundamental characteristics of Data Warehousing? (5-9)

A

Web based
Rational/multidimensional
Client/server
Real time
Includes metadata

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is a data mart?

A

A smaller data warehouse that focuses on a particular subject or department

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is an Operational Data Store?

A

A database that is used as an interim staging area for a data warehouse. Used for short-term decisions involving mission-critical applications rather than medium and long-term decisions.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is an Enterprise Data Warehouse?

A

A large-scale data warehouse used across the enterprise for decision support

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is metadata?

A

Data about data. Describes the structure of and some meaning about data, thereby contributing to their effectiveness.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What are the 6 major components of the data warehousing process?

A

Data sources
Data extraction and transformation
Data loading
Comprehensive database
Metadata
Middleware Tools

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What are the 5 alternative data warehousing architectures?

A

Independent data marts
Data mart bus architecture
Hub-and-spoke architecture
Centralized data warehouse
Federated data warehouse

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

How do Independent Data Marts approach data warehousing?

A

The DMs are developed to operate independent of each other to serve the needs of the individual organizational units.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

How does Data Mart Bus Architecture approach data warehousing?

A

The individual data marts are linked to each other via some kind of middleware

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

How does Hub-and-Spoke Architecture approach data warehousing?

A

The focus is building a scalable and maintainable infrastructure that includes a centralized data warehouse and several dependent DMs.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

How do Centralized Data Warehouses approach data warehousing?

A

There is a gigantic, centralized EDW that serves the needs of all organizational units.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

How do Federated Data Warehouses approach data warehousing?

A

They use all possible means to integrate analytical resources from multiple sources to meet changing needs or business conditions.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is the ETL process?

A

ETL stands for Extraction, Transformation, and Load. It involves reading the data, converting into the form that it needs to be so it can be used, and loading it into the data warehouse.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What does Enterprise Application Integration (EAI) mean?

A

It involves integrating application functionality and provides a vehicle for pushing data from source systems into the DW.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What does Enterprise Information Integration (EII) mean?

A

It is a mechanism for pulling data from source systems to satisfy a request for information.

17
Q

What is the difference of EAI and EII?

A

EAI is more focused on creating flexibility and reuse and EII is more focused on the speed of pulling data.

18
Q

What is Dimensional Modeling?

A

A retrieval-based system that supports high-volume query access.

19
Q

What is a Star Schema?

A

It is a style of dimensional modeling. It contains a central fact table that is surrounded by and connected to several dimension tables.

20
Q

What are Dimension Tables?

A

Dimensions tables contain attributes that describe the data contained within the fact table. They address how data will be analyzed and summarized. Dimension tables have a one-to-many relationship with rows in the central fact table.

21
Q

What is a Snowflake Schema?

A

A logical arrangement of tables in a multidimensional database in such a way that the entry-relationship diagram resembles a snowflake in shape.

22
Q

What are the differences between OLAP and OLTP?

A

OLTP captures and stores data related to day-to-day business functions, but the systems are not designed for ad hoc analysis and complex queries like OLAPs are. The two systems do rely heavily on each other.

23
Q

What are the 5 commonly used OLAP operations?

A

Slice
Dice
Drill Down/Up
Roll-up
Pivot

24
Q

What is a BPM? What is a performance measurement system as it relates to BPMs?

A

BPM is Business Performance Management. A performance management system assists managers in tracking the implementations of business strategy by comparing actual results against strategic goals and objectives.

25
Q

What is a KPI?

A

A Key Performance Indicator. KPIs represent strategic objectives and measure performance against a goal.

26
Q

What are the 10 differing types of KPIs and what do they represent? (1-6)

A

Strategy - KPIs embody a strategic objective
Targets - Measure performance against specific targets
Ranges - Targets have performance ranges
Encodings - Ranges are encoded in software, enabling the visual display of performance
Time Frames - When the targets must be accomplished
Benchmarks - Targets measured against a baseline

27
Q

What are the 10 differing types of KPIs and what do they represent? (7-10)

A

Customer Performance - Metrics for customer satisfaction and retention
Service Performance - Metrics for service-call resolution rates, service renewal rates, delivery performance, etc.
Sales Operations - New accounts, sales meetings secured, conversions of inquiries to leads, and average call closure time
Sales Plan/Forecast - Metris for price-to-purchase accuracy, purchase order-to-fulfillment ratio, quantity earned

28
Q

What is a BSC?

A

A balanced scorecard is a widely used performance management system that views the organization from four perspectives.

29
Q

What is Balance as it relates to BSC?

A

Balance is achieved by translating the org’s vision and strategy into a set of interrelated financial and nonfinancial objectives, measures, targets, and initiatives.

30
Q

What are the four BSC perspectives?

A

Financial
Customer
Internal/Business Processes
Learning and Growth

31
Q

What are the 3 Nonfinancial BSC Perspectives?

A

Internal/Business Processes
Customer
Learning and Growth

32
Q

What is Six Sigma?

A

It is a performance management methodology aimed at reducing the number of defects in a business process as close to zero DPMO as possible

33
Q

What is the DMAIC performance model?

A

Define
Measure
Analyze
Improve
Control

34
Q

What is the summarized difference between BSC and Six Sigma?

A

BSC is focused on improving overall strategy whereas Six Sigma is focused on improving processes.

Accounting 503 (7 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions