Звезды и С - Главная Звезды и С - Citrix Звезды и С - Microsoft Звезды и С - О нас

Спец. предложения|Обучение|Вебинары|Сертификация|Тестирование|О нас|Работа с сайтом|Новости|Поиск

Курс M20768: Построение моделей данных в SQL

Цена для физических лиц, р.: 18900
Цена для юридических лиц, р.: 19900
Цена вебинара для физических лиц, р.: 17900
Цена вебинара для юридических лиц, р.: 17900

Продолжительность курса (дней): 3

Даты (день): 11.12.2017, 29.01.2018, 12.03.2018, 16.04.2018, 04.06.2018

Даты (вечер): 11.12.2017, 29.01.2018, 12.03.2018, 16.04.2018, 04.06.2018

Курс готовит к тестам:

Цель:

Необходимая подготовка:

Предварительный тест:

Результат:

План курса:

Module 1: Introduction to Business Intelligence and Data Modeling

This module introduces key BI concepts and the Microsoft BI product suite.
  • Introduction to Business Intelligence
  • The Microsoft business intelligence platform
  • Lab : Exploring a Data Warehouse

Module 2: Creating Multidimensional Databases

This module describes the steps required to create a multidimensional database with analysis services.
  • Introduction to multidimensional analysis
  • Creating data sources and data source views
  • Creating a cube
  • Overview of cube security
  • Lab : Creating a multidimensional database

Module 3: Working with Cubes and Dimensions

This module describes how to implement dimensions in a cube.
  • Configuring dimensions
  • Define attribute hierarchies
  • Sorting and grouping attributes
  • Lab : Working with Cubes and Dimensions

Module 4: Working with Measures and Measure Groups

This module describes how to implement measures and measure groups in a cube.
  • Working with measures
  • Working with measure groups
  • Lab : Configuring Measures and Measure Groups

Module 5: Introduction to MDX

This module describes the MDX syntax and how to use MDX.
  • Обзор TCP/IP
  • MDX fundamentals
  • Adding calculations to a cube
  • Using MDX to query a cube
  • Lab : Using MDX

Module 6: Customizing Cube Functionality

This module describes how to customize a cube.
  • Implementing key performance indicators
  • Implementing actions
  • Implementing perspectives
  • Implementing translations
  • Lab : Customizing a Cube

Module 7: Implementing a Tabular Data Model by Using Analysis Services

This module describes how to implement a tabular data model in PowerPivot.
  • Introduction to tabular data models
  • Creating a tabular data model
  • Using an analysis services tabular model in an enterprise BI solution
  • Lab : Working with an Analysis services tabular data model

Module 8: Introduction to Data Analysis Expression (DAX)

This module describes how to use DAX to create measures and calculated columns in a tabular data model.
  • DAX fundamentals
  • Using DAX to create calculated columns and measures in a tabular data model
  • Lab : Creating Calculated Columns and Measures by using DAX

Module 9: Performing Predictive Analysis with Data Mining

This module describes how to use data mining for predictive analysis.
  • Overview of data mining
  • Using the data mining add-in for Excel
  • Creating a custom data mining solution
  • Validating a data mining model
  • Connecting to and consuming a data mining model
  • Lab : Perform Predictive Analysis with Data Mining


  Спец. предложения|Обучение|Вебинары|Сертификация|Тестирование|О нас|Работа с сайтом|Новости|Поиск

   Тел: +74953633686 email: info@stars-s.ru

   125040, Москва, Ленинградский проспект, д. 5, стр. 2, под. 5, офис "Звезды и С"

  © Учебный центр "Звезды и С", 1991-2017