Chapter 9 In Class Notes Flashcards
information
systems that process operational and other data to
identify patterns, relationships, and trends for use by
business professionals and other knowledge workers.
Business intelligence (BI) systems
patterns, relationships,
trends, or predictions
Business intelligence
The software component of a BI system is referred to
as a
BI application
Big Data
• A problem for data processing, organization and
storage
– Nonrelational data stores (a.k.a. NoSQL databases)
enter stage right. With celebrity endorsements by the
likes of Amazon (Dynamo), Google (Bigtable), and
Facebook (Cassandra), NoSQL architectures are gaining
in popularity and acceptance and are likely to have a big
impact on the BI space in the near future
BI Applications process data to produce business
intelligence via:
– Reporting
– Data Mining
– Knowledge Management
Where Does BI Data Come From?
- Operational Data
- Purchased Data (Data Vendors)
- Human Knowledge
Q1: How Do Organizations Use Business
Intelligence (BI) Systems?``
They make BI Applications that manage operational and purchased Data, and Human knowledge
What is BI used for? 4 things
Project management
problem solving
deciding
informing
Q2: What Are the Three Primary
Activities in the Business Intelligence
Process?
• Collecting Data: Obtaining, cleaning, organizing,
relating, and cataloging source data.
• Performing Analysis: Creating business intelligence
via reporting, data mining, and knowledge
management
• Publishing Results: Delivering business intelligence
to the knowledge workers who need it.
– Push publishing: BI is delivered without any request on
the part of the user (scheduled or event driven)
– Pull publishing: BI is delivered to users upon request
Push vs. Pull: Implications for BI?
• What are some suggestions for maintaining a healthy
dynamic between your reporting team and the end
users? 4 of them
– Voice of customer – Steering committee – Data sufficiency – Islands of automation and sharing of reporting information
Why Do Organizations Use Data
Warehouses and Data Marts to Acquire
Data?
• Creating reports and performing analyses from operational data is
generally not recommended
– Security and control
– Data structure is structured for fast and reliable transaction
process and not for BI analysis (one of the potential
downsides of Nonrelational database systems)
– BI analysis can be very resource intensive
• For these reasons, data is often extracted to a data warehouse
for BI analysis
Components of a Data Warehouse 3 of them
Cental is Data warehouse DBMS. 2 components coming off center are data warehouse metadata and data warehouse database
Data Warehouses
• Functions: (4 of them)
– Obtain data
– Cleanse data
– Organize and relate data
– Catalog data
Data Warehouses vs. Data Marts
• Data warehouse – Obtain data – Cleanse data – Organize and relate data – Catalog data • Data Mart: A collection of data smaller than a data warehouse that addresses the needs of a particular department or function
Q4 How Do Organizations Use Typical
Reporting Applications
Reporting applications apply reporting operations to
data to produce business intelligence.