Nicholas Bowskill

Nicholas Bowskill

Nicholas Bowskill

Nicholas had always had a keen interest in numbers and how these could represent different idea and information. Following this interest, mixed with a love of problem solving, he completed an integrated Masters in Mathematics; whilst this started off very interesting he started to become concerned with how niche the studying was becoming and saw bigger problems in the world that needed to be solved. Searching for problem solving careers, Nicholas found data analytics to be very promising and The Information Lab to be the breath of fresh air he needed.

Nicholas has always enjoyed being out in nature, he spent most of his childhood involved in the Scouting movement including being a young leader. Whilst many of the opportunities for making pointy sticks and camping in the woods may have passed for now, his love of nature has never left, he still enjoys many outdoor activities such as hiking, canoeing and cycling. This love has left him with the goal of using his career to have a positive impact on the environment and hoping that the use of data can be his path to this goal.

A Reflective Blog: Coming to the end of training

The Data School experience has been an amazing way to start my working career. After studying maths for 4 years in order to gain a degree and masters I thought that my working life would be somewhat of a boring ordeal, solving problems that would only affect a very...

Alteryx Core Exam Tips

The Alteryx Core exam is a very good way to test your Alteryx skills and also learn some new information that would usually be glossed over. The exam can be registered for here and at the start of the next month you will receive an email with a link that allows you to...

Tableau QA Revision Tips

Tableau QA Exam Tips The Tableau QA Exam can be a little intimidating, but there are lots of resources out there from the community and Tableau itself to help you pass the certification. Here I will go through some of the things I found most useful in preparing for...

Running Sum and Moving Average in SQL

Using Tableau's Superstore as the database, the SQL query: Select [Region], [Order Date], Sum([Sales]) as 'Sales' From superstore Group By Region, [Order Date] ; creates a table with column headers Region, Order Date and Sales, where the Sales is the sum of sales for...

Calculating Amount of Days from First Entry

In this blog we will use an LOD to calculate the first entry date of purchase of products in the Superstore data set and then use this LOD to calculate the running sum of sales over amount of days after the first sale. This normalises the start of selling for...

Dashboard Week – A Summary

It is the start of the week after dashboard week, this new week is one of festive joy rather than anticipation for what curve balls Andy could throw at us. During these moments of calm, I wanted to reflect on what I have learnt from last week's madness. The week...

Dashboard Week Day 4 – Bicycles in Seattle

Once again we started off the day by presenting our dashboards from the previous days, everyone got to proudly show off their Power BI creations! I showed off my dash about where the foreign monetary gifts were coming from and going to....

Dashboard Week Day 3 – Using Power BI!

Once again we start our day by presenting our visualisations we made the day before. I was happy to present my radial charts and get a little feedback from Andy about colour and lay out, if you'd like to look over it and give feedback the link is here:...

Dashboard Week Day 1 – NYC Snowplough (plow) Data

Before the rush of doing things I start the day by not really knowing what’s going on…. The tiredness of the Monday morning mixed with being hit with a 253 million dataset that we need to import to Exasol before being able to use it has gotten me a little confused....

How to Create New Users as an Admin in Alteryx Server

Admins on Alteryx Server have the ability to create new users and to set what permissions they have. With the increase in data analytics within companies and the growth of Alteryx as a provider of an easy to learn way for companies to conduct their own data analytics,...

An Overview of Webscraping using Alteryx

Webscraping can be a very powerful tool. It allows users to 'scrape' a website for the public data displayed on the site. Rather than having to manually note down figures or words on the site, software tools can be used to pull this data from the page source code and...

Merging Tricky Sheets in Alteryx and Tableau Prep

Tableau Prep is very user friendly and easy to use, but Alteryx has a much wider range of tools it can use in data preparation. Using Alteryx before learning Tableau Prep, something I was surprised at with Prep is the ability to wildcard input files with different...

A Macro Breakdown

My first experience of a macro was many years back when Runescape was all the rage and occasionally whilst playing you would come across lvl 3 players walking straight to a place to mine or chop trees, continuously mine or chop for 30 minutes and then walk to a bank...

Your Year in a Radial Graph

A radial graph is a graph rotating around the axis like a clock face. I took inspiration from Mina's Clock Chart blog (https://www.thedataschool.co.uk/mina-ozgen/make-clock-chart/) to use Alteryx and Tableau to make years worth of data into circles; as I thought this...