You're welcome to your opinion.
> 1/ How easy is it to get data in? Seems standard.
It supports a MySQL adapter and a PostgreSQL adapter and then a bunch of Google property adapaters. This is standard.
> 2/ Is my data safe? Doesn't use SSL, major red flag.
The PostgreSQL adapter doesnt use SSL (https://support.google.com/datastudio/answer/7288010?hl=en&r...). This is a showstopper.
> 3/ How easy is authoring? [EDIT] seems decent, see demo in reply.
You can see Felipe's demo here and make your own assessment. https://medium.com/google-cloud/showing-off-the-new-free-goo...
> 4/ Does it support pivots? Can't tell from the website or examples, red flag.
If you find an example I'd love to see it. My expectation at a bare minimum is a table view with a dimension down the left, a dimension across the top, and a measure in the cells. I looked through all the examples and did not see a clear example of a pivot.
> 5/ Can I model joins? [EDIT] it cant, see reply
It can't. https://news.ycombinator.com/item?id=15446616
> 6/ Does it support dashboard-wide filters? Many examples of this in the gallery
Most of the examples in the gallery use this feature.
> 7/ Does it support complex time comparisons? No examples, red flag.
Here's a couple very basic examples of what I'm talking about.
- Plug an TY date range into the dashboard filter. Get a view that shows you TY performance in that range vs LY
- Filter the dashboard using calendar dates, display using fiscal dates.
The rest is written from my personal experiences. If your experiences are different, I'm open to hearing about it. Feel free to email me if you'd prefer.
