$600

Microsoft Power BI Course - Introduction (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 will build and share interactive reports and dashboards.

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, business analysts, report consumers

Course Learning Outcomes

  • Master the Power BI Service environment
  • Use the Power BI Mobile App
  • Build this interactive report with Power BI Desktop application

Bring Your Own Device

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

Custom 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. Master Power BI Service

  • Understand the 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

2. Use Power BI Mobile App

  • Install Power BI Mobile app
  • Navigate on the app
  • Annotate and email a tile
  • Comment on a dashboard or tile
  • Set alerts

3. 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
  • Differentiate calculated columns and measures
  • Create a New Quick Measure
  • Create measures with functions: SUM, DIVIDE, CALCULATE, TOTALYTD, SAMEPERIODLASTYEAR
  • Publish to Power BI Service

Find out more about this Introduction Course to Power BI.

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