This is an example of a simple banner

Training: Prepare and visualize data with Microsoft Power BI (DP-605)

Ref. DP-605
Duration:
1
 day
Exam:
Not certifying
Level:
Fundamental

Prepare and visualize data with Microsoft Power BI (DP-605)

Develop your data visualization skills

Microsoft Power BI has become an essential tool for effectively visualizing data in the professional world. With our course, “Preparing and Visualizing Data with Microsoft Power BI (DP-605)”, you’ll learn how to easily connect to various data sources. You’ll also be able to transform and structure this data to create interactive and relevant reports. This training is specifically designed to help you make precise, data-driven decisions through data analytics.

Comprehensive training for high-performance interactive reports

You’ll discover how to fully utilize Power BI to create appealing reports, simplify the interpretation of results, and enhance your analytical performance. You’ll also master Microsoft Fabric, allowing you to centralize your entire analytical approach on one integrated platform. Through practical and concrete exercises, you’ll deepen your understanding of key stages: retrieving data from multiple sources such as Excel, relational databases, or NoSQL databases, thorough data cleaning using Power Query, and optimized design of semantic models.

Télécharger le PDF de la formation

Participant Profiles

  • Data analyst
  • Business analyst
  • Junior data scientist
  • Reporting manager

Objectives

  • Create interactive reports in Power BI
  • Efficiently import data from various sources
  • Clean and transform data with Power Query
  • Design a high-performance semantic model
  • Select the most suitable visualizations
  • Use Copilot to automate reports
  • Integrate analytics with Microsoft Fabric

Prerequisites

  • Understand the fundamentals of data analytics
  • Have practical experience with Microsoft Excel
  • Master essential database concepts

Course Content

Module 1: Get started building with Power BI

  • Use Power BI
  • Building blocks of Power BI
  • Tour and use the Power BI service

Module 2: 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

Module 3: 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

Module 4: 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 modeling challenges

Module 5: 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 visualizations
  • Work with key performance indicators

Module 6: Create interactive reports using Copilot for Power BI

  • Prepare your data for use with Copilot for Power BI
  • Use Copilot for Power BI to model your data
  • Create reports with Copilot for Power BI
  • Create summaries with Copilot for Power BI

Module 7: Introduction to end-to-end analytics using Microsoft Fabric

  • Explore end-to-end analytics with Microsoft Fabric
  • Data teams and Microsoft Fabric
  • Enable and use Microsoft Fabric

Documentation

  • Access to Microsoft Learn, Microsoft’s online learning platform, offering interactive resources and educational content to deepen your knowledge and develop your technical skills.

Lab / Exercises

  • This course provides you with exclusive access to the official Microsoft lab, enabling you to practice your skills in a professional environment.

Complementary Courses

Eligible Funding

ITTA is a partner of a continuing education fund dedicated to temporary workers. This fund can subsidize your training, provided that you are subject to the “Service Provision” collective labor agreement (CCT) and meet certain conditions, including having worked at least 88 hours in the past 12 months.

Additional Information

Enhance decision-making through data visualization

With the growing emergence of data within businesses, mastering data handling has become an essential skill. The course “Preparing and Visualizing Data with Microsoft Power BI (DP-605)” perfectly aligns with this need. By integrating this training into your professional journey, you’ll gain practical methods to effectively manage data. You’ll learn to precisely structure your data, integrate it into powerful models, and design interactive reports that facilitate deeper analysis.

Optimize your data with Microsoft Fabric

Microsoft Fabric is a powerful platform that simplifies analytics and centralizes all your data management activities. Through our training, you’ll discover how to fully leverage Microsoft Fabric to optimize your analytics processes. This integrated tool not only facilitates data access but also simplifies collaboration within multidisciplinary teams. You’ll be able to build efficient data models and easily share them within your organization, thus strengthening team collaboration.

Automate analytical tasks with Copilot

Automation plays a crucial role in accelerating and simplifying repetitive data tasks. With Copilot for Power BI, generative AI becomes your ally. It enables you to quickly create interactive and relevant reports, significantly reducing your manual workload. Throughout this course, you’ll explore in-depth how Copilot can enhance your analyses—from automatically modeling your datasets to rapidly generating comprehensive and intuitive reports.

Master best practices for a high-performance semantic model

Building a clear semantic model is essential for ensuring the performance of your Power BI reports. By following this training, you’ll gain solid expertise in optimally structuring your data through star schemas. You’ll learn to effectively manage table relationships and select the right data granularity to improve the readability and performance of your models. These skills will significantly enhance your analytical quality and enable quicker, more accurate decision-making.

How to effectively choose the right visualizations?

Creating clear and meaningful reports necessarily involves selecting appropriate visualizations. With the DP-605 course, you’ll gain expertise in choosing visual representations best suited to your data. Beyond simply creating charts, you’ll master best practices to optimize the usability and effectiveness of your reports. You’ll be able to deliver interactive reports to your colleagues, enabling rapid understanding of key data insights.

FAQ

What practical benefits will I gain from the DP-605 course?
This training provides you with practical data visualization skills, significantly improving your professional efficiency.

Do I need advanced computer skills?
No, basic knowledge of data analytics and familiarity with Excel are sufficient to comfortably follow this course.

What types of data sources will I learn to manage?
You will handle various data sources such as Excel, relational or NoSQL databases, and cloud services like Azure.

Is this training suitable for teamwork on data projects?
Yes, the training also covers Microsoft Fabric, specifically designed to enhance collaboration within data teams.

How can Copilot in Power BI benefit me?
Copilot automates report creation and data modeling through artificial intelligence, simplifying your daily professional tasks.

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
Mois actuel

mar22Avr09:00mar17:00VirtuelVirtual Etiquettes de sessionDP-605

mar22Avr09:00mar17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionDP-605

mar27Mai09:00mar17:00VirtuelVirtual Etiquettes de sessionDP-605

mar27Mai09:00mar17:00Genève, Route des Jeunes 35, 1227 Carouge Etiquettes de sessionDP-605

mar01juil09:00mar17:00VirtuelVirtual Etiquettes de sessionDP-605

mar01juil09:00mar17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionDP-605

mar05Aoû09:00mar17:00VirtuelVirtual Etiquettes de sessionDP-605

mar05Aoû09:00mar17:00Genève, Route des Jeunes 35, 1227 Carouge Etiquettes de sessionDP-605

mar09Sep09:00mar17:00VirtuelVirtual Etiquettes de sessionDP-605

mar09Sep09:00mar17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionDP-605

mar14Oct09:00mar17:00VirtuelVirtual Etiquettes de sessionDP-605

mar14Oct09:00mar17:00Genève, Route des Jeunes 35, 1227 Carouge Etiquettes de sessionDP-605

mar18Nov09:00mar17:00VirtuelVirtual Etiquettes de sessionDP-605

mar18Nov09:00mar17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionDP-605

Contact

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Opening hours

Monday to Friday
8:30 AM to 6:00 PM
Tel. 058 307 73 00

Contact-us

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Make a request

Contact

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Opening hours

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

Contact us

Your request