After completing a degree in International Relations in 2017, Diego worked in a consulting company focused on attracting foreign investments for the development of sustainable projects in Chile. There he discovered the importance of data-driven decisions and decided to start learning data analysis tools during its free time. After six Excel online courses he finally discovered Tableau, but he did not know where to start. It was during this period when he decided to move from Chile to the UK and by some ‘divine intervention’ he stumbled across The Information Lab online.
Before moving to the UK, Diego was always using every opportunity he had to travel. He volunteered in China and Greece as an English teacher and did one year in the UK as an exchange student before deciding to move indefinitely.
Outside the classroom, he likes to interact with the community in Twitter, play boardgames and read. The book that inspired him to start his data career was Factfullness by the Gapminder Foundation.
Today was our last day of #Dashboardweek, what a week has been! The data was about United States Interstate Traffic. Because Friday is presentation day at the DS, we only had until one to prepare the data and create a visualisation. This time the data was already...
Today was our fourth day of #Dashboardweek and we had to look into drought levels in the United States. For the first time in the week I ran out of time and tomorrow I will face the consequences!
Today was our third day of #Dashboardweek and as DS11 did last time, we had to use PowerBI. The data came from the New Orleans .gov site and it was about 3-1-1 calls. This number is a non-emergency phone number that people can call in many cities to find information about services, make complaints, or report problems like graffiti or road damage. Hence, the data was about different incidents, their nature and location.
Today was our second day of #Dashboardweek and the task this time was to look at the historic results of the London Marathon website. Because the results span all the way from 1981, Andy limited our search to only those entries that start with the first two letter of my surname -PA.
Today was our first day of #Dashboardweek and the task set by Andy consisted on using the Star Wars API (SWAPI). As there were only six of us today and six different topics in the API, each of us had to choose one. I have the habit of letting everyone choose before me and therefore I was left with “Vehicles”
If you have read part one, then you already know how to build a dynamic axis, and, in this post, I will explain you how to create a parameter to let your user sort between ascending descending. I recommend you that if you haven’t read about how to create a dynamic axis, you can read about it here as I will build upon that post.
Parameters are one of the most useful tools that Tableau has. They allow the user to input their own values, which allow us to create self-served dashboards and dynamic dashboards that won’t require a constant update. In this blog post I will guide you through the steps of two different uses of parameters. In the first part, I will show you how to create dynamic axis that allow the user to select a different measure. In the second part, I will show you a small trick to create an ascending/descending parameter for a better user experience.
Week Six (14/01/19 – 18/01/19) As we are currently in week 11, I must confess I have fallen behind on my journaling. However, before the memories fade completely I’ve decided to write a small recap of the things that we did and learnt during week six. The week was...
As I have recently started my journey in the Tableau community forums, I have come across different questions. One of them has repeated a few times and I thought I would make a blogpost using the tutorials I’ve already wrote on the forums, so more people can find them. How to swap sheets using images?
This week we finally experienced one of the things we had been looking forward the most, the client project. With the launch of our first client project. we finally got the chance to apply the things we have been learning into a real-case scenario.
One of the analytical features that Tableau offers is the capability to build a trendline with just a couple of clicks. However, trendlines in Tableau do have some limitations, among them is that you can’t use them within your calculations. This becomes especially troublesome if, for example, you want to calculate the distance to the trendline or do any other calculation that interacts with the trendline.
The week went very fast and it felt a bit like those small recap episodes between the seasons of a TV program. However, it was still challenging as we were introduced to Tableau Intermediate and very important concepts such as LODs, Table Calcs and Order of Operations.
When we work with data, our continuous data (such as sales or profit) it is usually grouped under some categorical field. Normally these fields would be our discrete variables in the data set, such as “Country” or “Category”. Nevertheless, sometimes we would like to group our data under numerical ranges, this is when we would create a bin based in a numeric dimension.
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.
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.
After a long application process and a month of waiting, the Data School finally started. What did DS12 do during their first week?
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.