{"id":136210,"date":"2025-03-25T13:10:10","date_gmt":"2025-03-25T12:10:10","guid":{"rendered":"https:\/\/www.itta.net\/?post_type=formations&#038;p=136210"},"modified":"2026-03-22T12:18:49","modified_gmt":"2026-03-22T11:18:49","slug":"prepare-and-visualize-data-with-microsoft-power-bi-dp-605","status":"publish","type":"formations","link":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/analytics-platform-bi-office-automation\/prepare-and-visualize-data-with-microsoft-power-bi-dp-605\/","title":{"rendered":"Prepare and visualize data with Microsoft Power BI (DP-605)"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">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.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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.<\/p>\n","protected":false},"featured_media":0,"parent":0,"menu_order":0,"template":"","editeurs":[1488,1493],"domaine":[1208,1268,1207,1265],"class_list":["post-136210","formations","type-formations","status-publish","hentry","editeurs-microsoft","editeurs-power-bi-microsoft","domaine-analyse-et-bases-de-donnees","domaine-analytics-platform-bi-office-automation","domaine-informatique","domaine-office-automation"],"acf":{"reference":"DP-605","duree_nombre":1,"duree_unite":"jour","prix_virtuel":850,"prix_presentiel":900,"prix_blended":"","prix_elearning":"","views":667,"niveau":["Fondamental"],"role":"","certifiant":"","pdus":"","lieux":["Gen\u00e8ve","Lausanne"],"formats_dapprentissage":["presentiel","virtuel"],"examen_inclus":"Non certifiant","garanti":[""],"financement":["Temptraining"],"description_temptraining":"","description_caf":"","description_title":"Prepare and visualize data with Microsoft Power BI Training (DP-605)","objectifs":"<ul>\r\n \t<li>Provision and configure SQL databases in Microsoft Fabric<\/li>\r\n \t<li>Design schemas and manage database objects<\/li>\r\n \t<li>Implement security policies and access controls<\/li>\r\n \t<li>Configure replication to the analytics endpoint<\/li>\r\n \t<li>Integrate SQL Database with other Fabric workloads<\/li>\r\n \t<li>Monitor database performance and troubleshoot issues<\/li>\r\n<\/ul>","connaissances":"<ul>\r\n    <li>Understand the fundamentals of data analytics<\/li>\r\n    <li>Have practical experience with Microsoft Excel<\/li>\r\n    <li>Master essential database concepts<\/li>\r\n<\/ul>\r\n","profils_participants":"<ul>\r\n    <li>Data analyst<\/li>\r\n    <li>Business analyst<\/li>\r\n    <li>Junior data scientist<\/li>\r\n    <li>Reporting manager<\/li>\r\n<\/ul>\r\n","examen":"","documentation":"<ul>\r\n<li>Access to Microsoft Learn, Microsoft's online learning platform, offering interactive resources and educational content to deepen your knowledge and develop your technical skills.<\/li>\r\n\r\n<\/ul>","lab__exercices":"<ul>\r\n<li>This course provides you with exclusive access to the official Microsoft lab, enabling you to practice your skills in a professional environment.<\/li>\r\n\r\n<\/ul>","contenu_cours":"<strong>Module 1: Get started building with Power BI<\/strong>\n<ul>\n\t<li>Use Power BI<\/li>\n\t<li>Building blocks of Power BI<\/li>\n\t<li>Tour and use the Power BI service<\/li>\n<\/ul>\n<strong>Module 2: Get data in Power BI<\/strong>\n<ul>\n\t<li>Get data from files<\/li>\n\t<li>Get data from relational data sources<\/li>\n\t<li>Create dynamic reports with parameters<\/li>\n\t<li>Get data from a NoSQL database<\/li>\n\t<li>Get data from online services<\/li>\n\t<li>Select a storage mode<\/li>\n\t<li>Get data from Azure Analysis Services<\/li>\n\t<li>Fix performance issues<\/li>\n\t<li>Resolve data import errors<\/li>\n<\/ul>\n<strong>Module 3: Clean, transform, and load data in Power BI<\/strong>\n<ul>\n\t<li>Shape the initial data<\/li>\n\t<li>Simplify the data structure<\/li>\n\t<li>Evaluate and change column data types<\/li>\n\t<li>Combine multiple tables into a single table<\/li>\n\t<li>Profile data in Power BI<\/li>\n\t<li>Use Advanced Editor to modify M code<\/li>\n<\/ul>\n<strong>Module 4: Configure a semantic model<\/strong>\n<ul>\n\t<li>Configure relationships<\/li>\n\t<li>Configure tables<\/li>\n\t<li>Configure columns<\/li>\n\t<li>Configure hierarchies<\/li>\n\t<li>Configure measures<\/li>\n\t<li>Configure parameters<\/li>\n<\/ul>\n<strong>Module 5: Design Power BI reports<\/strong>\n<ul>\n\t<li>Design the analytical report layout<\/li>\n\t<li>Design visually appealing reports<\/li>\n\t<li>Use report objects<\/li>\n\t<li>Select report visuals<\/li>\n\t<li>Apply filters and slicers to reports<\/li>\n\t<li>Understand filtering techniques and considerations<\/li>\n\t<li>Case study - Configure report filters based on feedback<\/li>\n<\/ul>\n<strong>Module 6: Get started with Copilot in Power BI<\/strong>\n<ul>\n\t<li>Use Copilot in Power BI to prepare and model data<\/li>\n\t<li>Create reports with Copilot in Power BI<\/li>\n\t<li>Get your data ready for AI usage in Power BI<\/li>\n<\/ul>\n<strong>Module 7: Introduction to end-to-end analytics using Microsoft Fabric<\/strong>\n<ul>\n\t<li>Explore end-to-end analytics with Microsoft Fabric<\/li>\n\t<li>Explore data teams and Microsoft Fabric<\/li>\n\t<li>Enable and use Microsoft Fabric<\/li>\n<\/ul>","cours_recommandes":[47768,14776],"infos_additionnelles":"<h3>SQL Database in Microsoft Fabric: bringing transactions to analytics<\/h3>\n<p>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.<\/p>\n<h3>What you practice during this 1-day training<\/h3>\n<p>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.<\/p>\n<h3>Frequently Asked Questions<\/h3>\n<h4>What are the prerequisites for this DP-605 training?<\/h4>\n<p>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.<\/p>\n<h4>Is this an Applied Skills credential or a certification?<\/h4>\n<p>DP-605 is a Microsoft Applied Skills credential, validating your practical ability to implement SQL databases in Fabric through a scenario-based assessment.<\/p>\n<h4>How does Fabric SQL Database differ from Azure SQL Database?<\/h4>\n<p>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.<\/p>","inclus_dans_ce_cours_virtuel":"<ul>\r\n<li>Training provided by a certified trainer<\/li>\r\n<li>180 days of access to Official Microsoft Labs<\/li>\r\n<li>Official documentation in digital format<\/li>\r\n<li>Official Microsoft achievement badge<\/li>\r\n<\/ul>","inclus_dans_ce_cours_presentiel":"<ul>\r\n<li>Training provided by a certified trainer<\/li>\r\n<li>180 days of access to Official Microsoft Labs<\/li>\r\n<li>Official documentation in digital format<\/li>\r\n<li>Official Microsoft achievement badge<\/li>\r\n<\/ul>","inclus_dans_ce_cours_blended":"","inclus_dans_ce_cours_elearning":"","inclus_dans_ce_cours_surmesure":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.5 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Implementing a SQL Database in Microsoft Fabric (DP-605) - ITTA<\/title>\n<meta name=\"description\" content=\"Microsoft Fabric SQL Database training DP-605 in 1 day. Provision and manage SQL databases in Fabric. Applied Skills course in Geneva and Lausanne.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.itta.net\/en\/trainings\/office-automation\/analytics-platform-bi-office-automation\/prepare-and-visualize-data-with-microsoft-power-bi-dp-605\/\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/analytics-platform-bi-office-automation\\\/prepare-and-visualize-data-with-microsoft-power-bi-dp-605\\\/\",\"url\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/analytics-platform-bi-office-automation\\\/prepare-and-visualize-data-with-microsoft-power-bi-dp-605\\\/\",\"name\":\"Implementing a SQL Database in Microsoft Fabric (DP-605) - ITTA\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#website\"},\"datePublished\":\"2025-03-25T12:10:10+00:00\",\"dateModified\":\"2026-03-22T11:18:49+00:00\",\"description\":\"Microsoft Fabric SQL Database training DP-605 in 1 day. Provision and manage SQL databases in Fabric. Applied Skills course in Geneva and Lausanne.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/analytics-platform-bi-office-automation\\\/prepare-and-visualize-data-with-microsoft-power-bi-dp-605\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/analytics-platform-bi-office-automation\\\/prepare-and-visualize-data-with-microsoft-power-bi-dp-605\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/analytics-platform-bi-office-automation\\\/prepare-and-visualize-data-with-microsoft-power-bi-dp-605\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.itta.net\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Office Automation\",\"item\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Analytics Platform - BI\",\"item\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/analytics-platform-bi-office-automation\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Prepare and visualize data with Microsoft Power BI (DP-605)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.itta.net\\\/en\\\/\",\"name\":\"ITTA\",\"description\":\"Formations &amp; Certifications en Suisse Romande\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.itta.net\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":[\"Organization\",\"EducationalOrganization\"],\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#organization\",\"name\":\"ITTA\",\"alternateName\":\"IT TRAINING ACADEMY SA\",\"url\":\"https:\\\/\\\/www.itta.net\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.itta.net\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/Logo-transparent.png\",\"contentUrl\":\"https:\\\/\\\/www.itta.net\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/Logo-transparent.png\",\"width\":1500,\"height\":623,\"caption\":\"ITTA\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/people\\\/ITTA\\\/100063747262936\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/1001738\",\"https:\\\/\\\/www.instagram.com\\\/itta_suisse\\\/\"],\"contactPoint\":{\"@type\":\"ContactPoint\",\"telephone\":\"+41 58 307 73 00\",\"contactType\":\"customer service\",\"availableLanguage\":[\"French\",\"English\"],\"areaServed\":[{\"@type\":\"Country\",\"name\":\"Switzerland\"},{\"@type\":\"Country\",\"name\":\"France\"}]},\"location\":[{\"@type\":\"Place\",\"name\":\"ITTA Geneve\",\"address\":{\"@type\":\"PostalAddress\",\"streetAddress\":\"Route des Jeunes 35\",\"addressLocality\":\"Carouge\",\"postalCode\":\"1227\",\"addressRegion\":\"GE\",\"addressCountry\":\"CH\"},\"geo\":{\"@type\":\"GeoCoordinates\",\"latitude\":46.18274,\"longitude\":6.12922}},{\"@type\":\"Place\",\"name\":\"ITTA Lausanne\",\"address\":{\"@type\":\"PostalAddress\",\"streetAddress\":\"Rue des Cotes-de-Montbenon 16\",\"addressLocality\":\"Lausanne\",\"postalCode\":\"1003\",\"addressRegion\":\"VD\",\"addressCountry\":\"CH\"},\"geo\":{\"@type\":\"GeoCoordinates\",\"latitude\":46.52111,\"longitude\":6.62734}}]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Implementing a SQL Database in Microsoft Fabric (DP-605) - ITTA","description":"Microsoft Fabric SQL Database training DP-605 in 1 day. Provision and manage SQL databases in Fabric. Applied Skills course in Geneva and Lausanne.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/analytics-platform-bi-office-automation\/prepare-and-visualize-data-with-microsoft-power-bi-dp-605\/","twitter_misc":{"Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/analytics-platform-bi-office-automation\/prepare-and-visualize-data-with-microsoft-power-bi-dp-605\/","url":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/analytics-platform-bi-office-automation\/prepare-and-visualize-data-with-microsoft-power-bi-dp-605\/","name":"Implementing a SQL Database in Microsoft Fabric (DP-605) - ITTA","isPartOf":{"@id":"https:\/\/www.itta.net\/en\/#website"},"datePublished":"2025-03-25T12:10:10+00:00","dateModified":"2026-03-22T11:18:49+00:00","description":"Microsoft Fabric SQL Database training DP-605 in 1 day. Provision and manage SQL databases in Fabric. Applied Skills course in Geneva and Lausanne.","breadcrumb":{"@id":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/analytics-platform-bi-office-automation\/prepare-and-visualize-data-with-microsoft-power-bi-dp-605\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.itta.net\/en\/trainings\/office-automation\/analytics-platform-bi-office-automation\/prepare-and-visualize-data-with-microsoft-power-bi-dp-605\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/analytics-platform-bi-office-automation\/prepare-and-visualize-data-with-microsoft-power-bi-dp-605\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.itta.net\/en\/"},{"@type":"ListItem","position":2,"name":"Office Automation","item":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/"},{"@type":"ListItem","position":3,"name":"Analytics Platform - BI","item":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/analytics-platform-bi-office-automation\/"},{"@type":"ListItem","position":4,"name":"Prepare and visualize data with Microsoft Power BI (DP-605)"}]},{"@type":"WebSite","@id":"https:\/\/www.itta.net\/en\/#website","url":"https:\/\/www.itta.net\/en\/","name":"ITTA","description":"Formations &amp; Certifications en Suisse Romande","publisher":{"@id":"https:\/\/www.itta.net\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.itta.net\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":["Organization","EducationalOrganization"],"@id":"https:\/\/www.itta.net\/en\/#organization","name":"ITTA","alternateName":"IT TRAINING ACADEMY SA","url":"https:\/\/www.itta.net\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.itta.net\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.itta.net\/wp-content\/uploads\/2023\/02\/Logo-transparent.png","contentUrl":"https:\/\/www.itta.net\/wp-content\/uploads\/2023\/02\/Logo-transparent.png","width":1500,"height":623,"caption":"ITTA"},"image":{"@id":"https:\/\/www.itta.net\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/people\/ITTA\/100063747262936\/","https:\/\/www.linkedin.com\/company\/1001738","https:\/\/www.instagram.com\/itta_suisse\/"],"contactPoint":{"@type":"ContactPoint","telephone":"+41 58 307 73 00","contactType":"customer service","availableLanguage":["French","English"],"areaServed":[{"@type":"Country","name":"Switzerland"},{"@type":"Country","name":"France"}]},"location":[{"@type":"Place","name":"ITTA Geneve","address":{"@type":"PostalAddress","streetAddress":"Route des Jeunes 35","addressLocality":"Carouge","postalCode":"1227","addressRegion":"GE","addressCountry":"CH"},"geo":{"@type":"GeoCoordinates","latitude":46.18274,"longitude":6.12922}},{"@type":"Place","name":"ITTA Lausanne","address":{"@type":"PostalAddress","streetAddress":"Rue des Cotes-de-Montbenon 16","addressLocality":"Lausanne","postalCode":"1003","addressRegion":"VD","addressCountry":"CH"},"geo":{"@type":"GeoCoordinates","latitude":46.52111,"longitude":6.62734}}]}]}},"_links":{"self":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations\/136210","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations"}],"about":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/types\/formations"}],"acf:post":[{"embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations\/14776"},{"embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations\/47768"}],"wp:attachment":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/media?parent=136210"}],"wp:term":[{"taxonomy":"editeurs","embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/editeurs?post=136210"},{"taxonomy":"domaine","embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/domaine?post=136210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}