This course was last updated on 5/2020.
We analyzed factors such as the rating (3.8/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.
✓ Explain and use Calculated Columns and Measures
✓ Explain and use aggregation functions and expressions in DAX such as SUM and COUNT
✓ Explain and use table functions such as Filter and RelatedTable
✓ Explain and use iteration pairs such as SUMX and COUNTX
✓ Set up Variables
✓ Work with IF statements and DAX SWITCH function
✓ Describe the fundamentals of how DAX works
✓ Explain Row context and nested Row context
✓ Explain Filter context
✓ Use the ALL function to remove filters
✓ Use the Calculate function to modify and replace basic filters
✓ Explain and demonstrate how Relationships and DAX work together
✓ Discuss the need for a DATE table
✓ Use DAX to create a DATE table using CalendarAuto and other DAX functions
✓ Use and explain Time Intelligence Functions such as TOTALTYD, SAMEPERIODLASTYEAR and more
✓ Calculate Moving totals and Rolling Totals
✓ Carry out Basic to Intermediate level DAX analysis
• You should be familiar with either Power Pivot, Power BI or Analysis Services
• You should have a want to learn DAX (Data Analysis Expressions)
• Have an interest in Data Modeling
• Analysis Services Users
• Power BI Users
• Excels Power Pivot Users
• Those that need to model data using SSAS, Power BI or Power Pivot
• Data Analyst, Finance and Accounting Staff, Marketing Professionals, Business Managers and all those involved with reporting
• This course is NOT for you if you are already comfortable working with basic and intermediate level DAX
The course costs $17.99. And currently there is a 82% discount on the original price of the course, which was $99.99. So you save $82 if you enroll the course now.
YES, Master DAX fundamentals : Power BI, Power Pivot & SSAS has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.
Paula Guilfoyle CPA & MVP has created 25 courses that got 10,904 reviews which are generally positive. Paula Guilfoyle CPA & MVP has taught 124,572 students and received a 4.3 average review out of 10,904 reviews. Depending on the information available, we think that Paula Guilfoyle CPA & MVP is an instructor that you can trust.
Microsoft MVP, CPA Accountant, & Life Long Learner
Paula is a qualified CPA with over 15 years’ experience in the fields of Accountancy, Business Management, Process improvement, Internal Audit, Group accountant, Operations Management and Training. All across a broad range of industries and sectors. Paula has been Key Speaker at many Accounting Events where her talks on Excel are received very positively. Taken from her experiences in Accounting and business fields, Paula also has Udemy courses for those wishing to upskill, especially in the area of Spreadsheets, Bookkeeping and Accounting.
In 2020 Paula was awarded with a Microsoft MVP award for her dedication to Excel and the Excel community.