Power BI Foundations

Learning the Basics
of Power BI

(1 day)

 

Hands-On Workshop
  • Participants must bring their own laptop.
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
Training Location

123 Slater Street, Ottawa ON K1P 5G4

$700.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

 

Bring Your Own Device

Each participant must bring his/her laptop with Power BI Desktop application.

Or add Laptop Rental to your cart.

 

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 6 attendees to address each participants questions and requests.

Training is delivered in a modern environment: offering a comfortable and bright workplace, centrally located.

 

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

You may also like…

Laptop Rental

Laptop rental for the entire training duration (1, 2 or 3 days).



View Details