Designing and Implementing Data Warehouses

Description

A crucial part of every Business Intelligence system is a data warehouse — its design and implementation determine if stored data can be used to answer business questions quickly and efficiently. Because data warehouses serve a different purpose than operational databases (OLTP), their structure is also different, which means that to create a successful data warehouse a distinct set of skills is needed.
The goal of the training is to equip BI specialists and database programmers with knowledge and skills necessary to manage and conduct data warehouse projects. The participants gain knowledge and necessary abilities on multidimensional modelling, in particular they get familiar with the two most popular multidimensional modelling methodologies — Ralph Kimball’s and William Inman’s ones.
The training emphasizes practical ramifications of multidimensional modelling and implementations of those techniques using Microsoft technologies, mainly SQL Server.

Options

Course level:300

Start date:as required

Duration time:3 days

Price: 3500 zł

Open training

On-site (costumer's premises)

Customer’s computer

Class

The course is addressed to BI specialists and database programmers. Its participants will be given a complete methodology of multidimensional modelling, starting with identifying business processes, through data warehouse design, dimension tables design and optimization, fact tables design and optimization, and finishing with making the DW highly efficient and scalable.

Plan

The basic training is comprised of 8 modules. Just like all the other courses on our offer, it has been designed by our experts, therefore we can freely customize it to suit the individual needs of the participants. We would like to encourage you not only to choose the modules which you find relevant for your needs, but also to feel free to contact us with your suggestions and questions you would like to hear answered during the course.
Our trainings are exceptional also because we limit the time set aside for laboratory type classes customarily conducted after the completion of each module, to the benefit of exercises done with the assistance of the trainer and demonstrations. We believe in this manner we can equip you with substantially more practical information and tips, and focus on dealing with the issues directly within your scope of interest. However, each day of the training is finished with a laboratory class of approximately 1hr, so that you can do self-practice and do exercises of your choice.