Learn Power BI – The Basics
(2 days – 9AM to 4PM)
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 an interactive report with Power BI Desktop application
- Develop strategies to pursue Power BI learning
Technical Requirements
- Power BI Desktop
- Teams
Alternative
$1,200.00
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: Teams 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 10 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 an 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 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
