logo image Write My Paper

INFS Quiz 3 Chapter 9 Business Intelligence and Data Mining

online transaction processing (OLTP)
updating (i.e. inserting, modifying and deleting), retrieving and presenting data from databases for operational purposes
online analytical processing (OLAP)
querying and presenting data from data warehouses and/or data marts for analytical purposes
OLAP/BI Tools
designed for analysis of data in data warehouses and data marts

allow users to retrieve needed date from data warehouses and data marts by using simple point-and-click mechanisms

the tool writes and executes the code in the language of the DBMS that hosts the data warehouse or data mart that is queried

OLAP/BI Tools Functionalities
basic OLAP/BI tool features:
-slice and dice
-pivot (rotate)
-drill down/ drill up

data visualization- graphically visualizing the answers

additional functionalities:
-creating and examining calculated data
-determining comparative or relative differences
-performing exception analysis, trend analysis, forecasting and regression analysis
-number of other analytical functions

OLAP
accessing data in data warehouses and data marts
use OLAP/BI tools for direct access

use front-end/BI applications for indirect access

use executive dashboards for a quick glance at the data

data mining
discovering novel and interesting patters in large amounts of data

is an interception of database management, artificial intelligence (machine learning), and statistics

*predictive analysis- using past data to predict future events

market basket analysis

(aka association rule mining)

-finds groups of items that tend to appear together in transactions
-association rule: X –> Y
correlations are expressed in the form:
“transactions that contain X are likely to contain Y as well”
-measures:
SUPPORT & CONFIDENCE
market basket analysis
“SUPPORT”
(number of transactions containing X&Y/ number of transactions total)

measures the significance of the rule

market basket analysis
“CONFIDENCE”
(number of transactions containing X&Y/ number of transactions containing X)

measures the strength of the correlation, so rules with low confidence are not meaningful, even if their support is high

business intelligence
a broad terms encompassing analytical use of data

incorporates various methods that give companies ability to discover and utilize information they already own and turn it into the knowledge that directly impacts corporate performance

business intelligence software
enables business users to see and use (analyze) large amounts of complex data

Need essay sample on "INFS Quiz 3 Chapter 9 Business Intelligence and Data Mining"? We will write a custom essay sample specifically for you for only $ 13.90/page

Can’t wait to take that assignment burden offyour shoulders?

Let us know what it is and we will show you how it can be done!

Emily from Businessays

Hi there, would you like to get such a paper? How about receiving a customized one? Check it out https://goo.gl/chNgQy

We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy close