The Data School Blog

The Top 5 Things I Learned Today

It’s #Week2 of Data School and despite the lack of R&R found this weekend, I found myself walking into 33 Cannon Street eagerly this morning. Since my last post got a bit out of hand in terms of length, I thought I’d aim for short and sweet today. That means it’s listicle time! Here are my favourite 5 things I learned today:

read more

Combining Data in Tableau and Alteryx

At the end of this first week, we’ve encountered a lot of new information. I thought I would use this post as an opportunity to set some of it straight in my head, and in doing so look at differences between Tableau and Alteryx. I’ll focus on how the two tools combine data sources.

read more

Alteryx. You had me at hello

The last two days at the Data School we have been learning Alteryx. This incredible piece of software can change your analytical life and I will take you through some of its capabilities. Sounds too good to be true? Keep reading. 

read more

First Day in DS8

Well…here I am.  Glad to finally say I have started my job here at the Data School and elated to be a member of DS8 🙂 Since being offered a place a month ago I was excited to start this new stage in my life. Today it was time to finally meet the rest of the members...

read more

DS8 – Day 1

1st day, 1st blog - reaching the data school and tackling timestamp data in Tableau. 1. Reaching the Data School Day 1 Having survived my first day at the data school (DS8), I felt like sharing a few moments, which ultimately led me to this day. Working with large...

read more

First day at the data school was very promising

The data school is all about potential and improvement, sharing ideas, work hard and play hard. The most important part of the training is communication: ask questions and be ready to learn. The best part of the Data School is that working is actually a fun experience.

read more

A fresh chick in the henhouse

It’s taken a while to finally get my foot in through the door but here I am! Read here about my story and how I got here and my advice for potential applicants of the future.

read more

Tableau for everyone

Tableau can be for everyone. Just find what drives them or what use can they give it and people will want to use it. Case in point: my father during the holidays.

read more

Dashboard week day 4: Cheeses, cheeses everywhere…

Dashboard week day four. No dataset as per say today, simply an instruction. Find some data about cheeses, and create a visualisation. Andy handed us the details of an API we could query to obtain the data about all the cheeses. First problem we encountered was...

read more

Dashboard Day 4: Edit Early!

Edit early. You’ll be much more able to see nuances in a smaller dataset. Even if you can’t find the greatest story ever – would you have had any better luck with 100x the amount of data?

read more

Dashboard Week Day 3: Lessons Learned

Today's Dashboard Week task was to analyse blog data. We connected to Google Analytics and joined to a dataset containing details about the authors in question.   I learned a few more things today.   I didn’t try to build the trickiest bit of functionality until the...

read more

Dashboard Day 2: A Day in the Life

A blow-by-blow account of the second day of dashboard week. How I contributed to the team using regex. How I needed help, and Steph came to my aid like a champ. How constructing a story in six hours is something of a challenge.

read more

Dashboard Week Day 2: What Have I Learned?

Today’s task was to visualise YouGov data about characteristics men and women of different nationalities found most attractive in a partner.   On top of that, we also had to use story points to tell a tale. It quickly became clear why: it would have been fairly easy...

read more

Dashboard Week Day 1: What Did I Learn?

It’s Dashboard Week this week in the Data School. Each day this week I’ll be writing a reflective blog on the lessons I’ve learnt from having to prepare and visualise data at speed.   Today was a mixed success, but I’ve learned a few things.   Narrow the scope of your...

read more

I Want a Career Change: Can the Data School Help?

Many people join the Data School from other professions. As someone who’s moved into the Data School from a different kind of role, I’d strongly recommend the programme to anyone who wants to start working in data analysis.   Traditional recruitment methods tend to...

read more

Dashboard Week Day 1: American Housing Survey

And we're off. For week 1 of Dashboard Week, DS7 has to download, parse, prep and visualize data from the American Housing Survey. Here's what they have to do: Download the data and table definitions here. Using Alteryx, import and prep the data (this is the messy...

read more

It’s Dashboard Week v7!

We were supposed to have a project for a client this week, but it had to be delayed at the last minute. Instead the team gets to experience Dashboard Week. Each cohort before them has gone through different flavors and it starts Monday for DS7. The point of Dashboard...

read more

Alteryx: How to Save Your Tool Configuration

Sometimes you need your workflow to remember the field settings for a particular tool. For example, if you’re building an iterative macro, you want the macro output to have exactly the same configuration as the macro input, so there’s no error when the workflow loops....

read more

Strong-Arming Tableau: Rounding Operations

Forcing Tableau to round up or down at specific decimal places Tableau has three interesting functions, ROUND() and FLOOR() and CEILING(). The ROUND() function allows you to choose the number of decimals to which you would like to round, but you cannot specify that...

read more

How to Quickly Open Files and Macros in Alteryx

Here’s a really simple tip when working with Alteryx: keep a Windows Explorer folder open with your input data files, apps and macros.   This allows you to drag your data and macros onto the canvas, opening them straight away. Dragging a csv onto the canvas will open...

read more

How to Use Wikipedia as a Data Source

Recently, I attempted to build an Alteryx workflow that extracted information from Wikipedia tables. I’ll publish my workflow once it’s fully operational, but for now I’ll talk through how to turn Wikipedia tables into a usable format. Below is a guide for the general...

read more

Why Isn’t my Iterative Macro Working?

We’ve been learning Alteryx macros this week in the data school. Other Data School blogs have explained how to build a macro, but I thought I’d give you my checklist of things that you might have done wrong.   If your iterative macro doesn’t work, it might be because:...

read more

Apply for The Data School

Our application process is always open. Get started with your application today!