Creating calculated columns and measures using DAX functions
Understanding implicit and explicit measures
Using CALCULATE functions to alter the filter context
Using FILTER functions to filter data
Introduction to Time Intelligence functions
Understanding implicit and explicit measures
Understanding SUMX,COUNTX,AVERAGEX,MAXX,MINX functions to summarize data
Use of Xlookup (the most powerful lookup function in Excel)
Creating calculated table by using SUMMARIZE functions
Understanding of the Dynamic array formula
Instructor
Dannis Mok
who has rich experience in business web and apps system development and have over 20 years of teaching experience.
He has great passion in learning and teaching new technologies and his teaching style is clear to point and can explain complex technologies in simple terms.
He has delivered various workshops and classes for different corporate, government departments and local universities and is the principal lecturer for NCC Education and University of Greenwich.
Besides BSc degree in IT, he also got a MBA, MSc in IT and MSc in Telecommunication degree.