Brief Introduction
Improve your Power Pivot skills to master level, learning advanced DAX functions and data modeling techniques.Description
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.
Requirements
- Requirements
- Power Pivot for Excel 2010 or Excel 2013
Data Analysis using Microsoft Excel
- 5
-
![]()
![]()
![]()
![]()
![]()
50 Lectures, 120 Assignments with video solutions, 762 Assignments with instant assessment using the TEST4U application ----- UPDATED FEBRUARY 2020 -----...
Mastering MS Excel
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Master MS Excel 2010-2016 in 5hrs of easy to follow videos The Mastering MS Excel is aimed at MS Excel 2010 to 2016....
Mastery Courses - Microsoft Excel, Word, Unlock Macros & VBA
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Mastery Series of Complete Microsoft Excel, Microsoft Word, Excel Macros & VBA in One! (Excel 2016, 2019 & Office 365) 1....
Practical Excel data analysis skills - Excel 2010, 2013,2016
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Excel 2010, 2013, 2016: Hands-on Excel data analysis skills for business analyst, small business owner, startup founder This course covers all must-have Excel skills to work effectively with Excel....
