Categories

Let’s practice with this month #SWDchallenge.

#SWDchallenge and where to find them

One of my favourite author about data visualisation, Cole N. Knaflic, published a new book Storytelling with data: Let’s Practice!

I am keen of getting my own copy, but while waiting I decided to take part in this month challenge. If you’re interested...

A 3D exploding pie chart: not a good idea.

A panel in a history of printing museum

Last week I was visiting this museum about the history of invention and development of printing in Bassano Del Grappa, a small little village in the North of Italy. The museum was really well presented and it reminded me how the...

Edward Tufte and the principle of Graphical Integrity

My favourite meet up in London

Often you learn more talking with people and sharing your experience than studying on your own. In London, there are plenty of opportunities for networking and knowledge sharing and my favourite place is definitely Tiny Tableau Talks, a selection of 5 minutes talks about data visualisation and storytelling. I love it so...

How to tell a story with data

The inspiration

It all started with a workshop on how to create an effective chart by Cole Nussbaumer Knaflic at the Tableau User Group London. It was so inspiring and captivating, she managed to engage the public asking for their own recommendations and ideas. I thought to do the same in my company, as we have a...

JOIN 2019, London

What is Join

Join – Tour is a conference for Looker users touring around the World and I took part in the London session on the 9th of April at The Brewery. Looker is a self -service...

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...

Snowflake vs Redshift: some syntax differences.

Moving code from Redshift to Snowflake

As I said here, my company is in the process of moving from Redshift to Snowflake. There are loads of reasons for doing it: to mention a few, better handling of permissions, less maintenance and less effort to optimise query performance.

A...

Querying a Snowflake Database

My company is in the process of moving from an Amazon Redshift to a Snowflake database, and without going into the consideration of pros and cons of each, let’s see how to query data from Snowflake.

Using the...

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...

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...