shillelagh VS seaborn

It should be possible (have not tried myself):

https://preset.io/blog/accessing-apis-with-superset/

"Shillelagh (ʃɪˈleɪlɪ) is a Python library and CLI that allows you to query many resources (APIs, files, in memory objects) using SQL. It's both user and developer friendly, making it trivial to access resources and easy to add support for new ones"

https://github.com/betodealmeida/shillelagh

Shillelagh (https://github.com/betodealmeida/shillelagh) is a wrapper that allows users to query APIs using SQL. You can join weather data with a Google spreadsheet, for example. It always need more help in adding adapters for new data sources.

You can read more about it in the architecture document.

I'm adding this to Apache Superset today!

- Shillelagh (https://github.com/betodealmeida/shillelagh): query API's .. using SQL!

If you are doing data analysis I don't think any of the 3 pieces of software you mentioned are going to be that helpful.

I see these products as tools for data visualization and reporting i.e. presenting prepared datasets to users in a visually appealing way. They aren't as well suited for serious analytics.

I can't comment on Superset or Tableau but I am familiar with Power BI (it has been rolled out across my org), the type of statistics you can do with it are fairly rudimentary. If you need to do any thing beyond summarizing (counts, averages, min, max etc). It is not particularly easy.

For data analysis I use SAS or R. This software allows you do things like multivariate regression, timeseries forecasting, PCA, Cluster analysis etc. There is also plotting capability.

Both these products are kind of old school, I've been using them since early 2000's, the "new school" seems to be Python. Pretty much all the recent data science people in my organization use Python. Particularly Pandas and libraries like Seaborn (https://seaborn.pydata.org/).

The "power" users of Power BI in my organization tend to be finance/HR people for use cases like drill down into cost figures or Interactively presenting KPI's and other headline figures to management things like that.

It's referring to the seaborn library (https://seaborn.pydata.org/), a Python library for data visualization (built on top of matplotlib).

While it’s not perfect and it’s not ggplot2, Seaborn is definitely a big improvement over bare matplotlib. You can still use matplotlib to modify the plots it spits out if you want to but the defaults are pretty good most of the time.

https://seaborn.pydata.org/

Seaborn: A statistical data visualization library based on Matplotlib, enhancing the aesthetics and visual appeal of statistical graphics.

Matplotlib Seaborn Example data sets

Seaborn - Statistical data visualization using Matplotlib.

Github: https://github.com/mwaskom/seaborn

Seaborn Documentation

You've done a great job presenting this. Maybe you already know, but seaborne is an extension of matplotlib that makes it pretty easy to "beautify" matplotlib charts