DAX - creating advanced formulas for Power BI, SQL Server Analysis Services

and for Power Pivot in Excel
    Duration
    Start hour
    Level

      DAX Training - creating advanced formulas

      Make strong, optimised measurements and calculated tables for business analytics that you can trust.

      Quick Facts

      • Price

        345 ÂŁ

      • Duration

        ⏰ 2 days (16 training hours) of practical training 

      • Training format

        Live Online Training: Learn in real-time with an expert instructor from anywhere.

      • Learning method
        • Interactive Hands-On Labs: Apply your knowledge immediately through practical exercises.
        • Real-World Business Data: Solve realistic problems using datasets relevant to your daily work.
      • Certificate

        Official training certificate issued upon course completion.

      • Registration

        Check available dates and register via this form.

        About the course

        This practical two-day online course teaches advanced DAX techniques used in Power BI, SQL Server Analysis Services and Excel PowerPivot.

        Participants will learn:

        • how to design effective measures,
        • deal with complicated connections,
        • do advanced temporal intelligence and ranking analyses through instructor-led seminars and hands-on work with actual corporate information.

        Who should attend?

        • Data analysts and BI developers who design reports and dashboards,
        • Excel power users using PowerPivot,
        • BI professionals seeking to improve DAX performance and maintainability.

        Learning outcomes

        After completing this course, participants will be able to:

        • Define and optimise measures, calculated columns and calculated tables
        • Compose complex DAX expressions and time intelligence calculations
        • Use table functions, iterators and advanced filters correctly
        • Build ranking and "Top N" analyses with RANKX
        • Handle inactive and virtual relationships and multi-column relationships
        • Create tree hierarchies and advanced relationship models

        Enrol now!

        FAQ

        What topics are covered?

        The DAX creating advanced formulas course syllabus includes:

        1. The essence of the data model
        2. Contexts of performance
        3. Calculated column vs measure
        4. Data types
        5. Operators
        6. Selected functions review:
        • aggregators and iterators
        • VALUES and DISTINCT
        • RELATED and RELATEDTABLE
        • CALCULATE and CALCULATETABLE
        • filters and modifiers
        1. Displaying messages - use of information functions
        2. Selected  time analysis functions
        3. Rankings
        • using the RANKX function
        • preparation of the "top N" analysis

        10.  Complex DAX expressions

        • syntax
        • code optimization
        • use in calculations and analyzes

        11.  Tables functions

        • defining calculated tables
        • grouping of data

        12.  Advanced relationship handling using the DAX functions

        • using inactive relationships
        • virtual relationships
        • multi-column relationships

        13.  Defining the tree hierarchy

        What requirements are needed?

        The DAX course participants are required to have:

        • knowledge of the Windows environment,
        • basic knowledge of Power BI or the Excel Power Pivot add-in (importing data, creating relationships, hierarchies and creating basic measures and calculated columns).
        • Earlier participation in the trainings Power BI - data analysis and visualization or Microsoft Excel - data analysis using Power Pivot, Power View, Power Query add-ons may be useful.
        What is included in DAX - creating advanced formulas course?
        • Two days of live training, course materials and an official completion certificate.
        • Training is carried out in the form of alternating lectures and practical exercises, performed individually or together.
        Is this DAX training is interactive?

        Yes - sessions include hands-on labs and real-world datasets.

        What's next after this course?
        How can I join?

        To sign up, simply fill out the short registration form.

        Go to form

        Similar training

        Sign up for training!

        Register now for our upcoming training sessions by filling out the registration form.

        Join us to build your expertise and take the next step in your career!

        Enrol now!

        đź“© Any questions? Get in touch with us!

        Lidia Waśnik

        lidia.wasnik@comarch.com

        +48 12 646 14 41