HN Explorer

Show HN: Product Analytics in SQL with dbt (github.com)

8 points by mjirv ↗ HN
Hey everyone!

Like many data analysts and engineers, I love SQL and the dbt ecosystem. So it bothers me that we have to use separate tools for product analytics. We do our transformations, BI work, and ad-hoc queries in SQL, but when it's time to look at funnels and flows, we have to use (and procure) a separate platform like Mixpanel or Amplitude.

This dbt package is a (very rough) start at fixing that. With it, you can create event streams and run funnel analyses via dbt[0]. More features like flows and retention are coming soon!

But I'm mostly curious how you all are doing product analytics right now. Are you using a dedicated tool like Amplitude? What could be better? Do you want to do product analytics in SQL in the warehouse or would you rather it live somewhere else?

Would love to get your thoughts, and thanks for taking a look!

---

0. (and soon, with dbt Server, in your favorite BI tool or SQL client): https://www.youtube.com/watch?v=MdSMSbQxnO0&ab_channel=dbt

2 comments

[ 3.2 ms ] story [ 18.5 ms ] thread
ljy6560
This looks amazing. We generally perform funnel analysis in our product analytics tool but I've been looking for a straightforward way to run it on Snowflake and surface the results in our BI tool. Will definitely test it out next week.
mjirv
Awesome! Feel free to reach out if you have any suggestions or questions that come up as you test.

(My email is on the website in my bio, or ping me on the dbt slack if you’re there).