$1,264.78
Power BI - M & DAX - Virtual Training  (2 days)

Power BI - M & DAX - Virtual Training (2 days)

Actions and Detail Panel

$1,264.78
$1,264.78

    Location

    Online

    100 Queen St West

    Toronto, ON M5H 2N2

    Canada

    View map

    Refund policy

    Refunds up to 7 days before event

    Eventbrite's fee is nonrefundable.

    Build more complex data models. Use M language to transform data. Build a reference tool on most common DAX functions and their application.

    About this event

    PREREQUISITE

    • Power BI Foundations course (1 day) is a prerequisite.
    • Participants must master the Power BI Service functionalities to properly use the Desktop application.
    • Participants must master navigation in Power BI Desktop, including the Power Query Editor.

    Virtual Training - LIVE Instructor

    Groups limited to 4 participants.

    Interact with instructor using a webconferencing interface: share screen and mouse control to resolve issues.

    Microsoft Certified Professional

    Our Ottawa-based instructor is certified by Microsoft, as a skilled professional in Business Intelligence Reporting. Read more.

    Target Audience

    Analysts, Accountants, Report Builders, Data Visualization Professionals, data analysis training enthusiasts

    Course Learning Outcomes

    • Use advanced functionalities in Power Query Editor and M language
    • Understand the different relationship types in data modelling
    • Build a DAX Reference Tool: understand and use DAX most common functions
    • Develop strategies to pursue M and DAX learning

    Technical Requirements for Power BI Online Course

    Participant must have access to 2 screens: using a laptop and a monitor is adequate.

    Participant must install free apps on his/her computer: Power BI Desktop and Zoom.

    Quality Service

    During this virtual course on Power BI, the participant is guided through practical exercices at his/her own pace. Participant's desktop can be shared with the instructor to resolve issues.

    All dates are guaranteed to run!

    Detailed Course Outline

    1. Power Query and M language

    • Connect to a folder and combine files
    • Explore Power Query Editor environment: Menus, Applied Steps, Advanced Editor
    • Explore M language syntax
    • Edit a query: remove columns, extract text after delimiter, add a conditional column, filter, unpivot columns, group by, drill down
    • Manage an error message
    • Edit an Applied Step using M language
    • Create Values, Lists and tables from blank queries
    • Use M functions: List.Dates, #date, Duration.Days, #duration, DateTime.LocalNow(), Date.AddYears(), Date.EndOfYear(), Date.From()
    • Create a dynamic date list
    • Search the web to resolve issues
    • Explore recommended web resources

    2. Understand relationship types in data modelling

    • Explore data model and table relationships concept
    • Visualize the impact of wrong relationships
    • Create relationships: edit type and filter direction
    • Use and understand the impact of Many-to-Many relationships
    • Edit model queries to eliminate Many-to-Many relationship

    3. Build a DAX reference tool

    • Understand DAX basic concepts and syntax
    • Differentiate measures and calculated columns
    • Use DAX functions: TODAY, YEAR, MONTH, DAY, FORMAT, COMBINEVALUES, COUNTA, COUNTBLANK, COUNTROWS, DISTINCTCOUNT, SUM, SUMX, FILTER, CALCULATE, ALL, ALLEXCEPT, DIVIDE, USERELATIONSHIP, IF, AND, OR, TOTALYTD, SAMEPERIODLASTYEAR
    • Use CALCULATE function to override relationship
    • Use Variables in DAX formulas
    • Use the What If Parameter
    • Deal with an inactive relationship
    • Search the web to resolve issues
    • Explore recommended web resources

    Learn more about us, visit www.daxel.ca, Power BI Expert in Ottawa.

    Browse other Power BI training offers by Daxel in Gatineau - Ottawa.

    Contact Daxel to schedule a private Power BI training for your organization in Gatineau - Ottawa, Toronto, Montreal and surroundings.

    FAQs

    How can I contact the organizer with any questions?

    Email at julie.foucault@daxel.ca or text/call 819-635-6564

    What's the refund policy?

    Refunds up to 7 days before event, Eventbrite's fee is nonrefundable.

    Can I update my registration information?

    Email any changes at julie.foucault@daxel.ca

    Is my ticket transferrable?

    Yes. Email request at julie.foucault@daxel.ca

    Is it ok if the name on my ticket or registration doesn't match the person who attends?

    Yes.

    Power BI - M & DAX - Virtual Training  (2 days) image

    Share with friends

    Save This Event

    Event Saved