{"id":8682,"date":"2020-07-06T06:16:00","date_gmt":"2020-07-06T06:16:00","guid":{"rendered":"https:\/\/ubiq.co\/tech-blog\/?p=8682"},"modified":"2025-08-18T04:43:01","modified_gmt":"2025-08-18T04:43:01","slug":"how-to-create-sql-dashboards","status":"publish","type":"post","link":"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/","title":{"rendered":"How to Create SQL Dashboards"},"content":{"rendered":"\n<p>SQL dashboards allow you to easily visualize data using SQL queries, plot charts &amp; graphs, and monitor them in interactive, web-based dashboards that you can share with others. Here&#8217;s how to create SQL dashboards and database reports for your business.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/#What_is_a_SQL_Dashboard\" >What is a SQL Dashboard<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/#How_to_Create_SQL_Dashboards\" >How to Create SQL Dashboards<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/#1_Determine_KPI_metrics\" >1. Determine KPI metrics<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/#2_Create_SQL_queries\" >2. Create SQL queries<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/#3_Choose_the_Right_Visualization\" >3. Choose the Right Visualization<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/#4_Design_SQL_Dashboard\" >4. Design SQL Dashboard<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_is_a_SQL_Dashboard\"><\/span>What is a SQL Dashboard<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>SQL dashboard is a visual presentation of data from SQL relational databases like MySQL, PostgreSQL, SQL Server and Oracle using SQL queries. Each KPI metric on an SQL dashboard is a result of an SQL query.<\/p>\n\n\n\n<p>These SQL queries are run in real-time on live databases, or on <a href=\"https:\/\/www.techtarget.com\/searchdatamanagement\/definition\/database-replication\">database replicas<\/a>. SQL dashboards automatically update their information based on latest query results. So you don&#8217;t need to manually update SQL dashboards. In fact, many SQL dashboards also support auto-refresh features.<\/p>\n\n\n\n<p>Most SQL dashboards are created using SQL dashboard software tools that allow you to create dashboard from SQL data. In fact, some of them even have drag &amp; drop query builder for users without SQL knowledge.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_to_Create_SQL_Dashboards\"><\/span>How to Create SQL Dashboards<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Creating SQL dashboards and database reports is easy. Here are the steps to create SQL dashboards &amp; reports.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_Determine_KPI_metrics\"><\/span>1. Determine KPI metrics<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The first step is to determine what KPI metrics you need to display in your SQL dashboard. Conduct 2-3 rounds of meetings with your team to determine the various performance metrics that you need to show on your dashboard.<\/p>\n\n\n\n<p>You may already be tracking many performance metrics, scattered across different systems and tools. Aggregate them.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_Create_SQL_queries\"><\/span>2. Create SQL queries<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Many times, your team is already running many SQL queries to generate different database reports in CSV, Excel, Workbench, and other tools.<\/p>\n\n\n\n<p>Gather all these SQL queries to come up with a list of SQL queries you need to run in your SQL dashboard software.<\/p>\n\n\n\n<p>If there are any new metrics, create SQL queries for them too.<\/p>\n\n\n\n<p>Typically, <a href=\"\/sql-reporting-tools\">SQL reporting tools<\/a> allow you to write or copy-paste SQL queries, run these queries with the click of a button, and render result using different visualizations such as <a href=\"\/create-graph-from-mysql-database\">graphs<\/a>, tables, line charts, pie charts, etc.<\/p>\n\n\n\n<p>You can save these SQL queries on a dashboard, and these queries run every time you run your SQL dashboard.<\/p>\n\n\n\n<p>Here&#8217;s an example of SQL report that you can create using <a href=\"https:\/\/ubiq.co\">Ubiq<\/a>. In the following example, we have pasted the an SQL query and click &#8216;<strong>Run Query<\/strong>&#8216;.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"730\" height=\"161\" src=\"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2020\/07\/create-chart-sql-example-1.png?resize=730%2C161&#038;ssl=1\" alt=\"\" class=\"wp-image-8685\" srcset=\"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2020\/07\/create-chart-sql-example-1.png?w=795&amp;ssl=1 795w, https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2020\/07\/create-chart-sql-example-1.png?resize=768%2C169&amp;ssl=1 768w\" sizes=\"auto, (max-width: 730px) 100vw, 730px\" \/><\/figure>\n<\/div>\n\n\n<p>Ubiq automatically returns the following result table.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"730\" height=\"121\" src=\"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2020\/07\/create-chart-sql-example-2.png?resize=730%2C121&#038;ssl=1\" alt=\"\" class=\"wp-image-8686\" srcset=\"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2020\/07\/create-chart-sql-example-2.png?w=1012&amp;ssl=1 1012w, https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2020\/07\/create-chart-sql-example-2.png?resize=768%2C127&amp;ssl=1 768w\" sizes=\"auto, (max-width: 730px) 100vw, 730px\" \/><\/figure>\n<\/div>\n\n\n<p>You can easily choose the visualization of your choice (line, pie, bar, area, column, etc) to visualize the SQL query result in different ways. Here&#8217;s an example the above table rendered as a line chart.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"730\" height=\"336\" src=\"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2020\/07\/create-chart-sql-example-3.png?resize=730%2C336&#038;ssl=1\" alt=\"\" class=\"wp-image-8687\" srcset=\"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2020\/07\/create-chart-sql-example-3.png?w=1019&amp;ssl=1 1019w, https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2020\/07\/create-chart-sql-example-3.png?resize=768%2C353&amp;ssl=1 768w\" sizes=\"auto, (max-width: 730px) 100vw, 730px\" \/><\/figure>\n<\/div>\n\n\n<p>Click <strong>Save<\/strong> to save the SQL query+graph onto your dashboard.<\/p>\n\n\n\n<p>In fact, Ubiq also provides a drag &amp; drop interface to help you build SQL queries, without any SQL knowledge.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"730\" height=\"365\" src=\"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2020\/07\/create_chart-768x384-1.png?resize=730%2C365&#038;ssl=1\" alt=\"\" class=\"wp-image-8688\"\/><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_Choose_the_Right_Visualization\"><\/span>3. Choose the Right Visualization<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>When you create SQL dashboards, it is important to choose the <a href=\"\/data-visualization-tools\">right visualization<\/a> for each KPI metric to make it easy for users to understand the data. Otherwise, it might confuse or even misguide users.<\/p>\n\n\n\n<p>For example, in which of the following visualizations, is the sales trend obvious?<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"730\" height=\"282\" src=\"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2020\/07\/choose-right-visualization-4-768x297-1.png?resize=730%2C282&#038;ssl=1\" alt=\"\" class=\"wp-image-8689\"\/><\/figure>\n<\/div>\n\n\n<p>The sales trend is easy to spot in the column chart on the right, while it is difficult to look at the pie slices and determine if your sales are growing or falling.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4_Design_SQL_Dashboard\"><\/span>4. Design SQL Dashboard<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Finally, you need to organize the KPI metrics on your SQL dashboard in an intuitive manner that allows users to easily draw insights and make better decisions.<\/p>\n\n\n\n<p>Organize your KPI metrics in a top-down manner into 3 layers. The most important &amp; urgent metrics can be placed on top, with trends, comparisons &amp; distributions in the middle, and granular table details at the bottom.<\/p>\n\n\n\n<p>Here&#8217;s an example of SQL dashboard created using <a href=\"https:\/\/ubiq.co\">Ubiq<\/a>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"730\" height=\"638\" src=\"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2020\/07\/sample-dashboard-2-768x671-1.png?resize=730%2C638&#038;ssl=1\" alt=\"\" class=\"wp-image-8690\"\/><\/figure>\n<\/div>\n\n\n<p>Optionally, when you create SQL dashboards, you can place related KPIs and graphs near each other. This will allow users to easily relate, compare and contrast information, and draw insights quickly.<\/p>\n\n\n\n<p>Hopefully, the above article will help you create SQL dashboards for your business.<\/p>\n\n\n\n<p><a href=\"http:\/\/ubiq.co\/\">Ubiq<\/a>&nbsp;makes it easy to visualize data in minutes, and monitor in real-time dashboards.&nbsp;<a href=\"http:\/\/ubiq.co\/accounts\/register\">Try it<\/a>&nbsp;Today!<\/p>\n\n\n\n<p>Also read:<br><a href=\"https:\/\/ubiq.co\/tech-blog\/top-5-call-center-dashboard-reporting-analytics-tips-for-you\/\">Top 5 Call Center Dashboard Reporting Tips<\/a><br><a href=\"https:\/\/ubiq.co\/tech-blog\/top-5-dashboard-features-for-business-dashboards\/\">Top 5 Dashboard Features for Business<\/a><br><a href=\"https:\/\/ubiq.co\/tech-blog\/how-to-choose-the-best-business-intelligence-software\/\">How to Choose Business Intelligence Software<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL dashboards allow you to visualize SQL query results in dashboards. Here&#8217;s how to create SQL dashboards for your business.<\/p>\n","protected":false},"author":1,"featured_media":8692,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[514],"tags":[538],"class_list":["post-8682","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dashboards","tag-sql-dashboard"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Create SQL Dashboards - Ubiq BI<\/title>\n<meta name=\"description\" content=\"SQL dashboards allow you to visualize SQL query results in dashboards. Here&#039;s how to create SQL dashboards for your business.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Create SQL Dashboards - Ubiq BI\" \/>\n<meta property=\"og:description\" content=\"SQL dashboards allow you to visualize SQL query results in dashboards. Here&#039;s how to create SQL dashboards for your business.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/\" \/>\n<meta property=\"og:site_name\" content=\"Ubiq BI\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ubiqbi\" \/>\n<meta property=\"article:published_time\" content=\"2020-07-06T06:16:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-18T04:43:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ubiq.co\/tech-blog\/wp-content\/uploads\/2020\/07\/create-sql-dashboards-730x410-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"730\" \/>\n\t<meta property=\"og:image:height\" content=\"410\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Sreeram Sreenivasan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@UbiqBI\" \/>\n<meta name=\"twitter:site\" content=\"@UbiqBI\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sreeram Sreenivasan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/\"},\"author\":{\"name\":\"Sreeram Sreenivasan\",\"@id\":\"https:\/\/ubiq.co\/tech-blog\/#\/schema\/person\/db98d49a766a3a111d8510935ab90abc\"},\"headline\":\"How to Create SQL Dashboards\",\"datePublished\":\"2020-07-06T06:16:00+00:00\",\"dateModified\":\"2025-08-18T04:43:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/\"},\"wordCount\":705,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2020\/07\/create-sql-dashboards-730x410-1.png?fit=730%2C410&ssl=1\",\"keywords\":[\"sql dashboard\"],\"articleSection\":[\"Dashboards\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/\",\"url\":\"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/\",\"name\":\"How to Create SQL Dashboards - Ubiq BI\",\"isPartOf\":{\"@id\":\"https:\/\/ubiq.co\/tech-blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2020\/07\/create-sql-dashboards-730x410-1.png?fit=730%2C410&ssl=1\",\"datePublished\":\"2020-07-06T06:16:00+00:00\",\"dateModified\":\"2025-08-18T04:43:01+00:00\",\"author\":{\"@id\":\"https:\/\/ubiq.co\/tech-blog\/#\/schema\/person\/db98d49a766a3a111d8510935ab90abc\"},\"description\":\"SQL dashboards allow you to visualize SQL query results in dashboards. Here's how to create SQL dashboards for your business.\",\"breadcrumb\":{\"@id\":\"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/#primaryimage\",\"url\":\"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2020\/07\/create-sql-dashboards-730x410-1.png?fit=730%2C410&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2020\/07\/create-sql-dashboards-730x410-1.png?fit=730%2C410&ssl=1\",\"width\":730,\"height\":410,\"caption\":\"create sql dashboards\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ubiq.co\/tech-blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Create SQL Dashboards\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ubiq.co\/tech-blog\/#website\",\"url\":\"https:\/\/ubiq.co\/tech-blog\/\",\"name\":\"Ubiq BI\",\"description\":\"Build dashboards &amp; reports in minutes\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ubiq.co\/tech-blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/ubiq.co\/tech-blog\/#\/schema\/person\/db98d49a766a3a111d8510935ab90abc\",\"name\":\"Sreeram Sreenivasan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g\",\"caption\":\"Sreeram Sreenivasan\"},\"description\":\"Sreeram Sreenivasan is the Founder of Ubiq. He has helped many Fortune 500 companies in the areas of BI &amp; software development.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/sreeram-sreenivasan\/\"],\"url\":\"https:\/\/ubiq.co\/tech-blog\/author\/wordpress\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Create SQL Dashboards - Ubiq BI","description":"SQL dashboards allow you to visualize SQL query results in dashboards. Here's how to create SQL dashboards for your business.","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:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/","og_locale":"en_US","og_type":"article","og_title":"How to Create SQL Dashboards - Ubiq BI","og_description":"SQL dashboards allow you to visualize SQL query results in dashboards. Here's how to create SQL dashboards for your business.","og_url":"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/","og_site_name":"Ubiq BI","article_publisher":"https:\/\/www.facebook.com\/ubiqbi","article_published_time":"2020-07-06T06:16:00+00:00","article_modified_time":"2025-08-18T04:43:01+00:00","og_image":[{"width":730,"height":410,"url":"https:\/\/ubiq.co\/tech-blog\/wp-content\/uploads\/2020\/07\/create-sql-dashboards-730x410-1.png","type":"image\/png"}],"author":"Sreeram Sreenivasan","twitter_card":"summary_large_image","twitter_creator":"@UbiqBI","twitter_site":"@UbiqBI","twitter_misc":{"Written by":"Sreeram Sreenivasan","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/#article","isPartOf":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/"},"author":{"name":"Sreeram Sreenivasan","@id":"https:\/\/ubiq.co\/tech-blog\/#\/schema\/person\/db98d49a766a3a111d8510935ab90abc"},"headline":"How to Create SQL Dashboards","datePublished":"2020-07-06T06:16:00+00:00","dateModified":"2025-08-18T04:43:01+00:00","mainEntityOfPage":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/"},"wordCount":705,"commentCount":0,"image":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2020\/07\/create-sql-dashboards-730x410-1.png?fit=730%2C410&ssl=1","keywords":["sql dashboard"],"articleSection":["Dashboards"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/","url":"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/","name":"How to Create SQL Dashboards - Ubiq BI","isPartOf":{"@id":"https:\/\/ubiq.co\/tech-blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/#primaryimage"},"image":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2020\/07\/create-sql-dashboards-730x410-1.png?fit=730%2C410&ssl=1","datePublished":"2020-07-06T06:16:00+00:00","dateModified":"2025-08-18T04:43:01+00:00","author":{"@id":"https:\/\/ubiq.co\/tech-blog\/#\/schema\/person\/db98d49a766a3a111d8510935ab90abc"},"description":"SQL dashboards allow you to visualize SQL query results in dashboards. Here's how to create SQL dashboards for your business.","breadcrumb":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/#primaryimage","url":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2020\/07\/create-sql-dashboards-730x410-1.png?fit=730%2C410&ssl=1","contentUrl":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2020\/07\/create-sql-dashboards-730x410-1.png?fit=730%2C410&ssl=1","width":730,"height":410,"caption":"create sql dashboards"},{"@type":"BreadcrumbList","@id":"https:\/\/ubiq.co\/tech-blog\/how-to-create-sql-dashboards\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ubiq.co\/tech-blog\/"},{"@type":"ListItem","position":2,"name":"How to Create SQL Dashboards"}]},{"@type":"WebSite","@id":"https:\/\/ubiq.co\/tech-blog\/#website","url":"https:\/\/ubiq.co\/tech-blog\/","name":"Ubiq BI","description":"Build dashboards &amp; reports in minutes","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ubiq.co\/tech-blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/ubiq.co\/tech-blog\/#\/schema\/person\/db98d49a766a3a111d8510935ab90abc","name":"Sreeram Sreenivasan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g","caption":"Sreeram Sreenivasan"},"description":"Sreeram Sreenivasan is the Founder of Ubiq. He has helped many Fortune 500 companies in the areas of BI &amp; software development.","sameAs":["https:\/\/www.linkedin.com\/in\/sreeram-sreenivasan\/"],"url":"https:\/\/ubiq.co\/tech-blog\/author\/wordpress\/"}]}},"jetpack_featured_media_url":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2020\/07\/create-sql-dashboards-730x410-1.png?fit=730%2C410&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/pbGGTT-2g2","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts\/8682","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/comments?post=8682"}],"version-history":[{"count":5,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts\/8682\/revisions"}],"predecessor-version":[{"id":9164,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts\/8682\/revisions\/9164"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/media\/8692"}],"wp:attachment":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/media?parent=8682"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/categories?post=8682"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/tags?post=8682"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}