en

Data Warehouse Dev. Adv.

As a TARGIT Data Warehouse Developer (Advanced), you will master the advanced functions you meet as a professional developer of different types of data warehouses.

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 all types of data warehouses -- multi-dimensional, relational or tabular data warehouses -- from scratch.

Prerequisite
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
The course runs for two days.

Class Selection

Filter:
Location
All countries
Language
All Languages
Currency
All Currencies
Data Warehouse Developer Advanced
Advanced
05/01/2018
Aalborg,
Denmark
Danish
2 Days
1220 €
Add Class
Data Warehouse Developer Advanced
Advanced
06/26/2018
Aalborg,
Denmark
Danish
2 Days
1220 €
Add Class

Can’t find what you’re looking for?