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 Teams Mastery Course CentralUSD 23
USD 100Duration: Upto 3 Hours - Microsoft Excel Diploma Course CentralUSD 23
USD 100Duration: Upto 13 Hours
