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.
Specialized Studies Award Requirements
Students must complete all three courses listed in order to qualify for the BIDW Specialized Studies Award. Students may also enroll in individual courses.
All requirements must be completed within five (5) years after the student
enrolls in his/her first course.
On-site Training Available
Through Corporate Training, we 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 UC Irvine Extension (classroom and online formats) require
professional-level English language proficiency in listening and note-taking, reading
comprehension and vocabulary, written expression, and oral presentation. If you
would like to refine your English language proficiency prior to beginning one of
our programs, please see our English
Stay Informed About
Business Intelligence & Data Warehousing
Students completing this progam will be able to:
- 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
- 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
- David Shelton, IT Director, Pacific Life
- Kugan Kandasamy, Consultant
- Jay Cook, Consultant
- Rick Hefner, Director, Process Effectiveness, Northrop