Find alternative to Google Data Studio

[KrauseFx]

A few things that I don't like about it:

• Only 3 dimensions at pivot tables
• No way to customize the heatmap for pivot tables, in particular:
  • from and to color, they only support one color
  • No way to have the color be calculated based on the row/column, so what ends up happening is that I can't render boolean values with range values or number values
• Generally seems pretty limited actually
• Sometimes it just resets sorting
• No good way to fetch screenshots/reports via an API, so I can't get them via Telegram. Daily/Weekly email reports are good enough though I guess

[KrauseFx]

James sent me https://d3js.org/, this looks promising, worth exploring for sure

[KrauseFx]

Sofia told me about https://www.stata.com/, need to look into this

[KrauseFx]

If it works for Lufthansa, it might be good enough for FxLifeSheet https://www.tableau.com/

[KrauseFx]

This is very interesting, Google supports running d3 directly on their platform https://www.benlcollins.com/spreadsheets/d3-google-sheets/

[KrauseFx]

Ok, I actually realized, I don't want to write JS code just to render graphs, that won't be sustainable, I need something like Google Data Studio, but a more advanced version of it

[eercanayar]

Hi there,

I'm coming from the Google API OAuth twitter discussion. Maybe it's time to migrate the solution to a cloud architecture. Microsoft Power BI or Amazon Quicksight can easily overcome these visualization needs. If we go with AWS (which I'm certified so I can help a lot) a PostgreSQL server can be the the time series database, Quicksight can pull data from PostgreSQL.

I'm aware that this needs almost refactor everything, but it's not possible to use Google Sheets or a similar thing as a data source of these kind of advanced analytics tools.

Edit:
I did a bit more research, on the Supported Data Sources documentation page of Amazon Quicksight, there are file based options like;

File Data Sources

You can use files in Amazon S3 or on your local network as data sources for Amazon QuickSight. Amazon QuickSight supports files in the following formats:

CSV/TSV – Delimited text files
ELF/CLF – Extended and common log format files
JSON – Flat or semistructured data files
XLSX – Microsoft Excel files

Since Google Sheets can be exported as CSV, JSON or XLSX; it seems it's still an option. But there is the Google API Oauth implementation should be resolved.

[skywinder]

James sent me https://d3js.org/, this looks promising, worth exploring for sure

Just have in mind this request, and came to suggest d3 :)
I will test, how it works with the data, it looks that it fits for many cases out of the box!🚀

[giansegato]

Ciao Felix.

Have you considered Redash? It's open source, self hosted and pretty solid.

[KrauseFx]

@giansegato Thanks, used it at work, might be a good candidate 👍

[swissmanu]

could https://superset.apache.org/ be a candidate as well?

[swissmanu]

could https://superset.apache.org/ be a candidate as well?

here are some first results using a superset instance running in my k8s cluster:

(not much data present yet... but promising nonetheless :) )

[KrauseFx]

This will be implemented with #74

[KrauseFx]

This is complete with KrauseFx/krausefx.com#27