Power BI Foundations (Virtual)

Learning the Basics
of Power BI

(1 day)

 

Hands-On Workshop
  • Participants interact with the instructor, in a virtual classroom, to complete hands on activities.
Learning Outcomes
  • Master the Microsoft Power BI Service environment
  • Build this interactive report with Power BI Desktop application
  • Develop strategies to pursue M and DAX learning
Technical Requirements
  • Power BI Desktop
  • Zoom

$650.00

Clear
Fast-paced Power BI Introduction. Build and share interactive reports and dashboards. Understand the tool as a whole: learn the Power BI Service functionalities to properly use the Desktop application. Learn best practices to build powerful reports in Power BI Desktop.
Target Audience

Managers, Analysts, Accountants, Report Builders

 

Technical Requirements

Participant must have access to 2 screens: using a laptop and a monitor is adequate.

Participant must install free apps on his/her computer: Zoom and Power BI Desktop.

 

Microsoft Certified Instructor

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

 

Quality Service

Workshops are limited to a maximum of 4 attendees to address each participant’s questions and requests.

Interact with instructor using a web-conferencing interface: share screen and mouse control to resolve issues.

 

Training Schedule

Training takes place from 9 a.m. to 4 p.m.

Learning Outcomes

  • Master the Microsoft Power BI Service environment
  • Build this interactive report with Power BI Desktop application
  • Develop strategies to pursue M and DAX learning

 

Topics

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 an Excel file or Import a Text file
  • 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
  • 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, DIVIDE, CALCULATE, TOTALYTD, SAMEPERIODLASTYEAR
  • Publish to Power BI Service