Business Intelligence
On this page:
- Business Intelligence Developer - Certificate of Achievement
- Business Intelligence Analyst - Certificate of Accomplishment
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 
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.