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

Algorithmic Trading with Python and R

  14 hours

Stata: Beginner to Advanced

  14 hours

Statistical Analysis with Stata and R

  35 hours

Alteryx Advanced

  14 hours

Alteryx for Data Analysis

  7 hours

Alteryx for Developers

  14 hours

Data Preparation with Alteryx

  7 hours

Google Sheets for Excel Users

  14 hours

IBM Cognos Analytics

  14 hours

Business Intelligence and Data Analysis with Metabase

  14 hours

QlikView for Business Users

  7 hours

QlikView for Developers

  14 hours

Data Analysis with Redash

  14 hours

Business Intelligence with SSAS

  14 hours