Kyle Stanford
Kyle holds a Masters in Teaching, specialising in mathematics and physical education, from WSU. After starting his career as a teacher’s aide and later as a teacher, he shifted to data analytics to explore the world beyond education. With a strong passion for problem-solving, honed communication skills, and an eye for visual design, data analytics has become a natural next step in his career.
Outside of work, Kyle participates in a variety of sports, including martial arts, but also enjoys more relaxed hobbies like gaming, anime, and music.
Changing Careers & Overcoming Imposter Syndrome
Let’s start with an obvious statement - changing careers can be challenging. Of course, people have different circumstances, but for many, the jump to a new field is difficult. The learning curve may feel more like a series of walls to be scaled, and the adjustment...
Dynamic Titles in Power BI – Using Parameters
Creating dynamic titles for charts in Power BI adds polish to any report. Whilst some situations call only for a simple change, scenarios involving multiple parameters or filters require a flexible approach. For example, a chart looking at "Profit by Category - Last 3...
Configuring Dropdowns in Alteryx Apps
Dropdowns are an effective way to give users options whilst conserving space. They are a convenient and user-friendly filter, but considerations should be made when configuring dropdowns in Alteryx apps. In this guide, I’ll demonstrate and explain best practices for...
Ways to Learn SQL
Last week at The Data School in Sydney, we learned basic and intermediate SQL querying. Like most skills that we have learned about so far, we approached different facets of SQL in a formulaic way: Explanation of [SQL concept here] Demonstration of [SQL concept here]...
Dashboard Week: Day 5 – Pixar Movies
Welcome back to my final Dashboard Week blog. Day 5 brought an exciting dataset about Pixar movies! We received 6 Excel files, covering the films themselves, their genre(s), awards won, box office earnings, the crew behind the scenes, and the public's response. With...
Dashboard Week: Day 4 – Alcohol Consumption & Violent Crime
Welcome back to my Dashboard Week at the Data School blog series. For day 4, we were challenged to web scrape this text file housing alcohol consumption statistics across all states in the U.S. The data comes from the latest consumption surveillance report by the...
Dashboard Week: Day 3 – The Metropolitan Museum of Art
It's day 3 of Dashboard Week at The Data School. Today we're getting creative with The Metropolitan Museum of Art Collection API. Our challenge is to connect to this API and build a dashboard with the data we retrieved. The API contains datasets on over 470,000...
Dashboard Week: Day 2 – English Women’s Football
Welcome to the second installment of DSAU27's Dashboard Week. Today we looked into the English Women's Football Database hoping to find insights worthy of a slow-motion replay. The dataset covers game statistics on all matches from the Women's Super League since the...
Dashboard Week: Day 1 – Nepal Himalaya Expeditions
Today, DSAU27 hit the ground running with the commencement of Dashboard Week. To kick things off, we were given data from the Himalayan Database (based on Elizabeth Hawley's expedition archives). The dataset covers expedition details, climber information, and...
Create and Format Bump Charts in Tableau
Bump charts are an effective way to explore how rankings change over time. However, formatting bump charts in Tableau to be visually effective can be tricky. This blog will first demonstrate how to construct a simple bump chart in Tableau, then give a few tips to...