Course details
The Advanced course enables you to master Power Pivot for Excel. You will understand DAX in depth, which is required for writing complex calculations. You will also learn how to create complex reports and data models by leveraging advanced features of both Excel and Power Pivot.
The course includes almost 4 hours of video in 24 lectures. You need some experience of Power Pivot and the DAX language, or you should take the Beginner and Intermediate courses before this one.
Sections included in this course:
- Creating Reports and KPI
- Advanced DAX Concepts
- Advanced DAX Functions
- DAX as a Query Language
- DAX Patterns
After this course, you will have all the tools and the knowledge to create complex calculations and models using Power Pivot for Excel.
Updated on 27 December, 2017 Visit Website
Courses you can instantly connect with... Do an online course on Microsoft Office starting now.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Excel : Top 50 Formulas Course DriveUSD 24
USD 160Duration: Upto 1 Hour - Microsoft Office 2016 Excel for Beginners Adams AcademyUSD 53
USD 530Duration: Upto 4 Hours
