Michaël Ménaché – Medium

Michaël Ménaché

Pinned

Michaël Ménaché

An introduction to Dynamic SQL in BigQuery

Stored Procedures in BigQuery (and in SQL in general) are a useful tool… but lack flexibility compared to what exists in other languages…

Jan 26, 2022

An introduction to Dynamic SQL in BigQuery

Jan 26, 2022

Michaël Ménaché

An introduction to flexible stored procedures in Snowflake (using Javascript)— Part 1

Tired of writing the same bits of code all over again? This step-by-step guide on how to make flexible Stored Procedures in Snowflake is…

Feb 6

An introduction to flexible stored procedures in Snowflake (using Javascript)— Part 1

Feb 6

Michaël Ménaché

The complete guide to creating columns based on multiple conditions in a Pandas DataFrame

Want to know the best way to to replicate SQL’s Case When… logic (or SAS’s If… then… else…) to create a new column based on conditions in a…

Jul 16, 2022

The complete guide to creating columns based on multiple conditions in a Pandas DataFrame

Jul 16, 2022

Michaël Ménaché

An introduction to git for personal projects — How I built my own DIY Covid dashboard for free

A little story and guide on how to use Git and Python to build a simple DIY dashboard for those who never used Git before

Jun 19, 2022

An introduction to git for personal projects — How I built my own DIY Covid dashboard for free

Jun 19, 2022

Michaël Ménaché

An introduction to Dynamic SQL in BigQuery — Part 2: flow control and loops

In Part 1, we saw the basic syntax for Dynamic SQL, now let’s focus on flow control and loops: a useful set of tools to make your Stored…

Feb 19, 2022

An introduction to Dynamic SQL in BigQuery — Part 2: flow control and loops

Feb 19, 2022

Michaël Ménaché

Michaël Ménaché

Lead Analyst at Quantium. Originally from Paris, now in Sydney, with 15 years of experience in retail and a passion for data. Oh, and I’m legally blind!

Following

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams