 Overview
Companies that build data warehouses and use business intelligence for decision-making ultimately save money and become more profitable. 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. You’ll 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. You’ll also 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 anyone else who needs 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. This program is also useful for project managers who oversee data integration projects.
Specialized Studies Award Requirements
Students must complete all three courses listed in order to qualify for the BIDW Specialized Studies Award. When you have completed your third course, please submit an Application for Candidacy.
|
|
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.
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
- Kugan Kandasamy, Consultant
- Jay Cook, Consultant
- Rick Hefner, Director, Process Effectiveness, Northrop
Grumman
|
