{"id":3345,"date":"2022-03-09T13:55:00","date_gmt":"2022-03-09T12:55:00","guid":{"rendered":"urn:uuid:b90f4d5d-c93f-400d-9df3-4a94640405c7"},"modified":"2026-02-03T13:57:12","modified_gmt":"2026-02-03T12:57:12","slug":"superset-bi-dashboard-plattform","status":"publish","type":"post","link":"https:\/\/www.datahouse.ch\/en\/blog\/superset-bi-dashboard-plattform\/","title":{"rendered":"Superset &#8211; The Open Source BI Dashboard Platform"},"content":{"rendered":"\n<div class=\"wp-block-group is-style-without-space is-layout-constrained wp-block-group-is-layout-constrained\">\n<div class=\"wp-block-columns alignfull is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:15.5%\"><\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.7%\">\n<p class=\"wp-block-paragraph\">Finally, there is an equivalent open source alternative to proprietary business intelligence solutions: Apache Superset. Create impressive dashboards with just a few clicks and share them with your team or the public.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-business-intelligence\">Business Intelligence<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">You want to monitor key business metrics or analyze your data and share insightful visualizations and dashboards with your team? To do that, you need a powerful business intelligence (BI) platform. Perhaps you&#8217;ve already been contacted by Microsoft&#8217;s sales team recommending PowerBI. Or you&#8217;ve discovered dashboard solutions from BI specialists like Tableau or Qlik. But do you fear high licensing costs as well as dependencies due to lock-ins (Tableau was acquired by Salesforce in 2019)? Then it&#8217;s time you get to know Superset.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-apache-superset\">Apache Superset<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/superset.apache.org\/\" target=\"_blank\" rel=\"noreferrer noopener\">Superset<\/a> is the leading open source alternative to proprietary BI solutions. Originally developed by Airbnb, Superset was subsequently released as an open source project and accepted into the Apache Incubator program. Meanwhile, Apache Superset has established itself as a powerful BI tool, securing $48.4 million USD for <a href=\"https:\/\/preset.io\/blog\/preset-raises-usd35-9m-series-b-to-democratize-business-intelligence\/\" target=\"_blank\" rel=\"noreferrer noopener\">further development<\/a> in 2021 under the name Preset. Superset is a pure web application and can therefore be used with all modern browsers.<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:15.5%\"><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns alignfull is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:6%\"><\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:88%\">\n<div class=\"image__wrapper alignfull withoutShadow\"><figure class=\"wp-block-image alignfull size-full size-large is-resized is-style-default withoutDescription withoutShadow\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"624\" src=\"https:\/\/www.datahouse.ch\/wp-content\/uploads\/superset_screenshot_main.webp\" alt=\"\" class=\"wp-image-3963\" srcset=\"https:\/\/www.datahouse.ch\/wp-content\/uploads\/superset_screenshot_main.webp 1024w, https:\/\/www.datahouse.ch\/wp-content\/uploads\/superset_screenshot_main-300x183.webp 300w, https:\/\/www.datahouse.ch\/wp-content\/uploads\/superset_screenshot_main-768x468.webp 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:6%\"><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns alignfull is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:15.5%\"><\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.7%\">\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-interactive-dashboards\">Interactive dashboards<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Impressive interactive and intuitive dashboards form the core of Superset. You design them with freely configurable dynamic and static elements. Choose from a variety of graphics, maps, tables or texts. Among them you will find familiar graphics such as time series, column or pie charts as well as complex display variants such as 3D maps, graphs, box plots, event flows, Sankey flow charts or sunburst charts.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-extensive-filtering-options\">Extensive filtering options<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">You can define extensive filtering options for the dashboards. With the filter manager, you configure the filter type, possible values and filter behavior for each available variable. Even complex hierarchical dependencies between variables are easily configurable. In addition, the scope of each filter can be specified in detail. This provides the dashboard visitor with intuitive and comprehensive options to customize the data display according to his preferences in order to identify any patterns in the data.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-advanced-analytics\">Advanced analytics<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Superset supports advanced analytics to perform calculations on charts within data series. Add rolling calculations such as moving averages or cumulative sums over specific time periods, or compare data series to themselves using various time offsets and comparison functions. For advanced users, direct use of SQL to manipulate data series is also possible.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:15.5%\"><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns alignfull is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:6%\"><\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:88%\">\n<div class=\"image__wrapper alignfull withoutShadow\"><figure class=\"wp-block-image alignfull size-full size-large is-resized is-style-default withoutDescription withoutShadow\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.datahouse.ch\/wp-content\/uploads\/superset_screenshot_analysis.webp\" alt=\"\" class=\"wp-image-3965\" srcset=\"https:\/\/www.datahouse.ch\/wp-content\/uploads\/superset_screenshot_analysis.webp 1024w, https:\/\/www.datahouse.ch\/wp-content\/uploads\/superset_screenshot_analysis-300x169.webp 300w, https:\/\/www.datahouse.ch\/wp-content\/uploads\/superset_screenshot_analysis-768x432.webp 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:6%\"><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns alignfull is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:15.5%\"><\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.7%\">\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-leverage-existing-data-infrastructure\">Leverage existing data infrastructure<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Superset was designed from the start for the largest data volumes and use in cloud environments. You don&#8217;t need to migrate your data, you can directly connect your existing data infrastructure. Superset can communicate with almost any SQL-based database technology. Of course, you can connect any number of data sources at the same time or directly import additional data as needed.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-share-and-publish\">Share and publish<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Dashboards including configured filter settings can be shared at any time. Via a dedicated URL, the selected view is directly accessible with any web browser. You can also create and share a direct link to a particularly important graph. Of course, as a team you can also work together on a dashboard.<br>When publishing a dashboard, you can customize its design in detail, e.g. to align it with your CD\/CI.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-detailed-permission-management\">Detailed permission management<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">You may want to publish your dashboards to the public or share them only within your company. Particularly sensitive data may even be restricted to just a few authorized users. Each of these scenarios can be easily implemented with Superset. Extensive user and role management ensures correct access and editing rights for all datasets, visualizations and dashboards.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-superset-by-datahouse\">Superset by Datahouse<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Superset is a comprehensive BI dashboard platform. Thanks to its open source strategy, there are no licensing costs and no lock-in risk for your data and analytics processes. Create impressive dashboards with a few clicks and share them within your company or publish them to the public.<br>We are happy to advise you on how to setup Superset or take care of this for you. Furthermore, we are happy to support you in the configuration of charts and dashboards or more generally in the optimization of your data processes. Contact us for an initial consultation.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:15.5%\"><\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-group is-layout-constrained wp-block-group-is-layout-constrained\">\n<div class=\"wp-block-columns alignfull is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\"><div class=\"grid__wrapper\">\n        <div data-component=\"PostGridBlock\" data-props=\"{&quot;query&quot;:{&quot;postType&quot;:&quot;post&quot;,&quot;itemsPerPage&quot;:&quot;3&quot;,&quot;orderBy&quot;:&quot;date&quot;,&quot;order&quot;:&quot;desc&quot;,&quot;postTypeRest&quot;:&quot;posts&quot;,&quot;taxQuery&quot;:{&quot;categories&quot;:&quot;117&quot;}},&quot;title&quot;:&quot;Similar articles&quot;,&quot;postsData&quot;:[813,812],&quot;align&quot;:&quot;none&quot;,&quot;displayType&quot;:&quot;grid&quot;,&quot;displayInfo&quot;:&quot;tags&quot;,&quot;gridColumns&quot;:3,&quot;selectPosts&quot;:false,&quot;navigation&quot;:{&quot;type&quot;:&quot;none&quot;}}\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Finally, there is an equivalent open source alternative to proprietary business intelligence solutions: Apache Superset. Create impressive dashboards with just a few clicks and share them with your team or the public. Business Intelligence You want to monitor key business metrics or analyze your data and share insightful visualizations and dashboards with your team? To &hellip; <a href=\"https:\/\/www.datahouse.ch\/en\/blog\/superset-bi-dashboard-plattform\/\">Continued<\/a><\/p>\n","protected":false},"author":13,"featured_media":3960,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[29,115,68,71,117],"tags":[],"class_list":["post-3345","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-science","category-data-science-en","category-diverse","category-software","category-software-en"],"acf":[],"image":{"url":"https:\/\/www.datahouse.ch\/wp-content\/uploads\/superset-preview-4.webp"},"_links":{"self":[{"href":"https:\/\/www.datahouse.ch\/en\/wp-json\/wp\/v2\/posts\/3345","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.datahouse.ch\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.datahouse.ch\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.datahouse.ch\/en\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.datahouse.ch\/en\/wp-json\/wp\/v2\/comments?post=3345"}],"version-history":[{"count":5,"href":"https:\/\/www.datahouse.ch\/en\/wp-json\/wp\/v2\/posts\/3345\/revisions"}],"predecessor-version":[{"id":9613,"href":"https:\/\/www.datahouse.ch\/en\/wp-json\/wp\/v2\/posts\/3345\/revisions\/9613"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.datahouse.ch\/en\/wp-json\/wp\/v2\/media\/3960"}],"wp:attachment":[{"href":"https:\/\/www.datahouse.ch\/en\/wp-json\/wp\/v2\/media?parent=3345"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.datahouse.ch\/en\/wp-json\/wp\/v2\/categories?post=3345"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.datahouse.ch\/en\/wp-json\/wp\/v2\/tags?post=3345"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}