Power BI Desktop Intermediate Training in Toronto

Take your Power BI skills to the next level with this advanced, practical 2-day intermediate Power BI Desktop Intermediate Training in Toronto. Designed for data professionals already familiar with Power BI, this course introduces advanced features and best practices in report interactivity, performance, security, and automation.

Learn how to secure your dashboards, implement row-level security, configure auto-refresh, and leverage Power BI features like Q&A, decomposition trees, smart narratives, custom tooltips, bookmarks, and more.

Whether you're preparing enterprise-level dashboards or aiming to create highly interactive visualizations, this course will sharpen your skills and boost your Power BI capabilities.

What You'll Gain

• Advanced-level Power BI Desktop skills

• Mastery over interactive report elements and layout control

• Knowledge of performance tuning and data refresh workflows

• Confidence to build enterprise-grade dashboards with security and automation

• Enhanced storytelling with advanced visuals and DAX techniques

Attendees should have completed Power BI Desktop for Technical Users or Power BI Desktop for Business Users, or possess equivalent Power BI Desktop experience.

Virtual Learning Requirements

For virtual attendees:

• A second monitor (minimum 19") is required

• Minimum screen resolution: 1280x1024 (critical for lab visibility)

• Labs will be conducted via GoToMyPC or LearnOnDemand

1. Security and Row-Level Filtering

• Create user roles and apply security filters using USERPRINCIPALNAME()

• Configure row-level security within the Power BI Service

2. Aggregations and Performance Optimization

• Implement DirectQuery with summarized and detailed tables

• Improve performance by letting visuals switch intelligently between views

3. Auto-Refresh in Power BI Desktop

• Configure report/dashboard auto-refresh based on time triggers or dataset changes

4. Auto-Refresh in Power BI Service

• Set up scheduled refresh for datasets in the Power BI cloud service

5. Parameters and Dynamic Reporting

• Use parameters and disconnected tables with DAX to make reports more interactive

6. Sync Slicers

• Apply slicers across multiple pages

• Share slicer values between unrelated tables (e.g., location filters)

7. Drillthrough Pages

• Create detailed drill-through pages accessible via buttons or right-click context

8. Buttons and Bookmarks

• Create custom navigation experiences using bookmarks and action-enabled buttons

9. Custom Tooltips

• Replace default tooltips with visual-rich custom tooltip pages

10. Key Influencers and Advanced Analytics

• Use Key Influencers visuals and scatter plots to identify significant data patterns

11. Decomposition Tree

• Break down metrics into constituent dimensions

• Enable visual-based filtering between charts

12. Q&A Visual & Synonyms

• Enable natural language queries using Q&A

• Train your model and configure synonyms for better user interaction

13. Smart Narrative

• Add auto-generated text summaries based on visual insights and measures

14. Metrics and Scorecards

• Publish Power BI reports and connect to manual/data-driven metrics in Scorecards

• Create a KPI-tracking workspace with linked metrics and reports