Header - EWS 2021

Affiliated with:

dmu logo white
Contact Us

DW 401 – Data Warehouse and Business Intelligence – Full Lifecycle Implementation

Duration: 3 – 5 days

This practical seminar provides you with an in-depth understanding of data warehousing and its application to business intelligence. You will learn the concepts and skills necessary to build a successful data warehouse to implement your business intelligence program on the first implementation.

Free Consultation

"*" indicates required fields

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

Description

This practical seminar provides you with an in-depth understanding of data warehousing and its application to business intelligence. You will learn the concepts and skills necessary to build a successful data warehouse to implement your business intelligence program on the first implementation. Real-world case studies of business intelligence and data warehousing implementations are used to leverage the lessons learned on these projects.

Through team interaction, attendees will be provided with a full lifecycle strategy and methodology for defining system requirements, capturing/integrating source data, metadata repository fundamentals, and accessing the information in the data warehouse.

Through case studies and team interaction, attendees will attain the real-world implementation skills necessary to build a data warehousing program for their organization. Hands-on workshops throughout the course will reinforce the learning experience and provide the attendees with concrete results that can be used in their organizations.

Objectives

  • Learn a full lifecycle methodology for implementing a business intelligence system using data warehouse technology
  • Understand how to define 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 

Seminar Content

  • Understanding Data Warehousing and Business Intelligence
    • Analyzing the current state of the data warehousing industry
    • Data warehousing fundamentals
    • Business intelligence fundamentals
    • Defining metadata and its critical role in data warehousing and business intelligence
  • Challenges in the Data Warehouse Industry
    • Selling the concept of building a data warehouse and business intelligence environment to management (ROI)
    • Challenges in data warehousing in the 21st century
    • Challenges in business intelligence in the 21st century
  • How to Implement a Data Warehouse, Data Mart, and Operational Data Store
    • Keys to a sound architecture for data warehousing and business intelligence
    • Defining system requirements for effective data warehousing and business intelligence
    • Creating a data integration strategy for your company
    • Integrating legacy system sources into a data warehouse
    • Accessing the data warehouse through business intelligence
    • Approaches to data warehouse development
    • Data model walkthrough (3rd normal and dimensional)
  • The Data Warehouse Team
    • Creating the data warehouse team
    • Creating the business intelligence team
    • Data warehouse and BI team role walkthroughs
    • Creating the data warehouse and BI project plan
    • Data warehouse ROI definition
    • Constructing the data warehouse scope document
    • Creating the business intelligence scope document
  • Understanding the Key Business Intelligence Vendors
    • The battle for metadata standards (as part of data governance and data management)
    • Evaluating data warehousing tools and BI access methods
    • Real-world analysis of tool vendors – process overview
  • Understanding Data Warehouse Methodologies in Data Warehousing and Business Intelligence
    • Data warehouse/business intelligence methodology frameworks overview
    • Customizing a methodology – an overview
    • Challenges to integrating a DW/BI methodology into an SDLC
  • Conclusion
    • Questions
    • Resource for further study

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.

David Marco PHD EWSolutions

Featured Courses

DW 102 – Data Warehousing 101 – IT Professionals

This course is presented in a straightforward manner and assumes that attendees have no prior knowledge of decision support concepts...

Learn More

DGS 301 – Data Stewardship Training

This intensive course will provide an introduction to data governance, its purpose, and how it can be implemented. The attendees...

Learn More

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

This practical course leverages the lessons learned from companies that have successfully deployed MMEs. Real-world MME case studies will be...

Learn More