Take your Power BI skills to the next level with this advanced, practical 2-day intermediate Power BI Desktop Intermediate Training in Spain. 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.

We can organize this training at your preferred date and location. Contact Us!

Prerequisites

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

Who Should Attend

This Power BI Desktop Intermediate Training in Spain is ideal for:

Power BI users with foundational report-building experience
Business intelligence professionals aiming to master intermediate techniques
Data analysts who want to implement advanced functionality in their reports

What You Will Learn

By the end of this Power BI Desktop Intermediate Training in Spain, you will have gained knowledge and skills in the following areas:

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

Training Outline

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

Why Choose Bilginç IT Academy

At Bilginç IT Academy, we combine our strong presence in both the UK and Türkiye to deliver high-quality, practical training solutions for organizations worldwide.

International Presence with Local Expertise
With operations in the United Kingdom and Türkiye, we bring together global standards and local market understanding to deliver effective training experiences across regions.

Expert Instructors with Real-World Experience
Our courses are delivered by certified trainers with extensive industry experience, ensuring you gain practical knowledge that can be applied immediately.

Corporate-Focused Training Approach
We specialize in training corporate teams, tailoring our programs to meet your organization’s goals, technologies, and project requirements.

Flexible Training Delivery Worldwide
We offer classroom, virtual classroom, and onsite training options globally, tailored to your organization’s needs.

Hands-On, Practical Learning
Our training sessions include real-world scenarios, case studies, and interactive exercises to ensure lasting understanding and skill development.

Proven Track Record
With over 10 years of experience, we have successfully trained professionals from leading organizations across different industries and regions.

Why have you chosen us?

I have attended a training from Bilginc IT Academy before and I was satisfied.

I have attended a training from a different provider and it was not helpful.

Other

How many employees do you have in your IT department?

0 – 50

50 – 250

250 – 1000

1000+

Power BI Desktop Intermediate Training in Spain