Posts

Forecasting with Facebook Prophet, an introduction.

Time series analysis and forecasting are useful in so many contexts, from economy to demographics, and in all the scenarios where you have a sequence of observations that are indexed over time. Examples include the number of Covid-19 cases per day (sadly we are all too familiar with this), the number of pizzas served in a day by...

Why I love dbt

I am an analyst and since the early days I’ve found quite frustrating having to wait days, weeks or even months for the data to be available – because the data warehouse developers were busy, and felt I couldn’t add value or contribute doing what I knew: analysing data.

And I still remember my first job as a BI developer...

Qualify

This is the second post about some Snowflake features, that I use often and find useful to write a better SQL. You can find the first of the series about aliasing here.

What is it?

Have you ever been in the situation where you want to keep all rows of your query but...

Aliasing

I’ll be starting a series of posts about some cool Snowflake (The cloud data platform) features, that makes SnowSQL really cool – compared to other SQL dialect (I am most familiar with Microsoft SQL Server or T-SQL).

I’ll start the series, talking about aliasing.

Sometimes our SQL get really complex: who haven’t seen a nested case...