Itsamejoshab (@itsamejoshabee) 's Twitter Profile
Itsamejoshab

@itsamejoshabee

ID: 1520124876312530946

calendar_today29-04-2022 19:36:40

19 Tweet

34 Takipçi

13 Takip Edilen

Rasgo (@rasgoai) 's Twitter Profile Photo

Don’t miss the Rasgo leadership team at the ❄️ #SnowflakeSummit❄️! We will be demonstrating our integration with Snowflake and DataRobot! Check out booth #1014D to see a demonstration of Rasgo! hubs.la/Q01dzlTJ0

Rasgo (@rasgoai) 's Twitter Profile Photo

🚫Stop writing SQL🚫… unless you want to! 📣⚡️Rasgo has officially launched its free SQL generator!📣⚡️ Select a transform and the column names of your table. Our SQL generator will automatically give you the SQL you need in copy/paste form. #data #sql hubs.la/Q01ffwx80

Itsamejoshab (@itsamejoshabee) 's Twitter Profile Photo

I'm one of those weirdos that thinks philosophically about SQL whenever I mow my grass. This time I wrote down my thoughts. #sql #dataanalysis lnkd.in/gm4upv9Z

SQL Daily (@sqldaily) 's Twitter Profile Photo

When working with time-series data, sometimes there are missing values Fill down the last known value with LAST_VALUE ( ... IGNORE NULLS ) OVER ( ORDER BY ... ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW ) Itsamejoshab explains medium.com/@jberry_33001/… #SQL

When working with time-series data, sometimes there are missing values

Fill down the last known value with

LAST_VALUE ( 
  ... IGNORE NULLS 
) OVER ( 
  ORDER BY ... 
  ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW 
)

<a href="/Itsamejoshabee/">Itsamejoshab</a> explains medium.com/@jberry_33001/…

#SQL
Itsamejoshab (@itsamejoshabee) 's Twitter Profile Photo

Does CLV and RFM feel repetitive? I wrote a SQL template to automate the data prep. #sql #clv #dataanalytics lnkd.in/efRtCg82

Itsamejoshab (@itsamejoshabee) 's Twitter Profile Photo

Last week - most popular SQL transforms This week - LEAST popular What they are, and how/why they are used #sql lnkd.in/e-BS9KS2

SQL Daily (@sqldaily) 's Twitter Profile Photo

Some tasks have non-obvious solutions in #SQL Itsamejoshab explains how to solve these 5 Date spines - generating missing values Pivot / unpivot One-hot encoding to map values Market basket analysis Time-series aggregations kdnuggets.com/2022/07/5-hard…

Rasgo (@rasgoai) 's Twitter Profile Photo

Trying to upskill your #sql skills this Friday afternoon? Itsamejoshab has put together a list of free learning resources perfect for anyone trying to enhance their SQL Knowledge. Check out the article now on KDnuggets! #DataAnalytics kdnuggets.com/2022/10/get-ru…

Itsamejoshab (@itsamejoshabee) 's Twitter Profile Photo

My latest hot take, accusing Data Quality of being boring, was too spicy for my normal medium publications! #data #analytics lnkd.in/ewSF5kwB