COURSE PACKET 4 Flashcards

1
Q

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

A

Business intelligence (BI)

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

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

A

Business Intelligence (BI)

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

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

A

BI

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

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.

A

LEADERSHIP

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

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.

A

STRATEGY

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

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.

A

PEOPLE

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

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

A

TECHNOLOGY

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

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.

A

Organizational Dynamics

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

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?

A

SALES AND MARKETING

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

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?

A

OPERATIONAL

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

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?

A

FINANCIAL

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

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

A

Business Intelligence VIsion

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

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.

A

The Data Analyst

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

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.

A

The Executive

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

has the capability
of working with complex data sets

A

power user

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

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

A

casual user

17
Q

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

A

the IT Team

18
Q

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

A

Stage 1. The Data

19
Q

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..

A

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

20
Q

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

A

Stage 3. Data Warehousing

21
Q

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

A

Stage 4. Analytic Engine

22
Q

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

A

Stage 5. Presentation Layer

23
Q

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

A

Online Transaction processing (OLTP)

24
Q

____ 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.

A

Online Analytical Processing (OLAP)

25
is a relational database management system (RDBMS) developed by Microsoft.
MS SQL Server
26
______ Service is a fully managed database service to deploy cloud-native applications using the world's most popular open source database.
MySQL Database
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.
database query
28
A software system used to maintain relational databases is a _____
relational database management system (RDBMS)
29
_____ is an analytically oriented, integrated, time- variant, and nonvolatile collection of data that supports decision making processes
Data warehouse
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.
data warehouse
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
Data Mining
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.
Technology agnostic
33
a set of high-level reports on key metrics, typically for managers.
Dashboard