Power BI Training: Unlocking Data Mastery with DAX
Are you ready to supercharge your Power BI training experience? Welcome to the world of Power BI training, where we delve into the art of Data Analysis Expressions (DAX) in the context of Power BI. In our dynamic ‘DAX in Power BI Part I’ course, we empower you with the knowledge and tools to harness the full potential of your data.
What You'll Learn
In this 1-day instructor-led course, you’ll master the intricacies of Power BI formulas. From understanding data types and calculated columns to unleashing the power of evaluation contexts and time intelligence functions, you’ll gain a comprehensive understanding of how to transform data into actionable insights. Whether you’re a Sales Executive, Business Analyst, Project Manager, or Financial Executive, this course is designed to elevate your analytical prowess with specialized Power BI training.
Our Teaching Approach
Our training methodology combines interactive lectures, PowerPoint presentations, lively discussions, and hands-on exercises, all tailored to enhance your Power BI training journey. We don’t just teach concepts; we help you apply them in real-world scenarios. By the end of the course, you’ll be equipped to create impressive presentations, perform calculations, work with tables, and handle data with confidence. Don’t miss out on the opportunity to become a data master. Join us for ‘DAX in Power BI Part I’ and embark on your journey to data excellence.
Unleash the power of data today with our specialized Power BI training!
Course Details
Duration: 1 Day; Instructor-led
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.
Audience
- Sales Executive / Managers
- Business Analysist
- Resource Planning Team
- Project Managers
- Purchasing Manager
- Financial Executive / Managers
Prerequisites
- Sales Executive / Managers
- Business Analysist
- Resource Planning Team
- Project Managers
- Purchasing Manager
- Financial Executive / Managers
Methodology
This program will be conducted with interactive lectures, PowerPoint presentation, discussion, and practical exercise.
Course Objectives
Upon completion of this program, participants should be able to :
- Enhance your productivity using ribbons in PowerPoint
- Move beyond default PowerPoint templates
- Create impressive presentations using templates
Upon completion of this program, participants should be able to:
- Getting Started with Microsoft Excel 2019, Identify the Elements, and Interface of Excel
- Performing Calculation, Basic Formula and Functions
- Modify worksheet & Formatting Worksheet
- Printing and managing large workbook
Outlines
Module 1: Introduction to DAX
- What is DAX?
- DAX data types
- Calculated columns
- Measures
- Aggregation functions
- Counting values
- Conditional functions
- Handling errors
- Using variables
- Mathematical functions
- Relational functions
Module 2: Table Functions
- Introduction to table functions
- Filtering a table
- Ignoring filters
- Mixing filters
- DISTINCT Function
- How many values for a column?
- ALLSELECTED function
- RELATEDTABLE function
- Tables and relationships
- Tables with one row and one column
- Table variables Â
Module 3: Evaluation Contexts
- Introduction to evaluation contexts
- Filter context
- Row context
- Context errors
- Filtering a table
- Using RELATED in a row context
- Ranking by price
- Evaluation contexts and relationships
- Filters and relationships
Module 4: Calculate Function
- Introduction to CALCULATE function
- CALCULATE function examples
- CALCULATE function recap
- What is a filter context?
- KEEPFILTERS function
- CALCULATE operators
- Use one column only in a compact syntax
- Variables and evaluation contexts  Â
Module 5: Advanced Evaluation Contexts
- CALCULATE modifiers
- USERELATIONSHIP function
- CROSSFILTER function
- ALL function
- ALLSELECTED function
- KEEPFILTERS function
- Context transition
- Circular dependency
- CALCULATE execution order
Module 6: Iterators
- Working with iterators
- MINX and MAXX functions
- Useful iterators
- RANKX function
- ISINSCOPE function
Module 7: Building a Date Table
- Introduction to date tables
- Auto Date/Time
- CALENDARAUTO function
- Mark as date table
- Using multiple dates
Module 8: Time Intelligence in DAX
- What is time intelligence?
- Time intelligence functions
- DATEADD function
- DATESINPERIOD function
- Running total
- Mixing time intelligence functions
- Semi-additive measures
- Calculation over weeks
Module 9: Hierarchies in DAX
- What are hierarchies?
- FILTER and CROSSFILTER function
- Percentages over hierarchies
- Parent-child hierarchies
