Intermediate Business Intelligence Analyst Certificate

The Intermediate Business Intelligence Analyst Certificate of Accomplishment will prepare students for entry and mid-level Business Intelligence (BI) positions in a variety of industries. 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. Students will also gain skills using BI tools to analyze and report data in a BI environment, and serve as team members on business intelligence and data warehousing projects.

Prerequisites

Individuals must have:

• MATH 130  with a C or higher
• BUSIT 103  with a C or higher

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
• Write and evaluate SQL code for the database including database stored procedures
• Design applications according to generally accepted object oriented principles.