huy

6 ms·

1.
by huy 2y ago
Congrats on the launch! I think here's a few players in this space (dev-friendly BI tool) already: - Holistics.io - Lightdash - Hashboard These tools all allow analysts to use both/either a local/cloud IDE to write analytics
2.
by huy 4y ago
> While it looks really nice, hard to imagine it's quicker to hand draw this than reverse it out of your existing schema They have an option to take your SQL dump text and convert it back to DBML which is the DSL they use to render.
3.
by huy 5y ago
If you're new to the BI space, this book should give you a pretty good high-level overview: https://www.holistics.io/books/setup-analytics/
4.
by huy 6y ago
If you’re using Chartio and looking to migrate, here are a few alternatives you can consider. These are mostly cloud-based tool that is SQL-native and sends your written SQL queries to your SQL data-warehouse. 1/ Redash: write SQL gets
5.
What We Know and Don't Know About Analytics Engineering(holistics.io)
2 points by huy 6y ago|0 comments
6.
The rise of analytics engineers and what we know about it(holistics.io)
1 points by huy 6y ago|0 comments
7.
by huy 6y ago
There are so many such solutions, that It depends on your use cases. If you're looking for high-level dashboarding/monitoring that connects directly with your sources (REST, 3rd-party apps like Facebook, Adwords, etc), then tools
8.
by huy 6y ago
For those who're curious, the tool to build the database diagrams is dbdiagram.io
9.
by huy 6y ago
I counted 6. Fivetran, dbt, Preset (Superset/Airflow), Sisu, Imply and Databricks. Though, as someone who's in this space a while, I think they did a decently fair job at articulating the 'modern' data infrastructure lan
10.
by huy 6y ago
I think you have a point, but there are more nuiances than that. There are typically 2 types of data to collect: Transactional data and behavioural data. Most transactional data, due to their important nature, are already generated and capt
11.
by huy 6y ago
For those who're interested in learning more about the history and evolution of data infrastructure/BI - basically why and how it has come to this stage - check out this short guidebook [1] that my colleagues and I put together a
12.
by huy 6y ago
I know of three (all OSS) * https://www.posthog.com/ (more mixpanel alternative, can auto-track events too) * https://snowplowanalytics.com/ * https://rudderstack.com/ (explicitly say it&#x
13.
A Short Story About SQL’s Biggest Rival(holistics.io)
256 points by huy 6y ago|123 comments
14.
by huy 6y ago
There's also dbdiagram.io that focuses exclusively on database diagrams. Nice thing about it is you can just write simple DSL code and they render the diagrams automatically. The downside is that they don't support collaborative
15.
by huy 6y ago
You can check out Holistics.io - It allows you to bring MongoDB data into a SQL DW, and visualize them in a single tool. https://www.holistics.io/blog/build-reporting-analytics-mong... It has a free version you can pos
16.
by huy 6y ago
This might help: https://www.holistics.io/features/scheduled-email-reporting/ It can generate a PDF with some data and charts. You can also schedule emails to share these PDFs with customers. Adding a customer fil
17.
Why Data Modeling (Analytics) Is Important(holistics.io)
1 points by huy 6y ago|0 comments
18.
by huy 6y ago
You should check out Holistics.io if you're disappointed with all 3 options. A balance between drag-and-drop for business users and SQL for data analysts, this is done through a SQL-based data modeling layer. Disclaimer: I work at Holi
19.
by huy 6y ago
Hey folks, Have you ever tried building a simple analytics stack for your company, yet not sure what’s the best way to start with “just the right amount of effort” that can still scale it up later when you grow? And when you went googling y
20.
Show HN: Analytics Setup Guidebook- Explaining the Confusing Analytics Landscape(holistics.io)
10 points by huy 6y ago|1 comments
21.
by huy 6y ago
You’re right, and also right that we might be biased. We actually not trying to say that with the modeling layer the CEO can remove her reliance on the DA completely, that would be foolish. We think she can only reduce that reliance down wh
22.
by huy 6y ago
We used iPad, Apple Pencil and Paper app :)
23.
by huy 6y ago
Yes.. we did get a number of early feedback about this exact topic of data quality. But we eventually decided to cover it in another separate sidebar to the book. It’s also not a simple topic to cover. And the book is supposed to “give you
24.
by huy 6y ago
Thank you for sharing your thoughts! Yes the concept of data modeling and self-service analytics are interesting, yet few people fully grasp it. Chapter 3.1 is probably one of my most favorites.
25.
by huy 6y ago
This is exactly why we started out writing this book. We actually spoke with a lot of customers, and a fair share of them sharing the same thing: They found a lot of how-to on the web, but none of which is comprehensive, and goes deep into
26.
by huy 6y ago
I'm one of the authors of the book. Yes you're right. The book outline the transition from the "old world of BI" to the "new world of BI". If you read through the book, you'll see the biases clearly stated
27.
Show HN: Free tool to draw database diagrams using code (Database as Code)(dbdiagram.io)
4 points by huy 6y ago|0 comments
28.
Ask HN: Markdown Editor (WYSIWYG) that link directly to Git/GitHub?
1 points by huy 6y ago|0 comments
29.
How to Measure Software Development(holistics.io)
3 points by huy 7y ago|0 comments
30.
by huy 7y ago
OP here. This blog post follows the previous post "The Rise and Fall of OLAP Cube" which was shared on HN a few days back. We realized a lot of people mistook the 2 terms OLAP and OLAP Cube. So this post is aimed to clarify that.

More ›