Certificate Program in Business Intelligence

Course Descriptions

BINT1001
Introduction to Data Warehouses and Business Intelligence

Description
This course provides an introduction to Business Intelligence.  It first introduces the student to databases and data warehouses.  It then presents tools and methods for conceptualizing and modeling data.  It then shows how a database can be transformed into a data warehouse.  It shows how queries can be used to retrieve data from both a database and a data warehouse.  All examples and exercises are based on MS Access.  The major topics are the following:
  1. Databases vs. data warehouses
  2. Conceptualizing and modeling of data
  3. Retrieving data from databases
  4. Retrieving data from data warehouses
  5. Uses of data warehouses
 
 
Learning Outcomes
  1. Databases vs. data warehouses
    1. Students will compare the structure, purpose, and technical characteristics of databases and data warehouses.
  2. Conceptualizing and modeling of data
    1. Students will distinguish a database model from a data warehouse model and explain how they differ.
    2. Students will read a database model and translate it into business terms.
    3. Students will read a data warehouse model and translate it into business terms.
  3. Retrieving data from databases
    1. Students will define Query-by-Example (QBE).
    2. Students will use QBE to answer management questions.
  4. Retrieving data from data warehouses
    1. Students will use QBE to answer data warehouse questions.
  5. Uses of data warehouses
    1. Students will explain how Business Intelligence (BI) is used in different industries.
    2. Students will explain how BI is used in different business functions.
 
 
 
 
 
 
 

BINT1002
Introduction to Data Analysis

Description
This course provides an overview of how MS Excel can be used as a Business Intelligence and decision support tool.  It examines issues of data presentation and visualization, statistical and predictive analysis, MS PowerPivot, and pivot tables.  The major topics are the following:
  1. Statistical concepts relevant to Business Intelligence
  2. Using Excel for queries with a databases and a data warehouse
  3. Using Excel’s BI tools such as PowerPivot and tables
  4. Finding optimal solutions for various business problems
  5. Statistical techniques for predictive analytics
 
 
Learning Outcomes
  1. Statistical concepts relevant to BI
    1. Students will define basic statistical terms and concepts – probability, population vs. sample, random variable, mean/mode/median, standard deviation, variance, regression analysis, multivariate analysis, Bayesian analysis, etc.
    2. Students will set up statistical problems and solve them with Excel functions.
  2. Excel queries with a database and a data warehouse
    1. Students will connect Excel to an Access query.
    2. Students will copy and paste query results from Access into Excel.
  3. Excel PowerPivot and tables
    1. Students will explain the relationship between a pivot table and a fact table with dimensions.
    2. Students will integrate data from a various sources, including corporate databases, spreadsheets, reports, text files, etc.
    3. Students will manipulate all the elements of a pivot table – rows and columns, stacked rows and columns, cells, the math and statistical operations on cells, and filters.
  4. Finding optimal solutions for various business problems
    1. Students will learn to model business problems in Excel.
    2. Students will use Excel Solver for finding optimal solutions to business problems such as maximizing profit or minimizing cost.
  5. Statistical techniques for predictive analysis
    1. Students will perform simple and multiple regression analysis on large data sets.
    2. Students will create forecasting models using moving averages and exponential smoothing.
 
 
 
 

BINT1003
Business Intelligence in Action

Description
This course is a capstone to the certificate program.  It causes the student to integrate and apply the concepts and techniques from the first two courses by using the BI tools that come with MS SQL Server Enterprise.  The course does not focus on the technology of SQL Server; instead, it concentrates on the data and the tools for analyzing it. The course also provides an overview of the design, implementation, and management of a data warehouse.  The major topics are the following:
  1. The different types of data structures used in data warehouses
  2. The management of data warehouses (e.g., extract/transform/load, security, and backup)
  3. Microsoft BI tools in SQL Server Enterprise
  4. Techniques for discovering patterns in the data (e.g., clusters, categories, market basket analysis)
  5. Techniques for forecasting outcomes (e.g., predictive analysis)
 
 
Learning Outcomes
  1. Data warehouse structures
    1. Students will explain the differences between database architecture and data warehouse architecture.
    2. Students will define terms like star, fact table, dimension, and snowflake.
    3. Students will convert a database data model to a data warehouse data model.
  2. Management of data warehouses
    1. Students will define the data integrity issues of a data warehouse.
    2. Students will define the data security issues of a data warehouse.
    3. Students will define the data storage issues of a data warehouse.
  3. Microsoft BI tools
    1. Students will define the differences among the various Microsoft BI tools.
    2. Students will apply BI tools to a large data set retrieved from a warehouse.
  4. Analysis techniques
    1. Students will apply Microsoft tools for cluster analysis.
    2. Students will define the technique of cluster analysis.
    3. Students will apply Microsoft tools for predictive analysis.
    4. Students will define the technique of predictive analysis.
    5. Students will apply Microsoft tools for market basket analysis.
    6. Students will define the technique of market basket analysis.