Forum Discussion

Ashwinc91191's avatar
Ashwinc91191
New Member
5 months ago
Solved

visual query

what is the use of visual query in microsoft fabric. Can we have usecase?

  • AntoineW's avatar
    AntoineW
    5 months ago

    Hello Ashwinc91191,

     

    Thanks for your question, Visual Query in Microsoft Fabric is a no-code experience to query and analyze data within a Microsoft Fabric Warehouse, SQL analytics endpoint, or Mirrored Database. It uses a drag-and-drop interface (based on the Power Query diagram view) to perform data transformations without writing T-SQL.

     

    It could be used by business users, who are not familiar with Code experiences, here are some use cases : 

    Use Cases

    • Data Merging: Joining a sales table (FactSale) with a geography table (DimCity) using a common key to analyze revenue by region without writing JOIN statements.

    • No-Code Reporting: An analyst can transform data visually and then use the "Visualize results" button to immediately build a Power BI report.

    • Rapid Prototyping: Quickly filtering and aggregating large datasets to verify data quality before committing to a formal SQL view.

    • Cross-Departmental Analysis: Merging marketing data from one warehouse with sales data from another to find correlations between campaigns and conversions.

     

    Find more elements in this resource on microsoft learn : 

    https://learn.microsoft.com/en-us/fabric/data-warehouse/sql-query-editor

3 Replies

  • AntoineW's avatar
    AntoineW
    Super User
    5 months ago

    Hello Ashwinc91191,

     

    Thanks for your question, Visual Query in Microsoft Fabric is a no-code experience to query and analyze data within a Microsoft Fabric Warehouse, SQL analytics endpoint, or Mirrored Database. It uses a drag-and-drop interface (based on the Power Query diagram view) to perform data transformations without writing T-SQL.

     

    It could be used by business users, who are not familiar with Code experiences, here are some use cases : 

    Use Cases

    • Data Merging: Joining a sales table (FactSale) with a geography table (DimCity) using a common key to analyze revenue by region without writing JOIN statements.

    • No-Code Reporting: An analyst can transform data visually and then use the "Visualize results" button to immediately build a Power BI report.

    • Rapid Prototyping: Quickly filtering and aggregating large datasets to verify data quality before committing to a formal SQL view.

    • Cross-Departmental Analysis: Merging marketing data from one warehouse with sales data from another to find correlations between campaigns and conversions.

     

    Find more elements in this resource on microsoft learn : 

    https://learn.microsoft.com/en-us/fabric/data-warehouse/sql-query-editor

  • v-sgandrathi's avatar
    v-sgandrathi
    Community Support
    5 months ago

    Hi Ashwinc91191,

     

    Thank you AntoineW for your answer to the query.

    Hope you're doing well! Just following up to see if the response we shared was helpful. If you have any further questions or need clarification, we’re here to assist.

    Thanks for being a part of the Microsoft Fabric Community!

  • v-sgandrathi's avatar
    v-sgandrathi
    Community Support
    5 months ago

    Hi Ashwinc91191,

     

    I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.

     

    Thank you.