Power BI Foundations (2 days)

Power BI Foundations (2 days)

Actions and Detail Panel



Training Room

123 Slater Street

Ottawa, ON K1P 5G4


View map

Refund policy

Refunds up to 7 days before event

Eventbrite's fee is nonrefundable.

Build interactive powerful reports and dashboards in Power BI. Understand the tool as a whole to to properly use the Desktop application.

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

Managers, Analysts, Accountants, Report Builders

Course Learning Outcomes

  • Master the Microsoft Power BI Service environment
  • Build an interactive report using Power BI Desktop application
  • Develop strategies to pursue self-paced 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. Master Power BI Service

  • Understand the terminology
  • Navigate the interface
  • Interact with a report : use filters, slicers, sort order, export, print, publish to web, etc.
  • Use storytelling tools: bookmarks, spotlight, focus, tooltip etc.
  • Collaborate within an App Workspace
  • Build a dashboard: Format dashboard tiles, Add an image tile, Review Web display versus Mobile Display
  • Publish an app to share
  • Explore Quick Insights functionality

2. Build a report with Power BI Desktop

  • Explore the Desktop application
  • Import data as an Excel file, a Text file, a Folder or a Web page
  • Use Power Query Editor to transform data: remove lines, use first row as header, remove columns, extract text using delimiters, replace values, set data types, rename fields and queries, append queries
  • Add relationships between tables
  • Edit fields data type, aggregation, categorization and sort by order
  • Create visualizations: bar chart, column chart, treemap, gauge, KPI, slicer, map
  • Customize visualizations: format axis, title, color theme, header
  • Insert visual elements: image, text box
  • Create and use a hierarchy
  • Edit interactions between visualizations
  • Add page filters
  • Create measures with functions: SUM, MAX, DIVIDE, CALCULATE, ALL, TOTALYTD
  • Publish to Power BI Service

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.


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?


Power BI Foundations (2 days) image