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.
Testimonials (6)
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)
Clear explanations with good examples so i could relate to my own line of work.
Elaine Vermeulen - Sandoz BV
Course - Alteryx for Developers
I enjoyed the exercises session the most as I get to understand how to apply. Would definitely enjoyed it more if there are more combination exercises :)
Joan Ng
Course - Data Preparation with Alteryx
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
Lo interactivo que es
Heriberto Prieto Gallego - Essilorluxottica Mexico
Course - Alteryx Advanced
team work