Data Warehouse Architecture - Series 1
Data Warehouse Architecture - Series 1
Duration: 01:42:37 | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 1.45 GB
Genre: eLearning | Language: English
Duration: 01:42:37 | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 1.45 GB
Genre: eLearning | Language: English
Key Architectural Considerations for Data Warehouse Implementation and Modernization Efforts
What you'll 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
Requirements
A basic working knowledge of Data Warehouses, their composition, and their uses.
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:
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.
Who this course is for:
Project Managers
Product Owners (technical and business)
Data Warehouse Architects
Analytical Program Management
More Info