$600

Multiple Dates

Power BI Training - Introduction (1-Day)

Event Information

Share this event

Date and Time

Location

Location

7th Floor

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

Description

In this Microsoft Power BI training, you will build and share interactive reports and dashboards.


Microsoft Certified Professional

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


Target Audience

Managers, business analysts, report consumers


Course Learning Outcomes


Bring Your Own Device

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


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.


Detailed Course Outline

1. Master Power BI Service

  • Understand the Power BI terminology
  • Differentiate reports and dashboards
  • Edit interface settings
  • Navigate through Home, Favorites, Recent, Apps, Shared with me and Workplaces
  • Interact with a report : use filters, slicers, sort order, export, print, publish to web, etc.
  • Use storytelling tools: bookmarks, spotlight, focus, tooltip etc.
  • Collaborate and share with an App Workspace
  • Ask a question about your data
  • Build a dashboard
  • Format dashboard tiles
  • Add an image tile
  • Review Web display versus Mobile Display
  • Set a featured dashboard
  • Share with individuals
  • Publish an app to share in Powe BI Service


2. Build a report with Power BI Desktop

  • Explore the Desktop application
  • Import an Excel file
  • Use Power Query Editor
  • Import a Text file
  • Transform data: remove lines, use first row as header, remove columns, extract text using delimiters, replace values, set data types, rename fields and 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
  • Use gridlines to position charts
  • Move and resize visualizations
  • Add analytics to charts
  • Create and use a hierarchy
  • Edit interactions between visualizations
  • Add report pages and duplicate pages
  • Add page filters
  • Explore Quick Insights in Power BI Service
  • Differentiate calculated columns and measures
  • Create a New Quick Measure
  • Create measures with functions: SUM, DIVIDE, CALCULATE, TOTALYTD, SAMEPERIODLASTYEAR
  • Publish to Power BI Service


Learn more about us, visit www.daxel.ca, Power BI specialist in Ottawa.

Browse other Power BI training offers by Daxel in Gatineau - Ottawa.

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 ?

Yes. Email request at julie.foucault@daxel.ca

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

Share with friends

Location

7th Floor

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