Analytics vocab test 2

Question 1

Simple choice among alternatives

Answer 1

Decision

Question 2

Routine and repetitive, has a procedure for dealing with it

Answer 2

Structured

Question 3

Partially programmable but requires judgement

Answer 3

Semi Structured

Question 4

novel and with no procedure (require evaluation, judgement, and insight)

Answer 4

Unstructured

Question 5

Ensures that day to day tasks are being conducted efficiently and effectively

Answer 5

Operational control

Question 6

Ensures the efficient, effective use of resources in achieving the goals laid out in strategic planning

Answer 6

Managerial control

Question 7

Higher level issues concerned with the overall direction of the organization

Answer 7

Strategic planning

Question 8

Sensing conditions and predicting what conditions will require action

Answer 8

Intelligence

Question 9

Developing alternative approaches to bringing about the required change or achieving the required goals

Answer 9

Design

Question 10

Selecting the most effective and efficient alternative

Answer 10

Choice

Question 11

The selected alternative is carried out

Answer 11

Implementation

Question 12

Encompasses the set of techniques that describes what has happened in the past

Answer 12

Descriptive Analytics

Question 13

Collections of tables, charts, maps, and summary statistics that are updated as new data become available

Answer 13

Data Dashboards

Question 14

Must have; minimum

Answer 14

Requirements

Question 15

Beyond minimum essential requirements

Answer 15

Goals

Question 16

determine how well each alternative meets the requirements and goals

Answer 16

Decision Criteria

Question 17

List advantages and disadvantages

Answer 17

Pros and Cons

Question 18

Series of steps or tasks required to achieve a specific goal

Answer 18

Process

Question 19

Several tasks that makeup a major part of a process

Answer 19

Sub-process

Question 20

Levels of Change

Answer 20

Automate, Informate, Transform

Question 21

directed towards collection, manipulation, and storage of data

Answer 21

Information systems

Question 22

organized collection of data

Answer 22

Database

Question 23

organizes data in connected two-dimensional tables, dominant type of database for business

Answer 23

Relational Database

Question 24

Provides means for creating, maintaining, and using databases

Answer 24

Database management system

Question 25

Refers to the overall completeness, accuracy and consistency of data

Answer 25

Data Integrity

Question 26

help maintain data integrity to ensure that data is correct, consistent, complete, and current.

Answer 26

Database Systems

Question 27

A thing with distinct and independent existence

Answer 27

Entity

Question 28

Properties of entities

Answer 28

Attribute

Question 29

Unique Identifier

Answer 29

Primary Key

Question 30

PK made up of more than one field

Answer 30

Composite Primary Key

Question 31

fields that reference a primary key in a related table

Answer 31

Foreign keys

Question 32

Captures how entities relate to each other

Answer 32

Relationship

Question 33

Using actual data to show the structure of a database only works for very small databases

Answer 33

Database Diagrams

Question 34

Vast amount of data created and stored that has grown beyond the capabilities of traditional data processing tools and applications

Answer 34

Big Data

Question 35

A table in a database contains information about Employees. The portion of the table that would contain the Employee First Name for all Employees would be known as what?

Answer 35

Field (up & down)

Question 36

Business process improvement is often called

Answer 36

Business Process Reengineering

Question 37

The horizontal rows are knows as what

Answer 37

Record (Left to Right)

Question 38

How should big data be stored

Answer 38

NAS & DAS

Question 39

How do data from various sources integrate with one another?

Answer 39

Uses ETL (extract, transform, load)

Question 40

Mapping processes and sub-processes

Answer 40

Process Modeling

Question 41

What is the purpose of process modeling

Answer 41

understand the various processes that occur at different levels in organizations and how they interrelate