The Best of DS11

This week is DS11’s last week of training. Next week, we’ll all be split up and sent to our placements for the next 6 months. We probably won’t all be back together for a while so I’ve been feeling quite reflective. Throughout the past 4 months, we have done some amazing work and in this post, I would like to highlight the vizzes and blogs that are personally my favourite. DS11 has produced so much useful and incredible content over the past few months and this post can’t possibly cover it all so be sure to check out our Twitters and Tableau Public profiles.


Meet us!


Favourite Viz : One

How could I have a favourite viz section and not include this beautiful viz by Ellie. This viz was done for Dashboard Week Day 1 and deservedly got Viz of the Day! Check it out here. Isn’t the snow incredible?!

Ellie’s VOTD!
Click to keep reading!

The Prep Off: Alteryx vs Tableau Prep Round 2


Two major contenders in the ring tonight: new but developing at light speed, Tableau Prep and tried and trusted, Alteryx Designer.

Who will win this time after a draw in the last Prep Off? Watch the replay of Round 1 here.

How do these two softwares compare when cleaning an Excel spreadsheet with 182 fields? The chosen data features the table seen in Figure 1. This data was used in Makeover Monday Week 2 2019 (after it was cleaned, of course). Download the Excel file (Freedom of the Press) and follow along with me. 


Fig 1. Original Excel spreadsheet. Years go from 1979-2016


Ready? Fight!

Click to keep reading!

Why You Should Apply For The Data School

Now that DS11 are approaching the end of our 4 months of training at the Data School and will soon be shipped off to our first of 4 placements, I have been reflecting on the experience and would like to convince you to apply for the Data School too.

 

Because it’s an amazing opportunity

Where do I start with this one? A salary of 30k in year one, rising to 35k in year two. That alone is a reason many would want this job but it’s so much more than the pay. You will be taught for four months (paid) by the best in the business. The Information Lab is home to 4 Tableau Zen Masters and 2 Alteryx Aces as well as so many of the brightest in the community. The wealth of knowledge and experience that you will have access to is something enviable for many. The Data School is an opportunity to learn and kickstart your career. By the time your 2.5 years are up, you will have worked at 5 different companies (incl. The Information Lab) and worked with many more clients while you were in training. There is no question that you will be qualified for some amazing jobs afterwards. In fact, if you have taken advantage of the opportunities presented to you in the 2.5 years, you will likely have a choice of jobs to go to.

 

Click to keep reading!

How to Prepare for your Alteryx Designer Core Exam

This month, many of DS11 are taking the Alteryx Designer Core Exam (as well as the Tableau QA), including myself. If you’re interested in my top tips on how to pass the Tableau QA, see my post here.

 

In this post, I will go through:

  1. The resources I found helpful while preparing for the exam
  2. My experience of taking the exam
  3. My top tips for passing!

 

Click to keep reading!

How to Teach Tableau/Alteryx

Last month, DS11 taught the public Tableau and Alteryx and this month, we are conducting webinars teaching the same content. Check out our meetup page for more details on upcoming webinars and events!

For both of these lessons, I taught Alteryx Data Prep. If you missed my webinar, it was recorded and will be uploaded so I will update this post with a link later.

In this blog post, I will go over my teaching experience and some top tips from myself and from the beautiful people at the Information Lab.

 

My Teaching Experience and Top Tips!

Fig 1. DS11’s Alteryx Training Day

 

To prepare for teaching, I sought advice from the wealth of experience of the Information Lab consultants. The advice I received was super useful and helped me to prepare my lesson plan. Figure 2 below shows all the teaching tips I gathered categorised into four sections.

 

Click to keep reading!

Louise’s 2018 in Data

This time last year, I was a final year Medical Engineering student without a clear career path. Now, I’ve graduated and I have a job that I love – more than I expected to have by this time!

Fig 1. My greatest accomplishments in 2018

 

2018 has been an amazing year and I’d like to take a moment to say I am so thankful for my family and friends for supporting me throughout and to everyone at the Data School and the wider data community for welcoming me. Now, on to a recap of the year…

 

Click to keep reading!

Dashboard Week Day 2: Everyone loves a pretty map

My first day of Dashboard Week! Yesterday the rest of DS11 enjoyed vizzing >200M rows of data about snow ploughing while I watched from home (hurray for a coincidental day of annual leave).

 

The Challenge

This morning I was rested and ready to take on the challenges of the week. Today, Andy set us the challenge of analysing New Orleans Police Department (NOPD) body-worn camera data. Now, this would have been super fun and interesting if there was information on the crime that was being recorded, whether this led to an arrest, etc.. but no. As you can see from Figure 1, the data contained information on the times body cams were used, where, how long each video is, when it was uploaded to the system… not exactly the juicy stuff.

 

Fig 1. What’s in this fascinating dataset?

 

Click to keep reading!

The Prep Off: Alteryx vs Tableau Prep

prep off

The Prep Off…

Two major contenders in the ring tonight: new kid on the block, Tableau Prep and reigning champion here at the Information Lab, Alteryx Designer.

How do these two softwares compare when cleaning two Excel sheets (within the same workbook)? The chosen data features the table seen in Figure 1. The data includes merged cells, totals, unnecessary content, dates in a row and times in a column, plus its in German! Download the Excel file (2018-09-18 Hamburg) and follow along with me.

Fig 1. Original Excel spreadsheet sample with red boxes indicating the removable content

 

Ready? Fight!

Click to keep reading!

Alteryx Designer: Getting Started Guide

DS11’s first week at the Data School was focused on introducing us to Alteryx; a super useful software for prepping messy data before visualising in Tableau. Amongst data preparation, Alteryx is also capable of spatial and predictive uses. In this guide, we will navigate through the interface of Alteryx Designer and I will also give some helpful hints on how to get started. Now, download Alteryx Designer and let’s get acquainted.

Alteryx Designer Interface

When opening Alteryx Designer, you will be met with an interface that looks like Figure 1. Matlab users out there will be very familiar with this layout!

Figure 1. Alteryx Designer interface

Click to Keep on Reading!