by Daniel Lawson | Jan 7, 2023 | Daniel Lawson
Welcome to the third instalment of my experience with The Data School’s infamous dashboard week. Going into DBW on Tuesday morning, I was feeling pretty comfortable with this whole arrangement; having an entire day to work on a small project seemed fairly...
by Daniel Lawson | Jan 4, 2023 | Daniel Lawson
Cafe Natalia: Creating a Spatial Intelligence Tool in PowerBI This dashboard is a story of dead ends and frustration. It may be the natural focus The Data School puts on Tableau, which after today’s experience with PowerBI, I love far more; but, putting together...
by Daniel Lawson | Jan 4, 2023 | Daniel Lawson
DSAU17 Dashboard Week Day 1 Welcome to Day 1 of Cohort 17’s Dashboard Week in our thirteenth week of training. With only a few short weeks of training left we are so excited to be undertaking the infamous dashboard week. Here is the first of four blog posts showcasing...
by Daniel Lawson | Dec 28, 2022 | Daniel Lawson
This is the first post in an N-Post series on Advanced SQL with a focus on Window Functions. Stick around to level up your SQL skills. Intro to Window Functions in SQL Window functions are a type of SQL function that allow you to perform calculations over a set of...
by Daniel Lawson | Dec 27, 2022 | Daniel Lawson
In the admittedly short time I’ve been a data analyst at The Data School, and even before that, I’ve been far more engaged by the back-end technical side of data. My earliest projects involved extracting my personal data to load or analyse in different ways. I’m a...
by Daniel Lawson | Dec 27, 2022 | Daniel Lawson
This is Part Two of a N-Part Series on SQL and its importance as a Data Analyst (Link to Part 1: My Experience) In my last blog post I introduced the “Every Data Analyst Should Learn SQL” series by outlining my experience with SQL from the perspective of a Data...