Midterm (1) ISM 3116

BI applications must be integrated with

(ALL OF THEM): databases, enterprise systems, legacy systems

Google Maps has set new standards for data visualization with its intuitive Web mapping software.

(T)rue

In what decade did disjointed information systems begin to be integrated?

1980s

______________ providers focus on providing technology and services aimed toward integrating data from multiple sources.

Data Warehouse

In the Dallas Cowboys case study, the focus was on using data analytics to decide which players would play every week.

False

The ________ Model, also known as the EDW approach, emphasizes top-down development, employing established database development methodologies and tools, such as entity-relationship diagrams (ERD), and an adjustment of the spiral development approach.

Inmon

This measure of dispersion is calculated by simply taking the square root of the variations.

Standard deviation

BI represents a bold new paradigm in which the company's business strategy must be aligned to its business intelligence analysis initiatives.

TRUE

With key performance indicators, driver KPIs have a significant effect on outcome KPIs, but the reverse is not necessarily true.

TRUe

Computer applications have moved from transaction processing and monitoring activities to problem analysis and solution applications.

True

Predictive algorithms generally require a flat file with a target variable, so making data analytics ready for prediction means that data sets must be transformed into a flat-file format and made ready for ingestion into those predictive algorithms.

Truee

Which characteristic of data requires that the variables and data values be defined at the lowest (or as low as required) level of detail for the intended use of the data?

data granularity

A(n) ________ data mart is a subset that is created directly from the data warehouse..

dependent

Which approach to data warehouse integration focuses more on sharing process functionality than data across systems?

enterprise application integration

________ describe the structure and meaning of the data, contributing to their effective use.

metadata

Oper marts are created when operational data needs to be analyzed

multidimensionally

Most data warehouses are built using ________ database management systems to control and manage the data.

relational

When representing data in a data warehouse, using several dimension tables that are each connected only to a fact table means you are using which warehouse structure?

star schema

A Web client that connects to a Web server, which is in turn connected to a BI application server, is reflective of a

three-tier architecture.

The data warehousing maturity model consists of six stages: prenatal, infant, child, teenager, adult, and sage.

truE