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.

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 

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

Two days

Class Selection

All countries
All Languages
All Currencies
Data Warehouse Developer Advanced
2 Days
1370 €
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.