Please enter something
Home Page Flashcards INFS Quiz 3 Chapter 9 Business Intelligence and Data Mining - Flashcards

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

Patrick Marsh
8 July 2022
11 test answers

Unlock all answers in this set

Unlock answers 11
question
online transaction processing (OLTP)
answer
updating (i.e. inserting, modifying and deleting), retrieving and presenting data from databases for operational purposes
question
online analytical processing (OLAP)
answer
querying and presenting data from data warehouses and/or data marts for analytical purposes
question
OLAP/BI Tools
answer
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
question
OLAP/BI Tools Functionalities
answer
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
question
OLAP accessing data in data warehouses and data marts
answer
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
Unlock the answer
question
data mining
answer
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
Unlock the answer
question
market basket analysis (aka association rule mining)
answer
-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
Unlock the answer
question
market basket analysis "SUPPORT"
answer
(number of transactions containing X&Y/ number of transactions total) measures the significance of the rule
Unlock the answer
question
market basket analysis "CONFIDENCE"
answer
(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
Unlock the answer
question
business intelligence
answer
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
Unlock the answer
question
business intelligence software
answer
enables business users to see and use (analyze) large amounts of complex data
Unlock the answer
Get an explanation on any task
Get unstuck with the help of our AI assistant in seconds
New
Get unstuck with AI assistant right now
  • Enter your topic/question
  • Receive an explanation
Pro tips to get quality response
  • Ask one question at a time
  • Enter a specific assignment topic
  • Aim at least 500 characters
Question
What is the right structure for an essay
Answer
A paragraph is a related group of sentences that develops one main idea. Each paragraph in the body of the essay should contain:
  • a topic sentence that states the main or controlling idea
  • supporting sentences to explain and develop the point you’re making
  • evidence from your reading or an example from the subject area that supports your point
  • analysis of the implication/significance/impact of the evidence finished off with a critical conclusion you have drawn from the evidence.