Hi! You may like to check out what our team has built at www.holistics.io. The pricing metrics of our embedded dashboards cater for you to scale to unlimited viewers, and you don't need to recreate a duplicate copy of your user accounts into our system for it to work. Check out the video below to find out more!
I don't understand why this gets downvoted. While it may lack context (with the aim of being controversial), it sparked a healthy amount discussion here!
I'm not the OP but having dealt with QuickSight it really feels super flaky and difficult to create graphs with. I can't remember the exact problems my co-worker had problems with it, but if I recall correctly one of the problems was that QuickSight expected all JSON data keys in S3 to be in the exact same order in every file thus making changing the schema a very huge pain in the butt. Also the UI itself is not good and creating eg running monthly average was very non-intuitive. A lot of small stuff that makes you not wanting to deal with it if possible. But it's cheap and has good AWS integration so I guess it has its purposes.
Hello Tensor! Will you like to review what our team has built at Holistics (www.holistics.io)? We are listed in the Gartner FrontRunner Quadrant for Business Intelligence Oct 2018.
Love to get your feedback on how you find us relative to the tools you are currently evaluating! Send me a note at v(@@)holistics.io or our team at hello(@@)holistics.io]!
Yes, like what scapecast mentioned, the key to writing and executing SQL well is to organize and transform your data. You won't want to be running queries across large events records.
We've just published a blog post last week on some tips for analysts starting their first data warehouse project.
Hello, you may like to try out what we've been working on at Holistics (www.holistics.io)! We make it easy for you to retrieve and share your SQL data.
We help in 2 use-cases to address the "duplicative" overhead of writing the same SQL query.
1. Where you just need to adjust specific parameters/values in your query
With Holistics, You can insert custom variables in your SQL query to make them dynamic to address the subtle differences without repeating yourself. See an example here: https://docs.holistics.io/guides/adding-filters/
2. Where you have chunks of text that are reused across multiple questions
This can be long chunks of `CASE-IFs` or CTE/sub-queries that you use across multiple reports. You can insert a template snippet (chunks of SQL syntax for example) that can be reused across multiple questions. You can find more information here: https://docs.holistics.io/query-templates/
Thanks for the response, I'm more on the research side of things now, so I don't have a current use case, but thinking about moving back to industry, and it's something that I remember having trouble with when I was last in industry.
I spent an hour on the phone with them yesterday, there are no viewer accounts. Basically I have Server, but it needs a named license to view. Named licenses are 1k down, $200 per year. To get a viewer account or to embed the content elsewhere for viewing I need a different kind of Tableau Server (core-based), of which there is no mention on the sales or pricing pages, but it starts at 72k/yr (non-profit pricing).
My completely misguided understanding was that I would pay for Desktop for the analysts, and Server was where folks could view the stuff. I was wrong. So everyone is now double-licensed, Desktop to do their work, Server to publish their work, and no-one but the very same analysts can actually look at the dashboards unless I add $1k licenses for everyone who needs to see data.
I feel your pain. We're running into that issue and it just absolutely blows my mind why they have this pricing model in place especially when all people care about is data - be it on Tableau Server or through email.
Hello! Redash is great if you are looking to host it in-house and have the engineering resources to set-up and maintain it.
If you are looking for an affordable SaaS alternative, you may want to look into Holistics (www.holistics.io). (Note I'm the other co-founder here with huy)
Besides supporting native SQL, Holistics is designed to address the gaps of SQL for common business reporting use-cases (flexible way of passing user inputs as parameters into report query; supporting if-else capabilities in SQL, reusable query templates and records/columns based access control for users/user groups).
This makes it easier to manage and reduce the management of duplicate SQL query syntax across multiple reports/dashboards (especially multiple UNIONS/Case-Ifs statements). We also have our own DSL for you to configure in more details how certain charts should look like (beyond the normal coloring).
A common problem we also see is that most data-related work is not just visualization, mainly for the reason that most data are not structured/formatted in the right table structure as most companies start off without a data warehouse.
While most query tools requires customers to work with a separate ETL/warehousing tool, we’ve built an integrated approach towards data reporting and data preparation. Insights from our data reporting module (reports with expensive joins, long query times, non-optimal table structures) provides your data analyst inputs to easily move, map records, and transform data without technical engineering knowledge. Data in Google Sheets or CSVs with their data sync automatically (incrementally or full) to their database.
And all this is done with the data not leaving our customers’ database (we don’t warehouse their data. Our data reporting module works directly with your database, and our data preparation module provides just the utilities (not infrastructure) to automate your data pipeline process.
Do take some time to check us out! Quote HN and we give you an additional one day of free trial! :P
> Hello! Redash is great if you are looking to host it in-house and have the engineering resources to set-up and maintain it.
If you are looking for an affordable SaaS alternative...
Well, actually there is a hosted SaaS version of Redash too (https://redash.io). This is what sponsors the work on Redash.
Hi @jsmeaton, this is Vincent from Holistics (www.holistics.io).
While our website also has a "request a demo" button in our landing page - It's because we have just launched and are looking to validate some of the use-cases that we have built. Will really appreciate if you can contact us and share with us your thoughts.
Will you mind dropping us a note on our website for us to contact you? It will be interesting to get your feedback, and I suspect what we have built (or are building) may meet some of the things you've listed above, though I still need your validation.
A brief introduction about us. We started off as an internal data dashboard for an online video streaming company, serving a specific reporting niche (not a full fledged BI tool) with use-cases different from BI vendors such as Quicksight or the other vendors.
https://www.holistics.io/guides/embed-analytics/