Info Systems 2/18/25

Business Intelligence Overview

  • Definition of Business Intelligence (BI):

    • Refers to the technologies and strategies used by enterprises for data analysis of business information.

    • Helps in transforming raw data into meaningful insights for effective decision-making.

  • Key Purpose of Business Intelligence:

    • To uncover patterns in data.

    • Identify opportunities and potential issues in a business context.

    • Supports management in making informed predictions about future market trends and customer behavior.

  • Data Processing in BI:

    • Raw data is analyzed to extract business intelligence.

    • Understanding 'who bought what’ to refine target marketing strategies.

  • Relevance of Data:

    • Data collected must be pertinent; oftentimes, incoming data can be incomplete or irrelevant.

Tools and Systems in BI

  • Access Database:

    • Not typically used for massive data warehouses.

    • Suitable for smaller datasets, managing and accessing operational data.

  • Microsoft Excel:

    • Essential tool for data recording, calculations, and data analysis in scientific and financial contexts.

    • Users can utilize Excel for business projects, including data manipulation through formulas and functions.

  • Excel Functions:

    • Users write and implement formulas for calculations, critical when dealing with large or medium-sized datasets.

    • Excel simplifies computations by allowing users to drag formulas across cells, automating repetitive calculations.

Assignments and Resources

  • Project Instructions:

    • Business unit projects located in the D2L platform under Module 3.

    • Access lecture PowerPoints for detailed review of pertinent information related to the coursework.

  • Step-by-Step Guidance:

    • Instructions divided into parts (steps 1-10, 11-20, 21-25) to facilitate the Excel project.

    • Encouragement to ask questions about formula usage and functionality.

  • Downloading Resources:

    • Students are instructed to download the project and accompanying files for personal or classroom computers.

    • Importance of saving files in accessible locations (e.g., OneDrive) to ensure smooth workflow for the project.