• Post category:StudyBullet-11
  • Reading time:5 mins read


Key Architectural Considerations for Data Warehouse Implementation and Modernization Efforts

What you will learn

Key architectural concerns for Data Warehouse Implementation

Benefits of Operational Data Store implementation and key implementation steps

Information Security and Governance structures relating to data warehouses

High level technical concepts of warehouse implementations that will help drive project/program management decisions

Description

Learn the key architectural elements, design choices, and considerations to be factored into a new or existing Data Warehouse implementation project, with the goal of adding the most value for the business, and reducing the downstream maintenance costs of the Warehouse.

The discussions in this course are platform agnostic, and apply to any Warehouse Environment, either Cloud-hosted or On-premise, and the concepts can be applied to any stack that is used for implementation (i.e. Microsoft, Oracle, etc.).

This course is technical in nature, however all topics are kept at a high level. This course is meant to provide value for individuals involved in a Data Warehouse project, whose roles may be one or more of the following:


Get Instant Notification of New Courses on our Telegram channel.


DealsCrown Telegram Banner
  • Program Manager over an Analytics Program
  • Product/System Owner (either Business or Technical) for a Data Warehouse
  • Solutions Architect
  • Warehouse Developer
  • Systems Engineer/Integrator

In this course, we will cover:

  • Key drivers for Business Value
  • Staging area design concepts, and the Operational Data Store concept
  • ETL processย considerations
  • Metrics, Measure and KPIย Considerations
  • Environmental Architecture Considerations
  • Information Security and Governance structures.
  • The various methods of data transmission from source systems to the warehouse, as well as their benefits and drawbacks.

Along the way, we will form a baseline for business requirements and a justification for warehouse components that can be used to document and detail your efforts.

English
language

Content

Course Introduction

Introduction

Course Outline

Outline

Desired Outcomes

Desired Outcomes

Creating Business Value

Creating Business Value

Introduction to the Operational Data Store

Introduction to the Operational Data Store concept

Benefits of an Operational Data Store

Learn the benefits of an ODS implementation

Environmental Architecture

Environmental Architecture Considerations

ETL Development Considerations

ETL Development Considerations

Metrics Considerations

Metrics Considerations

Change Management Best Practices

Change Management Best Practices

Governance Practices

Governance Practices

Information Security Best Practices

Information Security Best Practices

Resource Considerations

Resource Considerations

Course Wrap-up and Research Topics

Wrap-up

Appendix: Transmission Methods

Transmission Methods