INFS Quiz 3 Chapter 9 Business Intelligence and Data Mining – Flashcards

updating (i.e. inserting, modifying and deleting), retrieving and presenting data from databases for operational purposes

querying and presenting data from data warehouses and/or data marts for analytical purposes

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

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

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

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

-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

(number of transactions containing X&Y/ number of transactions total) measures the significance of the rule

(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

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

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