This is my first time posting to this group!!! I've been interested for a while and met a number of you at NTC19 in Portland. Excited to hear from everyone's experience.I'm looking to move our reporting/metrics into a more powerful, automated data analysis tool. I'm looking at Tableau & Google Data Studio right now, mostly because they're inexpensive, accessible, and relatively straightforward. I found this and this old thread, but had some follow up questions. If anyone has experience in this, I'd love to hear from you!1) Are there any privacy concerns with using Data Studio for data analysis? I'm thinking of plugging it directly into our SQL databases where we keep contact information, volunteer history, engagement activity, potentially donation records, etc.2) Does Data Studio save data in the cloud? Or does it pull in data via queries every time a report is accessed?3) Does using Data Studio give Google ownership of any our data?I'm reading through Data Studio's licensing & agreements, etc, but it's very jargon-y. If anyone has gone through this at their organization, let me know!
Hi Joe,We develop custom realtime data dashboards for many of our clients in Power BI, Tableau, and Data Studio. Most of our clients use Data Studio.You mention connecting directly to your SQL databases. Do note that the MySQL connector currently doesn't support JOINS! You can do a custom query on the whole database in your connector configuration, e.g. http://www.datacisions.com/data-studio-hack-connecting-to-the-wordpress-mysql-database/Sharing is really easy in Data Studio. Maybe too easy. Like any other google doc, the world can be granted access. Consider putting restrictions on who can share reports. You can prevent gSuite organization users from sharing outside their domain as a whole, but that is often impractical if you work with other orgs, or members of your board don't have org emails.Data is cached, but you can manipulate that:https://support.google.com/datastudio/answer/7020039?hl=enAccess to a report doesn't grant users access to the data source.Good luck in your quest. Happy to help more if you need us.