UNDERSTANDING DAX CONCEPTS WITH POWER BI & EXCEL

DAX formulas include functions, operators, and values to perform advanced calculations and queries on data in related tables and columns in tabular data models in Power BI. Learning how to create effective DAX formulas will help you get the most out of your data.

What is DAX?

Data Analysis Expressions (DAX) is a formula expression language used in Analysis Services, Power BI, and Power Pivot in Excel. DAX formulas include functions, operators, and values to perform advanced calculations and queries on data in related tables and columns in tabular data models.

JarinaCert

Trainer

Jarina Ismail, Microsoft Certified Trainer

Since 2005, Jarina is involved in delivering learning programs for Microsoft PowerBI, Microsoft Excel, PowerPoint, Project, Outlook, Access, Word, Publisher and Visio. As a Microsoft Office Specialist (MOS) in all versions (2003-365 & 2019), she is using her expertise to provide timely solutions to the end-user which ranges from basic to advanced level including power users. She has experience in training and coaching various teams of professionals like executives, engineers, managers and directors to organize, analyze, create report and present business data more efficiently.

Apart from training, she has also develops training material for Microsoft Office Applications. Furthermore the training experience leads her to design customized trainings for specific job-scope and industry to meet their training needs. Besides that, she also conducts pre and post assessment for the training attendees to identify training needs and evaluate learning effectiveness after the training. She is one of the main contributors to the Greenmark Entry Level Test development.

When to use?

  • Select, join, filter data in a dynamic way
  • Create smarter calculated columns and/or measures by which you can limit the data the dashboard has to fetch and visualize
  • Shows a cumulative growth in value overtime
  • Compare sales in a date range to another date range

Audience

  • Sales Executive / Managers
  • Business Analysist
  • Resource Planning Team
  • Project Managers
  • Purchasing Manager
  • Financial Executive / Managers

Prerequisites

  • Familiar with creating formulas in Microsoft Excel
  • Import data from various source into Power BI
  • Understand relationship between tables
  • Creating visual reports in Power BI

Courses

Part 1

Date : 26th March 2022

Time : 9AM – 5PM

Fee : RM79/pax

Part 2

Date : 9th April 2022

Time : 9AM – 5PM

Fee : RM79/pax

Ask Us