Course Duration
2 Days
Microsoft
Authorized Training
IT
Course cost:
was £1,790
£1,267
IT Certification Overview
This two-day instructor-led course provides data professionals with the knowledge and practical skills required to create secure, high-performing and highly interactive business intelligence solutions using Microsoft Power BI Desktop. Learners explore security models, performance optimisation techniques, refresh strategies, dynamic reporting, advanced interactivity, natural language analytics and KPI reporting to deliver meaningful business insights.
Through a combination of instructor-led learning and hands-on labs, participants gain practical experience implementing row-level security, monitoring and optimising report performance, configuring automated refresh processes, building dynamic report experiences, applying advanced analytical visuals, and enabling natural language data exploration. By the end of the course, learners will be able to confidently create enterprise-ready Power BI reporting solutions that support effective analysis and decision-making.
Newto Training Reviews
What Our Happy Alumni Say About Us
I had absolutely no experience in this field, but Newto Training recognised my potential and supported me every step of the way. The real-life scenarios were invaluable in making me job-ready.
The tutors at Newto are consistently patient, clear and more than willing to help. I couldn't have asked for a better learning environment.
From day one I felt welcomed and supported. The live sessions were interactive and the resources well thought-out. I passed my exam on the first attempt thanks to them.
I was nervous about switching careers but the practical approach and continual 1-to-1 support gave me the confidence I needed to succeed."
The training material was excellent, and the instructors really brought the subject to life with hands-on lab work. I feel fully prepared for the workplace."
What impressed me most was the flexibility and responsiveness of the support team. Whenever I had a question, they were there even outside of normal hours.
The course structure was superb. A great mix of theory and practice delivered at a pace that made sense even for beginners. Highly recommended.
Switching into IT felt overwhelming, but Newto Training made the journey manageable and quite enjoyable. Their coaching style is top class.
I particularly appreciated the way complex topics were broken down into manageable chunks, and the tutor actively encouraged questions at every stage.
The live-taught interactive classes set Newto apart from other providers. It wasn't just video-based learning and the real engagement made all the difference.
The cyber course exceeded my expectations. They've been on hand for everything and are constantly in touch with me
The resources provided were spot on and the teaching style made everything easy to understand. I particularly appreciated the extra help offered when needed.
Enrolling with Newto was one of the best decisions I've made. The job-readiness focus, strong teaching and excellent support all stood out.
I completed my SQL course and now feel confident in my skills. The real-world examples and supportive tutors made it all click.
I've just passed my AZ-900 exam thanks to the support received from Ken in the boot camp and his exam preparation sessions.
I've gained a qualification and the confidence to use it in real-world scenarios.
Their commitment to student success is obvious from the personalised guidance to the quality of delivery. I'd recommend them without hesitation.
Every tutor I encountered was professional, encouraging and keen to see me succeed. That personal touch made a big difference.
I'm now in a role I once thought was out of reach, thank you to the all the team
The bootcamps were excellent, we were given practical projects to complete and I feel so much more confident with my coding skills
I had absolutely no experience in this field, but Newto Training recognised my potential and supported me every step of the way. The real-life scenarios were invaluable in making me job-ready.
The tutors at Newto are consistently patient, clear and more than willing to help. I couldn't have asked for a better learning environment.
From day one I felt welcomed and supported. The live sessions were interactive and the resources well thought-out. I passed my exam on the first attempt thanks to them.
I was nervous about switching careers but the practical approach and continual 1-to-1 support gave me the confidence I needed to succeed."
The training material was excellent, and the instructors really brought the subject to life with hands-on lab work. I feel fully prepared for the workplace."
What impressed me most was the flexibility and responsiveness of the support team. Whenever I had a question, they were there even outside of normal hours.
The course structure was superb. A great mix of theory and practice delivered at a pace that made sense even for beginners. Highly recommended.
Switching into IT felt overwhelming, but Newto Training made the journey manageable and quite enjoyable. Their coaching style is top class.
I particularly appreciated the way complex topics were broken down into manageable chunks, and the tutor actively encouraged questions at every stage.
The live-taught interactive classes set Newto apart from other providers. It wasn't just video-based learning and the real engagement made all the difference.
I had absolutely no experience in this field, but Newto Training recognised my potential and supported me every step of the way. The real-life scenarios were invaluable in making me job-ready.
The tutors at Newto are consistently patient, clear and more than willing to help. I couldn't have asked for a better learning environment.
From day one I felt welcomed and supported. The live sessions were interactive and the resources well thought-out. I passed my exam on the first attempt thanks to them.
I was nervous about switching careers but the practical approach and continual 1-to-1 support gave me the confidence I needed to succeed."
The training material was excellent, and the instructors really brought the subject to life with hands-on lab work. I feel fully prepared for the workplace."
What impressed me most was the flexibility and responsiveness of the support team. Whenever I had a question, they were there even outside of normal hours.
The course structure was superb. A great mix of theory and practice delivered at a pace that made sense even for beginners. Highly recommended.
Switching into IT felt overwhelming, but Newto Training made the journey manageable and quite enjoyable. Their coaching style is top class.
I particularly appreciated the way complex topics were broken down into manageable chunks, and the tutor actively encouraged questions at every stage.
The live-taught interactive classes set Newto apart from other providers. It wasn't just video-based learning and the real engagement made all the difference.
The cyber course exceeded my expectations. They've been on hand for everything and are constantly in touch with me
The resources provided were spot on and the teaching style made everything easy to understand. I particularly appreciated the extra help offered when needed.
Enrolling with Newto was one of the best decisions I've made. The job-readiness focus, strong teaching and excellent support all stood out.
I completed my SQL course and now feel confident in my skills. The real-world examples and supportive tutors made it all click.
I've just passed my AZ-900 exam thanks to the support received from Ken in the boot camp and his exam preparation sessions.
I've gained a qualification and the confidence to use it in real-world scenarios.
Their commitment to student success is obvious from the personalised guidance to the quality of delivery. I'd recommend them without hesitation.
Every tutor I encountered was professional, encouraging and keen to see me succeed. That personal touch made a big difference.
I'm now in a role I once thought was out of reach, thank you to the all the team
The bootcamps were excellent, we were given practical projects to complete and I feel so much more confident with my coding skills
The cyber course exceeded my expectations. They've been on hand for everything and are constantly in touch with me
The resources provided were spot on and the teaching style made everything easy to understand. I particularly appreciated the extra help offered when needed.
Enrolling with Newto was one of the best decisions I've made. The job-readiness focus, strong teaching and excellent support all stood out.
I completed my SQL course and now feel confident in my skills. The real-world examples and supportive tutors made it all click.
I've just passed my AZ-900 exam thanks to the support received from Ken in the boot camp and his exam preparation sessions.
I've gained a qualification and the confidence to use it in real-world scenarios.
Their commitment to student success is obvious from the personalised guidance to the quality of delivery. I'd recommend them without hesitation.
Every tutor I encountered was professional, encouraging and keen to see me succeed. That personal touch made a big difference.
I'm now in a role I once thought was out of reach, thank you to the all the team
The bootcamps were excellent, we were given practical projects to complete and I feel so much more confident with my coding skills
Prerequisites
Participants should have:
- Experience creating reports using Microsoft Power BI Desktop.
- A working knowledge of Power BI data modelling concepts.
- Familiarity with business reporting and data analysis.
- An understanding of Power BI visualisations, filters and slicers.
- Experience publishing or sharing Power BI reports is beneficial.
Target audience
This course is designed for:
- Data analysts.
- Business intelligence developers.
- Power BI developers.
- Report and dashboard developers.
- IT professionals responsible for developing and supporting Power BI reporting solutions.
- Power BI users looking to enhance report performance, security and interactivity.
Learning Objectives
By the end of this course, learners will be able to:
- Configure workspace permissions and implement Row-Level Security (RLS) within Power BI.
- Analyse and optimise report performance using Performance Analyzer and aggregation techniques.
- Configure data refresh strategies and manage Power BI refresh options.
- Create dynamic reporting solutions using value and field parameters.
- Build highly interactive reports using slicers, drill-through pages, bookmarks, buttons and tooltips.
- Use Key Influencers and Decomposition Trees to support data exploration and root-cause analysis.
- Configure Q&A functionality, synonyms and natural language experiences within Power BI.
- Design scorecards, metrics and KPI reporting solutions to support business performance monitoring.
Power BI Desktop Intermediate Course Content
Module 1: Security and Access Management
- Understand Power BI workspace roles and permissions.
- Configure Admin, Member, Contributor and Viewer access.
- Implement Row-Level Security (RLS).
- Apply dynamic security using USERPRINCIPALNAME().
- Manage service-led, data-led and DirectQuery security scenarios.
Module 2: Performance Analysis and Optimisation
- Analyse report performance using Performance Analyzer.
- Identify performance bottlenecks in reports and visuals.
- Implement aggregations to improve query performance.
- Understand Import, DirectQuery and aggregation strategies.
- Optimise report responsiveness and data model performance.
Module 3: Refresh Strategies and Data Connectivity
- Configure automatic refresh in Power BI Desktop.
- Understand time-based and change-detection refresh options.
- Work with DirectQuery refresh scenarios.
- Configure refresh schedules within the Power BI Service.
- Apply incremental and on-demand refresh techniques.
Module 4: Visual Parameters and Dynamic Reporting
- Create and use value parameters.
- Implement field parameters for dynamic reporting.
- Build parameter-driven calculations and report behaviour.
- Enable dynamic field selection within reports.
- Enhance user-driven data exploration and analysis.
Module 5: Advanced Interactivity and Analytical Visuals
- Create and synchronise slicers across report pages.
- Configure drill-through pages, bookmarks and report navigation.
- Build interactive experiences using buttons, tooltips and the selection pane.
- Analyse business drivers using Key Influencers visuals.
- Perform root-cause analysis using Decomposition Trees.
Module 6: Q&A and Natural Language Analytics
- Configure Q&A functionality within Power BI.
- Create and manage synonyms for tables, columns and measures.
- Build linguistic schemas and manage business terminology.
- Configure multilingual Q&A experiences.
- Use Smart Narrative and Suggest Questions to improve insight discovery.
Module 7: Scorecards and KPI Management
- Create scorecards to monitor business performance.
- Define and manage metrics and KPIs.
- Configure targets, benchmarks and performance thresholds.
- Apply conditional formatting to highlight performance.
- Build interactive KPI reporting and monitoring solutions.
Exams and assessments
There are no formal examinations included in this course. Learners reinforce their understanding through practical hands-on labs, instructor-led demonstrations, and real-world reporting scenarios designed to build confidence creating secure, high-performing and interactive Power BI reporting solutions.
Hands-on learning
This course includes:
- Practical Microsoft Power BI Desktop labs.
- Hands-on exercises implementing Row-Level Security and workspace permissions.
- Guided activities using Performance Analyzer, aggregations and refresh strategies.
- Practical exercises using parameters, interactivity and analytical visuals.
- Hands-on configuration of Q&A, scorecards and KPI reporting.
- Real-world business intelligence reporting scenarios.
Power BI Desktop Intermediate Dates
Next 7 available training dates for this course
OFFER!
BOOK NOW
VIRTUAL
QA On-Line Virtual Centre
2 DAYS
|
ALL DAY
Wed 19 Aug 2026
AVAILABLE
was £1,790
£1,267
OFFER!
BOOK NOW
VIRTUAL
QA On-Line Virtual Centre
2 DAYS
|
ALL DAY
Tue 01 Sep 2026
AVAILABLE
was £1,790
£1,267
OFFER!
BOOK NOW
VIRTUAL
QA On-Line Virtual Centre
2 DAYS
|
ALL DAY
Tue 24 Nov 2026
AVAILABLE
was £1,790
£1,267
OFFER!
BOOK NOW
VIRTUAL
QA On-Line Virtual Centre
2 DAYS
|
ALL DAY
Tue 19 Jan 2027
AVAILABLE
was £1,790
£1,267
OFFER!
BOOK NOW
VIRTUAL
QA On-Line Virtual Centre
2 DAYS
|
ALL DAY
Wed 24 Mar 2027
AVAILABLE
was £1,790
£1,267
OFFER!
BOOK NOW
VIRTUAL
QA On-Line Virtual Centre
2 DAYS
|
ALL DAY
Thu 13 May 2027
AVAILABLE
was £1,790
£1,267
OFFER!
BOOK NOW
VIRTUAL
QA On-Line Virtual Centre
2 DAYS
|
ALL DAY
Thu 08 Jul 2027
AVAILABLE
was £1,790
£1,267
Advance Your Career with Power BI Desktop Intermediate
Gain the skills you need to succeed. Enrol in Power BI Desktop Intermediate with Newto Training today.
