This is an example of a simple banner

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

Ref. DP-605
Duration:
1
 jour
Exam:
Non certifiant
Level:
Fondamental

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

You need to provision and manage SQL databases within Microsoft Fabric but are unsure how this new capability integrates with the broader platform? Fabric SQL Database brings the familiar SQL Server experience directly into the Fabric environment, combining operational and analytical workloads. Without hands-on skills, leveraging this integrated database capability for transactional and analytical scenarios remains difficult.

This official Microsoft DP-605 Applied Skills training enables you in 1 day to implement SQL databases in Microsoft Fabric. Guided by MCT-certified trainers, you learn to provision databases, design schemas, manage security, configure replication to the analytics endpoint, and integrate with other Fabric workloads. You practice building operational databases that seamlessly connect to lakehouses and warehouses for unified analytics. This hands-on credential validates your SQL Database implementation skills on Fabric. Sessions are available in person in Geneva and Lausanne or via virtual classroom.

Participant Profiles

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

Objectives

  • Provision and configure SQL databases in Microsoft Fabric
  • Design schemas and manage database objects
  • Implement security policies and access controls
  • Configure replication to the analytics endpoint
  • Integrate SQL Database with other Fabric workloads
  • Monitor database performance and troubleshoot issues

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: Configure a semantic model

  • Configure relationships
  • Configure tables
  • Configure columns
  • Configure hierarchies
  • Configure measures
  • Configure parameters

Module 5: Design Power BI reports

  • Design the analytical report layout
  • Design visually appealing reports
  • Use report objects
  • Select report visuals
  • Apply filters and slicers to reports
  • Understand filtering techniques and considerations
  • Case study – Configure report filters based on feedback

Module 6: Get started with Copilot in Power BI

  • Use Copilot in Power BI to prepare and model data
  • Create reports with Copilot in Power BI
  • Get your data ready for AI usage in Power BI

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

  • Explore end-to-end analytics with Microsoft Fabric
  • Explore 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

SQL Database in Microsoft Fabric: bringing transactions to analytics

SQL Database in Microsoft Fabric is a new capability that brings the familiar SQL Server engine directly into the Fabric platform. This enables organizations to run transactional workloads alongside analytical ones, with automatic replication to the analytics endpoint. For database professionals in Switzerland, this represents an opportunity to unify operational and analytical databases in a single managed platform, reducing complexity and enabling real-time analytics on transactional data.

What you practice during this 1-day training

This hands-on training focuses on implementing SQL databases within Microsoft Fabric. You provision databases, design and create schemas, manage data through T-SQL, configure security policies, set up replication to the analytics endpoint and integrate with other Fabric workloads like lakehouses and warehouses. All exercises are performed on real Fabric environments with MCT-certified trainer guidance.

Frequently Asked Questions

What are the prerequisites for this DP-605 training?

You should have working knowledge of T-SQL and familiarity with SQL Server database concepts. Basic understanding of Microsoft Fabric is helpful but not required.

Is this an Applied Skills credential or a certification?

DP-605 is a Microsoft Applied Skills credential, validating your practical ability to implement SQL databases in Fabric through a scenario-based assessment.

How does Fabric SQL Database differ from Azure SQL Database?

Fabric SQL Database is integrated directly into the Fabric platform with automatic data replication to OneLake for analytics. Azure SQL Database is a standalone PaaS service. Fabric SQL Database is designed for scenarios where transactional and analytical workloads need to coexist seamlessly.

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

ven03juil09:00ven17:00VirtuelVirtual Etiquettes de sessionDP-605

ven03juil09:00ven17:00Genève, Route des Jeunes 35, 1227 Genève Etiquettes de sessionDP-605

ven07Aoû09:00ven17:00VirtuelVirtual Etiquettes de sessionDP-605

ven07Aoû09:00ven17:00Lausanne, Av. Mon-Repos 24, 1005 Lausanne Etiquettes de sessionDP-605

ven11Sep09:00ven17:00VirtuelVirtual Etiquettes de sessionDP-605

ven11Sep09:00ven17:00Genève, Route des Jeunes 35, 1227 Genève Etiquettes de sessionDP-605

ven16Oct09:00ven17:00VirtuelVirtual Etiquettes de sessionDP-605

ven16Oct09:00ven17:00Lausanne, Av. Mon-Repos 24, 1005 Lausanne Etiquettes de sessionDP-605

ven20Nov09:00ven17:00VirtuelVirtual Etiquettes de sessionDP-605

ven20Nov09:00ven17:00Genève, Route des Jeunes 35, 1227 Genève 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