Data Warehouse Fundamentals
Understand current approaches to designing data warehouses and using them in heterogeneous enterprise information systems.
24 hours
Online
English
EAS-004
Data Warehouse Fundamentals
Sign Up
Duration
24 hours
Location
Online
Language
English
Code
EAS-004
Schedule and prices
€ 410
Training for 7-8 or more people? Customize trainings for your specific needs
Data Warehouse Fundamentals
Sign Up
Duration
24 hours
Location
Online
Language
English
Code
EAS-004
Schedule and prices
€ 410
Training for 7-8 or more people? Customize trainings for your specific needs

Description

In our training youll learn about the main challenges you can face in the process of building data warehouses. Youll understand how goals influence the selection of architecture and what consequences insufficient attention to components may lead to. You will also get an idea of team members roles and impact on the result.

We cover the practical approaches to designing and implementing a data warehouse and its components - life cycle management, including decommissioning and migration to new systems, and review topics such as data management and building related services.

Throughout the training you will be involved in various exercises that help you put your skills to the test you will either work on a project of data warehouse migration or assess it in terms of capabilities, resources, and timing.
After completing the course, a certificate
is issued on the Luxoft Training form

Objectives

  • Understand the role and tasks of data warehouse in the enterprise IT landscapes
  • Learn all the stages of the DWH life cycle, from designing to implementation, operation and decommissioning
  • Learn how to avoid typical mistakes in creating data warehouses, and become familiar with methods and best practices for successful maintenance of data warehouses

Target Audience

  • Software architects
  • Technical leads and senior developers
  • System analysts and designers
  • DWH Product Owners
  • DWH Project Managers
  • DWH Unit Managers
  • Data quality (DQ) engineers
  • Business intelligence (BI) experts

Roadmap

Introduction
  • The idea of data warehouse. - its capabilities and constraints
  • The purpose of DWH and business tasks it solves

Components and Architecture
  • Traditional approaches to data warehouse design
  • Standard components and processes
  • Concepts of Inmon, Kimball, and DataVault methodologies
  • Overview of major components (stage, ODS, DDS, Data Marts, BI, Metadata) and processes (ETL, ELT, DQ, lineage)

Data Governance
  • General and specific issues of enterprise data governance
  • Information as an asset that brings value and requires costs on obtaining
  • The concept of master data and master data management (MDM)

Methods of Data Warehouse Design
  • Design steps
  • Standard techniques and tools
  • Stakeholders and infrastructure expertise

Initial Data Store Area - Stage
  • Need to store initial data from the source system
  • Typical mistakes in organizing this store area and its difference from Data Lake.

Permanent Storage Areas - ODS and DDS
  • Layers of operational and multi-dimensional data storage
  • Retrieval, cleaning, control, and storing processes - ETL\ELT
  • Transformation into a target storage system

Data Consumer Systems
  • Typical use cases of data retrieval from data warehouses
  • BI systems as major data warehouse consumers
  • Standard BI systems and reasons for their diversity

New Challenges in the Evolution of Data Warehouses
  • Overview of major scalability problems with a data warehouse
  • New challenges in machine learning
  • The concept of Data Mesh as an alternative for future development
Schedule and prices
View:
Register for the next course
Registering in advance ensures you have priority. Well notify you when we schedule the next course on this topic
+
Courses you may be interested in
Modern Data Management Approaches
This training provides an overview of modern methods for data storage, including key-value stores, document-oriented and database management systems, distributed data storage and processing systems.
BigData SQL Hive
This training is aimed at developers and covers the full stack of technical features, architecture and performance tuning. Apache Hive supports analysis of large datasets stored in Hadoop's HDFS and compatible file systems and it provides an SQL-like language with schema on read and transparently converts queries to map/reduce.
BigData SQL Impala
This is a training about Impala for developers covering the full stack of technical features, architecture and performance tuning. Impala supports analysis of large datasets stored in HDFS and compatible file systems, providing an SQL-like language.
View Catalog
Your benefits
Expertise
Our trainers are industry experts, involved in software development project
Live training
Facilitated online so that you can interact with the trainer and other participants
Practice
A focus on helping you practice your new skills
Still have questions?
Connect with us
Thank you.
Your request has been received.
Thank you!
The form has been submitted successfully.