en

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
09/05/2018
Hüfingen,
Germany
German
2 Days
$ 1700
Add Class
Data Warehouse Developer Advanced
Advanced
10/03/2018
Hüfingen,
Germany
German
2 Days
$ 1700
Add Class
Data Warehouse Developer Advanced
Advanced
10/31/2018
Hüfingen,
Germany
German
2 Days
$ 1700
Add Class
Data Warehouse Developer Advanced
Advanced
11/20/2018
Aalborg,
Denmark
Danish
2 Days
$ 1700
Add Class
Data Warehouse Developer Advanced
Advanced
01/08/2019
Aalborg,
Denmark
Danish
2 Days
$ 1700
Add Class

Can’t find what you’re looking for?


We use cookies to improve your site experience, but they also provide us with information on your use of our website.
To find out more about the cookies we use and how to delete them, see our Privacy Policy. By continuing to browse the site, you are consenting to our use of cookies.

ok