Data Warehouse Developer Basic

How to build a multi-dimensional data warehouse

The course will give you the fundamental knowledge that you need in order to implement a multi-dimensional data warehouse. And after completing the course, you will be able to implement minor adjustments and additions to your own data warehouse.

During the course, you will primarily be working on building and designing a multi-dimensional data warehouse in a Microsoft SQL Server environment. The course does not require previous training. No matter your level of knowledge and expertise, TARGIT’s experienced instructors will guide you through the course.

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

  • Understand and use basic data warehouse techniques 
  • Plan, supervise, and monitor the implementation of a data warehouse from beginning to end 
  • Adjust an existing solution with minor, everyday adjustments and additions

Course subjects

  • Basic data warehouse terms and definitions  
  • Construction of multi-dimensional data models with Microsoft SQL Server Analysis Services (SSAS)
  • Utilizing Named Calculations and Calculated Members
  • Data migration with Microsoft SQL Server Integration Services (SSIS)
  • Ensuring data quality and integrity
  • Building an advanced time dimension
  • Expansion of the data model with new data using data manipulation

Two days

Class Selection

All countries
All Languages
All Currencies
There are no courses available at this time.

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.