Level Up-Introduction to DAX Functions for Excel Users
Introduction
Great reports are built on great data models. In this course, learn how to create relationships, create measures, use DAX and all the other skills you need to build a data model that ensures your reports are top-notch! This course has been updated to the latest Power BI interface so you will be using the latest version available.
Course Objectives
By the end of this course, you will be able to:
- Have a COMPREHENSIVE understanding of creating data models and developing DAX formulas in Microsoft Power BI
- Create calculated FIELDS and MEASURES using DAX in Power BI
- Perform SOPHISTICATED calculations such as Time Intelligence, Filtered Data and Creating Calculated Tables
- Create RELATIONSHIPS between tables of data
Methodology
REQUIREMENTS
- You will require Power BI desktop and access to the Power BI Service on the Internet
- You should be able to work with data in Excel and do basic reporting
- Download the Power BI Desktop app which is available free from Microsoft for Windows
PREREQUISITES
- Excel 2016 Professional level and above, 2019, 365, 2021
Who Should Attend?
This course is for intermediate/ advanced of Excel user that needs to be able to slice and dice data, measure important values and to derive useful information to assist them in making business decisions.
Training Delivery
- Face to Face Training
or
- Remote Training via Zoom Platform
- Day One
- Day Two
Day One
MODULE 1: INTRODUCTION TO THE COURSE
MODULE 2: OVERVIEW OF THE POWER BI DATA MODEL
MODULE 3: CREATING CALCULATED COLUMNS
MODULE 4: CREATING POWER BI MEASURES
Day Two
MODULE 5: TIME INTELLIGENCE FUNCTIONS
MODULE 6: ADDITIONAL MEASURE CALCULATIONS
MODULE 7: VIRTUAL TABLES
MODULE 8: CREATING RELATIONSHIPS IN POWER BI/ EXCEL BI
You May Also Be Interested In
Be Updated on the latest HR & Training Best Practices
2
Stay Updated to the Latest HR News & Training Trend
Subscribe to Our Newsletter
By providing your information above, you consent to receive marketing emails from PM Resources Sdn Bhd, which will include the latest news and updates related to our businesses. Our privacy policy contains information how we store and process your data.
