Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

Business Admin 230 > Exam 2 > Flashcards

Exam 2 Flashcards

1
Q

real-time information

A

immediate, up-to-date information

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

real-time systems

A

provide real-time information in response to requests

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

info quality

A 
timeliness
accuracy
relevancy
completeness
consistent
uniqueness
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

costs of low quality information

A

time, money, reputations and even jobs

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

data steward

A

responsible for ensuring the polices and procedures are implemented across the organization and acts as a liaison between the mis department and the business

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

data governance

A

refers to the overall management of the availability, usability, integrity and security of company data

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

SQL

A

strutted query language

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

QBE

A

query-by-example

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

primary key

A

a field that uniquely identifies a given record in a table

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

foreign key

A

a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables

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

data warehouse

A

a type fo database that integrates copies of transaction data from disparate source systems and provisions them for analytical use

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

ETL

A

extraction, transformation and loading
a process that extracts information from internal and external databases, transforms the information using a common set of enterprise definitions and loads the information into a data warehouse

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

data mart

A

contains a subset of data warehouse information

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

SLA

A

service level agreements
many db can be subject to application SLAs that require 99.99% uptime. system failure can result in chaos and lawsuits. data warehouses may not have SLAs

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

purposes of a DW

A

descriptive
diagnostic
predictive
prescriptive

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

some reasons for DW failure

A 
lack of executive support
lave of companion
lack of vision and imagination
lack of resources 
failure to understand magnitude and complexity
biting off too much 
no data steward function 
not understanding proper business objectives
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

cube

A

common term for the representation of multidimensional information
pre defined calculations
difficult back up and recovery
more security

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

OLAP

A

on-line analytical processing

cubes ofter refereed to as OLAP cubes

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

dimensional model

A

contains the same information as normalized model, but packages the data in a format that delivers user understandability, query performance and resilience to change

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

dimension

A

a particular attribute of information

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

data cleansing / scrubbing

A

a process that weeds out and fixes or discards inconsistent, incorrect or incomplete information

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

data broker

A

a business that collects personal information about consumers and sells that information to other organizations

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

big data

A 
more data than your firm can comfortably handle 
volume
velocity 
variety 
veracity
complexity
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

size of a terabyte

A

1000 gigabytes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
size of a petabyte
1000 terabytes
26
two dominant sources
CGM - consumer generated media | IOT - internet of things
27
taxonomies
a scheme of classification
28
ontologies
a set of concepts and categories in a subject area that shows their properties and the relations between them
29
BLOB
binary large object | DB data type
30
percent of major corporation decisions by gut
40%
31
percent of major corporation decisions done correctly
50%
32
percent improvement using data directed approaches
5-6%
33
hadoop
used to process big data | massive paralusm by parsing your data set across a cluster of computers
34
map reduce
google, yahoo and facebook index serach translations counting, summing, collating, filtering, parsing and sorting
35
simple map and reduce
``` input map and combine shuffle and sort reduce output ```
36
big data example failures
thatched roofs | watson and cancer
37
hippo
highest paid persons opinion
38
most disruptive technology identified by executives
``` artificial intelligence / machine learning digital tech / internet of things fin tech solutions cloud computing blackchain ```
39
oakland a's
analyze data for baseball team | on-base percentage and slugging percentage
40
tableau
visual and popular data access / manipulation analysis reporting
41
distributed computing
processes and manages algorithms across many machines in a computing environment
42
virtualization
the creation of a virtual version of computing resources
43
data blending
altered results in a dataset with the purpose of supporting analysis for a specific business question and is created by business and data analysts
44
data mining
the process of analyzing data to extract information not offered by the raw data alone
45
recommendation engine
a data-mining algorithm that analyzes a consumers purchases and actions on a website and then uses the data to recommend complementary products
46
affinity grouping analysis
reveals the relationship between variables along with the nature and frequency of the relationships
47
market basket analysis
evaluates such items as websites and checkout scanner info to detect customers buying behavior and predict future behavior by identifying affinities among customers choices of products and services
48
POI
point of interest
49
POI example
digital yellow pages, name, address (lat and long)
50
cluster analysis
a technique use to divide an information set into manually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible
51
prediction
a statement about what will happen or might happen in the future
52
data scientist
extracts knowledge from data by performing statistical analysis, data mining and advanced analytics on big data to identify trends, market changes and other relevant information
53
analysis paralysis
occurs when the user goes into an emotional state of over-analysis a situation so that the decision or action is never taken, in effect paralyzing the outcome
54
information system
software that helps you organize and analyze data | intersection of technology, people and process with an organization
55
system
collection of parts that work together to achieve a goal or task
56
systems analysis
a problem-solving or creative technique that composes a system of requirements into its component pieces for the purpose of studying how well those component parts work and interact to accomplish their purpose
57
systems design
a complementary technique that reassembles a systems component pieces back into a complete system
58
SDLC
systems development life cycle planning, analysis, design, implementation/ preliminary investigation, system analysis, system design , development, implementation, maintenance
59
output at each stage
planning - project plan analysis - system proposal design - system specification implementation - new system and maintenance plan
60
purposes at four stages
planning - initiate, feasibility, schedule, approval analysis - business needs and requirements design - define solution system implementation - construct, test, train, install
61
planning tasks
initiation - develop request and feasibility analysis | project management - work plan, staff, control and direct project
62
analysis tasks
develop analysis strategy gather requirements develop a system proposal
63
implementation
construct system install system - training plan establish a support plan
64
system anaysis skills
``` technical business analytical communications interpersonal ethics ```
65
system flowchart symbols
trapezoid - manual input rectangle - process triangle - off line strorage squiggle - document
66
CASE
computer-aided software engineering
67
feasibility
economic technical operational
68
implementation
direct - simply abandoning the old and staring up the new parallel - old and new systems are operated side bu side util the new one proves to be reliable pilot - new system is tried out in only one part of the organization phased - new system is implemented gradually over a period of time
69
prototyping
to build a model or prototype that can be modified before the actual system is installed
70
RAD
rapid application development
71
top down
divide and conqueror break down to identify the programs processing steps called modules
72
pseudocode
an outline of the voice of the program you will write, summary of the program before it is written
73
flowcharts
``` graphically present the detailed sequence of steps needed to solve a programming problem rectangle - process quadrangle - input / output diamond - decision circle - connector rounded rectangle - terminal ```
74
logice structures
sequence - 1..2..3.. selection - if -yes -no repetition - describes a process that may be repeated as long as certain condition remains true
75
debugging
the process of testing and then eliminating errors
76
syntax errors
a violation of the rules of programming language
77
logic errors
occur when the programmer uses incorrect calculation or leave out a programming procedure
78
OOPs
object-oriented programming - process by which a program is organized into objects

Business Admin 230 (3 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions