Learn Power BI – the Basics
(2 days – 9AM to 4PM)
Hands-On Workshop
- Participants must bring their own laptop.
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
Training Location
123 Slater Street, Ottawa ON K1P 5G4
$1,200.00
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 their laptop with the Power BI Desktop application installed.
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 10 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 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
