Via Massive Open Online Courses (MOOCS) Nils discovered the world of data analysis. Especially analysing the effects of anti-poverty strategies and policies fascinates him since he has worked in underprivileged communities in South Africa. He is a fan of Tableau because it helps him to tell compelling stories which raise awareness for social issues. His educational background is in Business Administration (MSc). Before joining the Data School, he worked as project management consultant in Germany.
Nils loves travelling and getting outside his comfort zone during his journeys. He plays squash, works on improving his photography skills and has a passion for cooking.
Dashboard week came to an end with a data set about restrooms in Vancouver, Canada. The data was already structured in a Tableau friendly format, so no data preparation was required. Hence, I did not create an Alteryx workflow for today’s exercise. The dimensions of...
Today was another sports data set today. After having already analysed the London Prudential Race cycling data, we changed sports and dived deep into the world of baseball. Retrosheets has data about the MLB available going so far back as of 1871. The data is...
When you are going out in London, the Food Standards Agency makes sure you do not get food poising. It visits business which handle food and gives them a rating from 0-5 with 5 being the highest value.
Today’s data set took us deep into the life of Americans. The American Bureau of Labor And Statistics publishes data about how American spent their daily time. By the minute, the days are broken down into Major Categories e.g Household Activities or Work & Work related activities. These categories are then further broken down into sub-categories.
Day 1 one dashboard week started off with a sporty exercise. Our task was to scrap the web page of the Prudential Ride London Results homepage: https://results.prudentialridelondon.co.uk/2018/
In the first part of the parameter and sets Series I explained how these tools can help us to highlight members of a data set based on one criteria (revenue of companies).
In part 2 I will take this analysis further and demonstrate how we can identify the most shining diamond companies based on 3 criteria: Revenue, Growth and Expenses.
Sets enable you to visualize groups which match one or more criteria. They are even more powerful in combination with parameters which allow you to dynamically change the criteria for the sets.
You will often get into a position in which you will have to spend some time on cleaning the provided data before you can perform actual analysis on it.
The last() function can be very helpful when you want to highlight a single data point of your data series. May it be the last, second last or even the first point of the series.
You can save your audience some head leaning if you make your y-axis title horizontal instead of vertical. By default the y-axis title is vertical in Tableau and it is not possible to change the alignment to vertical. But with a little trick you can change that.
Marginal histograms are excellent for displaying your data on multiple aggregated levels in one view.
Cycle plots are great for comparing date values over time. Take this chart for example: If we wanted to compare how each month performed in terms of sales over the last 4 years, this would be difficult to do with this kind of line chart. We would have to find the...
Have you ever had the issue that you want to create extra space between bars which belong to a different category?
Each Friday, our coaches ask to present a project which relates to the content we have learned over the period of the week. This week, our task was to supplement our application visualization with additional data. This task helped us to revisit the major topics of the week: Data preparation and joins in Alteryx.
One of the big advantages of moving to London is the huge numbers of amazing speakers who make their appearance in the city. So during my first week in London I already had the opportunity to attend the talk of Alberto Cairo, the author of the very well appraised book the truthful art.