Microsoft Power BI Course- Intermediate (1-Day Training)

Event Information

Share this event

Date and Time

Location

Location

Suite 610

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
In this Microsoft Power BI training, you acquire intermediate skills to enhance your data and create complex, automated, interactive reports

About this Event

Microsoft Certified Professional

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

Target Audience

Business analysts, data analytics professionals, data analysis training enthusiasts

Prerequisites

Basic skills in Power BI Desktop: navigate the environment, connect to a data source, add relationships between tables, create visualizations

Course Learning Outcomes

Understand and use Power Query Editor advanced functionalities : values, lists and tables

Understand and edit M language in Power Query Editor

Build a DAX Reference Tool : understand and use DAX most common functions

Develop a learning strategy to pursue M and DAX learning

Bring Your Own Device

Each participant must bring his/her laptop with Power BI Desktop application. Additional fees for laptop rental.

Quality Service

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

The Power BI course is held at the Ottawa Impact Hub in a comfortable, bright and modern environment.

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
  • Understand the queries automatically generated to combine files
  • Edit a query: remove columns, extract text after delimiter, add a conditional column, filter, unpivot columns, group by, drill down
  • Manage an error message
  • Insert an Applied Step
  • Edit an Applied Step
  • Rename an Applied Step, a field and a query
  • Add a query description
  • Edit a query to disable load to report
  • 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. 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 Variables in DAX formulas
  • Build a What If Parameter
  • Deal with an inactive relationship
  • Search the web to resolve issues
  • Explore recommended web resources

Find out more about this Intermediate Microsoft Power BI Course.

Find out more about the 2-day Microsoft Power BI training also offered in Ottawa.

Share with friends

Date and Time

Location

Suite 610

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