Data Warehouse Fundamentals | | General Courses

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
13.03.2023 - 17.03.2023
€ 600
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
13.03.2023 - 17.03.2023
€ 600
Training for 7-8 or more people? Customize trainings for your specific needs

Description

In our training you’ll learn about the main challenges you can face in the process of building data warehouses. You’ll 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

a:2:{s:4:"TEXT";s:2056:"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
";s:4:"TYPE";s:4:"HTML";}
Schedule and prices
View:
13.03.2023 - 17.03.2023
09:00-14:00
Location:Online
Duration:24 hours
Language:English
Time:09:00-14:00
Trainer: Savchenko Yuriy
Trainer Savchenko Yuriy
€ 600
Sign Up
View Entire Schedule
Trainers
Savchenko Yuriy
Oracle Specialist
Yuriy has been working with DWH (financial regulatory) and OLTP (billing) systems since 2010. He has been involved in several successful long-term projects for 3 multinational investment banks and several short-term ones centered on billing projects.

His current role involves a host of responsibilities such as developing complex architectural solutions, gap analyses and building Kafka/Flink pipelines. Some of the technologies he works with are Oracle Exadata, QlikView, SAP Business Objects, Autosys and Unix shell scripting.

Yuriy is an Oracle Database 11g Administrator Certified Professional (OCP) and Oracle Advanced PL/SQL Developer Certified Professional. For Luxoft Training he delivers our courses on Oracle.
Courses you may be interested in
Modern Data Management Approaches in Real World Cases
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.
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!
The form has been submitted successfully.