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

Ref. DP-605
Duration:
1
 day
Exam:
Optional
Level:
Intermediate

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.

Prix de l'inscription
CHF 850.-
Inclus dans ce cours
  • Training provided by a certified trainer
  • 180 days of access to Official Microsoft Labs
  • Official documentation in digital format
  • Official Microsoft achievement badge

lun03Juin09:00lun17:00VirtuelVirtual Etiquettes de sessionDP-605

lun03Juin09:00lun17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionDP-605

lun08juil09:00lun17:00VirtuelVirtual Etiquettes de sessionDP-605

lun08juil09:00lun17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionDP-605

lun12Aoû09:00lun17:00VirtuelVirtual Etiquettes de sessionDP-605

lun12Aoû09:00lun17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionDP-605

lun16Sep09:00lun17:00VirtuelVirtual Etiquettes de sessionDP-605

lun16Sep09:00lun17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionDP-605

lun21Oct09:00lun17:00VirtuelVirtual Etiquettes de sessionDP-605

lun21Oct09:00lun17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionDP-605

lun25Nov09:00lun17:00VirtuelVirtual Etiquettes de sessionDP-605

lun25Nov09:00lun17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionDP-605

Horaires d’ouverture

Du lundi au vendredi, de 8:30 à 18:00.

Contactez-nous

Votre demande

Opening hours

Monday to Friday, from 8:30 am to 06:00 pm.

Contact us

Your request

X
X
X
X