Keren Aharon

Keren joined the Data School after graduating with a Bsc in Biomedical Sciences and a MSc in Pharmacology at the University of Bristol. Most of her university work focused on scientific data analysis using RStudio, SPSS statistics and Matlab. This sparked her passion for data interpretation and presentation which led her to exploring a career in data analysis. Shortly after graduating, Keren came across the Data school and was immediately drawn to Tableau!

In her free time Keren is involved in organising Jewish events through the UJS, cooking and spending time with her friends and family.

Blog Posts

Avatar
Fri 02 Aug 2024 | Keren Aharon
Nested Sorting in PowerBI
Nested sorting in Power BI refers to the process of sorting data within multiple levels of a hierarchy or within multiple columns simultaneously and can be useful in loads of different scenarios. How nested sorting works: * Primary Sort: The data is first sorted by the primary column
Avatar
Fri 27 Jan 2023 | Keren Aharon
Dashboard Week Day 5: Survival
Todays challenge was to analyze data from the tv show survival. The data was relatively clean so it gave us a lot of time for creativity. However, the way that the presentation is planned involves providing explanations and justifying why we chose each chart
Avatar
Thu 26 Jan 2023 | Keren Aharon
Dashboard week day 4 - Server
Todays challenge was to download the candy datasets from 2014-2017 and prep and analyze them in the server. Firstly I imported the data into the server and decided how I would union the tables
Avatar
Wed 25 Jan 2023 | Keren Aharon
Dashboard Week Day 3: Rick and Morty API
For todays challenge we were meant to use Alteryx and APIs to get data from the Rick and morty API website. This was very challenging as we were not taught APIs yet and needed to use this to extract the information from the website
Avatar
Tue 24 Jan 2023 | Keren Aharon
Dashboard Week Day 2: Power BI
For today's task, we were each given a dataset and were instructed to create a KPI dashboard using Power BI. After having only a few hours of experience with this software this was a big challenge and would require some time to become familiar with the tool again
Avatar
Mon 23 Jan 2023 | Keren Aharon
Dashboard Week Day 1: Accessibility
Today we learned all about data accessibility. We were given information on all the considerations and techniques we can use to accommodate as much of the population as possible
Avatar
Thu 19 Jan 2023 | Keren Aharon
How to Create a Dynamic Bar Chart Showing the Top and Bottom N Values in Tableau
Follow these simple steps to show the the top and bottom N values on the same chart (as shown below) using parameter actions! In this example, we are looking at the sales value for each subcategory. 1
Avatar
Thu 19 Jan 2023 | Keren Aharon
How to Prepare for the Tableau Certified Data Analyst Exam
Avatar
Mon 09 Jan 2023 | Keren Aharon
Highlighting Fields Using Set Actions in Tableau
Often it is useful to highlight specific fields in your dashboards using colours. In this example, when you click on a category from one sheet it will highlight the same category from the other sheet. Once you have created the charts, right-click on the field you have chosen and create a set
Avatar
Tue 10 Jan 2023 | Keren Aharon
Placement Interview Tips
After collecting information from previous placement DSers, here are some examples for placement interview questions that often come up
Avatar
Thu 29 Dec 2022 | Keren Aharon
Tips for Data Discovery Using Alteryx
Before starting a data analytics project its important to make sure that you fully understand the data by doing as much data discovery as possible. Data discovery will allow you to detect patterns and answer specific questions based on your project aims
Avatar
Sun 11 Dec 2022 | Keren Aharon
How to use the Trade Area tool in Alteryx
The trade area tool is found in the spatial tab in Alteryx and is used to create specified regions around a spatial point. In the configuration pane, select a column that contains the spatial object point. You can choose whether to keep this field in your output
Avatar
Wed 28 Dec 2022 | Keren Aharon
How to Use the Spatial Match Tool in Alteryx
The spatial match tool allows you to establish a spatial relationship between two spatial objects, referred to as "target" and "universe". This tool contains two input anchors. 1. The known spatial object is referred to as the target. 2. The unknown spatial object is referred to as the universe
Avatar
Fri 23 Dec 2022 | Keren Aharon
My experience as Project Manager
Being project manager was a very unfamiliar experience which I found extremely challenging but equally valuable. Prior to this week, I reflected on previous PMs and how they organized our cohort, considering what was helpful and what was not
Avatar
Fri 02 Dec 2022 | Keren Aharon
How to turn off all grid lines in Tableau
If you have ever used tableau its safe to assume you have spent a long time formatting grid lines. Two months into training I have learnt that you can turn all grid lines off with one button! Click on Format and then workbook Click on grid lines at the bottom left
Avatar
Fri 02 Dec 2022 | Keren Aharon
Learn What the Data School Learns - Alteryx Favourites
This week my cohort (ds35) were involved in teaching the public about Alteryx and Tableau. Here is what I want to share about my experience teaching the public and how I went about planning my session
Avatar
Tue 22 Nov 2022 | Keren Aharon
How to change the name and icon of your macro tool in Alteryx
If you have ever saved a macro file in alteryx with an incorrect or unclear name, it can make the use of this macro confusing for future use. To change the name of the macro click on the canvas and go to the configuration pane in the 'meta info' tab
Avatar
Mon 21 Nov 2022 | Keren Aharon
How To Manually Adjust the Moving Average Value With a Parameter in Tableau
Often you need to add a moving average to your line chart in tableau. Sometimes it can be useful to make the moving average adjustable for the user to change. Firstly, create your line chart. Drag the measures onto your columns and rows and change the mark type to line if it is not already
Avatar
Wed 16 Nov 2022 | Keren Aharon
Tips for #MakeoverMonday
Having to analyse and improve a data visualisation in 1 hour is overwhelming and hard to know where to start. Here are some key factors to consider when participating in a Makeover Monday
Avatar
Fri 04 Nov 2022 | Keren Aharon
How to Create Donut Charts in Tableau
The first step when making a donut chart is creating a normal pie chart. Drag your desired fields and change your mark type to pie. The next step is to create 2 dummy fields in the column by typing in 'avg(0.0)' and duplicating it
Avatar
Wed 02 Nov 2022 | Keren Aharon
How to Prepare for your Final Interview Presentation for The Data School
So you've just got into the final stage of interviews for the data school, congrats! You have probably spent hours and hours on your dashboard and now wondering how to begin preparing for the interview presentation. So here are my key tips
Avatar
Wed 26 Oct 2022 | Keren Aharon
How to Add a Dynamic Reference Line Using Parameters in Tableau
Reference lines are a useful feature which can be used to compare, refer to, or measure against the data values displayed in a graph. Reference lines are often used to show whether data has met a certain target
Avatar
Tue 04 Oct 2022 | Keren Aharon
Tips for applying to the Data School UK: A Tableau Beginner's Guide.
Avatar
Tue 18 Oct 2022 | Keren Aharon
The difference between Transpose and Cross-Tab tools in Alteryx
The transpose and cross-tab tools are two pivoting tools found in the transform menu in Alteryx. Pivoting data allows you to rearrange columns or rows in your dataset in order to view your data from a different perspective
Avatar
Thu 13 Oct 2022 | Keren Aharon
Two things I would change about my original application!
Changing tooltip colours based on conditions. One thing I wish I knew during my initial application was how to manually change the colour within the tooltip for certain variables so if the number is above a certain value it shows green and if it does not then red
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