Luisa Bez

Luisa Bez

Luisa Bez

Luisa holds a BSc in Chemistry from Freie Universitaet Berlin and an Msc in Crime Science from the University of Portsmouth. She discovered Tableau while working as Researcher in a management consultancy where it enabled her to support consultants by analysing data in no time. Seeing how colleagues were fascinated by interactive dashboards, made her realise how powerful and accessible Tableau is. After hearing about The Data School she was convinced it would be the best place to master Tableau and Alteryx.

In her free time she enjoys travelling and photography.

Why you should never hard-code in Tableau

Why you should never hard-code in Tableau

If you're a beginner at Tableau, it may be tempting to resort to hard-coding. After all, that's easier than to create complicated calculations, right? I'm going to walk you through an example that demonstrates the downsides of this approach. That being said, let's...

Dashboard Week Day 5 – The End

Dashboard Week Day 5 – The End

Dashboard Week has come to an end and all of DS9 survived! It's been the best week at the DS so far!! Going through presentations, data prep, creating a dashboard, and blogging every day was a fun challenge because I learnt a lot and felt accomplished at the end of...

Dashboard Week Day 4 – Baseball

Dashboard Week Day 4 – Baseball

Day 4 of dashboard week covered yet another sports dataset: 147 years worth of baseball data. Data preparation was fairly simple as we just needed to obtain headers for every column containing our data. Our Alteryx workflow looked like this: We started with a wildcard...

Dashboard Week Day 3 – Food Hygiene Ratings

Dashboard Week Day 3 – Food Hygiene Ratings

On day 3 of dashboard Week we investigated food hygiene ratings across the UK. In order to obtain the data we had load XML files into Alteryx which looked like this: We used an XML Parse tool and included Child Values and Outer XML which returned surprisingly clean...

Dashboard Week Day 2 – How Do Americans Spend Their Day?

Dashboard Week Day 2 – How Do Americans Spend Their Day?

My day started at 7.30am when I took the Tableau Qualified Associate exam. This meant missing out on everyone's day 1 presentations and diving straight into the new dataset. Today's task was to scrape survey data from the Bureau of Labor Statistic's website....

Dashboard Week Day 1 – Prudential Ride London

Dashboard Week Day 1 – Prudential Ride London

The infamous Dashboard Week has started! Today we looked at results of the Prudential London cycling event which took place at the end of July. Their website contains results of every cyclist who took part in the race, including age group, time needed to complete the...

Tip Week #4 – Pareto Charts

Tip Week #4 – Pareto Charts

What is a Pareto Chart? According to the Pareto Principle 'for many events roughly 80% of the effects come from 20% of the causes'. Or, in more practical terms, 20% of your customers/cities/regions are responsible for 80% of your sales. How do you build one in...

Tip Week #2 – Date Calculations

Tip Week #2 – Date Calculations

Date calculations are useful if you want to manipulate dates in your data source. To get you started I'm going to cover five of them in this blogpost: DATENAME DATEPART DATETRUNC DATEADD DATEDIFF Before I dive deeper into each function let me clarify a term I'm going...

Tip Week #1 – Ranked Sort

Tip Week #1 – Ranked Sort

If you've ever used Tableau you're probably familiar with the sort buttons. Clicking them will instantly sort your data in ascending or descending order. And while this is very straightforward in simple usecases, you might come across more complex problems where they...

First DS Project – Alteryx and Custom Regions

First DS Project – Alteryx and Custom Regions

Friday is Project Day at DS and in our first week we were lucky enough to be able to work with a familiar dataset: our application. The task was to supplement the first (or second) viz with additional data. I decided to remake my first viz on UK Tourism as it didn't...