Buisness Intelligence

According to Eckerson (2006), a well-known expert on BI dashboards, what are the three layers of information of a dashboard?

1.Monitoring - abstracted data shown in a graphical manner to monitor key performance indicators.2. Analysis - Summary data to analyze the cause of problems3. Management - Operational information to indicate what actions to take to solve a problem.

The "islands of data" problem in the 1980s describes the phenomenon of unconnected data being stored in numerous locations within an organization.

T or F True

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

T or F True

The hub-and-spoke data warehouse model uses a centralized warehouse feeding dependent data marts.

T or F True

There are basic chart types and specialized chart types. A Gantt chart is a specialized chart type.

T or F True

Visualization differs from traditional charts and graphs in complexity of data sets and use of multiple dimensions and measures.

T or F True

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

T or F True

Without middleware, different BI programs cannot easily connect to the data warehouse.

T or F True

How does the use of cloud computing affect the scalability of a data warehouse? Cloud computing has little effect on a data warehouse's scalability. Cloud computing vendors bring as much hardware as needed to users' offices. Hardware resources are dynamically allocated as use increases. Cloud vendors are mostly based overseas where the cost of labor is low.

Hardware resources are dynamically allocated as use increases.

This plot is a graphical illustration of several descriptive statistics about a given data set. kurtosis bar graph pie chart box-and-whiskers plot

box and whiskers plot

Which kind of chart is described as an enhanced version of a scatter plot? pie chart bubble chart heat map bullet

bubble chart

A(n) ________ is a communication artifact, concerning business matters, prepared with the specific intention of relaying information in a presentable form.

business report

In which stage of extraction, transformation, and load (ETL) into a data warehouse are anomalies detected and corrected? transformation load extraction cleanse

cleanse

This technique makes no a priori assumption of whether one variable is dependent on the other(s) and is not concerned with the relationship between variables; instead it gives an estimate on the degree of association between the variables. regression means test multiple regression correlation

correlation

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 accessibility data source reliability data richness data granularity

data granularity

Descriptive statistics is all about describing the sample data on hand.

T or F True

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

T or F True

Interval data are variables that can be measured on interval scales.

T or F True

One of SiriusXM's challenges was tracking potential customers when cars were sold

T or F True

One way an operational data store differs from a data warehouse is the recency of their data.

T or F True

Describe categorical and nominal data

Categorical data represent the labels of multiple classes used to divide a variable into specific groups. Nominal data contain measurements of simple codes assigned to objects as labels, which are not measurements.

Describe the difference between descriptive and inferential statistics.

Descriptive statistics describes sets of data. Inferential statistics draws conclusions about the sets of data based on sampling.

________ is a mechanism for pulling data from source systems to satisfy a request for information. It is an evolving tool space that promises real-time data integration from a variety of sources, such as relational databases, Web services, and multidimensional databases.

Enterpirse information integration (EII)

_______ is an evolving tool space that promises real-time data integration from a variety of sources, such as relational databases, Web services, and multidimensional databases. None of these Extraction, transformation, and load (ETL) Enterprise information integration (EII) Enterprise application integration (EAI)

Enterprise information integration (EII)

________ charts are a special case of horizontal bar charts that are used to portray project timelines, project tasks/activity durations, and overlap among the tasks/activities.

GANTT

Key performance indicators (KPIs) are metrics typically used to measure qualitative feedback. database responsiveness. internal results. external results.

Internal results

Structured data is what data mining algorithms use and can be classified as categorical or numeric.

T or F True

The ________ Model, also known as the data mart approach, is a "plan big, build small" approach. A data mart is a subject-oriented or department-oriented data warehouse. It is a scaled-down version of a data warehouse that focuses on the requests of a specific department, such as marketing or sales.

Kimball

Describe the difference between simple and multiple regression.

Simple regression only has one independent variable as multiple regression has two or more independent variables.

Data is the main ingredient for any BI, data science, and business analytics initiative.

T or F True

Data is the contextualization of information, that is, information set in context.

T or F

Because the recession has raised interest in low-cost open source software, it is now set to replace traditional enterprise software.

T or F False

Dashboards provide visual displays of important information that is consolidated and arranged across several screens to maintain data order.

T or F False

Data source reliability means that data are correct and are a good match for the analytics problem.

T or F False

Data warehouse administrators (DWAs) do not need strong business insight since they only handle the technical aspect of the infrastructure.

T or F False

Data warehouses are subsets of data marts.

T or F False

OLTP systems are designed to handle ad hoc analysis and complex queries that deal with many data items.

T or F False

Properly integrating data from various databases and other disparate sources is a trivial process.

T or F False

The BPM development cycle is essentially a one-shot process where the requirement is to get it right the first time.

T or F False

The data storage component of a business reporting system builds the various reports and hosts them for, or disseminates them to users. It also provides notification, annotation, collaboration, and other services.

T or F False

To respond to its market challenges, SiriusXM decided to focus on manufacturing efficiency.

T or F False

User-initiated navigation of data through disaggregation is referred to as "drill up."

T or F False

When telling a story during a presentation, it is best to avoid describing hurdles that your character must overcome, to avoid souring the mood.

T or F False

With the balanced scorecard approach, the entire focus is on measuring and managing specific financial goals based on the organization's strategy.

T or F False

Because of performance and data quality issues, most experts agree that the federated architecture should supplement data warehouses, not replace them.

T or F True

Data accessibility means that the data are easily and readily obtainable.

T or F True

What is the definition of a data warehouse (DW) in simple terms?

a pool of data to support decision making.

What is the definition of a data mart?

a subset of a data warehouse consisting of a single subject area.

When you tell a story in a presentation, all of the following are true EXCEPT well-told story should have no need for subsequent discussion. the outcome and reasons for it should be clear at the end of your story. a story should make sense and order out of a lot of background noise. stories and their lessons should be easy to remember.

a well-told story should have no need for subsequent discussion.

This measure of central tendency is the sum of all the values/observations divided by the number of observations in the data set. dispersion arithmetic mean mode median

arithmetic mean

________ charts are effective when you have nominal data or numerical data that splits nicely into different categories so you can quickly see comparative results and trends within your data.

bar

Why is a performance management system superior to a performance measurement system? because performance management systems cost more because measurement alone has little use without action because measurement automatically leads to problem solution because performance measurement systems are only in their infancy

because measurement alone has little use without action

A large storage location that can hold vast quantities of data (mostly unstructured) in its native/raw format for future/potential analytics consumption is referred to as a(n) data cloud. relational database. extended ASP. data lake.

data lake

Which characteristic of data means that all the required data elements are included in the data set? data source reliability data richness data granularity data accessibility

data richness

The three main types of data warehouses are data marts, operational ________, and enterprise data warehouses.

data stores

The role responsible for successful administration and management of a data warehouse is the ________, who should be familiar with high-performance software, hardware, and networking technologies, and also possesses solid business insight.

data warehouse administrator (DWA)

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

dependent

________ modeling is a retrieval-based system that supports high-volume query access.

dimensional

When querying a dimensional database, a user went from summarized data to its underlying details. The function that served this purpose is dice. roll-up. drill down. slice.

drill down

Information dashboards enable ________ operations that allow the users to view underlying data sources and obtain more detail.

drill-down/drill-through

What is the fundamental challenge of dashboard design? ensuring that the organization has the appropriate hardware onsite to support it ensuring that the organization has access to the latest Web browsers ensuring that the required information is shown clearly on a single screen ensuring that users across the organization have access to it

ensuring that the required information is shown clearly on a single screen

________ is a mechanism that integrates application functionality and shares functionality (rather than data) across systems, thereby enabling flexibility and reuse.

enterprise application integration

The ________ data warehouse architecture involves integrating disparate systems and analytical resources from multiple sources to meet changing needs or business conditions.

federated

Which data warehouse architecture uses metadata from existing data warehouses to create a hybrid logical data warehouse comprised of data from the other warehouses? independent data marts architecture federated architecture hub-and-spoke data warehouse architecture centralized data warehouse architecture

federated architecture

Operational or transaction databases are product oriented, handling transactions that update the database. In contrast, data warehouses are subject-oriented and nonvolatile. product-oriented and volatile. product-oriented and nonvolatile. subject-oriented and volatile.

subject-oriented and nonvolatile.

Which type of visualization tool can be very helpful when a data set contains location data? tree map highlight table geographic map bar chart

geographic map

Which data warehouse architecture uses a normalized relational warehouse that feeds multiple data marts? independent data marts architecture hub-and-spoke data warehouse architecture federated architecture centralized data warehouse architecture

hub-and-spoke data warehouse architecture

Data warehouses provide direct and indirect benefits to organizations. Which of the following is an indirect benefit of data warehouses? better and more timely information improved customer service extensive new analyses performed by users simplified access to data

improved customer service

Which kind of data warehouse is created separately from the enterprise data warehouse by a department and not reliant on it for updates? public data mart volatile data mart sectional data mart independent data mart

independent data mart

________ statistics is about drawing conclusions about the characteristics of the population.

inferential

Data ________ comprises data access, data federation, and change capture.

integration

More data, coming in faster and requiring immediate conversion into decisions, means that organizations are confronting the need for real-time data warehousing (RDW). How would you define real-time data warehousing?

loading and providing data via the data warehouse as they become available

________ regression is a very popular, statistically sound, probability-based classification algorithm that employs supervised learning.

logistic

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

metadata

________ management reports are used to manage business performance through outcome-oriented metrics in many organizations.

metric

List and describe the three major categories of business reports.

metric management reports: involve outcome-oriented metrics based on service level agreements and/or key performance indicators dashboard-type reports: present a range of performance indicators on one page, with both static/predefined elements and customizable widgets and views balanced scorecard-type reports: present an integrated view of a company's health and include financial, customer, business process, and learning/growth perspectives.

Oper marts are created when operational data needs to be analyzed multidimensionally. in a dashboard. linearly. unidimensionally.

multidimensionally.

The Internet emerged as a new medium for visualization and brought all the following EXCEPT new graphics displays through PC displays. new forms of computation of business logic. worldwide digital distribution of visualization. immersive environments for consuming data.

new forms and computation of business logic

When validating the assumptions of a regression, ________ assumes that the errors of the response variable are normally distributed.

normality

A(n) ________ data store (ODS) provides a fairly recent form of customer information file

operational

What is the management feature of a dashboard? graphical, abstracted data to monitor key performance metrics summarized dimensional data to analyze the root cause of problems summarized dimensional data to monitor key performance metrics operational data that identify what actions to take to resolve a problem

operational data that identify what actions to take to resolve a problem

Which of the following BEST enables a data warehouse to handle complex queries and scale up to handle many more requests? parallel processing Microsoft Windows use of the Web by users as a front-end a larger IT staff

parallel processing

Which type of visualization tool can be very helpful when the intention is to show relative proportions of dollars per department allocated by a university administration? heat map bullet pie chart bubble chart

pie chart

In ________ oriented data warehousing, operational databases are tuned to handle transactions that update the database.

product

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

relational

Given that the size of data warehouses is expanding at an exponential rate, ________ is an important issue.

scalability

________ plots are often used to explore the relationship between two or three variables (in 2-D or 2-D visuals).

scatter

Dashboards present visual displays of important information that are consolidated and arranged on a single ________.

screen

This measure of dispersion is calculated by simply taking the square root of the variations. variance range arithmetic mean standard deviation

standard deviation

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 snowflake schema dimensional schema relational schema

star schema

What are the four processes that define a closed-loop BPM cycle?

strategize, plan , monitor/analyze, and act/adjust,.

Dashboards can be presented at all the following levels EXCEPT the self-service cube level. the visual cube level. the visual dashboard level. the static report level.

the visual cube level

Benefits of the latest visual analytics tools, such as SAS Visual Analytics, include all of the following EXCEPT it is easier to spot useful patterns and trends in the data. there is less demand on IT departments for reports. they explore massive amounts of data in hours, not days. mobile platforms such as the iPhone are supported by these products.

they explore massive amounts of data in hours, not days.

A Web client that connects to a Web server, which is in turn connected to a BI application server, is reflective of a two-tier architecture. one-tier architecture. four-tier architecture. three-tier architecture.

three-tier architecture.

________ series forecasting is the use of mathematical modeling to predict future values of the variable of interest based on previously observed values.

time

Online ________ is a term used for a transaction system that is primarily responsible for capturing and storing data related to day-to-day business functions such as ERP, CRM, SCM, and point of sale.

transactional processing

Typical charts, graphs, and other visual elements used in visualization-based applications usually involve ________ dimensions.

two

Which type of question does visual analytics seeks to answer? When did it happen? What happened yesterday? What is happening today? Why is it happening?

why is it happening?