Chapter 1 Flashcards
Types of Business Analytics
Descriptive
Predictive
Prescriptive
Descriptive Business Analytic: Questions
What happened?
What is happening?
Descriptive Business Analytic: Enablers
- Business Reporting
- Dashboards
- Scoreboards
- Data warehousing
Descriptive Business Analytic: Outcomes
well-defined business problems and opportunities
Predictive Business Analytic: Questions
What will happen?
Why will it happen?
Predictive Business Analytic: Enablers
- Data mining
- Text mining
- Web/media mining
- Forecasting
Predictive Business Analytic: Outcomes
Accurate projections of future events and outcomes
Prescriptive Business Analytic: Questions
What should I do?
Why should I do it?
Prescriptive Business Analytic: Enablers
- Optimization
- Simulation
- Decision modeling
- Expert systems
Prescriptive Business Analytic: Outcomes
Best possible business decisions and actions
Define data wharehouse
- collection of databases storing content and historical data
- “single version of truth”
What are the components of data warehousing process?
- data sources
- ETL Process
- Enterprise data warehouse
- Metadata
- Data mart
- API/Middleware tools
OLTP: Purpose
to carry out day-to-day business functions
OLTP: Data source
- transaction database
- a normalized data repository
- focused on efficiency and consistency
OLTP: Reporting
- routine
- periodic
- narrowly focused