Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
30 Cards in this Set
- Front
- Back
Business intelligence (BI) is a narrow term that refers to specific architectures, tools, databases, analytical tools, applications, and methodologies. (True/False) |
False
|
|
There are three main types of data warehouses, which are data marts, operational data stores, and enterprise data warehouses. (True/False) |
True
|
|
BI system has four major components, they are? |
data warehouse, business analytics, business performance management; and a user interface
|
|
IN the WSJ article, what was given as "the essense of the data-driven company"? |
Transparency & Accountability are the essence of the data-driven company
|
|
According the the WSJ article, many employees get their information from _____ after the data has been cleaned up and verified. |
Dashboards
|
|
Which of the following is not a data source to a data warehouse? |
ETL
|
|
Once data are entered into the warehouse, users cannot change or update the data. Obsolete data are discarded, and changes are recorded as new data. This ________ characteristic is one of the characteristics of data warehousing.
|
Nonvolatile
|
|
Online Transaction Processing (OLTP) systems are involved in extracting information from data. In contrast, a data warehouse is typically a distinct system that provides storage for data that will be made use of in analysis.(True/False)
|
False |
|
Which of the following is not true about a successful BI implementation? |
BI installations are usually short tem projects |
|
Name the parts of a data warehouse
|
Independent Data Mart, Federated, Centralized Data Warehouse, Hub & Spoke
|
|
The ETL process includes
|
Load, Integrate, Select
|
|
A data warehouse is...
|
Integrated, Subject Oriented, Time Variant
|
|
An Operational Data Store is
|
Not Static
|
|
Advantage of Star Schema
|
Simpler Queries
|
|
Advantage of Snowflake |
Data Integrity
|
|
The Star Schema is.
|
Most common, allows for simpler queries, simplest style of dimensional modeling
|
|
What is a data cube?
|
Needed for near instantaneous analysis of data, fast access to data
|
|
Data Warehouse need
|
Executive sponsorship, low data quality, good choice of architecture
|
|
For successful DW implementation, you should avoid
|
1) Loading all data just because it is available 2) Believing promises of scalability 3) Deliver data w/confusing definitions |
|
Hub & Spoke Architecture is
|
Scalable, Often develop iteratively, most famous DW architecture
|
|
BPM is...
|
1) Real time 2) Encourages collaboration 3) Alerts managers to impending problems |
|
3 Components of BP
|
1) A set of processes that are supported by technology that support financial and operational activities |
|
BI is an outgrowth of BPM |
False (vice versa)
|
|
Drawbacks of using financial data
|
1) They are often products of allocations 2) They are lagging indicators 3) They are not process oriented |
|
Characteristics of well designed dashboards |
1) they use visual components to highlight, at a glance, the data and exceptions that require action
2) they are transparent to the user and extremely easy to use 3) They enable drilldown |
|
Most widely used performance management system is
|
BSC (Balanced scorecard)
|
|
BPM is
|
1) A set of integrated closed-loop management and analytic processes addressing financial & operational activities 2) Tools for businesses to define goals and then measure and manage against those goals 3) Core of processes, modeling, analysis and monitoring of KPI's |
|
BPM
|
.....is a framework for organizing, automating, and analyzing business methodologies, metrics, processes, and systems to drive the overall performance of the enterprise.
|
|
BPM is
|
Strategy driven
|
|
KPI's are multidimensional and
|
Measure performance against targets, time frames as assigned to targets, ranges are encoded in software |