It might seem a small thing, but I noticed that a recent update of the Snowflake database now allows you to have a trailing comma at the end of the SQL's SELECT statement. For example, this now works: SELECT my_field, my_field_2, FROM my_table Whereas before that'd give an error. It's arguably bad form nonetheless, but … Continue reading The great SQL leading vs trailing commas debate
Category: Uncategorized
Books I read in 2016
Reading is one of the favoured hobbies in the DabblingWithData household. In 2016 my beloved fiance invited me to participate in the Goodreads Reading Challenge. It's simple enough - you set a target and then see if you can read that many books. The challenge does have its detractors; you can see that an obsession with it will perversely incentivise reading … Continue reading Books I read in 2016
5 Power BI features that might make Tableau users a little jealous
New year, new blog post, new tool version to play with! It's clear that the field of data-related stuff progresses extremely rapidly at present, and hence it behoves those of us of an analyst bent to, now and then, go explore tools that we don't use day-to-day. We may already have our favourites in each … Continue reading 5 Power BI features that might make Tableau users a little jealous
Free interactive data and analysis tools from Public Health England
Public Health England is an agency sponsored by the UK Department of Health whose aim is to "protect and improve the nation's health and wellbeing, and reduce health inequalities". They use, generate or distribute a bunch of interesting health-related data. They've a collection of many, many "data and analysis tools", linked to from this page. There's something for everyone … Continue reading Free interactive data and analysis tools from Public Health England
Dabbling with Data 