SUPERSET - | Shalini Chauhan

Post

Pros

Open source.

Large number of pre built visualizations.

Leverage Apache Superset to embed the dashboards into your data applications.

Amazing community (I was able to get super fast support on a weekend).

Simple web server architecture.

Granular user access control.

Rest API based on OpenAPI specification.

Cons

Cannot do joins in charts and exploration sections. The dataset has to be pre joined or be a view.

Users will need to know SQL. Engineers can help with creation of views, etc. But to be a fully self serve BI tool, end users will need to know SQL.

Without a good dev ops and data team, management can be difficult. Unless you get the managed version from preset .

Conclusion

Hope this article gives you a good understanding of what Apache Superset is, its pros and cons and how you can leverage it to create visualizations and dashboards. There are more features like scheduling alert and building custom visualizations.

There are a lot of expensive vendor provided BI tools in the wild. I believe, if your company has the right engineering resources, using a open source tool has the potential to save a lot of money.