- Главная
- Курсы
- MICROSOFT
- Microsoft SQL Server
- Microsoft SQL Server 2014
Designing Self-Service Business Intelligence and Big Data Solutions
Даты проведения курса
Array
(
[1] => Array
(
[PRICES] => Array
(
[BASE] => Array
(
[PRICE_ID] => 1
[ID] => 60767
[CAN_ACCESS] => Y
[CAN_BUY] => Y
[MIN_PRICE] => Y
[CURRENCY] => RUB
[VALUE_VAT] => 33000
[VALUE_NOVAT] => 33000
[DISCOUNT_VALUE_VAT] => 33000
[DISCOUNT_VALUE_NOVAT] => 33000
[ROUND_VALUE_VAT] => 33000
[ROUND_VALUE_NOVAT] => 33000
[VALUE] => 33000
[UNROUND_DISCOUNT_VALUE] => 33000
[DISCOUNT_VALUE] => 33000
[DISCOUNT_DIFF] => 0
[DISCOUNT_DIFF_PERCENT] => 0
[VATRATE_VALUE] => 0
[DISCOUNT_VATRATE_VALUE] => 0
[ROUND_VATRATE_VALUE] => 0
[PRINT_VALUE_NOVAT] => 33 000 руб.
[PRINT_VALUE_VAT] => 33 000 руб.
[PRINT_VATRATE_VALUE] => 0 руб.
[PRINT_DISCOUNT_VALUE_NOVAT] => 33 000 руб.
[PRINT_DISCOUNT_VALUE_VAT] => 33 000 руб.
[PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб.
[PRINT_VALUE] => 33 000 руб.
[PRINT_DISCOUNT_VALUE] => 33 000 руб.
[PRINT_DISCOUNT_DIFF] => 0 руб.
)
)
[PRICE_MATRIX] =>
[MIN_PRICE] => Array
(
[PRICE_ID] => 1
[ID] => 60767
[CAN_ACCESS] => Y
[CAN_BUY] => Y
[MIN_PRICE] => Y
[CURRENCY] => RUB
[VALUE_VAT] => 33000
[VALUE_NOVAT] => 33000
[DISCOUNT_VALUE_VAT] => 33000
[DISCOUNT_VALUE_NOVAT] => 33000
[ROUND_VALUE_VAT] => 33000
[ROUND_VALUE_NOVAT] => 33000
[VALUE] => 33000
[UNROUND_DISCOUNT_VALUE] => 33000
[DISCOUNT_VALUE] => 33000
[DISCOUNT_DIFF] => 0
[DISCOUNT_DIFF_PERCENT] => 0
[VATRATE_VALUE] => 0
[DISCOUNT_VATRATE_VALUE] => 0
[ROUND_VATRATE_VALUE] => 0
[PRINT_VALUE_NOVAT] => 33 000 руб.
[PRINT_VALUE_VAT] => 33 000 руб.
[PRINT_VATRATE_VALUE] => 0 руб.
[PRINT_DISCOUNT_VALUE_NOVAT] => 33 000 руб.
[PRINT_DISCOUNT_VALUE_VAT] => 33 000 руб.
[PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб.
[PRINT_VALUE] => 33 000 руб.
[PRINT_DISCOUNT_VALUE] => 33 000 руб.
[PRINT_DISCOUNT_DIFF] => 0 руб.
)
[CATALOG_GROUP_ID_1] => 1
[~CATALOG_GROUP_ID_1] => 1
[CATALOG_GROUP_NAME_1] => Базовая цена
[~CATALOG_GROUP_NAME_1] => Базовая цена
[CATALOG_CAN_ACCESS_1] => Y
[~CATALOG_CAN_ACCESS_1] => Y
[CATALOG_CAN_BUY_1] => Y
[~CATALOG_CAN_BUY_1] => Y
[CATALOG_PRICE_ID_1] => 60767
[~CATALOG_PRICE_ID_1] => 60767
[CATALOG_PRICE_1] => 33000.00
[~CATALOG_PRICE_1] => 33000.00
[CATALOG_CURRENCY_1] => RUB
[~CATALOG_CURRENCY_1] => RUB
[CATALOG_QUANTITY_FROM_1] =>
[~CATALOG_QUANTITY_FROM_1] =>
[CATALOG_QUANTITY_TO_1] =>
[~CATALOG_QUANTITY_TO_1] =>
[CATALOG_EXTRA_ID_1] =>
[~CATALOG_EXTRA_ID_1] =>
[ID] => 58221
[~ID] => 58221
[IBLOCK_ID] => 24
[~IBLOCK_ID] => 24
[PROPERTY_85_VALUE] => 48497
[~PROPERTY_85_VALUE] => 48497
[PROPERTY_85_VALUE_ID] => 4230860
[~PROPERTY_85_VALUE_ID] => 4230860
[PROPERTY_DATE_FROM_VALUE] => 07.11.2019
[~PROPERTY_DATE_FROM_VALUE] => 07.11.2019
[PROPERTY_DATE_FROM_VALUE_ID] => 4230867
[~PROPERTY_DATE_FROM_VALUE_ID] => 4230867
[NAME] => Designing Self-Service Business Intelligence and Big Data Solutions
[~NAME] => Designing Self-Service Business Intelligence and Big Data Solutions
[PREVIEW_PICTURE] =>
[~PREVIEW_PICTURE] =>
[DETAIL_PICTURE] =>
[~DETAIL_PICTURE] =>
[CATALOG_QUANTITY] => 0
[~CATALOG_QUANTITY] => 0
[CATALOG_QUANTITY_RESERVED] => 0
[~CATALOG_QUANTITY_RESERVED] => 0
[CATALOG_QUANTITY_TRACE] => N
[~CATALOG_QUANTITY_TRACE] => N
[CATALOG_QUANTITY_TRACE_ORIG] => D
[~CATALOG_QUANTITY_TRACE_ORIG] => D
[CATALOG_CAN_BUY_ZERO] => N
[~CATALOG_CAN_BUY_ZERO] => N
[CATALOG_CAN_BUY_ZERO_ORIG] => D
[~CATALOG_CAN_BUY_ZERO_ORIG] => D
[CATALOG_NEGATIVE_AMOUNT_TRACE] => N
[~CATALOG_NEGATIVE_AMOUNT_TRACE] => N
[CATALOG_NEGATIVE_AMOUNT_ORIG] => D
[~CATALOG_NEGATIVE_AMOUNT_ORIG] => D
[CATALOG_SUBSCRIBE] => N
[~CATALOG_SUBSCRIBE] => N
[CATALOG_SUBSCRIBE_ORIG] => D
[~CATALOG_SUBSCRIBE_ORIG] => D
[CATALOG_AVAILABLE] => Y
[~CATALOG_AVAILABLE] => Y
[CATALOG_WEIGHT] => 0
[~CATALOG_WEIGHT] => 0
[CATALOG_WIDTH] =>
[~CATALOG_WIDTH] =>
[CATALOG_LENGTH] =>
[~CATALOG_LENGTH] =>
[CATALOG_HEIGHT] =>
[~CATALOG_HEIGHT] =>
[CATALOG_MEASURE] =>
[~CATALOG_MEASURE] =>
[CATALOG_VAT] =>
[~CATALOG_VAT] =>
[CATALOG_VAT_ID] =>
[~CATALOG_VAT_ID] =>
[CATALOG_VAT_INCLUDED] => N
[~CATALOG_VAT_INCLUDED] => N
[CATALOG_PRICE_TYPE] => S
[~CATALOG_PRICE_TYPE] => S
[CATALOG_RECUR_SCHEME_TYPE] => D
[~CATALOG_RECUR_SCHEME_TYPE] => D
[CATALOG_RECUR_SCHEME_LENGTH] =>
[~CATALOG_RECUR_SCHEME_LENGTH] =>
[CATALOG_TRIAL_PRICE_ID] =>
[~CATALOG_TRIAL_PRICE_ID] =>
[CATALOG_WITHOUT_ORDER] => N
[~CATALOG_WITHOUT_ORDER] => N
[CATALOG_SELECT_BEST_PRICE] => N
[~CATALOG_SELECT_BEST_PRICE] => N
[CATALOG_PURCHASING_PRICE] =>
[~CATALOG_PURCHASING_PRICE] =>
[CATALOG_PURCHASING_CURRENCY] =>
[~CATALOG_PURCHASING_CURRENCY] =>
[CATALOG_TYPE] => 4
[~CATALOG_TYPE] => 4
[CATALOG_BUNDLE] => N
[~CATALOG_BUNDLE] => N
[SORT_HASH] => d371cd69ab51e53c0e3cdbf453d65471
[LINK_ELEMENT_ID] => 48497
[PROPERTIES] => Array
(
[CML2_LINK] => Array
(
[ID] => 85
[IBLOCK_ID] => 24
[NAME] => Элемент каталога
[ACTIVE] => Y
[SORT] => 5
[CODE] => CML2_LINK
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => E
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] => CML2_LINK
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 25
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => Y
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] => SKU
[USER_TYPE_SETTINGS] => Array
(
[VIEW] => A
[SHOW_ADD] => N
[MAX_WIDTH] => 0
[MIN_HEIGHT] => 24
[MAX_HEIGHT] => 1000
[BAN_SYM] => ,;
[REP_SYM] =>
[OTHER_REP_SYM] =>
[IBLOCK_MESS] => N
)
[HINT] =>
[~NAME] => Элемент каталога
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => 48497
[PROPERTY_VALUE_ID] => 4230860
[DESCRIPTION] =>
[~VALUE] => 48497
[~DESCRIPTION] =>
)
[CITY] => Array
(
[ID] => 92
[IBLOCK_ID] => 24
[NAME] => Город проведения
[ACTIVE] => Y
[SORT] => 500
[CODE] => CITY
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => Y
[FILTRABLE] => Y
[IS_REQUIRED] => Y
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Город проведения
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => Москва
[PROPERTY_VALUE_ID] => 4230869
[DESCRIPTION] =>
[~VALUE] => Москва
[~DESCRIPTION] =>
)
[MAX_COUNT] => Array
(
[ID] => 100
[IBLOCK_ID] => 24
[NAME] => Исходное количество мест
[ACTIVE] => Y
[SORT] => 500
[CODE] => MAX_COUNT
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => N
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Исходное количество мест
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[DATE_FROM] => Array
(
[ID] => 101
[IBLOCK_ID] => 24
[NAME] => Начало курса
[ACTIVE] => Y
[SORT] => 500
[CODE] => DATE_FROM
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => Y
[FILTRABLE] => Y
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] => DateTime
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Начало курса
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => 07.11.2019
[PROPERTY_VALUE_ID] => 4230867
[DESCRIPTION] =>
[~VALUE] => 07.11.2019
[~DESCRIPTION] =>
)
[DATE_TO] => Array
(
[ID] => 102
[IBLOCK_ID] => 24
[NAME] => Окончание курса
[ACTIVE] => Y
[SORT] => 500
[CODE] => DATE_TO
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => Y
[FILTRABLE] => Y
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] => DateTime
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Окончание курса
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => 11.11.2019
[PROPERTY_VALUE_ID] => 4230868
[DESCRIPTION] =>
[~VALUE] => 11.11.2019
[~DESCRIPTION] =>
)
[FLAG_SALE] => Array
(
[ID] => 141
[IBLOCK_ID] => 24
[NAME] => Скидки
[ACTIVE] => Y
[SORT] => 500
[CODE] => FLAG_SALE
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => L
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => C
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Скидки
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
[VALUE_ENUM_ID] =>
)
[IN_ACTION] => Array
(
[ID] => 142
[IBLOCK_ID] => 24
[NAME] => Участвует в акциях
[ACTIVE] => Y
[SORT] => 500
[CODE] => IN_ACTION
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => E
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => Y
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 30
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] => EList
[USER_TYPE_SETTINGS] => Array
(
[size] => 1
[width] => 0
[group] => N
[multiple] => N
)
[HINT] =>
[~NAME] => Участвует в акциях
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[NEW] => Array
(
[ID] => 144
[IBLOCK_ID] => 24
[NAME] => Новинка
[ACTIVE] => Y
[SORT] => 500
[CODE] => NEW
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => L
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => C
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Новинка
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
[VALUE_ENUM_ID] =>
)
[DURATION_HOURS] => Array
(
[ID] => 174
[IBLOCK_ID] => 24
[NAME] => Длитеность, часов
[ACTIVE] => Y
[SORT] => 500
[CODE] => DURATION_HOURS
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => N
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Длитеность, часов
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => 40
[PROPERTY_VALUE_ID] => 4230863
[DESCRIPTION] =>
[~VALUE] => 40
[~DESCRIPTION] =>
)
[DURATION_DAYS] => Array
(
[ID] => 175
[IBLOCK_ID] => 24
[NAME] => Длитеность, дней
[ACTIVE] => Y
[SORT] => 500
[CODE] => DURATION_DAYS
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => N
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Длитеность, дней
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => 5
[PROPERTY_VALUE_ID] => 4230864
[DESCRIPTION] =>
[~VALUE] => 5
[~DESCRIPTION] =>
)
[COURSE_CODE] => Array
(
[ID] => 176
[IBLOCK_ID] => 24
[NAME] => Код курса
[ACTIVE] => Y
[SORT] => 500
[CODE] => COURSE_CODE
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Код курса
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => 20467
[PROPERTY_VALUE_ID] => 4230865
[DESCRIPTION] =>
[~VALUE] => 20467
[~DESCRIPTION] =>
)
[ACTION_NUMBER] => Array
(
[ID] => 177
[IBLOCK_ID] => 24
[NAME] => Номер акции
[ACTIVE] => Y
[SORT] => 500
[CODE] => ACTION_NUMBER
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Номер акции
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[MARKER] => Array
(
[ID] => 178
[IBLOCK_ID] => 24
[NAME] => Маркер
[ACTIVE] => Y
[SORT] => 500
[CODE] => MARKER
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Маркер
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => Ms
[PROPERTY_VALUE_ID] => 4230866
[DESCRIPTION] =>
[~VALUE] => Ms
[~DESCRIPTION] =>
)
[HINT] => Array
(
[ID] => 179
[IBLOCK_ID] => 24
[NAME] => Примечание
[ACTIVE] => Y
[SORT] => 500
[CODE] => HINT
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Примечание
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[B_SPECIAL_PRICE] => Array
(
[ID] => 180
[IBLOCK_ID] => 24
[NAME] => B_SPECIAL_PRICE
[ACTIVE] => Y
[SORT] => 500
[CODE] => B_SPECIAL_PRICE
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => N
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => B_SPECIAL_PRICE
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => 0
[PROPERTY_VALUE_ID] => 4230861
[DESCRIPTION] =>
[~VALUE] => 0
[~DESCRIPTION] =>
)
[NORMAL_PRICE] => Array
(
[ID] => 181
[IBLOCK_ID] => 24
[NAME] => Стандартная цена для 1 чел.
[ACTIVE] => Y
[SORT] => 500
[CODE] => NORMAL_PRICE
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => N
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Стандартная цена для 1 чел.
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => 33000
[PROPERTY_VALUE_ID] => 4230862
[DESCRIPTION] =>
[~VALUE] => 33000
[~DESCRIPTION] =>
)
[SECTION_CODE] => Array
(
[ID] => 186
[IBLOCK_ID] => 24
[NAME] => Подкатегория курса 4
[ACTIVE] => Y
[SORT] => 500
[CODE] => SECTION_CODE
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Подкатегория курса 4
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => 70
[PROPERTY_VALUE_ID] => 4230870
[DESCRIPTION] =>
[~VALUE] => 70
[~DESCRIPTION] =>
)
[SHOW_TO_MAIN] => Array
(
[ID] => 189
[IBLOCK_ID] => 24
[NAME] => Показывать на главной
[ACTIVE] => Y
[SORT] => 500
[CODE] => SHOW_TO_MAIN
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => L
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => C
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Показывать на главной
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
[VALUE_ENUM_ID] =>
)
)
[DISPLAY_PROPERTIES] => Array
(
[DATE_TO] => Array
(
[ID] => 102
[IBLOCK_ID] => 24
[NAME] => Окончание курса
[ACTIVE] => Y
[SORT] => 500
[CODE] => DATE_TO
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => Y
[FILTRABLE] => Y
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] => DateTime
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Окончание курса
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => 11.11.2019
[PROPERTY_VALUE_ID] => 4230868
[DESCRIPTION] =>
[~VALUE] => 11.11.2019
[~DESCRIPTION] =>
[DISPLAY_VALUE] => 11.11.2019
)
)
[PRODUCT] => Array
(
[TYPE] => 4
[AVAILABLE] => Y
[MEASURE] =>
[VAT_ID] =>
[VAT_RATE] =>
[VAT_INCLUDED] => N
[QUANTITY] => 0
[QUANTITY_TRACE] => N
[CAN_BUY_ZERO] => N
[SUBSCRIPTION] =>
[BUNDLE] => N
)
[ITEM_PRICE_MODE] => S
[ITEM_PRICES] => Array
(
[0] => Array
(
[UNROUND_BASE_PRICE] => 33000
[UNROUND_PRICE] => 33000
[BASE_PRICE] => 33000
[PRICE] => 33000
[ID] => 60767
[PRICE_TYPE_ID] => 1
[CURRENCY] => RUB
[DISCOUNT] => 0
[PERCENT] => 0
[VAT] => 0
[QUANTITY_FROM] =>
[QUANTITY_TO] =>
[QUANTITY_HASH] => ZERO-INF
[MEASURE_RATIO_ID] =>
[PRINT_BASE_PRICE] => 33 000 руб.
[RATIO_BASE_PRICE] => 33000
[PRINT_RATIO_BASE_PRICE] => 33 000 руб.
[PRINT_PRICE] => 33 000 руб.
[RATIO_PRICE] => 33000
[PRINT_RATIO_PRICE] => 33 000 руб.
[PRINT_DISCOUNT] => 0 руб.
[RATIO_DISCOUNT] => 0
[PRINT_RATIO_DISCOUNT] => 0 руб.
[PRINT_VAT] => 0 руб.
[RATIO_VAT] => 0
[PRINT_RATIO_VAT] => 0 руб.
[MIN_QUANTITY] => 1
)
)
[ITEM_QUANTITY_RANGES] => Array
(
[ZERO-INF] => Array
(
[HASH] => ZERO-INF
[QUANTITY_FROM] =>
[QUANTITY_TO] =>
[SORT_FROM] => 0
[SORT_TO] => INF
)
)
[ITEM_MEASURE_RATIOS] => Array
(
[0] => Array
(
[ID] => 0
[RATIO] => 1
[IS_DEFAULT] => Y
)
)
[ITEM_MEASURE] => Array
(
[ID] =>
[TITLE] => место
[~TITLE] => место
)
[ITEM_MEASURE_RATIO_SELECTED] => 0
[ITEM_QUANTITY_RANGE_SELECTED] => ZERO-INF
[ITEM_PRICE_SELECTED] => 0
[CHECK_QUANTITY] =>
[CATALOG_MEASURE_NAME] => место
[~CATALOG_MEASURE_NAME] => место
[CAN_BUY] => 1
[ITEM_PRICES_CAN_BUY] => 1
[~BUY_URL] => /courses/_20467/?ELEMENT_CODE=_20467&action=BUY&id=58221
[BUY_URL] => /courses/_20467/?ELEMENT_CODE=_20467&action=BUY&id=58221
[~ADD_URL] => /courses/_20467/?ELEMENT_CODE=_20467&action=ADD2BASKET&id=58221
[ADD_URL] => /courses/_20467/?ELEMENT_CODE=_20467&action=ADD2BASKET&id=58221
[~SUBSCRIBE_URL] => /courses/_20467/?ELEMENT_CODE=_20467&action=SUBSCRIBE_PRODUCT&id=58221
[SUBSCRIBE_URL] => /courses/_20467/?ELEMENT_CODE=_20467&action=SUBSCRIBE_PRODUCT&id=58221
[~COMPARE_URL] => /courses/_20467/?ELEMENT_CODE=_20467&action=ADD_TO_COMPARE_LIST&id=58221
[COMPARE_URL] => /courses/_20467/?ELEMENT_CODE=_20467&action=ADD_TO_COMPARE_LIST&id=58221
[~COMPARE_DELETE_URL] => /courses/_20467/?ELEMENT_CODE=_20467&action=DELETE_FROM_COMPARE_LIST&id=58221
[COMPARE_DELETE_URL] => /courses/_20467/?ELEMENT_CODE=_20467&action=DELETE_FROM_COMPARE_LIST&id=58221
[CATALOG_MEASURE_RATIO] => 1
[OFFER_GROUP] =>
[RATIO_PRICE] => Array
(
[VALUE] => 33000
[DISCOUNT_VALUE] => 33000
[PRINT_VALUE] => 33 000 руб.
[PRINT_DISCOUNT_VALUE] => 33 000 руб.
[DISCOUNT_DIFF] => 0
[PRINT_DISCOUNT_DIFF] => 0 руб.
[DISCOUNT_DIFF_PERCENT] => 0
[CURRENCY] => RUB
)
[MORE_PHOTO] => Array
(
[0] => Array
(
[SRC] => /bitrix/templates/.default/components/bitrix/catalog.element/course/images/no_photo.png
[WIDTH] => 150
[HEIGHT] => 150
)
)
[MORE_PHOTO_COUNT] => 1
)
)
- 07.11.2019 Москва записаться
Курс предназначен для специалистов в области бизнес-аналитики и баз данных, отвечающих за проектирование инфраструктуры бизнес-аналитики и ее взаимосвязи с другими системами данных. Также, эти специалисты отвечают за проектирование кубов OLAP и интеграцию с Microsoft SharePoint и другими бизнес-приложениями. Навыки, полученные в этом курсе применимы к базам данных в среде Windows Azure SQL Server.
После успешного прохождения курса слушатели должны уметь:
Планировать компоненты решения бизнес-аналитики
Планировать инфраструктуру бизнес-аналитики
Проектировать хранилища данных
Разрабатывать решения ETL (извлечение, трансформация, загрузка)
Планировать аналитические модели
Планировать решения по предоставлению данных
Создавать проекты Reporting Services
Проектировать решения отчетности на базе Excel
Планировать решения бизнес-аналитики с использованием SharePoint
Выполнять мониторинг и оптимизацию решений бизнес-аналитики
Планировать административные задачи систем бизнес-аналитики
Необходимая предварительная подготовка:
Базовое понимание пространственного моделирования (схема звезда) центров данных
Умение создавать пакеты Integration Services, включающие контролирующие потоки (control flow) потоки данных (data flow)
Умение создавать базовые многомерные кубы с использованием Analysis Services
Умение создавать базовые табличные модели с использованием PowerPivot и Analysis Services
Умение создавать отчеты Reporting Services с использованием Report Designer
Умение настраивать аутентификацию и разрешения для баз данных SQL Server, Analysis Services, Reporting Services
Базовые знания SharePoint Server и приложений Microsoft Office, в особенности Excel
После успешного прохождения курса слушатели должны уметь:
Необходимая предварительная подготовка:
Аудитория курса:
Планирование аналитического решения
Элементы аналитического решения. Аналитическая платформа от Микрософта. Планирование аналитического решения.
Планирование инфраструктуры бизнес-аналитики
Ключевые критерии. Требования к оборудованию.
Проектирование хранилища данных
Этапы проектирования хранилища. Проектирование таблиц размерностей. Проектирование фактических таблиц. Планирование физической реализации хранилища.
Проектирование загрузки хранилища
Обзор ETL-процесса. Извлечение данных. Преобразование данных. Загрузка данных.
Проектирование аналитических моделей
Введение в аналитические модели данных. Проектирование моделей. Размерности. Дополнительная функциональность.
Проектирование механизмов доставки отчётов
Ключевые критерии. Типовые сценарии. Выбор инструмента генерации отчётов.
Проектирование решения на базе Reporting Services
Планирование решения. Проектирование отчётов. Согласованность отчётов.
Проектирование решения на базе Excel
Использование Excel для аналитики и отчётности. PowerPivot. PowerView.
Проектирование решения на базе SharePoint
SharePoint как платформа для бизнес-аналитики. Планирование безопасности. Конфигурация Reporting Services. Конфигурация PowerPivot. Панели PerformancePoint.
Мониторинг и оптимизация аналитического решения
Постановка задачи. Мониторинг и оптимизация хранилища. Мониторинг и оптимизация аналитических служб. Мониторинг и оптимизация служб отчётности.
Эксплуатация аналитического решения
Обзор и постановка задачи. Эксплуатация ETL-решения. Работа с хранилищем. Работа с аналитическими службами. Работа с отчётными службами.