Data Warehouse Fundamentals for Executives
Instructor: David Marco
Duration: 1-day (full course) or half-day (reduced version)
Seminar Overview
A comprehensive on-site overview of date warehousing, data marts, decision support architecture, and its utilization to obtaining business objectives. The purpose of this course is to take attendees with little to no background in data warehousing to a functional understanding of business objectives tied to ROI, project management, architecture, critical success factors, risk factors, design, process, and tools.
This course is presented is a straight-forward, non-technical manner. It assumes that attendees have no prior knowledge of decision support concepts or data warehouse/data mart implementations. It is founded on the practical experiences of real-world implementations of data warehouse and data mart projects. This seminar provides the critical prerequisites for successful, profitable, and extendable data warehouse and data mart implementations.
Benefits To Your Company
- Learn the key concepts in data warehousing in an easily understood manner.
- Understand how to identify the key business requirements that yield positive ROI.
- Identify the challenges of implementing a data warehouse.
- Understand how to build a data warehouse that is flexible to the changing technical marketplace.
Who Should Attend & What You Will Learn
CIOs and Executive Management will learn how to…
- Cost justify and build a business intelligence system using data warehouse technology for a competitive advantage in the marketplace.
- Understand how to manage risk and anticipate the stumbling blocks before they occur.
- Attain a sound overview of the key concepts of business intelligence
Seminar Outline
- Understanding Business Intelligence
- Analyze the current state of the data warehousing industry
- Data warehousing fundamentals
- Operational data store
- Data mart
- Defining meta data and its critical role in data warehousing
- Challenges in the Data Warehouse Industry
- Selling the concept of building a data warehouse to management (ROI)
- Cutting through the vendor hype
- The Data Warehouse Team
- Data Warehouse Team Role Walkthroughs
- Reviewing the Data Warehouse Project Plan
- Data Warehouse ROI Definition
- Understanding the Key Business Intelligence Vendors
- Understanding Data Warehousing Tools, including ETL (extract, transform, & load), OLAP (online analytical processing), and portals
- Real-world analysis of tool vendors
- Understand the Trends in Business Intelligence
- Data Warehousing Changing Landscape
- Meta Data
- XML
