I have a RedShift data warehouse filled with dozens of different tables. For some processes, a few joins might be needed for pre-processing.
Lately, I've been messaged by several data visualization platforms looking to streamline reporting.
What platforms have you used for your non-technical coworkers? What's the associated price tag per user-type? How much training did it require for you and your team?
My first thought here is Google Data Studio—but it doesn’t natively integrate with Redshift, so that may be a bit more trouble on your setup end than other tools. The good thing with Google Data Studio is that it’s incredibly easy for anyone with any G Suite experience to use. Basically, if you know how to use a spreadsheet and create charts from it in a presentation, you can use Data Studio.
Other great options from Capiche discussions about tracking data in dashboards, KPI tracking, and data visualization include Grow, Graphy, Databox, Metabase, Looker, Amplitude, Chart.io, and more were all recommended. Of those, Grow and Chartio both seem to be fairly accessible to non-technical users and have built-in Redshift integrations, so they might be good to check.
In the company I was previously working, business people were using SQL server management studio with queries saved in .sql files to create a report.
I was in shock when I saw one of them connect to the production DB and opened up a query window.
I don't have a solution for you yet but what you're describing is what we're working on at Graphy – https://www.graphyapp.com. So far we've been focused on direct integrations with tools but we're starting to explore how to bring database connections into the product and make it easy for non-technical users to get the most from the data, with the least amount of SQL possible.
If you're up for it, I'd love to talk to you more about your use case in specific to better understand it. :)
At a previous employer we had a similar setup, from what I recall they also used Redshift. The only thing I can't tell you were the costs, because I don't know these costs :).
Now the tool that was used internally, for people like me that are non-technical-ish, was Saiku (https://www.meteorite.bi/products/saiku/). A super 2000s looking interface, but that was powerful, fast and always got the job done. Basically all of our dimensions and metrics where in there, allowing us to combine different data cubes to extract the data we were looking for. Every new hire got a training of a few days and had to do an exam before they were given access. Not necessarily because they could break stuff, but merely to tackle the simple questions upfront.
For our more technical employees we had Mode Analytics, where they could write their own SQL queries and obviously do more with the different cubes.
But these two really helped our teammates to get the answers they were looking for without disturbing our BI team too much.
Hope this helps!
Are you looking to give the users the ability to do the joins? Or just a finished view on top of the processed data so they can visualize / access?
If the latter, Hex (hex.tech) might be a good fit. Happy to hook you up with early access (email me at barry@).
You are able to do this with Phiona- users can access the underlying Redshift data and join and/or manipulate the data tables without SQL or Python in our platform. Feel free to reach out at firstname.lastname@example.org and I'd be happy to give you a demo!
We do team-based pricing, so for Redshift access and reasonable data sizes / refresh frequencies, it should be pretty cost efficient compared to some of the larger BI platforms.
I've got a funny use-case for a client I'm volunteering on. They're dealing with some legacy folks who work in Excel. Every week they send out an email to a series of people with an Excel sheet at...
"The future's here, just not evenly distributed" quipped author William Gibson—and nowhere is that more true than in software. Features show up in one app, and then end up becoming a new requiremen...
Several months back, Amazon AWS launched Amazon Honeyccode as a low-code app builder, something slightly akin to Airtable. Then Microsoft launched Microsoft Lists as a way to "track information an...