DW 102 – Data Warehousing 101 – IT Professionals

Duration: 1-2 days

This course is presented in a straightforward manner and assumes that attendees have no prior knowledge of decision support concepts or data warehouse/data mart implementations. This course 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.

Free Consultation

"*" indicates required fields

Company

This field is for validation purposes and should be left unchanged.

Name

Company Name

Email*

Phone

Message*

Description

Data Warehousing 101 is a comprehensive overview of data warehousing, data marts, decision support architecture, and their utilization to attaining 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 and technical challenges tied to ROI, project management, architecture, critical success factors, risk factors, design, process, and tools.

This course lays the groundwork and provides the fundamentals required to leverage your company’s investment in an enterprise or department-level decision support system. It quickly elevates the understanding of the value and objectives of a data warehouse, while providing a common terminology and basic architecture to use for future data warehouse discussions.

Objectives

Understand the basic concepts and architecture of data warehousing and data marts
Learn how data warehouses support decision-making and business objectives
Identify the key components of a successful data warehouse, including ROI, architecture, and design
Gain insight into critical success factors, risk factors, and project management techniques for data warehouse implementation
Develop a common terminology and framework for future data warehouse discussions
Learn from real-world case studies to understand practical challenges and solutions

Seminar Content

Seminar Outline
- Understanding business intelligence
Analyze the current state of the data warehousing industry
- Data warehousing fundamentals
- Operational data store
- Data marts
- Defining metadata 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
- Metadata
- Data exchange languages and techniques
Data warehouse project management overview
- Goals and objectives
- Critical success factors
- Business problems in data warehousing
- Measuring results
- Risks, issues, challenges in data warehouse project management
- Selecting the first data warehouse project
Workshop conclusion
- Summary, additional exercises, sources for further reading, etc.

About the Course Designer

This training was designed by David Marco, PhD, an internationally recognized authority on data and AI governance, to help teams succeed in real organizational conditions. The curriculum equips participants with practical judgment, shared language, and decision clarity that hold under scale, risk, and executive accountability.

DW 102 – Data Warehousing 101 – IT Professionals

Free Consultation

Description

Objectives

Seminar Content

About the Course Designer

Featured Courses

DGS 301 – Data Stewardship Training

MDM 401 – Managed Metadata Environment (MME) Full Life-Cycle Guide

MDM 301 – Metadata Modeling Design and Implementation