{"id":38636,"date":"2024-07-15T17:47:02","date_gmt":"2024-07-15T12:17:02","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=38636"},"modified":"2024-07-15T17:47:02","modified_gmt":"2024-07-15T12:17:02","slug":"visualizing-data-models-with-copilot-in-an-erd-view","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2024\/07\/visualizing-data-models-with-copilot-in-an-erd-view\/","title":{"rendered":"Visualizing Data Models with Copilot in an ERD View"},"content":{"rendered":"<p><img decoding=\"async\" class=\"alignnone wp-image-38646 size-full\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View.png\" alt=\"Visualizing Data Models with Copilot in an ERD View\" width=\"2800\" height=\"1600\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View.png 2800w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-300x171.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-1024x585.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-768x439.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-1536x878.png 1536w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-2048x1170.png 2048w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-660x377.png 660w\" sizes=\"(max-width: 2800px) 100vw, 2800px\" \/><\/p>\n<p style=\"text-align: justify;\">Exploring the capabilities of Copilot Studio within Microsoft Dynamics and Power Platform opens up new avenues for enhancing business application development. A critical aspect of this process involves constructing intricate data models that often include multiple tables. The introduction of the innovative <strong>&#8216;Create New Tables (Preview)<\/strong>&#8216; feature in <strong>Copilot Studio<\/strong> transforms this procedure by enabling the seamless creation and visualization of data models through an intuitive <strong>Entity Relationship Diagram (ERD)<\/strong> view. This blog post delves into how this feature significantly boosts efficiency and precision in crafting robust data models, thereby maximizing the potential of Microsoft Dynamics and Power Platform to meet diverse business needs.<\/p>\n<p style=\"text-align: justify;\">This innovative feature enables seamless data integration from diverse sources such as natural language inputs, Excel files, and SharePoint lists. Users can easily manage and manipulate data with a straightforward drag-and-drop interface.<\/p>\n<p style=\"text-align: justify;\">With the help of <strong>Copilot<\/strong>, this feature allows you to create multiple tables and relationships in the <strong>ERD <\/strong>view.<\/p>\n<p style=\"text-align: justify;\"><u>Steps to Create and set up the new tables in <strong>ERD <\/strong>view<\/u>:<\/p>\n<h2 style=\"text-align: justify;\"><strong>Step 1: Enable Copilot(preview) Feature<\/strong><\/h2>\n<p><strong>1. 1 Sign in with your Microsoft Dataverse:<br \/>\n<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>Move to the <a href=\"https:\/\/admin.powerplatform.microsoft.com\/\" target=\"_blank\" rel=\"noopener\">Power Platform Admin Center<\/a>.<\/li>\n<li>Select the environment where you want to enable features: <strong>Settings<\/strong> \u2192 <strong>Features<\/strong> \u2192 <strong>Enable Copilot Preview Feature<\/strong> for your environment.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img decoding=\"async\" class=\"alignnone wp-image-38637 size-full\" style=\"border: 1px solid #000000; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-1.png\" alt=\"Visualizing Data Models with Copilot in an ERD View\" width=\"1000\" height=\"527\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-1.png 1000w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-1-300x158.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-1-768x405.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-1-660x348.png 660w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-1-380x200.png 380w\" sizes=\"(max-width: 1000px) 100vw, 1000px\" \/><\/p>\n<p><strong>1.2 Activate the New Data Experience<\/strong>:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Turn to the <a href=\"https:\/\/make.powerapps.com\/\" target=\"_blank\" rel=\"noopener\">Power Apps Home Page<\/a> for the selected environment.<\/li>\n<li>Enable the <strong>\u2018Try the new data experience\u2019<\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img decoding=\"async\" class=\"alignnone wp-image-38638 size-full\" style=\"border: 1px solid #000000; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-2.png\" alt=\"Visualizing Data Models with Copilot in an ERD View\" width=\"1000\" height=\"420\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-2.png 1000w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-2-300x126.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-2-768x323.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-2-660x277.png 660w\" sizes=\"(max-width: 1000px) 100vw, 1000px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Once enabled, you can access the new data experience through various pathways, such as the home page, tables page, and app designers\u2014available wherever you can create new tables.<\/li>\n<\/ul>\n<h2 style=\"text-align: left;\"><strong>Step 2: Create tables with <\/strong><strong>Create new tables(preview) feature in<\/strong><strong> ERD view:<\/strong><\/h2>\n<p><strong>2. 1 Create a table in the ERD view with Copilot<br \/>\n<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>You can create tables by describing them to <strong>Copilot<\/strong>. <strong>Copilot <\/strong>will generate one or multiple tables with relationships based on your instructions. Furthermore, you can manage column additions and removals by providing descriptions to <strong>Copilot<\/strong>. Below is the screen clip for reference,<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img decoding=\"async\" class=\"alignnone wp-image-38639 size-full\" style=\"border: 1px solid #000000; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-3.png\" alt=\"Visualizing Data Models with Copilot in an ERD View\" width=\"1000\" height=\"512\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-3.png 1000w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-3-300x154.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-3-768x393.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-3-660x338.png 660w\" sizes=\"(max-width: 1000px) 100vw, 1000px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>After creating the table, the <strong>ERD <\/strong>view will open, allowing users to see the tables, their columns, data, and relationships, as shown below,<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img decoding=\"async\" class=\"alignnone wp-image-38640 size-full\" style=\"border: 1px solid #000000; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-4.png\" alt=\"Visualizing Data Models with Copilot in an ERD View\" width=\"1000\" height=\"504\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-4.png 1000w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-4-300x151.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-4-768x387.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-4-660x333.png 660w\" sizes=\"(max-width: 1000px) 100vw, 1000px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>You can create relationships between tables in <strong>ERD <\/strong>by simply drag and drop.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img decoding=\"async\" class=\"alignnone wp-image-38641 size-full\" style=\"border: 1px solid #000000; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-5.png\" alt=\"Visualizing Data Models with Copilot in an ERD View\" width=\"1000\" height=\"474\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-5.png 1000w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-5-300x142.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-5-768x364.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-5-660x313.png 660w\" sizes=\"(max-width: 1000px) 100vw, 1000px\" \/><\/p>\n<p style=\"text-align: justify;\"><img decoding=\"async\" class=\"alignnone wp-image-38642 size-full\" style=\"border: 1px solid #000000; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-6.png\" alt=\"Visualizing Data Models with Copilot in an ERD View\" width=\"1409\" height=\"677\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-6.png 1409w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-6-300x144.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-6-1024x492.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-6-768x369.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-6-660x317.png 660w\" sizes=\"(max-width: 1409px) 100vw, 1409px\" \/><\/p>\n<h2 style=\"text-align: justify;\"><strong>Step 3: Edit table properties with the Data drawer<\/strong><\/h2>\n<ul style=\"text-align: justify;\">\n<li>Beyond the ERD view, the new data experience includes a <strong>Data drawer<\/strong> feature, which lets you simultaneously view the schema and a tabular representation of your data model.This dual-view setup allows for direct editing of table elements such as columns, rows, and table properties.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone wp-image-38643 size-full\" style=\"border: 1px solid #000000; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-7.png\" alt=\"Visualizing Data Models with Copilot in an ERD View\" width=\"1000\" height=\"498\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-7.png 1000w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-7-300x149.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-7-768x382.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/07\/Visualizing-Data-Models-with-Copilot-in-an-ERD-View-7-660x329.png 660w\" sizes=\"(max-width: 1000px) 100vw, 1000px\" \/><\/p>\n<h2 style=\"text-align: justify;\"><strong>Conclusion<\/strong>:<\/h2>\n<p style=\"text-align: justify;\">Integrating Copilot with the ERD view for data models revolutionizes database design and management for developers and data professionals alike. This integration automates table creation and manipulation, offers contextual assistance, and provides a seamless drag-and-drop interface, significantly boosting productivity and ensuring precision in data handling.<\/p>\n<h2><strong><div class=\"su-heading su-heading-style-default su-heading-align-center\" id=\"\" style=\"font-size:15px;margin-bottom:5px\"><div class=\"su-heading-inner\"> Experience the power of Dynamics 365 and Power Platform with Copilot! <\/div><\/div><\/strong><\/h2>\n<p>Stay ahead with the latest updates in Copilot, integrating <a href=\"https:\/\/bit.ly\/45q16LG\">Microsoft Copilot<\/a> into your developments. Connect with us at <a href=\"mailto:crm@inogic.com\">crm@inogic.com<\/a> for personalized AI-enabled solutions tailored to your business needs.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Exploring the capabilities of Copilot Studio within Microsoft Dynamics and Power Platform opens up new avenues for enhancing business application development. A critical aspect of this process involves constructing intricate data models that often include multiple tables. The introduction of the innovative &#8216;Create New Tables (Preview)&#8216; feature in Copilot Studio transforms this procedure by enabling\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.inogic.com\/blog\/2024\/07\/visualizing-data-models-with-copilot-in-an-erd-view\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[2746],"tags":[2905],"class_list":["post-38636","post","type-post","status-publish","format-standard","hentry","category-copilot","tag-data-models"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/38636","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=38636"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/38636\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=38636"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=38636"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=38636"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}