MIS Chapter 9 Business Intelligence – Flashcards
Unlock all answers in this set
Unlock answersquestion
Business Intelligence System
answer
Information systems that searches vast amount of data to find information, analyze past performance, and make predictions
question
Data Marts
answer
mini data warehouse that holds subsets of data from the data warehouse
question
Challenges to BI
answer
Poor quality, context, user resistance
question
Typical uses of BI
answer
-Changes in purchasing pattern -Entertainment -*Predictive Policing
question
3 Primary activities in the BI Process
answer
1. Acquire Data 2. Perform Analysis 3. Publish Results
question
Primary Activity in BI: Data Acquisition
answer
process of obtaining, cleaning, organizing, relating and cataloging source data
question
Primary Activity in BI: Perform Analysis
answer
process of creating BI. Three fundamental categories of BI analysis are reporting, data mining and BigData
question
Primary Activity in BI: Publish Results
answer
process of delivering BI to users to the knowledge workers who need it. Push publishing delivers BI to users w/o any request from the users (according to schedule). Pull Publishing requires users to request BI results
question
Functions of a Data warehouse
answer
- Extract data from operational, internal and external databases - Cleanse data - Organize, relate data warehouse - Catalog data using metadata
question
3 Techniques for processing BI data
answer
1) reporting analysis ---create info about past performance 2) Data Mining---classify and predict 3) Big Data---find patterns and relationships in big data
question
BI Processing technique: Reporting
answer
Goal: create info about past performance -Process is structured by 1) sorting 2) filtering 3) grouping 4) calculating 5) formatting
question
BI Processing technique: Data Mining (goal and what it is)
answer
Goal: classify and predict -software that searches through data to create trends, patterns, correlations (finds patterns and relationships)
question
Unsupervised Data Mining
answer
analysts do not create a model or hypothesis before running the analysis. They simply apply the technique to the data and observe the results (ex: cluster analysis)
question
Supervised Data Mining
answer
data miners develop a model prior to the analysis and apply statistical techniques to data to estimate parameters of the model (ex: regression analysis y=mx+b)
question
BI Processing technique: Big Data
answer
Goal: find patterns and relationships in big data -Term used to describe data collections that are characterized by huge volume (petabyte in size), rapid velocity (generated rapidly), and great variety (free-form text)
question
MapReduce
answer
• Technique for harnessing the power of thousands of computers working in parallel • Basic idea is that the BigData collection is broken into pieces, and hundreds or thousands of independent processors search these pieces for something of interest
question
Hadoop
answer
• An open source program that manages thousands of computers that implements MapReduce
question
3 Alternatives for publishing BI
answer
• Static Reports • Dynamic Reports • Subscriptions
question
Static Reports
answer
BI documents that are fixed at the time of creation and do not change (ex: a printed sales analysis)
question
Dynamic Reports
answer
BI documents that are updated at the time they are requested. Publishing a dynamic report requires the BI application to access a database or other data source at the time the report is delivered to the user
question
Subscriptions
answer
user requests for particular BI results on a particular schedule or in response to particular events
question
2 Functions of a BI server
answer
1) Management function maintains metadata about the authorized allocation of BI results to users. Server tracks what results are available, what users are authorized to view those result, and the schedule upon which the results are provided to the authorized users 2) Delivery function allows BI servers to use metadata to determine what results to send to which users and, possibly, on which schedule
