Viewing profile — huy

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…

> 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 …

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/

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 querie…

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-pa…

For those who're curious, the tool to build the database diagrams is dbdiagram.io

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 articulat…

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, d…

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 guid…

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 …

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 d…

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-mon…

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…

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 SQ…

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 s…

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…

We used iPad, Apple Pencil and Paper app :)

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 s…

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 m…

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 …