UNDERSTANDING DAX CONCEPTS WITH POWER BI
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. DAX formulas include functions, operators, and values to perform advanced calculations and queries on data in related tables and columns in tabular data models.
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
Data Modeling & Calculations in Power BI
Participants will be able to transform raw datasets into reliable, scalable, and efficient models that support accurate reporting and insights.
Date : 29 – 30 September, 24 – 25 November.
Best for:
Data Analysts, Business Analysts, IT/Data Engineers.
Powerful Visualization with
Power BI
The course ensures learners can turn complex data into compelling visuals that drive better business decisions.
Date : 8 – 9 September, 17 – 18 November.
Best for:
Sales Managers, Marketing Executives, ,Finance Executives, Report/Dashboard Designer.
HR Analytics using Power BI
Participants will learn to analyze trends, track KPIs, and generate actionable HR insights.
Date : 26 – 28 November.
Best for:
HR Managers, HR Executives, HR Analysts.
Expert Data Visualization & Analytics
The program is ideal for those who want to communicate insights clearly, making data-driven messages resonate with stakeholders and decision-makers.
Date : 3 – 4 September, 3 – 4 December.
Best for:
BI Developers, Business Managers, Executives.