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

Number of participants



Price per participant

Testimonials (5)

Related Courses

Introduction to SQL Server 2012 Integration Services (SSIS)

28 Hours

Related Categories