Programs

Business Intelligence

On this page:

Certificate of Achievement Business Intelligence Developer

Brief Description

Intended to prepare students for entry and mid-level positions developing Business Intelligence (BI) systems. Students design, create and move data to multi-dimensional online analytical processing (OLAP) databases using dimensional modeling tools. The certificate covers skills needed to create predictive queries using data mining techniques.

Learning Outcomes

Certificate recipients should possess the skills and abilities described below:

  • Develop a dimensional model for a business process
  • Implement a complex dimensional model by creating a data mart or a data warehouse that satisfies accepted practices
  • Create a multidimensional database using a data mart and/or a data warehouse as a data source
  • Create and manipulate advanced On Line Analytical Processing (OLAP) objects that satisfy stated requirements
  • Create complex reports using data from a multidimensional database that satisfy stated requirements
  • Design, create and apply Multi Dimensional (MDX) queries against an OLAP cube Design and create Data Mining models based on a business scenario

Completion Worksheet

Download the completion worksheet for this certificate (PDF)

Requirements

Course No. Course Name  Credit Hrs.
BUSIT 105 Multi Dimensional Analysis I 5
BUSIT 110 Data Warehouse I 5
BUSIT 115 Data Mining I 5
BUSIT 202 Dimensional Modeling 5
BUSIT 205 Multi Dimensional Business Analysis II 5
BUSIT 209 Data Visualization 5
BUSIT 210 Data Warehouse II 5
Choose 5 credits from the following: 5
BA 240 Statistical Analysis (5 Cr)  
MATH 130 Introduction to Statistics (5 Cr)  
Approved Business Elective 5
Total   45

Certificate of Accomplishment Business Intelligence Analyst

Brief Description

Designed to prepare students for entry-level positions developing data warehouses and data marts as part of an overall Business Intelligence System. The certificate provides skills needed to transform and load data into an online analytical processing (OLAP) database, and develop and implement a security plan for the OLAP database

Learning Outcomes

Certificate recipients should possess the skills and abilities described below:

  • Develop a dimensional model for a business process
  • Implement a simple dimensional model by creating a data mart or a data warehouse that satisfies accepted practices
  • Create a multidimensional database using a data mart and/or a data warehouse as a data source
  • Create and manipulate On Line Analytical Processing (OLAP) objects that satisfy stated requirements
  • Create reports using data from a multidimensional database that satisfy stated requirements

Completion Worksheet

Download the completion worksheet for this certificate (PDF)

Requirements

Course No. Course Name  Credit Hrs.
BUSIT 105 Multi Dimensional Analysis I 5
BUSIT 110 Data Warehouse I 5
BUSIT 115 Data Mining I 5
Choose 5 credits from the following: 5
BA 240 Statistical Analysis (5 Cr)  
MATH 130 Introduction to Statistics (5 Cr)  
Approved Business Elective 5
Total   25

Courses marked with a Renamed or Renumbered Course symbol changed course number and/or title begining summer 2008 to reflect a new common course numbering system. Courses with previous number/title are still applicable. Learn more about Common Course Numbering.

Professional or technical program offerings and course requirements listed in this website may be altered by the college to reflect the needs of industry, student interests and availability of resources.