SALE LIVE
SAVE 60% BLACK FRIDAY

Develop dynamic reports with Microsoft Power BI DP605 Course Black Friday Offers

Develop dynamic reports with Microsoft Power BI DP605 Course is part of our Black Friday sale. Lock in 60% off now, choose online, classroom or onsite training, and schedule your course any time through 2027. Group bookings save up to 60%.

FROM £795 £1,995 SAVE £1,200

Offer ends 27 November 2026

Develop dynamic reports with Microsoft Power BI DP605 Course Overview

Course syllabus

Who it’s for

What’s included

FAQs

Develop dynamic reports with Microsoft Power BI (DP-605) Course Outline

Module 1: Get Data in Power BI

  • Introduction
  • Get Data from Files
  • Get Data from Relational Data Sources
  • Create Dynamic Reports with Parameters
  • Get Data from a NoSQL Database
  • Get Data from Online Services
  • Select a Storage Mode
  • Get Data from Azure Analysis Services
  • Fix Performance Issues
  • Resolve Data Import Errors
  • Exercise - Prepare Data in Power BI Desktop

Module 2: Clean, Transform, and Load Data in Power BI

  • Introduction
  • Shape the Initial Data
  • Simplify the Data Structure
  • Evaluate and Change Column Data Types
  • Combine Multiple Tables into a Single Table
  • Profile Data in Power BI
  • Use Advanced Editor to Modify M Code
  • Exercise - Load Data in Power BI Desktop

Module 3: Design a semantic model in Power BI

  • Introduction
  • Work with Tables
  • Create a Date Table
  • Work with Dimensions
  • Define Data Granularity
  • Work with Relationships and Cardinality
  • Resolve Modeling Challenges
  • Exercise - Model Data in Power BI Desktop

Module 4: Add Measures to Power BI Desktop Models

  • Introduction
  • Create Simple Measures
  • Create Compound Measures
  • Create Quick Measures
  • Compare Calculated Columns with Measures
  • Check your Knowledge

Module 5: Add Calculated Tables and Columns to Power BI Desktop Models

  • Introduction
  • Create Calculated Columns
  • Learn about Row Context
  • Choose a Technique to Add a Column

Module 6: Design Power BI Reports

  • Introduction
  • Design the Analytical Report Layout
  • Design Visually Appealing Reports
  • Report Objects
  • Select Report Visuals
  • Select Report Visuals to Suit the Report Layout
  • Format and Configure Visualisations
  • Work with Key Performance Indicators
  • Exercise - Design a Report in Power BI Desktop

Module 7: Configure Power BI Report Filters

  • Introduction to Designing Reports for Filtering
  • Apply Filters to the Report Structure
  • Apply Filters with Slicers
  • Design Reports with Advanced Filtering Techniques
  • Consumption-Time Filtering
  • Select Report Filter Techniques

Module 8: Create and Manage Workspaces in Power BI

  • Introduction
  • Distribute a Report or Dashboard
  • Monitor Usage and Performance
  • Recommend a Development Life Cycle Strategy
  • Troubleshoot Data by Viewing its Lineage
  • Configure Data Protection

Module 9: Manage Semantic Models in Power BI

  • Introduction
  • Use a Power BI Gateway to Connect to on-premises Data Sources
  • Configure a Semantic Model Scheduled Refresh
  • Configure Incremental Refresh Settings
  • Manage and Promote Semantic Models
  • Troubleshoot Service Connectivity
  • Boost Performance with Query Caching (Premium)
Show more blue-arrow
Show more blue-arrow

Who Should Attend this Develop dynamic reports with Microsoft Power BI (DP-605)?

This course is tailored for professionals who aim to leverage the robust capabilities of Microsoft Power BI in their organisation’s data management and analysis efforts. However, this training will be especially beneficial for:

  • Business Analysts
  • Data Analysts
  • Project Managers
  • BI and Reporting Managers
  • IT Professionals
  • Marketing Managers
  • Financial Analysts

Prerequisites of the Develop dynamic reports with Microsoft Power BI (DP-605) Course?

Delegate should have a basic understanding of data management and Microsoft Excel functions. Familiarity with business intelligence tools and database structures is beneficial.

Develop dynamic reports with Microsoft Power BI (DP-605) Course Overview

Develop Dynamic Reports with Microsoft Power BI (DP-605) is a focused training program designed to empower professionals with the capabilities to build and manage interactive reports using Microsoft Power BI. This course emphasises the vital skills needed to transform raw data into compelling visual narratives that drive business decisions. Through this training, organisations can expect to see an enhancement in their ability to understand complex data through accessible and actionable reports. For individuals, it provides a robust foundation in data visualisation techniques and the strategic use of Power BI tools, improving their analytical skills and career prospects.   

During this training course, delegates will learn to master the functionalities of Power BI, from data integration and real-time dashboard creation to developing comprehensive dynamic reports that adapt to evolving business needs.  Delegate will engage in practical exercises to gain hands-on experience in report design and deployment, ensuring they can apply their skills immediately in their professional roles. This training will be delivered by seasoned experts in data visualisation and business intelligence, providing a learning experience grounded in real-world applications.

Course Objectives

  • To acquire skills in sourcing data from diverse origins
  • To master data cleaning, transforming, and loading processes
  • To develop advanced data modeling and semantic models
  • To create and manage dynamic and interactive reports
  • To implement data analysis expressions and measures
  • To design and customise powerful data visualisations
  • To effectively manage and optimise Power BI environments

After attending this training, delegates will be equipped to handle the end-to-end process of data reporting with Power BI. They will be able to extract and integrate data from various databases and online services, transform raw data into a structured form, and create meaningful visual representations that provide actionable insights. Delegates will also learn to design reports that are not only visually appealing but also interactive, with the ability to apply advanced filtering and slicer techniques for tailored data exploration.

Show more blue-arrow

What’s included in this Develop dynamic reports with Microsoft Power BI DP605 Course?

  • World-Class Training Sessions from Experienced Instructors
  • Develop dynamic reports with Microsoft Power BI DP605 Course Certificate
  • Digital Delegate Pack
Show more blue-arrow

Train Your Workforce

Looking for Develop dynamic reports with Microsoft Power BI DP605 Course in-house or onsite training Glasgow. We specialise in corporate group training and bulk bookings for organisations of all sizes. Our trainers deliver tailored sessions at your premises, online, or hybrid, with best price guarantee, group discounts and flexible scheduling.

Approved supplier to 53,573 organisations

The Knowledge Academy is an approved training supplier to 53,573 organisations across the UK, Europe, North America and Australia, so most buyers can book through their existing purchasing process with no new supplier setup.

Our Glasgow venue

Includes..

Free Wi-Fi

To make sure you’re always connected we offer completely free and easy to access wi-fi.

Air conditioned

To keep you comfortable during your course we offer a fully air conditioned environment.

Full IT support

IT support is on hand to sort out any unforseen issues that may arise.

Video equipment

This location has full video conferencing equipment.

Glasgow is the largest city in Scotland and is the third largest city in the UK. The population of Glasgow is around 600,000 inhabitants. Glasgow is now considered the largest seaport in Britain. Glasgow is well known for its higher education facilities and has four universities within 10 miles of the city centre. The four main universities in Glasgow are the University of Glasgow, University of Strathclyde, Glasgow Caledonian University and University of the West of Scotland. There are also a few colleges and higher education facilities in Glasgow such as; the City of Glasgow College, Glasgow Clyde College and Glasgow Kelvin College.

The Higher education facilities include Jordanhill Teacher Training College, Royal Conservatoire of Scotland and Glasgow School of Art. The University of Glasgow is the fourth oldest University in the UK. It was founded in 1451. Glasgow originally only educated wealthy students but has however become a pioneer in higher education. Glasgow offered studies to the wealthy in Law, Medicine, Civil Servicing, Teaching and Church Studies. The University of Glasgow currently offers degrees in Arts, Humanities, Modern Languages, Sciences, Medicine, Veterinary Medicine, Engineering and Social Sciences. The University of Glasgow had some notable alumni such as Lady Hazel Cosgrove who became the first woman to be appointed as a permanent seat as a judge in the Court of Session. The University of Strathclyde is another major university in Glasgow. It was established in 1796 and is the third largest university in Scotland with around 20,000 students in attendance. The University offers various degrees in areas such as Engineering, Architecture, Chemistry, Mathematics, Physics, Education, Law, Psychology and Economics.

The University of Strathclyde also has many notable alumni and academics such as Jim McColl who is the richest man in Scotland, Henry Faulds who founded fingerprint identification and John Logie Baird who invented the world’s first working television. The Glasgow Caledonian University is another university located in Glasgow. It has roots tracing back to 1875 but was formally established in 1993. Glasgow Caledonian has around 18,000 students in attendance and is one of Scotland’s Largest Universities. Glasgow Caledonian is ranked among the UK’s top 10 universities. Glasgow Caledonian has many notable alumni, such as Gordon Brown and Neil Buchanan. 

Popular searched areas in and around Glasgow include:-

  • Balmaha
  • Barrhead
  • Bearsden
  • Bishopbriggs
  • Blantyre
  • Bowling
  • Cambuslang
  • Cumbernauld
  • East Kilbride
  • Giffnock
  • Ibrox
  • Kilsyth
  • Kirkintilloch
  • Milngavie
  • Mount Vernon
  • Newton Mearns
  • Pollock
  • Rutherglen
  • Uddingston

Show moredown

Ways to take Develop dynamic reports with Microsoft Power BI DP605 Course in Glasgow

Live Online

The same live course from home, with a live instructor and other delegates. Mirrors the classroom schedule.

Best for: starting soon, without travel.

1 day · next Fri 8 Jan 2027

See live online dates

Online Self-Paced

Study 24/7 on your own schedule through our learning platform, with progress tracking.

Best for: fitting study around work.

90 days of access

See self-paced options

Onsite

We bring the course to your team, at your premises, online or hybrid, on dates that suit you.

Best for: groups and bulk bookings.

Tailored to your team

Get a team quote

Loading ....

Package deals for Develop dynamic reports with Microsoft Power BI DP605 Course in Glasgow

Our training experts have compiled a range of course packages on a variety of categories in Develop dynamic reports with Microsoft Power BI DP605 Course, to boost your career. The packages consist of the best possible qualifications with Develop dynamic reports with Microsoft Power BI DP605 Course, and allows you to purchase multiple courses at a discounted rate.

Develop Dynamic Reports With Microsoft Power BI DP605 Training in Glasgow FAQs

What are the pre-requisites?

Delegate should have a basic understanding of data management and Microsoft Excel functions. Familiarity with business intelligence tools and database structures is beneficial.

Who should attend this course?

This course is tailored for professionals who aim to leverage the robust capabilities of Microsoft Power BI in their organisation’s data management and analysis efforts.

Do you offer support for the course?

We are able to provide support via phone & email prior to attending, during and after the course.

What is included in the course?

Delegate pack consisting of course notes and exercises, Experienced Instructor.

What is the duration of this course?

This course is for 1 day.

How long until I receive the course confirmation details?

Once your booking has been placed and confirmed, you will receive an email which contains your course location, course overview, pre-course reading material (if required), course agenda and payment receipts

What is the cost/training fees for Develop dynamic reports with Microsoft Power BI DP605 Course in Glasgow?

The training fees for Develop dynamic reports with Microsoft Power BI DP605 Course in Glasgow starts from £1995

Which is the best training institute/provider of Develop dynamic reports with Microsoft Power BI DP605 Course in Glasgow?

The Knowledge Academy is one of the Leading global training provider for Develop dynamic reports with Microsoft Power BI DP605 Course.

What are the best Microsoft Azure Certification courses in Glasgow?

Please see our Microsoft Azure Certification courses available in Glasgow

Show more blue-arrow

Customers Reviews

Request For Pricing

WHO WILL FUNDING THE COURSE?
+44

Corporate Training

Unlock tailored pricing and customised training solutions for your team’s needs.

Request your quote today!

Why choose The Knowledge Academy

price

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

trusted

Trusted & Approved

Recognised by leading certification bodies, we deliver training you can trust.

learning

Many delivery methods

Flexible delivery methods are available depending on your learning style.

resources

High quality resources

Resources are included for a comprehensive learning experience.

Our Clients

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water
santander barclays bmw google thames-water deloitte bupa tesla
cross

Exclusive Deals For Future Leaders!

friday-sale UP TO 60% OFF!

* WHO WILL BE FUNDING THE COURSE?

close

close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

close

close

Press esc to close

close close

Back to course information

Thank you for your enquiry!

One of our training experts will be in touch shortly to go overy your training requirements.

close close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.