Excel Power Pivot DAX in Depth Год выпуска: 2015 Производитель: Lynda Сайт производителя: lynda.com Автор: Ron Davis Продолжительность: 2:25 Тип раздаваемого материала: Видеоурок Язык: Английский Описание: You cannot get far in Excel Power Pivot, the future of personal business intelligence, without an understanding of DAX: Data Analysis Expressions. This course teaches you how to unlock DAX's power by understanding its fundamental elements: its syntax, operators, data types, and functions, including the revolutionary CALCULATE function. Author Ron Davis also helps you understand how evaluation context affects DAX expression output, and integrate time and dates into Power Pivot calculations. Start watching now to take your data analysis skills to the next level with DAX. Анализ данных в Excel 2013.
Содержание
Introduction Welcome What you should know before watching this course Using the exercise files 1. Introduction to DAX Getting familiar with DAX Exploring DAX syntax Exploring data types Utilizing operators Exploring the Power Pivot data model Understanding errors 2. Using DAX Functions Using mathematical functions Using logical functions Using information functions 3. Understanding Evaluation Contexts How to proceed through this chapter Understanding evaluation context for calculated columns and fields Understanding single table evaluation context Understanding multiple table evaluation context Exploring FILTERS and the ALL functions Understanding the syntax and rules of the CALCULATE function Exploring how CALCULATE works Utilizing CALCULATE to change evaluation context 4. Working with Dates Understanding time intelligence Sourcing calendars Working with date functions Working with DATESINPERIOD functions Exercising caution with time intelligence 5. Utilizing Advanced DAX Functionality Utilizing many-to-many relationships Implementing banding DAX Studio and EVALUATE Conclusion Next steps
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}
