Develop Dynamic Reports with Microsoft Power BI (DP-605)

Course 8687

Duration: 1 day
Language: English
Level: Intermediate

Take this 1-day Microsoft Power BI course, Develop dynamic reports with Microsoft Power BI (DP-605), and learn to harness the power of Power BI to transform and load data, define semantic model relationships and calculations, create interactive visuals, and distribute reports seamlessly.

Develop dynamic reports with Microsoft Power BI (DP-605) Delivery Methods

In-Person
Online
Upskill your whole team by bringing Private Team Training to your facility.

Develop dynamic reports with Microsoft Power BI (DP-605) Training Information

In this course, you will learn how to:

Gain proficiency in retrieving data from diverse sources.
Learn advanced techniques for cleaning and transforming data.
Master the art of semantic modelling for optimised report performance.
Enhance report visualisation skills for effective data communication.
Acquire expertise in report filtering and workspace management for streamlined report distribution.

Training Prerequisites

Basic understanding of Data Analytics and Power BI

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

Get Data in Power BI

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

Check Your Knowledge

Clean, Transform, and Load Data in Power BI

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

Check Your Knowledge

Design a Semantic Model in Power BI

Work with Tables
Create a Date Table
Work with Dimensions
Define Data Granularity
Work with Relationships and Cardinality
Resolve Modelling Challenges

Exercise - Model Data in Power BI Desktop

Check Your Knowledge

Add Measures to Power BI Desktop Models

Create Simple Measures
Create Compound Measures
Create Quick Measures
Compare Calculated Columns with Measures
Check Your Knowledge

Exercise - Create DAX Calculations in Power BI Desktop

Add Calculated Tables and Columns to Power BI Desktop Models

Create Calculated Columns
Learn about Row Context
Choose a Technique to Add a Column
Check Your Knowledge

Design Power BI Reports

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

Check Your Knowledge

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
Case Study - Configure Report Filters Based on Feedback
Check Your Knowledge

Create and Manage Workspaces in Power BI

Distribute a Report or Dashboard
Monitor Usage and Performance
Recommend a Development Life Cycle Strategy
Troubleshoot Data by Viewing Its Lineage
Configure Data Protection
Check Your Knowledge

Manage Semantic Models in Power BI

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)
Check Your Knowledge

Get This Course £835

1-Day Instructor-Led Training
Hands-On Labs
Microsoft Official Content
After-Course Instructor Coaching Included
Available for Private Team Training

Include dates with afternoon start times

#8687

Aug 27 9:00 AM - 4:30 PM BST

AnyWare
Sep 17 2:00 PM - 9:30 PM BST

AnyWare
Oct 6 2:00 PM - 9:30 PM BST

AnyWare
Nov 6 2:00 PM - 9:30 PM GMT

AnyWare
Nov 25 9:00 AM - 4:30 PM GMT

AnyWare
Dec 2 2:00 PM - 9:30 PM GMT

AnyWare
Jan 5 2:00 PM - 9:30 PM GMT

AnyWare
Feb 5 2:00 PM - 9:30 PM GMT

AnyWare
Feb 26 9:00 AM - 4:30 PM GMT

AnyWare
Mar 2 2:00 PM - 9:30 PM GMT

AnyWare
Apr 2 2:00 PM - 9:30 PM BST

AnyWare
May 28 9:00 AM - 4:30 PM BST

AnyWare

Scroll to view additional course dates

Bring this or any training to your organisation
Full-scale programme development
Delivered when, where, and how you want it
Blended learning models
Tailored content
Expert team coaching

#8687

Speak with a Learning Consultant

Inquiring For

Myself

Team/Group

First Name*

Last Name*

Email*

Phone Number*

Company*

Job Title

I'm interested In

* Required Fields

Speak with a Learning Consultant

Fill out the form below or call 44 (0) 207 874 5000

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

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

You can retrieve data from a variety of sources, including Microsoft Excel, relational databases, NoSQL data stores, online services, and more.

Power BI offers robust features in Power Query dedicated to cleaning and preparing data, such as simplifying complex models, changing data types, and profiling columns.

Semantic modelling simplifies complex data structures, aids in creating efficient relationships, and ensures optimal performance and usability of reports.

Power BI offers various filtering techniques, including applying filters to report structures, using slicers, and implementing advanced filtering options, ensuring intuitive data exploration and analysis.