$1,356

Power BI - M & DAX languages (2 days)

Event Information

Share this event

Date and Time

Location

Location

Training Room

123 Slater Street

Ottawa, ON K1P 5G4

Canada

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Eventbrite's fee is nonrefundable.

Event description
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.

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

Bring Your Own Device

Each participant must bring his/her laptop with Power BI Desktop application.

Laptop Rental Available.

Quality Service

This Power BI training session is limited to 6 attendees to address each participants questions and requests.

The course is delivered at the Ottawa Impact Hub in a comfortable, bright and modern environment. COVID-19 restrictions applied to ensure social distancing.

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.

Daxel may also be contacted 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

Can I rent a laptop with Power BI Desktop application installed ?

Yes. Email request at julie.foucault@daxel.ca or book online.

Are snacks provided ?

Yes. Tea, coffee and snacks are provided by the organizer.

What's the refund policy?

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

Do I have to bring my printed ticket to the event?

No. Simply bring positive attitude!

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.

Share with friends

Date and Time

Location

Training Room

123 Slater Street

Ottawa, ON K1P 5G4

Canada

View Map

Refund Policy

Refunds up to 7 days before event

Eventbrite's fee is nonrefundable.

Save This Event

Event Saved