About the Course
Data Analysis Expressions (DAX) is a programming language that is used throughout Microsoft Power BI for creating calculated columns, measures, and custom tables. It is a collection of functions, operators, and constants that can be used in a formula, or expression, to calculate and return one or more values.Dr. Sameer Rohadia, a Microsoft Certified Power BI Professional & Microsoft Certified Trainer, has trained 9000+ Industry professionals, University Professors and students in the area of MS Power BI and MS Excel. He has a reputation for delivering excellent, logically structured courses that are easy to follow and get the point across without wasting learners’ time.
In this 15-hour virtual & hands-on course, you will learn how to create relationships, measures, calculated columns, use DAX and all the other skills you need to build a data model that ensures your reports are top-notch!
Course Objective
- Enjoy clear and concise step by step lessons from a 5-star rated BI Specialist & Certified IT Trainer
- Use DAX and learn what you can achieve with DAX if utilized well
- Structure and format DAX formula
- Have a comprehensive understanding of creating data models and developing DAX formulas in Microsoft Power BI
- Create calculated Columns and Measures using DAX in Power BI
- Perform sophisticated calculations such as Time Intelligence, Relationship and Table functions
- Audit your formulas by understanding Filter and Row context
Basic Knowledge
Some basic knowledge in Power BI is strongly encouraged.Agenda
- Introduction to DAX
- Evaluation contexts
- CALCULATE function
- Table functions
- Relationship functions
- Time Intelligence functions
Who Should Attend
- Aspiring data professionals looking to master the #1 BI tool on the market.
- Excel users who want to learn how to create Professional reports in Power BI.
- Data Analytics or BI professionals looking to build expert-level DAX + Power BI skills.
- St
