My Reflective Blog, or 5 Things I Loved About Data School

Life is unpredictable. Six months ago, I was looking for a job that would teach me Tableau. Little did I know I’d come across the Data School, giving me four months of expert training, nine real-world client projects, improved presentation and project management...

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...

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...

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...

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...

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....

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...

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...