30. 1月 2020 - 10:30
Training Room, Ottawa
それを共有します:

Power BI - M & DAX languages (2 days) | 木曜日, 30. 1月 2020

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 email or text/call 819-635-6564


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

Yes. Email request at email 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 email


Is my ticket transferrable?

Yes. Email request at email


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

Yes.


https://cdn-az.allevents.in/events10/banners/93e29710-d3ea-11ea-be1a-cdb6f93da770-rimg-w720-h360-gmir.jpg