Hi, is there any tools for visualising query execution

I would recommend to use SSRS or Power BI Desktop.

I have wrote several articles in SSR, Power BI and Data Sources. Please check.

https://www.c-sharpcorner.com/article/power-bi-report-dashboard-design-options-with-an-example-of-pie-and-column-char/

https://www.c-sharpcorner.com/article/learn-about-power-bi-data-source-options-and-sql-database-connection-part-one/

https://www.c-sharpcorner.com/article/ssrs-rdl-report-design-using-microsoft-report-builder/

If you want to visualize and build reports then use Power BI Desktop.

It is quite simple to use and can connect to any data sources.

https://powerbi.microsoft.com/en-us/desktop/

DBAs use sql profiler for monitoring or optimising the cost.

Check this article for query execution visulization tools

https://solutioncenter.apexsql.com/visual-tools-for-monitoring-sql-server-query-performance/