$1,356

Multiple Dates

Power BI - M & DAX languages (2 days)

Actions and Detail Panel

$1,356
$1,356

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.


		Power BI - M & DAX languages (2 days) image
Share with friends

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.

{ _('Organizer Image')}

Organizer Daxel

Organizer of Power BI - M & DAX languages (2 days)

Save This Event

Event Saved