Kofi Bonsu

Kofi joined The Data School from a Biomedical Sciences background, working in the NHS. Mainly unpacking, processing and entering data without exploring any of it.

Becoming aware of the increasing importance of data and data analysis in Healthcare while becoming disillusioned with the repetitive and uninspired nature of the position, Kofi stumbled upon Tableau which piqued his interest in creativity and storytelling. Attending a Meet & Greet at The Data School solidified the decision to progress with data analytics and join.

Outside of data, Kofi enjoys going to the gym, playing mini golf and football.

Adding an All Option to a Parameter Filter

A Parameter is defined as a user generated value that allows the user to change the view. A parameter can also be used as a filter. For this example the EU Superstore data set is used. I start by putting the Country in the view. I'll be using Region as my filtering...

Dashboard Week, Day 5 US Highway Traffic

Today's challenge was to visualise one month of hourly traffic counts at stations across the U.S in Tableau Prep. Joining and prepping the data in Prep has reinforced my preference in Alteryx. Every new action in Prep causes the workflow to run which leads to a lot of...

Dashboard Week, Day 4. USA Drought Statistics

So yeah, this one didn't go as well as planned. It took a while to work out the correct api call, since not all the parameter options were laid out in the documentation. I decided to look at the Weather Forecast Office Statistics data on drought using the drought...

Dashboard Week, Day 2. London Marathon Runners

I've only got 10 minutes to write this so its' going to be a short one. For Day 2 of Dashboard Week, we were tasked with visualizing historical London Marathon data, runners with the letters "bo" in their surname for me specifically. The first thing to do was to...

Dashboard Week, Day 1 – Star Wars

I picked to attempt a visualization of the Starships in the Star Wars universe. Once I connected to the SWapi in Alteryx, I noticed that I was only getting 10 results which was a little unusual. On further inspection, the api call was only getting the first page worth...

Creating Dashboard Alerts in Tableau Server

Tableau Server can be used to send email Alerts to predefined users if a threshold is met. This is only possible on a view that has a continuous (green pill) numeric axis. To do this on a dashboard, click on a continuous axis of the view that the Alert will be set on....

Asymmetric Drill Down using Set Actions

In order to create a drill down the data set needs to have hierarchical information . Superstore will be used in this example to make a Tree map, using Sales on the Size mark. To create a hierarchy drag the 2nd level dimension of the hierarchy onto the 1st dimension....

Use Case for the Tile Tool

For a recent DS project I ended up with a data set that had all the information I needed in one column similar to the example below. Fortunately the data is structured and repeating, every 5 lines. The aim is to get each Player on their own row with the rest of their...

Gridding in Alteryx

In a recent Alteryx lesson we learnt about creating a shape file with the location names attached. In this specific workflow I am using the Match tool to combine a shape file to location data in the .csv file. When selecting the Grid tool there is the option to choose...

Using Alteryx to Append Fields with a Lookup Table

While attempting the recent NHL Makeover Monday, I decided to supplement the attendance data with stadium capacity data. I found some data that would work and after some quick cleaning of the data set, added it to the NHL data on Tableau. I ended up with a lot of null...

Line of Best Fit

When you go to the analytics tab and drag the trend line onto your scatterplot Tableau creates a line going through your plots. But what is it doing and what do the figures mean? When plotting a linear trend line Tableau uses the equation y=ax+b In this equation a is...

Why Colours Matter

Using colour in your viz adds another dimension that can ascend your dashboard from average to amazing or burn your audience’s retinas. Colour allows you to direct your audience’s attention or gloss over background information. It can be used to invoke emotion, set a...