Week 11 Flashcards
What do business intelligence systems do?
Summarize large data sets to understand what’s happening
Business intelligence is the process of _________ data to put together a picture of what is going on in a business
collecting
Business intelligence vs Data Analytics
BI describes past occurrences using data, future decisions can be made based on this
Data Analytics predicts the future
Name this type of BI Decision:
Short-term decisions taken frequently
Administrative decision
Name this type of BI Decision:
Use information to make better decisions
Strategic decision
Name this type of BI Decision:
Helps identify processes to optimize
Operational decision
Name the timeline/frequency of purpose of this BI decision: Strategic
Long-term decisions, deal with organizational growth
Name the timeline/frequency of purpose of this BI decision: Administrative
Daily decisions, deal with the welfare of the employees
Name the timeline/frequency of purpose of this BI decision: Operational
Not frequent, related to production and factory growth
Name the 4 main components of BI systems:
- Data warehouses
- Business Analytics tools
- Business performance tools
- Visualization
Which component of BI systems does this: manipulates and analyzes data
Business Analytics tools
Which component of BI systems does this: monitors and analyzes performance
Business performance tools
Which component of BI systems does this: shows portals, dashboards, scorecards
Visualization
How often is a data warehouse typically updated?
Daily
Name this: Pulls data from inventory, sales, etc. so that an overall picture can be created to support decision
Data warehouse
ETL stands for
Extract, Transform, Load
Name this ETL process: pulls data from its raw source
Extraction
Name this ETL process: manipulates the data to convert it to the format you want
Transform
Name this ETL process: stores the data in the final target (DW or DM)
Load
What is a data mart? What is stored there?
A mini data warehouse. Typically 1 portion of the warehouse (sales, marketing, finance). Each department an organization has their own mart.
A data mart is extracted from a data warehouse, what is its advantage?
Can store summarized data rather than raw data
Name this: This system processes any type of transaction, it’s always running, it’s fast and maintains data integrity
Online Transaction Processing System (OLTP)
Name this: This system is used to operate long-running queries, looking for patterns in data. Does data mining, business reports, etc.
Online Analytical Processing (OLAP)
What type of operations does OLTP use?
Mostly INSERT, UPDATE, DELETE
Is this an OLAP or OLTP query?
SELECT PASSWORD FROM ACCOUNTS
WHERE USERID = 1234;
OLTP
Is this an OLAP or OLTP query?
SELECT PRODUCT, SALES
RANK() OVER (ORDER BY SALES ASC),
FROM SALES
ORDER BY SALES
OLAP
T/F - Normal company staff use OLAP systems
False. Normal company staff use OLTP systems
T/F - Specialized users use OLAP systems
True, it provides them summarized data to analyze the business
T/F - OLAP works on current data
False. OLTP uses current data, OLAP uses historical
