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

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 Developers

  14 hours

QlikView for Business Users

  7 hours

Google Sheets for Excel Users

  14 hours

IBM Cognos Analytics

  14 hours

Cognos 11

  14 hours

Alteryx for Developers

  14 hours

Data Preparation with Alteryx

  7 hours

Alteryx for Data Analysis

  7 hours

Alteryx Advanced

  14 hours

Stata: Beginner to Advanced

  14 hours

Algorithmic Trading with Python and R

  14 hours