Viewing profile — bayan1234

For this reason, I use gpt4 mostly just to start off new functions and then I edit them myself. It would be awesome if gpt4 could be made to edit the code and therefore, it didn’t …

Yes exactly. My company has asked AWS if they will be adding support for pgvector for rds but they haven't been able to confirm if that will happen any time soon. If the vectors ar…

The hack to solve this is to embed each paragraph in your large corpus. Find paragraphs most similar to the user query using embeddings. Put the paragraphs and the raw user query i…

I would subscribe but your website doesn't have a clear demo video of a child using the product to read. It looks very interesting and useful though!

Fivetran, Stitch, Meltano and Airbyte are tools used to extract data from tools such as these into databases. Census and Hightouch can be used to sync data into these tools from da…

Forecast package in R is quite useful. Even if you don’t use R, this book by Rob Hyndman is very approachable and easy to follow. https://otexts.com/fpp2/

Create features for day of week, day of year, month of year, lagged values of y, lagged values of y for each period (eg: 1, 2, 3 weeks and years ago etc). You then predict forward …

I think the author isn't talking about changing the product, but the market positioning and how it's communicated to customers.

This looks really cool! I really like the free form chart builder. I work at Simply Wall St and we also make financial data easy to use and understand. We’ve realised that a bigger…

I was initially excited about this as I think it might solve our Redshift pain points and potentially avoid us having to deal with a migration to Snowflake but then I remembered wh…

If you have a very stable SQL pipeline that runs frequently during the day then it's probably cheaper to have it on a normal Redshift cluster.

Having used Redshift considerably in the past and experienced significant pain with many aspects of it, I would stay away. There are other much better options, ideally Snowflake.

I read somewhere (a YC video or post I can't find now) that during a pivot, the problem you're working on shouldn't really change, but the solution might change completely. I inter…

I think one of the less discussed advantages of SQL and reasons why it might be so prevalent in the analytics world is that users don't really need to spend much time to set up the…

This is exactly my experience. I've found becoming proficient with Pandas to take much more time than other data manipulation libraries like dplyr or Pyspark dataframes. The Pandas…

Hi, I’m Bayan, author of the post. I would love to hear if you agree/disagree with the definition of a unicorn product analyst or you’ve met anyone who fits the mould. Keen to hear…