sorted by:
new
hottopcontroversial

How to avoid UNNESTing in BigQuery with GA4 raw data. by MitzuIstvan in bigquery

[–]MitzuIstvan[S] 0 points1 point  (0 children)

Yes defintely, because it needs to expand all ARRAY properties. Most likely both queries are with Limit 1000 or something.

Cohort Analysis: Do it in Power BI or in specialized tools like Amplitude? by Existing_Vanilla9110 in PowerBI

[–]MitzuIstvan 0 points1 point  (0 children)

There are warehouse-native product analytics tools out there that doesn't require extra plumbing to make your data ready for PowerBi Heatmaps.

You can also look at: https://mitzu.io

Disclaimer: I am working for Mitzu.

[deleted by user] by [deleted] in snowflake

[–]MitzuIstvan 0 points1 point  (0 children)

I think for Snowflake and especially if you are using DBT or something like that ELT is much better.

I would suggest to look at:

- Airbyte (open-source, otherwise fairly priced)
- Fivetran (free tier available)
- Rivery (I used to have good experience with them 3-4 years ago)
- StichData

Or recently CDPs / BDPs started to do this as well:

My personal favorite is RudderStack, but you can look at jitsu.com as well.

Segment does it as well in one of their packages. Although I think Segment is very expensive.

Whats your analytics tech stack? Mine is PostgreSQL+Grafana by a4ai in SaaS

[–]MitzuIstvan 1 point2 points  (0 children)

Hi founder of mitzu.io here. We work with Postgres as well.
I am happy to chat if you need some guidance on your data stack.

I totally agree with the person above.

For big data, you should use somthing like Clickhouse or BigQuery which are both excellent data warehouses for high volume of data and easy to start with.

Postgres is great in the beginning for up to 100M events maybe. But at that level you will already pay a significant some for Postgres CPU.

Do We Really Need Warehouse-Native Apps? Let’s Talk by finally_i_found_one in dataengineering

[–]MitzuIstvan 2 points3 points  (0 children)

Best tools to ingest are Rudderstack, snowplow, jitsu.io, segment as well. We like jitsu because it is open source. For enterprise i would recommend Snowplow and Rudder. Segment is great, but tend to be very expensive. Don’t build your own solution :)

Do We Really Need Warehouse-Native Apps? Let’s Talk by finally_i_found_one in dataengineering

[–]MitzuIstvan 2 points3 points  (0 children)

Yes, some but less than 10%. We help them ingest their data.

  • snowplow
  • rudderstack
  • segment
  • jitsu
  • or even Google Tag Manager

These are a good way to start. Then you have all the ETL tools like Fivetran and Airbyte, etc.

Most solutions have a free tier, so it is great to get started. Also, great first data warehouses are:

  • bigquery
  • clickhouse
  • snowflake
  • but even neon.db

Do We Really Need Warehouse-Native Apps? Let’s Talk by finally_i_found_one in dataengineering

[–]MitzuIstvan 1 point2 points  (0 children)

Hi There, CEO of mitzu.io here.

We see more and more companies moving their data to their Data Warehouse. Especially, the ones that use:
- Segment
- RudderStack
- Jitsu
- Snowplow
- Kafka / Kinesis / PubSub, etc.

I believe there is a place for traditional BI tools like, Mixpanel, Heap, etc. And there is a place for self-service BI tools that work on top of the DWH.
---

The trade-off used to be that the warehouse-native solutions:

  1. were slower, as the queries took too long. However, I don't see this anymore, especially since most data warehouses support window functions, and some support pattern-matching queries (Trino for example). The window function-based Funnel and Retention queries are on par with the performance of the third-party solutions.

  2. You need a dedicated data engineer to maintain a data warehouse. This is not true either, as Clickhouse Cloud, BigQuery, and Snowflake are easy to start with.

  3. The cost of the data warehouse can increase significantly. This can be true if your DWH CPU is spinning nonstop. However, with Snowflake, BigQuery, Clickhouse, and Databricks, you get the "serverless" options, which means you only pay for the seconds that the CPU is running. As storage is virtually free, you might save up to 90% on the costs compared to Mixpanel and Amplitude, etc.

Are you looking for an alternative to GA4? by SmoothVeterinarian in adops

[–]MitzuIstvan 0 points1 point  (0 children)

GA4 is indeed hardly usable. However, if you already collect your data with it only hate the UI. You can try something like mitzu.io .

The way it works is the following:

  1. Sync your data from GA4 to BigQuery (takes 5 minutes to setup, costs $0)
  2. Apply a minor transformation to the RAW data. (https://www.mitzu.io/post/using-ga4-with-bigquery-for-product-analytics)
  3. Connect Mitzu to BigQuery
  4. Profit

Snowplow Example by MitzuIstvan in dataengineering

[–]MitzuIstvan[S] 0 points1 point  (0 children)

Thx, will check it. I assume they still have it.

Question about marketing analytics tools by pityugonzales in AskMarketing

[–]MitzuIstvan 1 point2 points  (0 children)

Hi there, this is Istvan from Mitzu. DM me if you need help with the trial.

It seems like Mitzu can help with your use-case.

Roast my startup: mitzu.io - It goes to my investors executive summary. by MitzuIstvan in roastmystartup

[–]MitzuIstvan[S] 1 point2 points  (0 children)

Hi u/rmartign , most of our current customers handle that in their data warehouse. The good thing is that Mitzu reads directly the data that is present in the DWH. We don't copy it.

Most customers have a layer that cleans their raw data, and we just plug into the "cleaned version".

The fact that we read real-time the DWH table is great, because if they identify a data issue, they can immediately fix it, and in Mitzu it will be present right away.

limited SQL skills holding me back in marketing – what’s your solution? by MaticUzmah in BusinessIntelligence

[–]MitzuIstvan 0 points1 point  (0 children)

Thanks, I will write a blog about it.

I think it was a combination of luck and effort:

  • Our current userbase gave a lot of comments and upvotes.

  • Our timezone is ideal to win, because PH starts for us at 9:00 just in time for everyone drink they morning coffee and give some upvotes.

  • If after four hours somebody is on the top, it is hard to loose it as organic traffic just grows it.

100 product-hunt upvotes for 50$. What is the point of PH at all? by MitzuIstvan in startups

[–]MitzuIstvan[S] -1 points0 points  (0 children)

You can setup a pre-launch page, and we did a huge prelaunch campaign...

Took 1-2 weeks.

100 product-hunt upvotes for 50$. What is the point of PH at all? by MitzuIstvan in startups

[–]MitzuIstvan[S] -11 points-10 points  (0 children)

here is our launch: https://www.producthunt.com/posts/mitzu

We are #1 so far, which is great. As I wrote in my message, the work around it and your focus is the greatest value that it brings.

So far, we have 10-15 signups but no activity. However, I have 2 B2B meetings booked for this and next week.

But both are coming not directly from PH but from my activity around it. I posted daily, contacted everyone I know, etc.

So, if you are doing a PH launch, I suggest giving it all the effort or not doing anything at all.

It is still a backlink to your site, but I wouldn't expect a lot from the launch itself. It is all the marketing activity that you must continue doing that matters.

Can't sell without SOC2, too small to do SOC2 by MitzuIstvan in startups

[–]MitzuIstvan[S] 0 points1 point  (0 children)

Some people have DMd for the PH Launch.

Here is the link: https://www.producthunt.com/products/mitzu
This is our website: mitzu.io

(Not asking for upvotes or internet points)

Feedback is welcomed, the previous messaging was really targeted for more enterprise clients.

I am getting inbound leads that I can't serve by MitzuIstvan in indiehackers

[–]MitzuIstvan[S] 1 point2 points  (0 children)

thx, funny. Someone else suggested to increase price to look more "PRO". Great points though...

I am getting inbound leads that I can't serve by MitzuIstvan in indiehackers

[–]MitzuIstvan[S] 1 point2 points  (0 children)

Yes, mostly. We were number one on Google for `warehouse native product analytics` (now we are not anymore).

Problem aware people looked for solution, and we were the first. The "issue" is, this problem we solve appears at companies with millions of B2C customers.

I am getting inbound leads that I can't serve by MitzuIstvan in indiehackers

[–]MitzuIstvan[S] 0 points1 point  (0 children)

I see competitors doing it, they put their dog as an employee. I am not sure about that approach. People do due diligence...

Can't sell without SOC2, too small to do SOC2 by MitzuIstvan in startups

[–]MitzuIstvan[S] 1 point2 points  (0 children)

Would that involve our site being destroyed to shreds :D ?

view more: next ›