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

Business Intelligence with SSAS

14 Hours

Introduction to SQL Server 2012 Integration Services (SSIS)

28 Hours

Data Analysis with Redash

14 Hours

Business Intelligence and Data Analysis with Metabase

14 Hours

QlikView for Business Users

7 Hours

QlikView for Developers

14 Hours

Google Sheets for Excel Users

14 Hours

Cognos 11

14 Hours

IBM Cognos Analytics

14 Hours

Alteryx Advanced

14 Hours

Alteryx for Data Analysis

7 Hours

Alteryx for Developers

14 Hours

Data Preparation with Alteryx

7 Hours

Algorithmic Trading with Python and R

14 Hours

Stata: Beginner to Advanced

14 Hours

Related Categories

1