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 (5)
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
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
team work