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!
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/
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
https://www.holistics.io/guides/embed-analytics/