Power Pivot DAX in Depth Excel
By: Ron Davis
Duration: 2h 25m
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.
- Exploring DAX syntax and data types
- Using functions
- Understanding evaluation contexts
- Using CALCULATE to change evaluation context
- Working with dates
- Utilizing many-to-many relationships
- Implementing banding
Ron (NorSivad) Davis has spent over forty years in technology, and has held positions ranging from customer engineer–now called technician–through senior manager at a mid-cap US corporation. Ron has owned and operated several businesses over the years and has concentrated on business intelligence for over ten years. Ron has written over twenty courses for the Microsoft Community Courseware library, which have been distributed and delivered worldwide by Microsoft Learning Partners. Ron lives and works at his home in Plano, Texas, and on his tree farm near Linden, Texas. While in Plano, Ron continues to develop and teach courses, and in Linden he wonders what you do with a tree farm. Ron is also the owner/publisher of BlueBuffaloPress.com.