Data warehouse modeling and design

This is an introductory course that covers the basics of data warehouse.
Code: EAS-006
Duration: 8 hours

Description

This is an introductory course that covers the basics of data warehouse. Participants will have the opportunity to get acquainted with the core components of architectural solutions. They will learn how to work with architecture patterns such as 3NF, star, and snowflake schemas, as well as with entities like Dimensions & Facts.

Considerable attention is given to describing Data Vault architecture, its components and comparative analysis.

Roadmap

  • What is a data warehouse (DW)
  • What can be a DW
  • What cannot be a DW
  • DW architecture
  • Dimensions and Facts: definitions
  • DW design patterns
  • Types of dimensions
  • Types of facts
  • Data Vault architecture

Objectives

  • To familiarize participants with THE general concepts of data warehouses
  • To analyze existing architectures
  • To give an overview of THE advantages and disadvantages of current practices

Target Audience

  • Developers / database architects
  • ETL developers
  • DWH architects


Trainer in Wroclaw
Pavel Abdyushev Test Automation Consultant
Pavel is a highly experienced specialist in test automation. Currently he is a head of Luxoft automation group supporting one of Deutsche Bank projects. He developed easily extensible framework for automatic testing of the records system. He plays active role in testers’ community (http://it4business.ru). Pavel is co-author of the report “Using frameworks in automated functional testing” presented at SQA-II conference.
Course is scheduled in: Wroclaw
21.02.2020
Time: 09:00-17:00
City: Wroclaw
Duration: 8 hours
Language: English
Trainer
Pavel Abdyushev
Test Automation Consultant
€220
Register for the next course
+
Registering in advance ensures you have priority. Well notify you when we schedule the next course on this topic
Register for the next course
+
Registering in advance ensures you have priority. Well notify you when we schedule the next course on this topic
Bucharest €220
Krakow €220
Wroclaw €220

Invoices for the course will be issued in local currency. All fees above can change according to training location and delivery mode and are subject to change while scheduling. For individual participants the price is as displayed. For legal entities VAT is added to the displayed price.

Courses you may be interested in:

Recommended Reading:

Practical or theoretical knowledge of integration projects

Sign up

Choose dates
First Name*
Last Name*
Company
Email*
Phone
Your Comment
Luxoft Warsaw - Warsaw Spire, plac Europejski 1, 00-844 Warszawa
Dimitrie Pompeiu nr 5-7 , building C, Et. 5, sect 2, Bucharest, 014459

Contact phone:

021 371 4858
Luxoft Poland Wroclaw - Silver Tower pl. Konstytucji 3-go Maja 3 50-048 Wroclaw
Aleja Generała Tadeusza Bora-Komorowskiego 25, Quattro Business Park Five, 31-476 Kraków, Poland

Contact phone:

+48 122110650
Success
Thank you.
Your request has been received.