The Data School Blog

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

read more

Using LODs to Calculate Customer Retention

This post looks at how we can display what percentage of customers is made up of return customers, and what percentage is new customers. To achieve this, I'm using Level of Detail expressions to essentially create bins of customers, depending on when they placed their...

read more

Tableau MIN(Date) LOD’s – Use Cases

Tableau LOD's can be used to get the date of first purchase, first signed up, first order etc. This has many real world applications such as tracking percentage difference from this first date, looking at customer retention from first date and seeing how long it...

read more

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!     2018 has been an amazing year and I'd like to take a moment to...

read more

Web Scraping 101: A short introduction

What is web-scraping? Web-scraping is the automated collection of information from webpages.   The authors of “Automated Collection with R. A Practical Guide to Webscraping and Text Mining” explain the process very clearly: “The Web consists predominantly of...

read more

Common Baseline Graph With Parameter (Part 2)

In the first step, I have shown how to create a common baseline graph. Here I will show you how to use parameters to make this graph more dynamic. We will use a parameter control to highlight a chosen subcategory and create a dual axis which will create a large...

read more

Creating a Common Baseline Chart (Part 1)

A common baseline chart will allow you to create a view which will show each dimension starting at the same time to compare their overall trend. From each product’s beginning to end. For example, you could use this chart if you wanted to see how much each product has...

read more

2018 Data Reflections

  2018 has been a big year for me, data wise, so I thought it was apt to reflect back before moving forward with some goals into 2019. This seemed especially relevant today, given that I've just passed the Tableau QA Exam! Like my half way through blog, this will...

read more

Diego’s journal (DS12) – Week Three

During week three we went back to ETL, starting with a deep dive in Tableau Prep followed by a very intensive couple of days learning Alteryx Macros. We finished our week with an introduction to statistics in data visualisation and the different tools that Tableau and Alteryx provide to do descriptive and inferential analytics. One of the different things about week three was that we didn’t have any class with our usual coaches (Carl and Andy) but previous Data Schoolers who now work with the Core Team.

read more

How to create a Gantt Chart in Tableau

In this post, I'll take you through how to create a Gantt chart. This is a useful chart that shows the duration of events, e.g. delivery times or hospital wait times. The date field is usually on the column, and then the various dimensions are on the rows. I'll be...

read more

Tableau: Creating a customer drop-off tracker

Tracking the rate of your customers' orders so that you can react if a customer appears to be dropping off   A few weeks ago I built a rudimentary customer drop off tracker for a client project and I thought I'd share the technique. It relies on finding the...

read more

Dashboard Week Finishing Touches

With some time free over Christmas I decided to look over my vizzes from Dashboard week with a fresher pair of eyes and fix some things that were annoying me. New York City Snowploughs Day ones snow ploughing dashboard was my least favourite of the week and I didn't...

read more

Dashboard Week Day 5: Boy Bands

For Dashboard week day 5 we were given a dataset on boy bands. The data contained the highest charting single, dated when it charted highest, for every boy band. It also contained information about every boy band member such as height, hair style and hair colour. We...

read more

Adding Test Conditions to a Standard Macro

One of the topics covered by DS12 this week has been macros which included learning the difference between standard, iterative and batch macros. We also briefly delved into the world of apps. I wouldn't really consider myself the most tech-savvy person so finding out...

read more

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

read more

How to make a Dynamic Tooltip

Dynamic Tooltips   For this topic I am looking into the average adjusted inflation gross versus budget for each of the Disney Renaissance films. Link to dataset.   A dynamic tooltip provides Tableau users a little more flexibility in what they would like to...

read more

DS11 Dashboard Week // Day Five: Boy Bands

The final day of our dashboard week was so fun! We got a cheeky hint from Andy on Thursday evening with a gif featuring the BackStreet Boys.   He then announced, via his blog of course, that we were to analyse data about Boy Bands from the Internet Boy Band...

read more

DS11 Dashboard Week Day 5: Boyz Boyz Boyz!

This is going to be a short one since it's been a long week and quite frankly, there is notv all that much to say about what I have created today. Still, it has been a great last day of a long week full of excitement, frustration, satisfaction and tons of lessons...

read more

DS11 Dashboard Week Day 4: I Want to Ride my…

After our excursion into the new, eciting, sometimes confusing, often just plain wierd world of Power BI, we were back in our native Tableau for our second to last Dashboard Week Challenge. This was another data set from the US (it's like nothing interesting ever...

read more

Dashboard Week Day 4: Seattle Bike Count Summary

For day 4 of Dashboard week we had to analyse data from Seattle bike counters at various routes through the city. I produced a summary report kind of dashboard which looked into the difference in bike usage between weekdays and the weekend. Bikes were used much more...

read more

Dashboard Week Day 4 : Seattle, i.e. Cyclist Heaven

It's day 4 of dashboard week and I am starting to fatigue. No matter! We push on.   The Challenge Today's dataset counts the number of cyclists riding through the roads of Seattle. Potentially very interesting for a Seattleite (/satellites) or a keen cyclist. For...

read more

Dashboard Week Day #4

Today Andy set us the task of visualising some data about bike traffic around Seattle. The data comes from about 13 spots around the city where bike traffic is measured. I had a clear idea of what I wanted to achieve in the day. I wanted to make a coxcomb chart, the...

read more

DS11 Dashboard Week // Day Four: Seattle’s Cyclists

Day four's challenge was back in Tableau - analysing count of cyclists from Seattle's Open Gov data. Over the past four or five years Seattle have implemented counters to track the number of cyclists over time in various parts of the city. This is because there are...

read more

DS 11 Dashboard Week Day 3: I Got the Power

Try Something New! It was hump day for DS11's dashboard week today, reason enough for Andy to mix things up a little and drag us (some of us willingly, some less so) out of our comfort zone. The task for today was to visualise a data set on money paid to US higher...

read more

Dashboard Week – Day 3

Today’s task required us to use Power BI for the First time. It only took 15 minutes within using the tool did I become a fan. I find it easy to build different chart types without having to create any complicated calculations (depending on what you want to...

read more

Dashboard Week Day 3 : Power BI for noobs

SPOILER ALERT: I like Power BI. Of course it has pros and cons, but overall, not too shabby.     Woah, we're half way there! Woahhhhh! It's day 3 of Dashboard week which means we're at the halfway point! See my viz from yesterday here. Last night, Andy...

read more

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

read more

A short introduction to Microsoft’s Power BI

Here at the Data school we are habitual Tableau users; hardly a day goes by, including weekends, without opening Tableau at least once, even if only to make a minor tweak or two. I've been here close to 3 months now, and last week ran a brief intro to Tableau training...

read more

Dashboard Week – Day 2

For day 2, Andy presented us with very clean data. The data was about police body cam use, in New Orleans. The problem I faced, to begin with, was that I felt that the data was too simple and did not have enough information to create a visualisation with.  So I spent...

read more

DS 11 Dashboard Week Day 2: I Spy…

Today's assignment was to create a dashboard based on metadata about Body Camera usage in the New Orleans Police Department. The data consists of one entry per recording that was uploaded to the NOPD's archives, with time stamps for when the recording was started, how...

read more

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

read more

Diego’s journal (DS12) – Week Two

Week 2 was all about data visualisation. We learnt about how the brain responds to visualisation cues, explored techniques to build a good infographic and then moved into working with Tableau and Big Data.

read more

Dashboard Week Day #2

For day 2 of dashboard week we have been looking at metadata around body mounted camera usage by police officers in New Orleans. The data contains the locations, times and duration of the creation of footage.   I decided fairly quickly that the route I would like...

read more

Dashboard Week: #1 A Winter Storm In New York

So 71 days or 102,240 minutes after joining the data school as DS11 our time has arrived for first day of "Dashboard Week". What is "Dashboard Week" i hear you ask? Well for each of 5 consecutive days the morning brings us a new data source, normally in a highly...

read more

DS 11 Dashboard Week Day 1: Let it Snow. Or Not.

Day One to Forget About Today's challenge was to create a dashboard inspired by this article using data from NYC Open Data about snow plough coverage in New York City. Reading through the article got us all very excited for the day ahead - playing around with maps and...

read more

Dashboard Week Day 1: NYC Ploughing

For our first day of Dashboard Week we were given the task of visualising ploughing in New York during snow storms. The original article from which the task was based (found here) looked into plough utilisation on November 15th 2018 due to the poor response to the...

read more

Dashboard Week – Day 1

First task - Download a Shapefile with a few Thousand records. Second task -  Download a file with 250 Million records. Third task  - Try to be productive while you wait 2 and a half hours for the Second file to be downloaded.   With the large data file we were...

read more

DS11 Dashboard Week // Day One: NYC Snowplow

To kick off a wintery dashboard week, the topic of the day was NYC snow-plow (or as we call them, snow-plough) frequency over the last 3 years or so. We were to join this to NYC street level data to explore which streets or boroughs were most often ploughed, as well...

read more

Dashboard Week Day #1

Today's task was to download New York snow plow data but it was us that got plowed.   We were advised to download the data and upload it to Exasol, a columnar storage database which is super fast in Tableau for large data sets. Given that the plow data set is...

read more

How to make a butterfly chart using Tableau

How to make butterfly chart using Tableau   I am looking into the average adjusted inflation gross versus budget for each of the Disney Renaissance films. I thought the best way for me to compare the two was by doing a butterfly chart on Tableau. Link to dataset....

read more

How to Approach a Time-Limited Project

At the Data School, we are constantly challenged and pushed with limited time projects. This is to develop our time management capabilities, to teach us to set realistic goals and to give us the confidence and knowledge that we can do it. So, what have I learned? In...

read more

Imposter Syndrome: Feeling like you belong

A reflective log and a message to current and future Data Schoolers...   Have you ever doubted your abilities? Have you felt like you're not as smart as people think you are? Have you thought your accomplishments are due to luck? Have you been afraid of being...

read more

Joins and Unions

When should I use a join? What type of join should I use? When should I use a union instead?
This blog post it is an introduction to the concept of joins and unions that hopes to answer these questions.

read more

Data School Application

Hi! I have recently joined the DS12 cohort this week. The one thing I really wished I had available when I was applying back in September was at least a description of what someone who’d been in my shoes had previously experienced with their Data School application....

read more

You don’t use E-mail?

We're sitting on the midweek hump of Week 1 here at The Data School as DS12. Day one consisted of digesting some background and history about The Information Lab and getting kitted out with some swag and laptops. On day two, Carl made it much clearer what our...

read more

Automating my Former Job Using Alteryx

Background Before joining the Data School, I worked as a Pricing and Revenue Analyst for a car rental company. The job title was fancy, and the advert intriguing. Promising analysis of previous and current market trends, development of competitive pricing strategies...

read more

How to Embed Spotify in your Vizzes

For my TIL Christmas Song viz in Figure 1 (see it here!), I embedded a Spotify playlist so you can listen to the music in the viz as you explore. Embedding a Spotify playlist/ track/ album can be great for adding another dimension to your vizzes. For example, they can...

read more

Halfway there….

DS10 graduated on Friday....we (DS11) are now half way through our DS training journey .... and DS12 start tomorrow...time is flying by! I thought I’d take a look back through the first part of my DS journey and take note of five things I’ve learnt so far:  ...

read more

One Thing Ends, Another Begins

I can’t quite believe how fast these past four months have gone. It’s quite a strange feeling knowing that in only a few days we’ll all be heading out to our first placements rather than gathering in the DS for another day. It’s be quite an exhausting few months, but...

read more

Alteryx Quality of Life Tips

I have only been using Alteryx for a couple of months now, but already I'm starting to come across some of those little things that make you think: "I can't believe I didn't know this". In the following I've compiled a list of some of those knacks and quality of life...

read more

Uploading and Updating to Alteryx Server

To upload a workflow to Alteryx server first connect to the server through Options > Manage Server Credentials and then completing the login to the server using the correct URL. You can then begin saving the workflow to the server by choosing File > Save As >...

read more

Apply for The Data School

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