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

Microsoft Power BI Course- Intermediate (1-Day Training)
Image from eventbrite.ca
Thu 10 October 2019
Thursday 10 October 2019
9:00 AM - 4:00 PM
Ended


In this Microsoft Power BI training, you acquire intermediate skills to enhance your data and create complex, automated, interactive reports

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.

https%3A%2F%2Fcdn.evbuc.com%2Fimages%2F61363986%2F288479184069%2F1%2Foriginal.20190429-155251?h=2000&w=720&auto=compress&s=5b3d781c7ea10d31c09808e0348a80ff

1 Views - 11/10/2019 Last update
culture sports
Suite 610
123 Slater Street, Ottawa, K1P 5G4, ON, Canada

Event from
eventbrite.ca

Are you an event organizer?
Create events for free. They will be immediately recommended to interested users.
Create event

Nearby hotels and apartments

123 Slater Street, Ottawa, K1P 5G4, ON, Canada

Browse other venues in Ottawa
Discover now

The best nearby experiences from our partners

Get your guide
Viator
WhitLocals
Tiqets
Musement
bed egges

Discover more events in Ottawa
Discover now



Suite 610
123 Slater Street, Ottawa, K1P 5G4, ON, Canada

Event from
eventbrite.ca

Are you an event organizer?
Create events for free. They will be immediately recommended to interested users.
Create event
 
 
 
 
Your changes have been saved.