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
The Business Intelligence Developer Certificate of Achievement prepares students for entry and mid-level positions developing business intelligence (BI) systems. Students use state-of the-art tools to design and create BI solutions. They design and develop database reports, data warehouses and multi-dimensional databases. The Business Intelligence Analyst Certificate of Accomplishment may be applied to earn this certificate.
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
The certificate in Business Intelligence Analyst is designed to prepare students for entry-level business intelligence (BI) positions in a variety of industries. Students gain skills using BI tools to analyze and report on data in a BI environment, and serve as team members on business intelligence and data warehousing projects.
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 103 | SQL Fundamentals | 5 |
| 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 | 30 | |
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.
