ITEC39 Flashcards
It is a collective information that gives you the ability to make effective, important, and strategic business decisions.
Business Intelligence
It is the science of fact-based decision making.
Analytics
OLTP stands for?
Online Transaction Processing
OLAP stands for?
Online Analytical Processing
It is the collection of information that you organize and access according to the logical structure of the information.
Database
The series of logically related two-dimensional tables or files for storing information.
Relational Database
The field (or group of fields) that uniquely describes each record.
Primary Key
The primary key of one file that appears in another file.
Foreign Key
It helps you specify the logical requirements for a database and access and use the information in a database
Database Management System (DBMS)
5 Components of DBMS
- DBMS engine
- Data definition subsystem
- Data manipulation subsystem
- Application generation subsystem
- Data administration subsystem
It is the collection of information
(from many places) that supports business analysis activities and decision making.
Data Warehouse
Analytics Life Cycle
- Gather analytics needs
- Find the data
- ETL
- Mine the data
The subset of a data warehouse in
which only a focused portion of the data warehouse information is kept.
Data Mart
Decision and Decisions Support
- Intelligence
- Design
- Choice
- Implementation
A highly flexible and interactive system that is designed to support decision making when the problem is not structured.
Decisions Support System (DSS)
DSS designed specifically to analyze spatial information.
Geographic Information System (GIS)
The Tool Set of the Analytics Professional
- Query and Reporting Tools
- Artificial intelligence
- Multidimensional Analysis Tools
- Digital Dashboard
- Statistical Tools
A highly computational data mining technology that uses information and business intelligence to build a predictive model for a given business application.
Predictive Analytics
Uses of Predictive Analytics
- Insurance
- Retail
- Healthcare
- Travel
- Financial services
- CRM
- SCM
- Credit scoring
It uses statistical, AI, and linguistic technologies to convert textual information into structured information.
Text Analytics
The science of making machines imitate human thinking and behavior, can replace human decision making in some instances.
Artificial Intelligence
An artificial intelligence system that applies reasoning capabilities to reach a conclusion.
Expert System
An artificial intelligence system that is capable of finding and differentiating patterns.
Neural Network
A mathematical method of handling
imprecise or subjective information, like “short” or “tall”.
Fuzzy Logic
