Marcelo Ramos

Marcelo studied Business Economics at the University of Greenwich, where he fell in love with solving problems using analysis and logical thinking. After discovering Tableau and the Data School, he decided to pursue a career in data analytics because of its power to quickly uncover valuable insights.


While at the Data School, Marcelo became an advanced user of Tableau and Alteryx and consulted various clients such as State Street Global Advisors, where he became proficient in a multitude of skills:

  • SQL
  • Regex
  • Data preparation and visualization in web analytics
  • Data visualization best practices

Beyond his professional endeavors, Marcelo enjoys gaming, exploring culinary creations in the kitchen, and crafting the perfect espresso.

Blog Posts

Avatar
Fri 30 Sep 2022 | Marcelo Ramos
Dashboard Week - Day 5 - Boy Bands
Welcome to the final installment of DS32's Dashboard Week. In true star like fashion, our final task was to produce a dashboard on Boy Bands in the US Billboards top 100 from https://github.com/the-pudding/data/tree/master/boybands. It consisted of two CSVs, one for the bands and one for the boys
Avatar
Thu 29 Sep 2022 | Marcelo Ramos
Dashboard Week - Day 4 - Breaking Bad
Welcome back to the penultimate installment of our dashboard week. Today held a great task for us, which was to pull in data from a Breaking Bad API and make a Breaking Bad Dashboard. I am a huge fan of Breaking Bad and have watched it two times over
Avatar
Wed 28 Sep 2022 | Marcelo Ramos
Dashboard Week - Day 3 - Accessibility
Welcome back to the blog and the third installment of DS32's Dashboard Week, with today's focus being on accessibility. Accessibility is extremely important data visualisation to account for in our work so that we ensure nobody misses important information or insights
Avatar
Tue 27 Sep 2022 | Marcelo Ramos
Dashboard Week - Day 2 - The Watchdog
Today we were given our second task of the week, which was outlined as such: The industry I chose was the luxury watch industry, and more specifically a luxury watch retailer called The Watchdog
Avatar
Mon 26 Sep 2022 | Marcelo Ramos
Dashboard Week: Day 1
In dashboard week, we have 5 days of daily dashboards that we have to make for our coaches to judge, and see how much we've grown throughout the 4 months of training. This is my first day of the dashboard week!
Avatar
Tue 30 Aug 2022 | Marcelo Ramos
Trying to recreate my DS Application on PowerBI
See how I fared in recreating my first DS application viz in PowerBI!
Avatar
Thu 04 Aug 2022 | Marcelo Ramos
How to Calculate Z-scores in Tableau pt. 1
Do you want to find the biggest outliers in your view on your Tableau Worksheet? Calculating z-scores will allow you to find how many standard deviations away from the mean your values are, and in turn show you those that are the furthest away from the mean
Avatar
Thu 14 Jul 2022 | Marcelo Ramos
How to Click & Sort with a Set Action | Tableau
Want to click on a mark and have that sorted to the top of the viz? Well now you can, with Set Actions!
Avatar
Mon 11 Jul 2022 | Marcelo Ramos
The Date Interface Tool in Alteryx
I was doing an Alteryx challenge where you make an App to find how many years, months, weeks, days and hours difference there is between the present and a chosen date. At first I used a Text Box tool as shown: However, it seemed a bit more fitting to use the Date interface tool
Avatar
Fri 08 Jul 2022 | Marcelo Ramos
Spatial Match in Alteryx
With a spatial match, you can create a relationship between two geographical objects. An example of this would be finding points in London city, such as bus stops, that are inside specific London boroughs to then use that for further analysis
Avatar
Thu 30 Jun 2022 | Marcelo Ramos
Cardinality in Tableau Relationships
Cardinality refers to how unique a field is in terms of its values. For example, if every record within a field is unique, then it has perfect cardinality, if there are duplicates present then the field has lower cardinality
Avatar
Thu 16 Jun 2022 | Marcelo Ramos
Tableau: How to create Dynamic Reference Lines
Tableau's true functional beauty comes into play when we bring some helpful tools into play. A dynamic reference line is a reference line that changes which value it rests on without the user having to input a line from the analytics pane
Avatar
Wed 15 Jun 2022 | Marcelo Ramos
Tableau Location dimensions show null values on map
There has been many times where I have become very confused as to why some of my location values won't appear on the map, so here is a possible reminder to me in the future or to a reader who has stumbled upon this blog post. Why are there nulls? Imagine you're indoors on a nice sunny day
Avatar
Wed 08 Jun 2022 | Marcelo Ramos
Hot 4 Hotkeys
A small-ish list of my favoured hotkeys most people can benefit from, if they don't utilise them already!
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2025 The Information Lab