ISYS Exam 3 Ch. 17 ABCC – Flashcards
Unlock all answers in this set
Unlock answersquestion
Business Intelligence
answer
Refers to an assortment of software applications to analyze an organization's raw data.
question
Let's say you're not a Business Intelligence or database expert; does that mean you're left out of the BI game?
answer
The answer is a resounding "no!"
question
Decision Support Systems (DSS)
answer
are computer-based systems that support an organization's decision-making activities.
question
Big Data
answer
Data would also include smartphone metadata, Internet usage records, social media activity, computer usage records, and countless other data sources, so it could be sifted for patterns and trends
question
Data can be categorized in three groups:
answer
Structured Data, Unstructured Data, Semi-structured Data.
question
Structured Data
answer
This data is typically well labeled and often with traditional fields and records of common data tables.
question
Unstructured Data
answer
Disorganized data that cannot be easily read or processed by a computer because it is not stored in rows and columns like traditional data tables.
question
Semi-structured Data
answer
Unstructured data and can possibly be converted into structured data, but not without a lot of work.
question
An organization can use the following " Four V's" of Big Data as a guideline:
answer
Volume, Velocity, Variety, Veracity.
question
Volume
answer
- Refers to the amount of data collected by an organization. How much data does your business need, and further, where do you keep it once you've collected it?
question
Velocity
answer
- How fast can you collect data, and more importantly, how quickly can you analyze it?
question
Variety
answer
- You may have identified what data you wish to collect, but is it Structured, Semi-structured, or Unstructured? Very likely it is a combination of all three, which could potentially throw a wrench into your data collection gears.
question
Veracity
answer
- Is the data your organization collected any good? Just because some other business amasses data you may want, doesn't necessarily make it trustable or valuable. Lots of data sources have data that is not "clean," meaning it may be too fragmented to be valuable or usable, or that it was simply collected poorly in the first place.
question
CRM
answer
Customer Relationship Management System. Contains information about an organization's sales, marketing, customer service records, and much more.
question
One more thing:
answer
Remember that most of this data is unstructured, 80% of it.
question
Data Warehouses
answer
Where an organization stores and consolidatea disparate data in a central location.
question
Datamart
answer
Limited in complexity of databases, and smaller than a Data Warehouse, but are cheaper to implement than a full warehouse.
question
ETL
answer
Extract, Transform, and Load. Used to standardize data across systems, that allow it to be queried.
question
ETL is
answer
an acronym for Extract, Transform, and Load,
question
Querying is
answer
a tool that lets you ask your data questions that in turn lead to answers, and eventually decisions.
question
Extract -
answer
Once you've determined where your data resides, you can start extracting it, often from Customer Relationship Management (CRM) or Enterprise Resource Planning (ERP) software.
question
One of ERPs main function's is
answer
to centralize an organization's data so that it ends up being a wealth of data with value across the organization.
question
Transform -
answer
Once you've extracted data, it needs to become normalized. Data is no good to you unless it's organized.
question
Normalizing data means
answer
that your data is typically organized into the fields and records of a relational database.
question
Normalizing provides
answer
the standard data format required to analyze data.
question
Load -
answer
Once data is transformed and normalized, it's ready to be finally transferred into the data warehouse or datamart.
question
The water metaphor illustrates
answer
the massive amounts of time, money, bandwidth and storage space required for ETL.
question
Hadoop
answer
an infrastructure for storing and processing large sets of data across multiple servers.
question
Map Reduce
answer
is the processing arm, or engine of Hadoop.
question
Data Analysis is
answer
basically applying statistics and logic techniques to define, illustrate, and evaluate data.
question
Data Analysis
answer
attempts to make sense of an organization's collected data and turn it into useful information and validate its future decisions, like what product to sell or whom the organization should hire.
question
Data Mining
answer
The examination of huge sets of data to find patterns and connections, and identify outliers.
question
Topic Analytics
answer
Catalogs phrases of an organization's customer feedback into relevant topics.
question
Text Analytics
answer
Searches through unstructured text data to look for useful patterns.
question
Business Analytics
answer
Attempts to make connections between data so organization's can try to predict future trends that may give them a competitive advantage.
question
The following are forms of business analytics:
answer
Descriptive Analytics, Predictive Analytics, Decision Analytics
question
Descriptive Analytics
answer
Defines an organization's past data that can be grouped into significant pieces.
question
Predictive Analytics
answer
attempts to reveal future patterns in a marketplace, essentially trying to predict the future by looking for data correlations between one thing, and any other things that pertain to it.
question
Decision Analytics
answer
builds on Predictive Analysis to make decisions about future industries and marketplaces.
question
Data Visualization
answer
Graphic display of the results of data mining, analytics and BI in general, typically in real time.
question
Dashboards
answer
Easy-to-use graphical interfaces that characterize specific data analysis through visualization.
question
What refers to the amount of data?
answer
Volume
question
What software helps BI become more usable through visualization?
answer
Dashboards
question
What allows a cluster system that allows data to be stored on multiple servers?
answer
Hadoop
question
What is a smaller Data Warehouse?
answer
Datamart
question
What kind of data resides in fixed formats?
answer
Structured
question
What attempts to reveal future patterns in the marketplace?
answer
Predictive Analytics
question
What refers to an assortment of software applications to analyze an organization's raw data?
answer
BI
question
Large collected datasets are called what?
answer
Big Data
question
What decade did businesses start DSS?
answer
1950's
question
Why is keeping enormous amounts of inventory a bad thing?
answer
It's too expensive
question
What held up the emergence of the Cloud?
answer
Internet speeds
question
In BI, what does the acronym CRM mean?
answer
Customer Relationship Management
question
In relation to BI, what does the acronym DSS mean?
answer
Decision Support System
question
What refers to how fast data is collected?
answer
Velocity
question
What refers to quality of data?
answer
Veracity
question
In BI, which of the following is not part of ETL?
answer
Transmission
question
What is another term for Data Mining?
answer
Data Discovery
question
What refers to different kinds of data?
answer
Variety
question
How much data is unstructured?
answer
80%
question
What consolidates disparate data?
answer
Data Warehouse
question
What is another term for Text Analytics?
answer
Text-Mining
question
What data is disorganized and not easily read?
answer
Unstructured
question
What is a graphical interface that characterizes specific data analysis through visualization?
answer
Dashboard
question
What provides a standard format to organize data?
answer
Normalization
question
What is Doug Cutting's son's toy elephant's name?
answer
Hadoop