Power BI Advanced Features

Trained 50k+ People

Over 100+ Countries

By Specialist Trainers

With Over 20 Years' Experience

Enquire Now
Book Now
Download Overview

By the end of this course, learners will be able to design and optimize complex data models, create advanced DAX measures and calculations, implement row-level security, build dynamic and interactive reports and dashboards, and apply best practices for performance tuning and advanced analytics in Power BI. These skills enable users to extract deep insights from business data and support data-driven decision-making at an organizational level.

1. Power Query ® Transform Data

More Transformations
Merge Queries, Append Queries
Connect to other Data Sources

2. Data Model ® Manage

Using Calendar Tables to enable Time Intelligence
Group Items (Group/Bin)

3. DAX Formulas

Popular DAX Functions (COUNTROWS, RELATED®)
Override Filters (CALCULATE, ALL etc.)
Time Intelligence (YEAR-TO-DATE etc.)

4. Building Dynamic Reports

Filtering and Slicers
Interactions between Visuals, Drill-Down
Other Visual Elements (Text Box, Shape, Image etc.)

5. Visualisations

Formatting Visuals
Conditional Formatting
Custom Visuals

6. Power BI Service

Workspaces and Sharing
Handling Datasets, Reports and Dashboards

Data analysts, BI developers, report creators, and professionals seeking to enhance their Power BI expertise

Course slides, Sample datasets and Practice dashboards

Basic Power BI knowledge, familiarity with data modeling concepts, and experience with DAX basics

Microsoft Docs: Power BI Advanced Modeling

This course supports preparation for the Microsoft PL-300: Data Analyst Associate certification exam. The exam tests advanced skills in data modeling, DAX, report design, and analytics in Power BI. It includes multiple-choice, scenario-based, and practical exercises to validate the learner’s ability to create scalable and insightful Power BI solutions for real-world business problems.

Proctored Exam

Microsoft Certified: Data Analyst Skills

After this course, learners can pursue specialized BI and analytics courses, including Power BI Performance Optimization, AI integrations, and advanced data analytics using Azure and Power BI.

Prerequisites

Part 1: Power BI Essentials

Why Choose Us?

We Are Here To Help You Pass

All of our trainers have achieved exceptionally high delegate pass rates for accredited examinations for all our courses. We also offer complimentary pre and post-course support for any questions you may have.

We Are Flexible

We try and be as flexible as we can and accommodate your needs. We can swap delegates at any time with no charge. We can also create bespoke content should this be required.

We Are The Specialists

We specialise in IT Service and Project Management. All of our Trainers and Consultants have considerable years of hands-on experience in IT Service / Project Management, working across a wide number of industry sectors.

We Are Professionals

Our training, sales and admin staff are all professional, helpful, friendly and approachable. We believe in providing excellent customer service. You will always have a dedicated friendly Account Manager

Reviews

Purple Griffon recently delivered 2 service management courses for the MOD and we all found it to be a very positive experience. The Company is very professional, with extremely knowledgeable and experienced trainers, who have real world skills.

Garry Jones - Procurement Manager, MOD

It was a beast of a course but very rewarding. Thanks for the assistance around the booking - the customer service was excellent. I no longer have to hide behind my project management team and can say loud and proud I am a PRINCE2® practitioner!

Matthew Slater - Service Delivery Manager, InTechnology

The training was organised well, administrative help was quick and relevant which made the information gathering and training preparations fast & easy. The trainer was knowledgeable and experienced. We’ve received very good feedback.

Karolina Manka - Training Specialist, Accenture

I passed! which I must admit was 100% down to your trainer Bob. He gave us enough stories and tips to get me through it and sometimes the stories sink in better than anything else. Thanks again, I'd definitely use your company again because of him.

Tracy Iqbal - IT Assistant, MacRoberts

Feedback from staff has been positive and you have helped us to effectively embed the ITIL® framework into our working processes and achieve key organisational goals. We look forward to continuing with rest of our ITIL® courses throughout the year.

Max Khalid - ITSM Specialist, London Programme for IT

I have self-funded several courses with Purple Griffon, and passed all of my exams to gain ITIL® Expert accreditation. This wouldn't have been possible without the help from the team and tutors. This makes Purple Griffon my first choice of training provider.

Sarah Jamieson - Individual , Self-Funded

Excellent course material and exercises and discussion facilitate learning in the classroom. Managed to pass all exams of courses taken with Purple Griffon! And I believe on this latest course a 100% pass rate from all delegates on the course!

Rob James - Individual, Self-Funded

Great company and Steve is a really knowledgeable guy as well!

Maurits Van Der Plas - Director, Van Haren Learning Solutions

I could not find any other training exclusively focused on the IT SDM roles and responsibilities elsewhere, making this course possibly the best IT SDM training in the world! I consider this course among the top courses I've had the pleasure of attending.

Michael Hilliker - IT Branch, Gouvernement Du Canada

The free "Introduction To The World Of The Service Desk" provided a great insight into the world of IT Service Management. Excellent slides.

Chinonyerem Mpamah - Learner, Self-Funded

I have been using Purple Griffon since 2013 after taking a course with another company and didn't receive the best experience. Since 2013 I haven't used anyone else. Excellent courses and very personable trainers and high pass rates.

Terry Wilder - Learner, Self-Funded

The Purple Griffon E-Learning study material is very complete, and prepared me for the exam in an excellent way. I am happy to have used the Purple Griffon material and I am planning to do so again in the near future.

Louis Rademaker - Learner, Self-Funded

I've taken classroom training via Purple Griffon and their exceptional team on several occasions. In my case it has been ITIL® based and I can only recommend their services.

David Barrow - Learner, Self-Funded

From what I see the course for CDS is well organised and staff that prepared the materials are really looking for their students to pass the exam with good marks. I wish that whenever I need extra help the staff will help me immediately

Fawaz Yelda - Professional, Control Risks

I got studying material from Purple Griffon and the quality is more than good. Good work!

Sergio Enriquez - Learner, Self-Funded

Very good training provider and the instructor was very knowledgeable

Nigel Rooms - Professional, CDW

Great training - passed my ITIL® exam!

Luca Bakshi - Technical Analyst, Trayport

I found the ITIL® 4 Foundation online training course very good and easy to follow. I think good values.

Keith Brain - Individual, Self-Funded

The Digital Twins Basics Online Workshop (60 Minutes) was simple and the content was easy to understand.

Titilayo Iya Y - Individual, Self-Funded

INFORMATION

Power BI Advanced Features Course Dates

There are currently no course dates that match your selected filter options. Please try another filter or contact one of our dedicated account managers on +44 208 1428 961 to discuss your requirements. Thanks.