Terms in this set (54)
BI is an umbrella term that combines:
architectures, tools, databases, data warehouses, analytical tools, applications, and methodologies.
BI system has four major components:
a data warehouse, business analytics, business performance management, and user interface
is the cornerstone of any BI system. Originally, the data warehouse included only historical data that were organized and summarized, so end users could easily view or manipulate data and information for decision making. Nowadays, some data warehouse also include current data as well, so they can make real-time decision support.
end users can work with the data and information in a data warehouse by using a variety of tools and techniques. These tools fit into two major categories:
1. Reports and queries. Business analytics include static and dynamic reporting all types of queries, discovery of information, multi-dimensional view, drill down to details, and so on.
2. Data, text, and web mining and other sophisticated mathematical and statistical tools. Data mining is a process of searching for unknown relationships or information in large databases or data warehouse, using intelligent tools such as neural computing, predictive analytics technique, or advanced statistical methods.
Business performance management
is an emerging portfolio of applications and methodology that contains evolving BI architecture and tools in its core. It embraces processes such as planning and forecasting as core tenets of a business strategy. BPM usually combined with balanced scoreboard methodology and dashboards.
The user interface
dashboards and other information broadcasting tools. Dashboards provide a comprehensive visual view of corporate performance measures, trends, and exceptions. They integrate information from multiple business areas.
Dashboards present graphs that show actual performance compared to desired metrics; thus, a dashboard presents an at-a-glance view of the health of the organization.
In addition to dashboards, other tools that broadcast information are corporate portals, digital cockpits, and other visualization tools. Many visualization tools ranging from multi-dimensional cube presentation to virtual reality, are integral parts of BI systems.
BI's major objective is:
to enable easy access to data (and models) to provide business managers with the ability to conduct analysis.
transform data, to information (and knowledge), to decisions, and finally to action.
The term BI was coined by the Gartner Group in the mid-1990s.
By 2005, BI systems started to include artificial intelligence capabilities and powerful analytical capabilities and powerful analytical capabilities.
capacity for learning, reasoning, understanding, and similar forms of mental activity.
The science of logical analysis
is an advance discipline within business intelligence
The BI system has four major components:
1. data warehouse
2. business analytics
3. business performance management
4. user interface
is the cornerstone of any BI system. Originally, the data warehouse included only historical data that were organized and summarized, so end users could easily view or manipulate data and information for decision-making. Now, some data warehouses also include current data and can make real-time decision support.
A process that uses statistical, mathematical, and artificial intelligence techniques to extract and identify useful information and subsequent knowledge from large sets of data.
1. prediction (classification, regression)
Both web mining and text mining:
are the derivatives of data mining.
Text mining is:
the semi-automated process of extracting patterns from large amounts of unstructured data sources.
Web mining is:
the process of discovering intrinsic relationships from web data, which are expressed in the form of textual, linkage, or usage.
raw facts that describe the characteristics of an event or object
data converted into a meaningful and useful context
1. Transactional information (a sale record, a receipt)
2. Analytical information (product statistics, sales prediction)
real time information (immediate, up-to-date)
1. Data inconsistency
2. Data integrity
Availability, usability, integrity, security
maintains information about various types of objects, events, people and places.
A database management system
creates, reads, updates, and deletes data in a database while controlling access and security.
Tools for retrieving information from DBMS
1. Query-by-example tool: helps users graphically design the answer to a question against a database.
2. Structured Query Language (SQL): asks users to write lines of code to answer questions against a database.
Data element (data field)
1. Is the smallest or basic unit of information.
2. Name, address, email, product name etc.
Logical data structures that detail the relationships among data elements using graphics or pictures
1. Provides details about data.
2. Metadata for an image could include its size, resolution etc.
Compiles all of the metadata about the data elements in the data model.
A relational database model stores information in the form of logically related two-dimensional tables.
Stores information about a person, place, thing, transaction, or event.
(columns or fields) are the data elements associated with an entity
Is a field or group of fields that uniquely identifies a given record in a table.
Is 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.
What are the two primary Tableau benefits?
Visualization of data and Speed of analysis
a record (row)
is a collection of related data elements
Visualization of data
1. Tableau excels at displaying data visually.
2. Tableau's core purpose is to help you draw conclusions from your data visually.
Speed of analysis
Analyzing data in Tableau is incredibly fast (assuming you present Tableau with a well-performing data source).
Once you master the basic paradigm of the Tableau data pane, shelves, and cards, you can literally answer your "what-if" and "how" questions as quickly as you can think of them.
Standard Tableau Workbook (.twb file)
This workbook contains worksheet and dashboard definitions only. Any data sources and external files (custom background images, image files in dashboards, and so forth) are not saved in the .twb file.
Tableau Packaged Workbook (.twbx file)
A packaged workbook is a self-contained workbook with any necessary external files embedded in it.
It contains worksheet and dashboard definitions, as well as file-based data sources, image files, custom shapes, and any other external files necessary to interact with any sheet or dashboard.
are non-number fields that categorize data.
are numeric fields that are aggregated as sums, averages, and so forth for each occurrence of the categorized dimension.
is unique to Tableau, and refers to a particular part of the worksheet where you can drag and drop a field from the
is a single area of the workspace that allows you to customize display of that chart "marks" (bars, circles, shapes, and so forth) that make up your chart.
What is descriptive statistics?
1. is the discipline of quantitatively describing the main features of a collection of data.
2. Numbers that summarize a group of data.
Frequency, min, max, mean (average), standard deviation (variance), median, mode etc.
What is bar chart?
1. categorical data
What is pie chart?
1. categorical data (if not many data)
What is line chart?
1. time series data
What is scatter plot?
correlation between two series of quantitative values
What is histogram?
1. data frequency
What is pivot table?
What is PowerPivot?
YOU MIGHT ALSO LIKE...
Test Preparation TOEIC, SAT, TOEFL
ISOM Chapter 6
Data Warehousing Questions
Advanced Database ch13 Business Intelligence and Datawarehouse
OTHER SETS BY THIS CREATOR
Foundation Exam part 2
Foundation Exam part 1
ITIL Terms and Concepts
THIS SET IS OFTEN IN FOLDERS WITH...
SCSM 451 Midterm review
MIS 390 exam 3
Chapter 1- Introduction to Business Intelligence