Microsoft DW/BI Technologies

Description

The key to every successful DW/BI (Data Warehouse & Business Intelligence) system implementation is understanding the business requirements and preparing the data necessary to meet them. This means that a project’s success relies on how accurately business processes will be identified and modeled, as well as on obtaining proper data quality and structure.
The goal of the training is to equip analysts, BI specialists and database programmers with knowledge and skills necessary to create DW/BI systems according to the methodology established by Ralph Kimball and his group, the Kimball Lifecyle. This is one of the most commonly used methodologies, which in a detailed way describes each step of designing, implementing and maintaining a DW/BI class system, and may successfully be applied for Microsoft technology. The training emphasizes the crucial role of a properly designed data warehouse and the ETL (Extract, Transform and Load ) process which supplies it, in creating functional and efficient analysis-report systems, not omitting nonetheless the issues related to providing access to the systems to business users.

Options

Course level:300

Start date:as required

Duration time:5 days

Price: 5000 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 DW/BI projects, starting with identifying business processes, through the implementation of information management processes, multi-dimension modeling, creating analytic databases, and finishing with making information available to the users in the form of an Excel sheet and reports. They will also be trained in Microsoft technologies enabling to create DW/BI systems and to apply them in business analysis.

Plan

The basic training is comprised of 11 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.