Product Analytics in SQL with dbt
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…
What it does
In the maker’s words, at launch
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
Does the same job
all alternatives →
More dev tools this month
the category →
Open-source GTM skills for technical founders
Dev tools · 29d ago · gtmcofounder.com
OpenTrailPaper is open-source bike computer firmware for the LilyGO T5S3 4.7" E-Paper PRO. It supports offline maps, GPX routes, FIT recording and Bluetooth sensors.
Dev tools · 1d ago · opentrailpaper.com
Launched alongside, June 2022
the whole month →- AF
I've seen some interests in (simulation) video games here on HN so I thought I'd share a short version of our story. More than 6 years ago, me and my friend from university were playing around with an idea of making a game we always wanted to play. We worked on it on weekends but the progress was quite slow, especially due to so many dead ends and wasted effort. Eventually however, we solidified our direction and decided to take the risk to resign from our well paid SWE jobs and work on it full time. It took more than a year but yesterday we have finally released it on Steam:…
Life & fun · 2022
- AC
Life & fun · 2022 · benoitessiambre.com
- IS
Life & fun · 2022 · github.com
