Skip Navigation

Business Intelligence & Data Warehousing

Overview

Companies that build data warehouses and use business intelligence for decision-making ultimately save money and increase profit. In addition, initiatives ranging from supply chain integration to compliance with government-mandated reporting requirements (such as Sarbanes-Oxley and HIPAA) depend on well-designed data warehouse architecture. This specialized studies program introduces you to the main components of a data warehouse for business intelligence applications. Learn how a data warehouse fits into the overall strategy of a complex enterprise, how to develop data models useful for business intelligence, and how to combine data from disparate sources into a single database that comprises the core of your data warehouse. Explore how to define and specify useful management reports from warehouse data.

Who Should Enroll

Data systems modelers, database administrators, data architects, IT managers, business analysts, CIOs, and others who need to take data from different databases or data sources and combine them into a single repository that can be used to produce executive dashboards, generate summary reports, and glean “hidden” information from business databases. Those who provide the requests for data in order to analyze trends and systems should also attend.

Career Insight

Occupational summary for management analysts. Source: Economic Modeling Specialists Intl.

702,633
Annual Job Openings
(2019)
13.6%
Projected Growth
(2019-2029)
$83k
Median Salary
(Highly experienced workers can earn up to $152k)

Program Benefits

  • Explain how a data warehouse combined with good business intelligence can increase a company’s bottom line
  • Describe the components of a data warehouse
  • Describe different forms of business intelligence that can be gleaned from a data warehouse and how that intelligence can be applied toward business decision-making
  • Develop dimensional models from which key data for critical decision-making can be extracted
  • Sketch out the process for extracting data from disparate databases and data sources, and then transforming the data for effective integration into a data warehouse
  • Load extracted and transformed data into the data warehouse

Course Schedule

Required Courses

TitleWinterSpringSummerFall
I&C SCI X427.01
Business Intelligence & The Data warehouse Development Process (2.50 Units)
I&C SCI X427.01
      Online
I&C SCI X425.32
Data Integration, Modeling, and ETL (2.50 Units)
I&C SCI X425.32
Online   to be scheduled  
I&C SCI X450.72
Introduction to SQL Programming (2.50 Units)
I&C SCI X450.72
Online to be scheduled to be scheduled Online

Elective Courses

TitleWinterSpringSummerFall
Business Intelligence and Data Warehousi
I&C SCI X494.94
Fundamentals of Agile (3.00 Units)
I&C SCI X494.94
  to be scheduled   Online
I&C SCI X427.40
Digital Fundamentals and Emerging Technologies (3.00 Units)
I&C SCI X427.40
Online   to be scheduled  
I&C SCI X425.94
    to be scheduled  

Course schedules are subject to change. Individual courses may be taken without enrolling in the full program.

Receive Customized Training for your Employees
×

Academic Calendar

Event Fall 2020 Winter 2021 Spring 2021 Summer 2021
Registration Begins (after 2pm PT) Jul 16 Oct 22 Jan 21 Apr 22
Courses Begin* (week of) Sep 21 Jan 4 Mar 29 Jun 21
Courses End* (week of) Dec 14 Mar 15 Jun 7 Sep 7
Parking Permits Expire Dec 31 Mar 31 Jun 30 Sep 30
Administrative Holidays Nov 11, Nov 26-27, Dec 24-25, Dec 31 Jan 1, Jan 18, Feb 15 Mar 26, May 31 Jul 5, Sep 6

*Actual dates may vary by program.

×
Learn How To Earn Your Certificate

Specialized Studies Award Requirements

The specialized studies certificate is awarded upon completion of three required courses and one elective course (a total of 9.5 units) with a grade of “C” or better in each course. To receive your digital certificate, submit a Request for Certificate with a non-refundable $35 application fee after completing all program requirements. All requirements must be completed within 5 years after the student enrolls in his/her first course. Students not pursuing a specialized studies award are welcome to take as many individual courses as they wish.

Advisory Committee

  • Allan Elder, President, Numen Consulting, Inc.
  • Victor Wu, CTO EmpowerTrain Corp.
  • Patti Lassen, Lead Systems Engineering, Experian
  • Gary Falacara, Consultant
  • Fu-Tien Chiou, Senior Information Architect, Capital Group
  • David Shelton, IT Director, Pacific Life
  • Jay Cook, Consultant
  • Rick Hefner, Director, Process Effectiveness, Northrop Grumman

On-site Training Available

Our Corporate Training specialists can deliver this program or customize one that fits your organization’s specific needs. Visit Corporate Training or call (949) 824-1847 for information.

English Proficiency Requirement
All certificate programs at UCI Division of Continuing Education (classroom and online formats) require professional-level English language proficiency in listening and note-taking, reading comprehension and vocabulary, written expression, and oral presentation.