{"id":134156,"date":"2025-02-24T09:53:38","date_gmt":"2025-02-24T08:53:38","guid":{"rendered":"https:\/\/www.itta.net\/?post_type=formations&#038;p=134156"},"modified":"2026-03-22T12:18:50","modified_gmt":"2026-03-22T11:18:50","slug":"develop-data-driven-applications-by-using-azure-sql-database-dp-3020","status":"publish","type":"formations","link":"https:\/\/www.itta.net\/en\/trainings\/it-pro\/cloud-computing\/develop-data-driven-applications-by-using-azure-sql-database-dp-3020\/","title":{"rendered":"Develop data-driven applications with Azure SQL Database (DP-3020)"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">You need to build semantic models for Power BI reporting but struggle with data modeling best practices and DAX optimization? Semantic models are the foundation of every Power BI report, and poorly designed models lead to slow reports, incorrect calculations and frustrated users. Without proper modeling skills, analytics investments fail to deliver their full value.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This official Microsoft DP-3020 Applied Skills training enables you in 1 day to build Power BI semantic models in Microsoft Fabric. Guided by MCT-certified trainers, you learn to design star schemas, create relationships, write DAX measures and calculated columns, implement row-level security, and optimize model performance. You practice building production-ready semantic models connected to Fabric data sources. This hands-on credential validates your data modeling skills for Power BI analytics. 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,1490],"domaine":[1256,1253],"class_list":["post-134156","formations","type-formations","status-publish","hentry","editeurs-microsoft","editeurs-microsoft-azure-microsoft","domaine-cloud-computing","domaine-it-pro"],"acf":{"reference":"DP-3020","duree_nombre":1,"duree_unite":"jour","prix_virtuel":850,"prix_presentiel":900,"prix_blended":"","prix_elearning":"","views":514,"niveau":["Interm\u00e9diaire"],"role":"","certifiant":"","pdus":"","lieux":["Gen\u00e8ve","Lausanne"],"formats_dapprentissage":["presentiel","virtuel"],"examen_inclus":"Non certifiant","garanti":[""],"financement":["Temptraining"],"description_temptraining":"","description_caf":"","description_title":"Develop data-driven applications with Azure SQL Database Training (DP-3020)","objectifs":"<ul>\r\n \t<li>Design star schemas for Power BI semantic models<\/li>\r\n \t<li>Create and manage table relationships<\/li>\r\n \t<li>Write DAX measures and calculated columns<\/li>\r\n \t<li>Implement row-level security for data access control<\/li>\r\n \t<li>Optimize semantic model performance<\/li>\r\n \t<li>Connect models to Fabric data sources<\/li>\r\n<\/ul>","connaissances":"<ul>\r\n    <li>Experience with relational databases<\/li>\r\n    <li>Knowledge of security concepts: identities and permissions<\/li>\r\n    <li>Using the Azure Portal to create resources<\/li>\r\n<\/ul>","profils_participants":"&lt;ul&gt;\r\n&lt;li&gt;Solution architects&lt;\/li&gt;\r\n&lt;li&gt;Application developers&lt;\/li&gt;\r\n&lt;li&gt;Database administrators&lt;\/li&gt;\r\n&lt;li&gt;DevOps engineers&lt;\/li&gt;\r\n&lt;li&gt;IT project managers&lt;\/li&gt;\r\n&lt;\/ul&gt;","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 with Azure SQL Database for modern application development<\/strong>\n<ul>\n\t<li>Explain deployment options<\/li>\n\t<li>Explore Hyperscale capabilities<\/li>\n\t<li>Understand the serverless compute tier<\/li>\n\t<li>Enable application resilience with Azure SQL Database<\/li>\n\t<li>Understand AI capabilities for Azure SQL Database<\/li>\n<\/ul>\n<strong>Module 2 : Develop for Azure SQL Database<\/strong>\n<ul>\n\t<li>Create and configure an Azure SQL Database<\/li>\n\t<li>Use SQL Database Projects<\/li>\n\t<li>Build and deploy database projects in GitHub Actions and Azure DevOps<\/li>\n\t<li>Secure and monitor Continuous Integration and Continuous Deployment (CI\/CD)<\/li>\n<\/ul>\n<strong>Module 3 : Develop a data API for Azure SQL Database<\/strong>\n<ul>\n\t<li>Explore Data API Builder for Azure SQL Database<\/li>\n\t<li>Develop a data API using Azure Static Web Apps<\/li>\n\t<li>Develop a data API using Azure Web App for Containers<\/li>\n<\/ul>\n<strong>Module 4 : Explore data manipulation options in Azure SQL Database<\/strong>\n<ul>\n\t<li>Use RESTful endpoints to import data to Azure SQL Database<\/li>\n\t<li>Manipulate data in Azure SQL Database with Azure Functions<\/li>\n\t<li>Understand the data movement tools available<\/li>\n<\/ul>\n<strong>Module 5 : Explore security practices for Azure SQL Database<\/strong>\n<ul>\n\t<li>Explore authentication methods<\/li>\n\t<li>Configure managed identity<\/li>\n\t<li>Understand firewall rules<\/li>\n\t<li>Explore advanced data security<\/li>\n<\/ul>","cours_recommandes":[14594,47363],"infos_additionnelles":"<h3>Power BI semantic models: the foundation of effective analytics<\/h3>\n<p>Semantic models are the core of every Power BI report, defining how data is structured, related and calculated. A well-designed semantic model ensures fast reports, accurate calculations and a consistent user experience. In Microsoft Fabric, semantic models benefit from direct connectivity to lakehouses and warehouses through OneLake. This DP-3020 credential validates your ability to build production-ready models, an essential skill for analytics professionals in Switzerland.<\/p>\n<h3>What you practice during this 1-day training<\/h3>\n<p>This hands-on training focuses on building semantic models in Microsoft Fabric. You design star schemas with fact and dimension tables, create relationships and manage cardinality, write DAX measures and calculated columns, implement row-level security for data access control, optimize model performance through best practices, and connect to Fabric data sources. 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-3020 training?<\/h4>\n<p>You should have basic Power BI experience and understanding of data modeling concepts. Familiarity with DAX fundamentals is helpful but the training covers essential DAX patterns.<\/p>\n<h4>Is this an Applied Skills credential or a certification?<\/h4>\n<p>DP-3020 is a Microsoft Applied Skills credential, validating your practical semantic model building skills through a scenario-based assessment.<\/p>\n<h4>Do I need Microsoft Fabric to use semantic models?<\/h4>\n<p>Semantic models can be built in both Power BI Desktop and Microsoft Fabric. This training focuses on the Fabric environment where models benefit from tighter integration with lakehouses and warehouses, but the skills are transferable to Power BI Desktop as well.<\/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>Building Power BI Semantic Models in Microsoft Fabric - ITTA<\/title>\n<meta name=\"description\" content=\"Power BI semantic model training DP-3020 in 1 day. Build and optimize data models for reporting. 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\/it-pro\/cloud-computing\/develop-data-driven-applications-by-using-azure-sql-database-dp-3020\/\" \/>\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\\\/it-pro\\\/cloud-computing\\\/develop-data-driven-applications-by-using-azure-sql-database-dp-3020\\\/\",\"url\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/it-pro\\\/cloud-computing\\\/develop-data-driven-applications-by-using-azure-sql-database-dp-3020\\\/\",\"name\":\"Building Power BI Semantic Models in Microsoft Fabric - ITTA\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#website\"},\"datePublished\":\"2025-02-24T08:53:38+00:00\",\"dateModified\":\"2026-03-22T11:18:50+00:00\",\"description\":\"Power BI semantic model training DP-3020 in 1 day. Build and optimize data models for reporting. Applied Skills course in Geneva and Lausanne.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/it-pro\\\/cloud-computing\\\/develop-data-driven-applications-by-using-azure-sql-database-dp-3020\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/it-pro\\\/cloud-computing\\\/develop-data-driven-applications-by-using-azure-sql-database-dp-3020\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/it-pro\\\/cloud-computing\\\/develop-data-driven-applications-by-using-azure-sql-database-dp-3020\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.itta.net\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"IT Pro\",\"item\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/it-pro\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Develop data-driven applications with Azure SQL Database (DP-3020)\"}]},{\"@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":"Building Power BI Semantic Models in Microsoft Fabric - ITTA","description":"Power BI semantic model training DP-3020 in 1 day. Build and optimize data models for reporting. 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\/it-pro\/cloud-computing\/develop-data-driven-applications-by-using-azure-sql-database-dp-3020\/","twitter_misc":{"Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.itta.net\/en\/trainings\/it-pro\/cloud-computing\/develop-data-driven-applications-by-using-azure-sql-database-dp-3020\/","url":"https:\/\/www.itta.net\/en\/trainings\/it-pro\/cloud-computing\/develop-data-driven-applications-by-using-azure-sql-database-dp-3020\/","name":"Building Power BI Semantic Models in Microsoft Fabric - ITTA","isPartOf":{"@id":"https:\/\/www.itta.net\/en\/#website"},"datePublished":"2025-02-24T08:53:38+00:00","dateModified":"2026-03-22T11:18:50+00:00","description":"Power BI semantic model training DP-3020 in 1 day. Build and optimize data models for reporting. Applied Skills course in Geneva and Lausanne.","breadcrumb":{"@id":"https:\/\/www.itta.net\/en\/trainings\/it-pro\/cloud-computing\/develop-data-driven-applications-by-using-azure-sql-database-dp-3020\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.itta.net\/en\/trainings\/it-pro\/cloud-computing\/develop-data-driven-applications-by-using-azure-sql-database-dp-3020\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.itta.net\/en\/trainings\/it-pro\/cloud-computing\/develop-data-driven-applications-by-using-azure-sql-database-dp-3020\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.itta.net\/en\/"},{"@type":"ListItem","position":2,"name":"IT Pro","item":"https:\/\/www.itta.net\/en\/trainings\/it-pro\/"},{"@type":"ListItem","position":3,"name":"Develop data-driven applications with Azure SQL Database (DP-3020)"}]},{"@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\/134156","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\/47363"},{"embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations\/14594"}],"wp:attachment":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/media?parent=134156"}],"wp:term":[{"taxonomy":"editeurs","embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/editeurs?post=134156"},{"taxonomy":"domaine","embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/domaine?post=134156"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}