{"id":134164,"date":"2025-02-24T10:23:21","date_gmt":"2025-02-24T09:23:21","guid":{"rendered":"https:\/\/www.itta.net\/?post_type=formations&#038;p=134164"},"modified":"2026-03-22T12:18:50","modified_gmt":"2026-03-22T11:18:50","slug":"configure-and-migrate-to-azure-database-for-postgresql-dp-3021","status":"publish","type":"formations","link":"https:\/\/www.itta.net\/en\/trainings\/it-pro\/cloud-computing\/configure-and-migrate-to-azure-database-for-postgresql-dp-3021\/","title":{"rendered":"Configure and migrate to Azure Database for PostgreSQL (DP-3021)"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">You need to create compelling Power BI reports but your dashboards lack visual impact and user engagement? Report design is both an art and a science, requiring knowledge of visualization best practices, interactivity features and performance optimization. Without proper design skills, reports fail to communicate insights effectively and users abandon them.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This official Microsoft DP-3021 Applied Skills training enables you in 1 day to build Power BI reports in Microsoft Fabric. Guided by MCT-certified trainers, you learn to design report layouts, choose appropriate visualizations, implement drill-through and cross-filtering, add bookmarks and buttons for navigation, and optimize report performance. You practice creating interactive, visually compelling reports connected to semantic models in Fabric. This hands-on credential validates your Power BI report design skills. 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-134164","formations","type-formations","status-publish","hentry","editeurs-microsoft","editeurs-microsoft-azure-microsoft","domaine-cloud-computing","domaine-it-pro"],"acf":{"reference":"DP-3021","duree_nombre":1,"duree_unite":"jour","prix_virtuel":850,"prix_presentiel":900,"prix_blended":"","prix_elearning":"","views":484,"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":"Configure and migrate to Azure Database for PostgreSQL Training (DP-3021)","objectifs":"<ul>\r\n \t<li>Design effective report layouts and page structures<\/li>\r\n \t<li>Choose appropriate visualizations for different data types<\/li>\r\n \t<li>Implement drill-through, cross-filtering and interactive features<\/li>\r\n \t<li>Add bookmarks and buttons for report navigation<\/li>\r\n \t<li>Optimize report performance and loading times<\/li>\r\n \t<li>Create visually compelling dashboards connected to semantic models<\/li>\r\n<\/ul>","connaissances":"<ul>\r\n \t<li>Master relational databases<\/li>\r\n \t<li>Have basic SQL knowledge<\/li>\r\n \t<li>Understand cloud computing principles<\/li>\r\n<\/ul>","profils_participants":"<ul>\r\n \t<li>Database administrators<\/li>\r\n \t<li>Cloud engineers<\/li>\r\n \t<li>Back-end developers<\/li>\r\n \t<li>Cloud solutions architects<\/li>\r\n<\/ul>","examen":"","documentation":"<ul>\r\n \t<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<\/ul>","lab__exercices":"<ul>\r\n \t<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<\/ul>","contenu_cours":"<strong>Module 1: Explore PostgreSQL architecture<\/strong>\n<ul>\n\t<li>Describe Azure Database for PostgreSQL<\/li>\n\t<li>Understand PostgreSQL architecture<\/li>\n\t<li>Understand PostgreSQL shared memory<\/li>\n<\/ul>\n<strong>Module 2: Understand client-server communication in PostgreSQL<\/strong>\n<ul>\n\t<li>Understand connection handling<\/li>\n\t<li>Understand the PostgreSQL client tools<\/li>\n<\/ul>\n<strong>Module 3: Understand PostgreSQL query processing<\/strong>\n<ul>\n\t<li>Identify the query processing components<\/li>\n\t<li>Understand the EXPLAIN statement<\/li>\n<\/ul>\n<strong>Module 4: Secure Azure Database for PostgreSQL<\/strong>\n<ul>\n\t<li>Describe Azure Database for PostgreSQL security<\/li>\n\t<li>Describe built-in Azure Database for PostgreSQL server roles<\/li>\n\t<li>Grant permissions in Azure SQL Database for PostgreSQL<\/li>\n\t<li>Understand encryption in Azure Database for PostgreSQL<\/li>\n<\/ul>\n<strong>Module 5: Procedures and functions in PostgreSQL<\/strong>\n<ul>\n\t<li>Create a stored procedure in Azure Database for PostgreSQL<\/li>\n\t<li>Call a stored procedure in Azure Database for PostgreSQL<\/li>\n\t<li>Create and use a function in Azure Database for PostgreSQL<\/li>\n<\/ul>\n<strong>Module 6: Understand write-ahead logging<\/strong>\n<ul>\n\t<li>Describe write ahead logging<\/li>\n\t<li>Describe replication and logical decoding<\/li>\n<\/ul>\n<strong>Module 7: Configure and manage Azure Database for PostgreSQL<\/strong>\n<ul>\n\t<li>Understand the system catalogs and system views<\/li>\n\t<li>Investigate metadata with system catalogs and system views<\/li>\n\t<li>Explain the purpose of vacuum and autovacuum<\/li>\n\t<li>Configure autovacuum server parameters<\/li>\n<\/ul>\n<strong>Module 8: Understand concurrency in PostgreSQL<\/strong>\n<ul>\n\t<li>Understand multi-version concurrency control (MVCC) and snapshots<\/li>\n\t<li>Describe isolation levels<\/li>\n\t<li>Understand locking<\/li>\n<\/ul>\n<strong>Module 9: Tune queries in Azure Database for PostgreSQL<\/strong>\n<ul>\n\t<li>Understand statistics<\/li>\n\t<li>Assess query performance with the Query Store<\/li>\n<\/ul>\n<strong>Module 10: Migrate to Azure Database for PostgreSQL flexible server<\/strong>\n<ul>\n\t<li>Compare online and offline migrations<\/li>\n\t<li>Identify migration tool options<\/li>\n\t<li>Analyze the decision criteria for tool selection and migration model<\/li>\n<\/ul>","cours_recommandes":[50223,14594],"infos_additionnelles":"<h3>Power BI reports: turning data into visual insights<\/h3>\n<p>Report design in Power BI is the final mile of the analytics pipeline, where data models become actionable business insights. Effective reports require more than just placing charts on a page; they need thoughtful layout design, appropriate visualization choices, intuitive interactivity and optimized performance. In Microsoft Fabric, Power BI reports connect directly to semantic models and benefit from the unified platform. This DP-3021 credential validates your ability to create impactful reports.<\/p>\n<h3>What you practice during this 1-day training<\/h3>\n<p>This hands-on training focuses on building Power BI reports in Microsoft Fabric. You design effective page layouts, choose appropriate visualizations for different data types, implement drill-through and cross-filtering interactions, add bookmarks and buttons for navigation, optimize report performance and loading times, and create mobile-responsive designs. 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-3021 training?<\/h4>\n<p>You should have basic Power BI experience and understanding of semantic models. Completing DP-3020 beforehand provides an excellent foundation for this report design training.<\/p>\n<h4>Is this an Applied Skills credential or a certification?<\/h4>\n<p>DP-3021 is a Microsoft Applied Skills credential, validating your practical Power BI report design skills through a scenario-based assessment.<\/p>\n<h4>Can I use these skills in Power BI Desktop as well?<\/h4>\n<p>Yes, report design skills are fully transferable between Microsoft Fabric and Power BI Desktop. This training uses the Fabric environment but all visualization and interactivity techniques apply to Desktop as well.<\/p>","inclus_dans_ce_cours_virtuel":"<ul>\r\n \t<li>Training provided by a certified trainer<\/li>\r\n \t<li>180 days of access to Official Microsoft Labs<\/li>\r\n \t<li>Official documentation in digital format<\/li>\r\n \t<li>Official Microsoft achievement badge<\/li>\r\n<\/ul>","inclus_dans_ce_cours_presentiel":"<ul>\r\n \t<li>Training provided by a certified trainer<\/li>\r\n \t<li>180 days of access to Official Microsoft Labs<\/li>\r\n \t<li>Official documentation in digital format<\/li>\r\n \t<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 Reports in Microsoft Fabric (DP-3021) - ITTA<\/title>\n<meta name=\"description\" content=\"Power BI report design training DP-3021 in 1 day. Create impactful reports and dashboards. 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\/configure-and-migrate-to-azure-database-for-postgresql-dp-3021\/\" \/>\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\\\/configure-and-migrate-to-azure-database-for-postgresql-dp-3021\\\/\",\"url\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/it-pro\\\/cloud-computing\\\/configure-and-migrate-to-azure-database-for-postgresql-dp-3021\\\/\",\"name\":\"Building Power BI Reports in Microsoft Fabric (DP-3021) - ITTA\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#website\"},\"datePublished\":\"2025-02-24T09:23:21+00:00\",\"dateModified\":\"2026-03-22T11:18:50+00:00\",\"description\":\"Power BI report design training DP-3021 in 1 day. Create impactful reports and dashboards. Applied Skills course in Geneva and Lausanne.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/it-pro\\\/cloud-computing\\\/configure-and-migrate-to-azure-database-for-postgresql-dp-3021\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/it-pro\\\/cloud-computing\\\/configure-and-migrate-to-azure-database-for-postgresql-dp-3021\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/it-pro\\\/cloud-computing\\\/configure-and-migrate-to-azure-database-for-postgresql-dp-3021\\\/#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\":\"Configure and migrate to Azure Database for PostgreSQL (DP-3021)\"}]},{\"@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 Reports in Microsoft Fabric (DP-3021) - ITTA","description":"Power BI report design training DP-3021 in 1 day. Create impactful reports and dashboards. 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\/configure-and-migrate-to-azure-database-for-postgresql-dp-3021\/","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\/configure-and-migrate-to-azure-database-for-postgresql-dp-3021\/","url":"https:\/\/www.itta.net\/en\/trainings\/it-pro\/cloud-computing\/configure-and-migrate-to-azure-database-for-postgresql-dp-3021\/","name":"Building Power BI Reports in Microsoft Fabric (DP-3021) - ITTA","isPartOf":{"@id":"https:\/\/www.itta.net\/en\/#website"},"datePublished":"2025-02-24T09:23:21+00:00","dateModified":"2026-03-22T11:18:50+00:00","description":"Power BI report design training DP-3021 in 1 day. Create impactful reports and dashboards. Applied Skills course in Geneva and Lausanne.","breadcrumb":{"@id":"https:\/\/www.itta.net\/en\/trainings\/it-pro\/cloud-computing\/configure-and-migrate-to-azure-database-for-postgresql-dp-3021\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.itta.net\/en\/trainings\/it-pro\/cloud-computing\/configure-and-migrate-to-azure-database-for-postgresql-dp-3021\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.itta.net\/en\/trainings\/it-pro\/cloud-computing\/configure-and-migrate-to-azure-database-for-postgresql-dp-3021\/#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":"Configure and migrate to Azure Database for PostgreSQL (DP-3021)"}]},{"@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\/134164","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\/14594"},{"embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations\/50223"}],"wp:attachment":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/media?parent=134164"}],"wp:term":[{"taxonomy":"editeurs","embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/editeurs?post=134164"},{"taxonomy":"domaine","embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/domaine?post=134164"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}