#089 How to create Graph Table in Azure SQL | SQL Server

We'll learn about the techniques

1. :Use a

   Thesaurus

   • dictionary to create a data model that relates synonyms and related terms, providing a more robust query structure.

2. Create Tables to Store Nodes and Edges:

   • Define tables in the database to store information about nodes (NODES) and edges (EDGE) that represent relationships.

3. Insert Records into the Node Table:

   • Add records to the node table (NODES) representing entities or concepts.

4. Insert Records into the Edge Table:

   • Add records to the edge table (EDGE) representing connections or relationships between the nodes.

5. Query table records:

   • Perform queries to visualize the data stored in the tables, obtaining information about nodes and edges.
Filter records by conditional nodes and edges
6. :
   • Use WHERE and MATCH clauses to filter records based on specific conditions, considering nodes and edges.

7. Get data from the database in

   Power BI:
   • Use Power BI to connect to the SQL Server database, choosing the connectivity mode (DIRECTQUERY) for direct interaction with the data.
Create

8. in-database view: Create

   • in-database views, such as views (VIEW), which can include operations such as CONCAT to combine data.

9. Get new

   Power BI visual
   • : In Power BI, get specific visualizations, such as the "Force-Directed Graph" visual, to represent the relationships between nodes and edges.

10. Format visual display of relationships between nodes:

    • Customize the formatting of the "Force-Directed Graph" visual in Power BI, adjusting elements such as links, arrows, colors, and labels to improve the presentation of relationships.