Becoming a Master Criminal in LA

Becoming a Master Criminal in LA

Yesterday marked the start of Dashboard Week for the Brisbane cohort. We kicked things off with data pertaining to crimes reported to the Los Angeles Police Department from 2020 to 2023. The premise of Dashboard Week is to create a unique dashboard every day,...
Data Basics: Data Types

Data Basics: Data Types

When working with data, it is important to understand the different data types and how to store and use them. This blog post is written for a data novice and will cover some of the basic data types, their uses and sizes.   Bytes: A byte is a unit of data that is...
SQL Part Deux: Joins and Unions

SQL Part Deux: Joins and Unions

  I have previously looked at the core SQL syntax to form the majority of basic functions. Today I will look at JOINS and UNIONS in SQL. JOINS A JOIN clause is used to combine rows from two or more tables, based on a related column between them. So first up what...