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.

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
  Remote   to be scheduled
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

Elective Courses

TitleWinterSpringSummerFall
Business Intelligence and Data Warehousi
I&C SCI X427.40
Digital Fundamentals & Emerging Technologies (3.00 Units)
I&C SCI X427.40
  to be scheduled    
I&C SCI X425.94
    to be scheduled  
I&C SCI X450.79
Intermediate SQL Programming (2.50 Units)
I&C SCI X450.79
  Remote    

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 Winter 2024 Spring 2024 Summer 2024 Fall 2024
Registration Begins (after 2pm PT) Oct 19 Jan 18 Apr 18 Jul 11
Courses Begin* (week of) Jan 8 Apr 1 Jun 24 Sep 23
Courses End* (week of) Mar 18 Jun 10 Sep 9 Dec 9
Administrative Holidays Jan 15, Feb 19 Mar 29, May 27 Jun 19, Jul 4, Sep 2 Nov 11, Nov 28-29, Dec 24-25, Dec 31, Jan 1

*Actual dates may vary by program.

×
Learn How To Earn Your Certificate

Earn a Certificate

Apply to become a candidate for the program: A Declaration of Candidacy is required to establish candidacy in this program. Complete the application and pay the application and candidacy fee of $125 (non-refundable). Learn more about the benefits of becoming a candidate. Candidacy is not required to enroll into individual course in a program.

A candidate in the program is awarded a specialized studies certificate upon the successful completion of three (3) required courses and one (1) elective course totaling 9.5 units, each with a letter grade of “C” or better. All requirements must be completed within five (5) years after the student enrolls in their first course. To receive the Certified Digital Certificate after the completing all the program requirements, students must submit the Request for Certificate to initiate the certificate audit process. Students not pursuing the certificate 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

Career Advancement Network (CAN)

We are proud to provide our certificate students and alumni with newly enhanced career services that include one-on-one coaching, technology tools, webinars and workshops, networking events, mentorship/internship opportunities, and a rich collection of free online career resources. Learn more.

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.