Excel BI - Learn Power Pivot and DAX functions Год выпуска: 2015 Производитель: Udemy Сайт производителя: udemy.com Автор: Paula Guilfoyle Продолжительность: 2:36 Тип раздаваемого материала: Видеоклипы Язык: Английский Описание: Power Pivot is an Excel add-in, available in Excel 2010 and certain versions of Excel 2013. You can use Power Pivot, with its own DAX functions to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily. Обзор дополнения Power Pivot для Экселя.
Содержание
1 - Opening Intro 2 - Power Pivot for the Excel User - Introduction 3 - Installing Power Pivot 4 - Import data from access 5 - import data from custom query 6 - import data from excel 7 - Importing text files 8 - Saving your Power Pivot file 9 - Section 1 review 11 - Working with tables 12 - relationships 13 - Calculated Columns 14 - Insert Pivot Table 15 - Insert Pivot Charts 16 - Slicers 17 - Section 2 review 18 - understand measures 19 - Creating Measures 20 - Section 3 review 21 - DAX an introduction 22 - x functions and countrows 23 - Related and Related table 24 - Filer and Distinct 25 - Calculate function 26 - Section 4 review 27 - Time intelligence 1 28 - Time intelligence 2 29 - time intelligence 3 30 - Closing lecture
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon}
