COURSE PACKET 4

Question 1

____ is a set of theories, methodologies, processes,
architectures, and technologies that transform raw data into meaningful and
useful information for business purposes

Answer 1

Business intelligence (BI)

Question 2

is about getting the right information, to the
right decision makers, at the right time.

Answer 2

Business Intelligence (BI)

Question 3

enterprise-wide platform that supports reporting, analysis and
decision making that leads to fact-based decision making “single version of the
truth”

Answer 3

BI

Question 4

committed ______ from the top is a vitally important
element. Repeated studies have shown that a lack of commitment at the
top is a major reason BI projects fail.

Answer 4

LEADERSHIP

Question 5

another important factor. You have to have a clear
vision of what you’re trying to accomplish and how you intend to get
there. Further, this vision has to be aligned with your business goals.

Answer 5

STRATEGY

Question 6

Dedicated ______ are also central to making BI succeed.
This includes not just the people who use BI, but also the
supporting players. Quality staff becomes more important as BI works to
wring value out of the operation.

Answer 6

PEOPLE

Question 7

This one comes far down the list for a reason. While ______ is an important enabler for BI, it is not the dominant factor

Answer 7

TECHNOLOGY

Question 8

have to be in place to make
BI central to your business’ efforts. This means change in your business
processes and the organization has to accept change. This is another place
where top level support is vital.

Answer 8

Organizational Dynamics

Question 9

Which customers should I target?
What has caused the change in my pipeline? Which are my most profitable campaigns per region?
Did store sales spike when we advertised in the local paper or launched
an email campaign?
What is the most profitable source of sales leads and how has that changed
over time?

Answer 9

SALES AND MARKETING

Question 10

Which vendors are best at delivering on time and on budget? – How many
additional personnel do we need to add per store during the holidays?
Which order processing processes are most inefficient?

Answer 10

OPERATIONAL

Question 11

What is the fully loaded cost of new products?
What is the expected annual profit/loss based on current marketing and
sales forecasts?
How are forecasts trending against the annual plan?
What are the current trends in cash flow, accounts payable and accounts
receivable and how do they compare with plan?

Answer 11

FINANCIAL

Question 12

improving organizations by providing business insights to all employees leading to better, faster, more relevant decisions

Answer 12

Business Intelligence VIsion

Question 13

lives and breathes data. A
statistician by nature, they will drill deep down into data, looking for fresh
insights that will be used to underscore business strategy. The role includes
documenting all your business data, identifying patterns and creating reports
and dashboards that will support the decision-making process.

Answer 13

The Data Analyst

Question 14

The CEO, of course, is at the helm of the business, driving the
company’s success by improving operational analytics efficiency and
constantly looking for ways to reduce costs.

Answer 14

The Executive

Question 15

has the capability
of working with complex data sets

Answer 15

power user

Question 16

____ will make use of
dashboards to analyze predefined sets of data.

Answer 16

casual user

Question 17

is another key player in the BI process. The ___ user still plays a central
role – maintaining the infrastructure and giving departments the tools that
allow them to fulfill their own data requests

Answer 17

the IT Team

Question 18

defining which data will be loaded into the system and
analyzed.

Answer 18

Stage 1. The Data

Question 19

extracts data from
multiple sources, transforms it into a format satisfying the operational and analytical requirements of the business, and loads it to a target destination, such
as a database or data warehouse..

Answer 19

Stage 2. The ETL (Extract, Transform, and Load) Engine

Question 20

Connects electronic data from different operational systems so
that the data can be queried and analyzed over time for business
decision making.

Answer 20

Stage 3. Data Warehousing

Question 21

Analyzes multidimensional data sets found in a data warehouse to
identify trends, outliers, and patterns.

Answer 21

Stage 4. Analytic Engine

Question 22

The dashboards, reports and alerts that present findings from the analysis.
Typically, Technology Agnostic

Answer 22

Stage 5. Presentation Layer

Question 23

The main focus of _____
system is to record the
current Update, Insertion
and Deletion while
transaction. ____ administers day to day
transaction of an
organization.

Answer 23

Online Transaction processing (OLTP)

Question 24

____ database stores
historical data that has
been inputted by OLTP. It
allows a user to view
different summaries of
multi-dimensional data.
Using ____, you can
extract information from a
large database and
analyze it for decision
making.

Answer 24

Online Analytical Processing (OLAP)

Question 25

is a
relational database
management system
(RDBMS) developed by
Microsoft.

Answer 25

MS SQL Server

Question 26

______ Service is a fully managed
database service to
deploy cloud-native
applications using the
world’s most popular open
source database.

Answer 26

MySQL Database

Question 27

A ____ is a
request for data from a
database. Usually the
request is to retrieve data;
however, data can also be
manipulated using
queries.

Answer 27

database query

Question 28

A software system used to
maintain relational
databases is a _____

Answer 28

relational
database management
system (RDBMS)

Question 29

_____ is an analytically oriented, integrated, time-
variant, and nonvolatile collection of data that supports decision
making processes

Answer 29

Data warehouse

Question 30

is a data store for implementation of decision-making activities.
It stores historical data which is used by enterprises for making strategies in their
business processes.

Answer 30

data warehouse

Question 31

It is the process of extracting patterns from data.

can be used to uncover patterns in data but is often
carried out only on samples of data

Answer 31

Data Mining

Question 32

____ is a term that we use in the business
that simply means, we are unbiased towards the use of different
technology tools to solve different problems.

Answer 32

Technology agnostic

Question 33

a set of high-level reports on key metrics, typically
for managers.

Answer 33

Dashboard