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

Ref. DP-605

Download PDF

Duration:

1

day

Exam:

Optional

Level:

Intermediate

Funding:

Temptraining

Home > Trainings > Office Automation > Analytics Platform - BI > Develop dynamic reports with Microsoft Power BI (DP-605)

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

Boost your data analysis skills with our course, “Develop Dynamic Reports with Microsoft Power BI (DP-605).” Designed for those familiar with Power BI, this practical course will guide you through key steps to master the tool: from data collection and transformation, to creating semantic models and interactive visualizations, to distributing insightful reports. Learn to tackle real data problems and design captivating reports, all in a concise and engaging format.

Participant profiles

Data analysts
Business intelligence specialists
Project managers
IT professionals and developers
Management consultants
Marketers
Finance professionals
Business leaders and entrepreneurs

Objectives

Acquire mastery of the tools and techniques necessary to obtain, clean, transform, and load data into Power BI.
Understand the fundamental principles of semantic model design in Power BI.
Develop skills to create dynamic and visually appealing reports in Power BI.
Know how to configure and manage report filters.
Master the techniques of managing workspaces.
Deepen understanding of advanced concepts such as measures and calculated columns.

Prerequisites

Basic understanding of data analysis and Power BI.

Course content

Module 1 – Obtaining Data in Power BI

Obtain data from files
Obtain data from relational data sources
Create dynamic reports with parameters
Obtain data from a NoSQL database
Obtain data from online services
Select a storage mode
Obtain data from Azure Analysis Services
Resolve performance issues
Resolve data import errors

Module 2 – Clean, Transform, and Load Data into Power BI

Format initial data
Simplify data structure
Evaluate and change data types of columns
Combine multiple tables into a single table
Profile data in Power BI
Use the Advanced Editor to modify M code

Module 3 – Designing a Semantic Model in Power BI

Work with tables
Create a date table
Work with dimensions
Define data granularity
Work with relationships and cardinality
Solve modeling challenges

Module 4 – Adding Measures to Power BI Desktop Models

Create simple measures
Create composite measures
Create quick measures
Compare calculated columns with measures

Module 5 – Adding Tables and Calculated Columns to Power BI Desktop Models

Create calculated columns
Understand row context
Choose a technique to add a column

Module 6 – Designing Power BI Reports

Design the layout of analytical reports
Design visually appealing reports
Report objects
Select report visuals
Choose report visuals suitable for the report layout
Format and configure visualizations
Work with key performance indicators

Module 7 – Configuring Power BI Report Filters

Introduction to report design for filtering
Apply filters to the report structure
Apply filters using slicers
Design reports with advanced filtering techniques
Filtering at the time of consumption
Select report filter techniques
Case study – Configure report filters based on feedback

Module 8 – Creating and Managing Workspaces in Power BI

Distribute a report or dashboard
Monitor usage and performance
Recommend a development lifecycle strategy
Troubleshoot data by visualizing its lineage
Configure data protection

Module 9 – Managing Semantic Models in Power BI

Use a Power BI gateway to connect to on-premise data sources
Configure scheduled refresh of the semantic model
Configure incremental refresh settings
Manage and promote semantic models
Troubleshoot service connectivity
Enhance performance with query caching (Premium)

Documentation

Digital course material included

Complementary courses

Temptraining funding

ITTA is a partner of Temptraining, the continuing education fund for temporary workers. This training fund can subsidize continuing education for anyone who works for an employer subject to the Collective Work Agreement (CCT) Rental of services.

Additional information

Data Discovery and Integration with Develop dynamic reports with Microsoft Power BI (DP-605)

In the dynamic world of data analytics, accessing and mastering information is crucial. Our initial module guides you through the essential steps to extract data from various sources, ranging from traditional files to relational and NoSQL databases, online services, and Azure Analysis Services. We teach you to wisely select the optimal storage mode and effectively solve any performance issues or data import errors, ensuring your dynamic reports are always up-to-date and accurate.

Data Transformation and Enrichment

Data transformation is a pillar of analytics, enabling the conversion of raw data into meaningful information. This module introduces you to advanced techniques for formatting and simplifying data structures. Learn to assess and modify data types, merge tables for a unified view, and use the Advanced Editor to customize M code, ensuring a solid foundation for your analyses.

In-Depth Semantic Modeling

Creating a robust semantic model in Power BI is essential for insightful analysis. We guide you in designing tables, creating relevant date tables, managing dimensions, and defining data granularity. Learn to master the relationships between tables and overcome modeling challenges for a high-performance data model.

Mastery of Measures and Calculated Columns

This module is dedicated to the development of measures and calculated columns in Power BI Desktop. From creating simple measures to implementing composite and quick measures, we cover it all. You’ll understand the difference between calculated columns and measures, and how to choose the right technique to enrich your data models with actionable insights.

Designing Persuasive Reports

The art of designing attractive and functional reports in Power BI is at the heart of this module. We explore best practices for layout, selecting suitable visuals, and customizing visualizations to tell a compelling story with your data. Key performance indicators (KPIs) are also discussed, enabling you to highlight the most important insights.

Advanced Report Filtering Strategies

Learn to apply advanced filters to your Power BI reports for targeted and relevant analysis. This module covers everything from basic filters to advanced filtering techniques, including the use of slicers for intuitive user interaction. Discover how to design reports that adapt at the time of consumption, providing a personalized experience for each user.

Workspace Management and Distribution

Managing workspaces in Power BI is crucial for effectively distributing reports and dashboards. This module prepares you to monitor usage and performance, recommend development strategies, and configure data protection, ensuring your organization makes the most of Power BI.

Advanced Administration of Semantic Models

The final module equips you to manage semantic models in Power BI in an advanced way. From using Power BI gateways to connect on-premise data sources to configuring incremental refreshes and promoting semantic models, we guide you through the best practices to optimize performance and ensure data reliability.

Our Power BI training offers an immersive and comprehensive experience, preparing you to fully exploit the potential of your data. Join us to elevate your analytics skills and take your reports to the next level.