Soha Elghany

Soha Elghany

Soha Elghany

Soha is a psychologist that developed an intrigue for data during her MSc in psychosis. She conducted a research study into factors affecting sense of presence in a virtual reality social environment, which has been submitted to the journal of Cyberpsychology, Behaviour and Social Networking. This was Soha's first insight into the impact data and research can have, and she wanted to be able to answer more complex in-depth questions with data. Her experience encouraged her to explore a career within the data field and led her to encounter Tableau, and the integral role of storytelling in data can have.

Outside of her passion for data, she is a future yogi that enjoys expressing her creativity through her art and losing herself in fiction.

Tips for the Tableau Desktop Qualified Associate exam!

I recently took the Tableau Desktop Qualified Associate exam and passed after 2 months of training at the data school, so I felt compelled to write a quick guide about the resources I utilised. Taking the exam was a great confidence booster in my knowledge and it's...

How to visualise missing dates? #tableautip

I'm going to show you 2 different ways you can show a gap between your missing values in your time series graph. In my example below I wanted to show the gap in time for WWII because the winter Olympics didn't happen in that time period:     The first way to show this...

Dashboard week: calculating distance

Friday marked the last day of dashboard week the dataset was about the locations of the bathrooms in the city of Vancouver, there was a time limit to produce something insightful in a visualisation. So I went with the idea of calculating the distance between Vancouver...

Dashboard week: knowledge is key

For today's dashboard week we received data about major league baseball containing 147 years worth of baseball data from the retrosheet. This was also parsed using the XML tool and we had to use the data dictionary to match the header to the corresponding values. Data...

Dashboard week: finding a story

Day 3 was food hygiene data from the food standard agency first we had to download the data and XML parse it because the data is in XML like this: We used an XML Parse tool and included Child Values and Outer XML to include all the data in the outer XML code and inner...

Dashboard week: decoding the data

How do Americans spend their time was our dataset this week from Andy Kriebel since 2003, the Bureau of Labor Statistics sponsored the American Time Use Survey who asked thousands of people aged from 15 years and older the question: How do you spend your time? One...

Dashboard week: generate rows to get more results

For dashboard week: day 1 we had to web scrape the results table of the Prudential ride London from their official site: https://results.prudentialridelondon.co.uk The first step was to be able to download and access the data was to use Alteryx and build a workflow...

Calculating working business hours in Alteryx

The most common request you will receive is to calculate something based on work hours especially concerning questions around productivity, hours and sales. Laine has a detailed blog post on Part 1 of calculating business hours which you can access: here I will be...

All about parameters: part 2 #tableautip

In this tableau tip, I'm going to show you how you can link 2 parameters together and get them both to operate together just like in the image below. So for this example, I used the superstore data I calculated 'day of year' by using this calculated field:  ...

All about parameters: part 1 #tableautip

What is a parameter? Parameters are a dynamic field that offers the user the ability to interact with your dashboard, it also adds a degree of flexibility to your dashboard. How is a parameter different from a filter? You can filter a dimension or measure and this...

How to create dots at the end of your line #tableautip

In this tableau tip I'm going to show you how to create dots at the end your line graph using the Superstore Sales data in this example: A Line Graph is one of the most frequently used graphs to show trends and analyse how the data has changed over time. When you have...

Blacking out your map #tableautip

For this map in Tableau, I want to show the top 3 ranked states by region that had the highest amount of profit. For the rest of the states that were ranked below the top 3, I wanted them to be blacked out.

Understanding Alteryx as a SQL user: part 1

SQL is one of the most common programming language used for designing, managing and analyzing data. However, it is one of the most complex programming languages to work with and can be incredibly time-consuming and frustrating especially when your query will not...