BUS303 Study Guide

Unit 3: Using Information for Decision Making

3a. Explain the concept of business intelligence

1. Business intelligence (BI) is a vague term that combines aspects of reporting, data exploration, ad hoc queries, and sophisticated data modeling and analysis.

  • Understand analytics and how they are used to describe the extensive use of data, statistical, and quantitative analysis.
  • The benefits of BI and analysis offer organizations a competitive advantage. Understand how major corporations have used BI and analysis to grow their empire.
  • Understand the three factors necessary to make an effective decision.

2. Static reports, dynamic reports, and dating mining are the three types of business intelligence.

  • Static reports are the most common form of BI. Static reports include summarized reports laid out and printed to assist in managerial decision making.
  • Dynamic reports are similar to static reports but are online and interactive. A manager can view a summary on a dashboard and dig to expose the level of detail necessary for that report.
  • Data mining uses computer programs and statistical analysis to search for unexpected patterns, correlations, trends, and clustering in data.

 

3b. Compare and contrast system design methodologies

1. Information systems (IS) affect most management functions and are essential to competitive advantage and survival in the "new global digital economy". Organizations are under pressure and need to adapt to changes and align themselves with newly introduced information systems.

  • Understand why IS projects frequently failed and what organizations can do to turn failures around.
  • The three basic stages of a design methodology are plan, develop, and manage. Understand the definition and use of each of these stages.
  • Methodologies provide users with ways of thinking, doing, and learning.

2. Methodologies are developed and used in systems development. Each methodology differs in details and the expected work products.

  • Strategic Information Systems Planning (SISPM) seeks to integrate and align strategic objectives with an existing IS plan or business need.
  • Business Process Re-engineering (BPRM) is used to maximize corporate profitability by redesigning and transforming the organization's business processes.
  • System Development Methodologies (SDMs) are used to design different types of information systems such as transaction processing systems, enterprise information systems, decision support systems, etc.
  • Information Security Methodologies (ISM) assist organizations in establishing a security plan to address vulnerability associated with unauthorized misuse of information.

Review Information Systems Methodologies.

3. Organizations use different methodologies depending on the need of the project.

  • The waterfall methodology is the oldest and most known methodology used to coordinate the efforts of IS development.
  • Agile methodology is based on the belief that projects should be small with minimal features.
  • Understand the comparison between hard and soft methodologies.

 

3c. Analyze how data warehousing and data mining can be used as part of an organization's strategy

1. A data warehouse is a set of databases designed to support decision making in an organization. It is structured for fast online queries and exploration. Data warehouses may aggregate an enormous amount of data from many different operational systems.

  • Data warehouses and data marts are repositories for large amounts of transactional data awaiting analytics and reporting.
  • Large data warehouses are complex, can cost millions, and take years to build.
  • List issues that need to be addressed to design, develop, deploy, and maintain data warehouses and data marts.

Review Data Warehouses and Data Marts.

2. Data mining is the process of discovering new patterns from large data sets.

  • Data mining starts with "Knowledge Discovery in Database". Data mining is one of the steps in the process of knowledge discovery in a database.
  • Understand the five steps in the knowledge discovery process.
  • Understand the key areas where businesses are leveraging data mining.
  • Data mining tools help spot underlying trends in modern data sets.

Review The Data Asset: Databases, Business Intelligence, and Competitive Advantage, Business Intelligence Analysis of App Sales Data, and Data Mining: A Simple Guide for Beginners.

 

Unit 3 Vocabulary

This vocabulary list includes terms that might help you answer some of the review items above and some terms you should be familiar with to be successful in completing the final exam for the course.

  • Datamart
  • Data mining
  • Data warehouse
  • Knowledge discovery in database
  • Methodology
  • Strategic Information Systems Planning (SISPM)
  • Business Process Re-engineering (BPRM)
  • System Development Methodologies (SDMs)
  • Information Security Methodologies (ISM)
  • Business Process Re-engineering
  • Agile
  • Waterfall
  • Formalized methodologies
  • Method engineering
  • Transformational projects
  • Methods
  • Problem situation
  • Problem-solving processing
  • Hard methodologies
  • Soft methodologies
  • Ad-hoc methodologies