Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
- basis, objectives and application of data warehouse, data warehouse server types
- base building ETL processes in SSIS
- basic design data cubes in an Analysis Services: measure group measure
- dimensions, hierarchies, attributes,
- development of the project data cubes: measures calculated, partitions, perspectives, translations, actions, KPIs,
- Build and deploy, processing a partition
- the base XML / A: Partitioning, processes and overall Incremental, delete partitions, processes of aggregation,
- base MDX language
Requirements
Knowledge of Windows, basic knowledge of SQL and relational databases.
14 Hours
Testimonials (5)
Clear explanations with good examples so i could relate to my own line of work.
Elaine Vermeulen - Sandoz BV
Course - Alteryx for Developers
The adjustment made in the lecture/lessons by the trainer once he understood the current SSIS application that we are bound to maintain. The topics became more suitable/usable to us.
Angelito Aguilar - Metrobank
Course - Introduction to SQL Server 2012 Integration Services (SSIS)
Use cases were awesome! and Ray involved each and every one of us in each use case.
Zara - Trench Ltd
Course - Alteryx for Data Analysis
Used good examples, good pace of the training and covered most things
David - McGraw Hill
Course - Data Preparation with Alteryx
team work