HN user

aceregen

22 karma
Posts5
Comments17
View on HN

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.

Here's a customer case study we've just published recently: https://www.holistics.io/customers/floship-ecommerce-fulfill...

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]!

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

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.

Hi Zed,

Just want to give kudos to you for the book. I agree with your approach of teaching the language - the portion on argv, args was clearer than the tutorials I have went through so far.

Keep up the good work!

I noticed the following characteristic about one friend who always sounded cheery.

When things go wrong (and there's often 1001 ways things go wrong, and 1 way where they go right) - We often slap ourselves and say "It could have been better if.."

However, I noticed my friend tend to think along these lines - "It could have been much worse, but that didn't happen. Somehow we got through it."

What doesn't kill you, make you stronger anyway.

If you want to start something, and nobody is interested in your idea or you can't find anyone good enough - Just start it alone.

If you have an idea, and you know a fellow co-founder that's interested in starting up - Just start it with him and work together.

Bottom line: Instead of thinking about the non-essential stuff- Just get the first prototype up even if it might mean doing it yourself.

Any school of thoughts that places restrictions on an ideal founding team size is crap. The debate that advocates an optimum team size is no different from saying that man cannot complete a mile in under 4 minutes.

Work with what you have, not what you don't have.