Podcast
Questions and Answers
What is a significant change in the evolution of Business Intelligence that occurred in the 2000s?
What is a significant change in the evolution of Business Intelligence that occurred in the 2000s?
- Development of Data Warehousing
- Use of Dashboards and Scorecards (correct)
- Introduction of Executive Information Systems
- Implementation of Decision Support Systems
Which term best describes the concept that provides actionable insight derived from information?
Which term best describes the concept that provides actionable insight derived from information?
- Knowledge (correct)
- Information
- Wisdom
- Data
Which of the following components is part of the Business Intelligence (BI) process?
Which of the following components is part of the Business Intelligence (BI) process?
- Cloud Computing
- Performance Management (correct)
- Big Data
- Transactional Processing
What was the focus of Business Intelligence systems in the 1990s?
What was the focus of Business Intelligence systems in the 1990s?
What does the acronym DIKW stand for in the context of Data Science?
What does the acronym DIKW stand for in the context of Data Science?
Which company had the highest market share in the BI market in 2013?
Which company had the highest market share in the BI market in 2013?
What was the revenue growth percentage for Microsoft in 2013?
What was the revenue growth percentage for Microsoft in 2013?
Which position is NOT typically associated with BI careers?
Which position is NOT typically associated with BI careers?
What revenue did the 'Others' category achieve in the BI market in 2013?
What revenue did the 'Others' category achieve in the BI market in 2013?
Which of the following is included in the 'big four' BI vendors?
Which of the following is included in the 'big four' BI vendors?
What challenge is primarily associated with information overloading?
What challenge is primarily associated with information overloading?
What is a characteristic of structured data?
What is a characteristic of structured data?
Which of the following is an example of unstructured data?
Which of the following is an example of unstructured data?
What type of data is referred to as numerical data?
What type of data is referred to as numerical data?
What kind of data is primarily stored in transactional systems?
What kind of data is primarily stored in transactional systems?
External data can provide insights about which of the following?
External data can provide insights about which of the following?
What characteristic defines qualitative data?
What characteristic defines qualitative data?
What problem does 'spreadmart' refer to in data management?
What problem does 'spreadmart' refer to in data management?
What is the main purpose of ETL in data processing?
What is the main purpose of ETL in data processing?
Which of the following best describes the 'Transformation' step in ETL?
Which of the following best describes the 'Transformation' step in ETL?
Who are considered super or power users in BI applications?
Who are considered super or power users in BI applications?
Which application area focuses on analyzing customer behavior?
Which application area focuses on analyzing customer behavior?
What type of data formats do operational databases commonly use?
What type of data formats do operational databases commonly use?
Which of the following is NOT a component of BI reporting?
Which of the following is NOT a component of BI reporting?
What is a key use of BI in healthcare management?
What is a key use of BI in healthcare management?
Which of the following describes distributed data?
Which of the following describes distributed data?
What is the primary function of Business Intelligence?
What is the primary function of Business Intelligence?
Which of the following statements best defines Business Intelligence?
Which of the following statements best defines Business Intelligence?
What is the difference between transactional processing and analytical processing?
What is the difference between transactional processing and analytical processing?
How does Business Intelligence relate to knowledge management?
How does Business Intelligence relate to knowledge management?
What is typically involved in the creation of a Business Intelligence system?
What is typically involved in the creation of a Business Intelligence system?
Which tool is an example of a front-end analytical tool in Business Intelligence?
Which tool is an example of a front-end analytical tool in Business Intelligence?
What is the role of a data warehouse in Business Intelligence?
What is the role of a data warehouse in Business Intelligence?
Which statement accurately reflects a key aspect of Business Intelligence?
Which statement accurately reflects a key aspect of Business Intelligence?
What is an essential technical knowledge required for Business Intelligence?
What is an essential technical knowledge required for Business Intelligence?
Which ability is important for translating business requirements into technical specifications?
Which ability is important for translating business requirements into technical specifications?
Which of the following is NOT a critical skill for effective communication in a business intelligence context?
Which of the following is NOT a critical skill for effective communication in a business intelligence context?
What is one of the roles of a professional working in Business Intelligence?
What is one of the roles of a professional working in Business Intelligence?
Which of the following describes a key aspect of the BI project lifecycle?
Which of the following describes a key aspect of the BI project lifecycle?
What does knowledge of data and information policies ensure in Business Intelligence?
What does knowledge of data and information policies ensure in Business Intelligence?
Effective communication within a business intelligence framework primarily involves which skill?
Effective communication within a business intelligence framework primarily involves which skill?
What should be the focus when managing database system implementation in BI?
What should be the focus when managing database system implementation in BI?
Flashcards
Data
Data
Raw facts or values collected before any processing. Think of it as the basic building blocks of information.
Information
Information
Organized, structured data that provides context and meaning. It turns raw data into something understandable.
Knowledge
Knowledge
The ability to apply knowledge and understanding to a situation, making it useful and actionable. It's about turning information into insights.
Wisdom
Wisdom
Signup and view all the flashcards
Analytical Processing
Analytical Processing
Signup and view all the flashcards
What is Business Intelligence?
What is Business Intelligence?
Signup and view all the flashcards
Data Processing in BI
Data Processing in BI
Signup and view all the flashcards
Transactional Processing
Transactional Processing
Signup and view all the flashcards
Data Warehouse
Data Warehouse
Signup and view all the flashcards
Data Mart
Data Mart
Signup and view all the flashcards
Analytical Tools
Analytical Tools
Signup and view all the flashcards
Intelligence from Data
Intelligence from Data
Signup and view all the flashcards
Information Overloading
Information Overloading
Signup and view all the flashcards
Data Everywhere
Data Everywhere
Signup and view all the flashcards
Difficulty of Access
Difficulty of Access
Signup and view all the flashcards
Structured Data
Structured Data
Signup and view all the flashcards
Unstructured Data
Unstructured Data
Signup and view all the flashcards
Numeric Data
Numeric Data
Signup and view all the flashcards
Textual Data
Textual Data
Signup and view all the flashcards
Internal Data
Internal Data
Signup and view all the flashcards
External Data
External Data
Signup and view all the flashcards
Mega-vendors in BI
Mega-vendors in BI
Signup and view all the flashcards
Gartner Magic Quadrant
Gartner Magic Quadrant
Signup and view all the flashcards
BI Tools and Systems Framework
BI Tools and Systems Framework
Signup and view all the flashcards
BI Solution Architects
BI Solution Architects
Signup and view all the flashcards
Business and BI Analysts
Business and BI Analysts
Signup and view all the flashcards
Operational Database
Operational Database
Signup and view all the flashcards
BI Applications
BI Applications
Signup and view all the flashcards
BI Reporting and Delivery
BI Reporting and Delivery
Signup and view all the flashcards
Power User
Power User
Signup and view all the flashcards
Average User
Average User
Signup and view all the flashcards
Data Extraction in ETL
Data Extraction in ETL
Signup and view all the flashcards
Data Transformation in ETL
Data Transformation in ETL
Signup and view all the flashcards
What is data warehousing?
What is data warehousing?
Signup and view all the flashcards
What is data analytics?
What is data analytics?
Signup and view all the flashcards
What is data mining?
What is data mining?
Signup and view all the flashcards
What is data science?
What is data science?
Signup and view all the flashcards
What is the role of "business and user requirements" in BI?
What is the role of "business and user requirements" in BI?
Signup and view all the flashcards
What is the importance of a "BI project lifecycle and management"?
What is the importance of a "BI project lifecycle and management"?
Signup and view all the flashcards
What is the importance of "understanding information flow in an organization" for BI?
What is the importance of "understanding information flow in an organization" for BI?
Signup and view all the flashcards
Study Notes
Lecture 1: Business Intelligence Introduction
- OSCM 603: Business Intelligence
- Lecture 1, Introduction
- Instructor: Prof. Awuni Emmanuel
- Topics include: BI process, system components, technologies and applications, Types of Data, BI industry, market and career overview
- Business Intelligence is a set of methods, processes, architectures, applications and technologies utilized to gather and transform raw data into useful, meaningful information.
- This information is used to furnish more strategic, tactical and operational insights for a business. This drives business operations and growth.
- Data is the raw elements that form the foundation of information, knowledge and wisdom.
- Information is the result of collecting and organizing data in a structured context.
- Knowledge is the understanding of information. This allows for useful and actionable data that leads to knowledge.
- Wisdom is the best practice in decision making.
- This is the most effective way to employ information, knowledge and data for sound decision making.
Overview
- BI process, system components, technologies and applications
- Types of Data
- BI industry, market, and career overview
Introduction: Evolution of BI
- 1980s: Search for perfect “business insight system”
- Executive information systems (EIS), Decision support systems (DSS)
- 1990s:
- Data warehousing (DW), Business intelligence (BI)
- 2000s:
- Dashboards and scorecards, Performance management
- 2010+:
- Big data, Mobile BI, Personal BI, etc.
- Capabilities increased with new iterations.
- Enterprises became sophisticated; computational and analytical needs increased and computer hardware and software matured.
Data Processing Types
- Transactional Processing: Focuses on routine processing, modification, insertion, deletion and transmission of data.
- Analytical Processing: Focuses on reporting, analysis, transformation and decision support focused on reporting.
Business Intelligence
- One ultimate use of data gathered and processed in the data life cycle—to drive business intelligence.
- This is about the creation or use of a data warehouse or data mart for data storage.
- Tools like Oracle's Sales Analyzer, Financial Analyst, or Micro Strategy's Web are used.
- These tools enable access to data, enable querying, support ad-hoc reports, and support the examination of scenarios and the creation of CRM activities, and strategic pricing strategies.
How Business Intelligence Works
- Begins with raw data stored in corporate databases.
- Example: a national retail chain's data about inventory, customer information, promotions, and sales numbers.
- Information may be scattered; BI software integrates this data.
- Data is placed into a data warehouse (or mart).
- Tables are linked, and data cubes are formed (linked to sales numbers and customer databases, enabling deep analysis).
BI System at a Glance
- Operational systems
- Data warehouse
- ETL tools
- Logistics
- Marketing
- Performance evaluation
- Multidimensional cubes
- Exploratory data analysis
- Time series analysis
Assignment
- Data warehouse
- Data Analytics
- Data mining
- Data science
Next Week: Data Warehousing
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.