es

Data Warehouse Dev. Adv.

TARGIT Data Warehouse Developer (Advanced)

The course will give you an advanced knowledge of the implementation of data warehouses for the use of business intelligence. After completing the course, you'll be able to implement a variety of data warehouses -- multi-dimensional, relational or tabular data warehouses -- from scratch.

Prerequisites
During the course, you'll be working on further developing a multi-dimensional data warehouse while including optimization and best practices. Additionally, you'll learn to design alternative data warehouses: relational and tabular mode. The course requires knowledge of multi-dimensional data warehouses equivalent to the level represented in the TARGIT Data Warehouse Developer Basic course 

Goals
After completing the course, you'll be able to:

  • Implement a business intelligence data warehouse from scratch
  • Identify advantages and disadvantages of different design solutions
  • Utilize advanced optimization techniques and best practices to benefit the most from a data warehouse


Course subjects

  • Microsoft SQL Server 2012 Tabular Model Data Warehouse
  • TARGIT Relational Model Data Warehouse
  • Normalization vs. denormalization
  • Display folders
  • Dimension member translations
  • Actions; drillthrough action
  • Aggregations: Wizard design, usage-based design and advanced design
  • Partitions
  • Dynamic Time dimension: basic to advanced via Lookup table
  • Fiscal Time dimension; Period Table Task offset
  • Attribute relationships; natural hierarchies
  • Incremental update


Duration
Two days

Class Selection

Filter:
Location
All countries
Language
All Languages
Currency
All Currencies
Data Warehouse Developer Advanced
Advanced
04/23/2018
Athens,
Greece
Greek
2 Days
1300 €
Add Class
Data Warehouse Developer Advanced
Advanced
05/01/2018
Aalborg,
Denmark
English
2 Days
1300 €
Add Class
Data Warehouse Developer Advanced
Advanced
05/16/2018
Hüfingen,
Germany
German
2 Days
1300 €
Add Class
Data Warehouse Developer Advanced
Advanced
05/21/2018
Athens,
Greece
Greek
2 Days
1300 €
Add Class
Data Warehouse Developer Advanced
Advanced
06/13/2018
Hüfingen,
Germany
German
2 Days
1300 €
Add Class
Data Warehouse Developer Advanced
Advanced
07/03/2018
Aalborg,
Denmark
Danish
2 Days
1300 €
Add Class
Data Warehouse Developer Advanced
Advanced
07/11/2018
Hüfingen,
Germany
German
2 Days
1300 €
Add Class
Data Warehouse Developer Advanced
Advanced
08/08/2018
Hüfingen,
Germany
German
2 Days
1300 €
Add Class
Data Warehouse Developer Advanced
Advanced
09/05/2018
Hüfingen,
Germany
German
2 Days
1300 €
Add Class
Data Warehouse Developer Advanced
Advanced
10/03/2018
Hüfingen,
Germany
German
2 Days
1300 €
Add Class
Data Warehouse Developer Advanced
Advanced
10/31/2018
Hüfingen,
Germany
German
2 Days
1300 €
Add Class

Can’t find what you’re looking for?