Hesham Eissa

Hesham Eissa

Hesham Eissa

After completing his 5 years in Petroleum and Petrochemical Engineering, Hesham wasn’t sure what to do. Wanting a bigger challenge, he decided to come to the UK to do his MBA at Coventry University London Campus. Hesham worked afterwards in a Strategy Consulting company for 1 year helping out Private Equities. Realizing that his favorite part was his minimal exposure to quantitative data, however he was fed up of staying late hours changing rows and columns on Excel and creating maps on Powerpoint. When he came across The Data School he was instantly hooked on the idea of presenting data in a creative and accessible format and found that The Data School is the best place for him to develop his skills, grow and become more creative.

Dashboard Week: Day 5

Task https://www.thedataschool.co.uk/andy-kriebel/day-5-powerlifting/ Data Prep Luckily today we didn't have to do any data prep - most probably because we had to be finished with the dashboard and blog post before 1 PM The Viz For today's viz - I wanted to compare...

Dashboard Week Day:4

Task https://www.thedataschool.co.uk/andy-kriebel/day-4-candy/ Data Preparation To prepare the data we were only allowed to use Tableau Prep Builder. Given that the data was coming from a survey - I decided to focus only few fields and ended up with 4 columns instead...

Dashboard Week: Day 3

Task https://www.thedataschool.co.uk/andy-kriebel/day-3-solar-system/ Data Preparation Getting the data today was quite easy and smooth. we only had to insert an API endpoint and all the data was listed nicely on Alteryx. Luckily we didn't need to do any pagination -...

Dashboard Week: Day 2

Task https://www.thedataschool.co.uk/andy-kriebel/day-2-battlefield-sites/ Data Preparation To get the data, we had to web scrape Historic UK website to get all the data for all battle fields in the UK. Webscraping the data was quite challenging because most of the...

Dashboard Week Day 1

Task https://www.thedataschool.co.uk/andy-kriebel/day-1-ufo-sightings/ Getting the data We had to web scrap the data from National UFO Reporting Center website for all years since 2008 until 2019. The process wasn't too complicated and we were able to get the data...

Tableau Quick Tip: Unfix your axes with one click

In this Tableau quick tip I am going show you how to dynamically spread your line chart. People often have a parameter that allows them to select different metric over time. Sometimes, someone hands a workbook to you where the axes are all fixed and when you start...

Step by step guide into creating a Macro

What is a Macro? A Macro is a group of tools that are grouped together into a single tool. In Alteryx there a 4 types of macros: Standard Macro: runs only once – used when the exact same process is repeatedBatch Macro: repeats the process for each incoming field into...

Calculating Minimum Dates Without Using LODs

Usually, to calculate the minimum date you would use an LOD calculation to get it – the equation would be {Fixed [Dimension] : Min([Date])} and in case you want to get the minimum date for the whole dataset (to the lowest level of detail) you would use {Min ([Date])}....

Top tips for project management

DS14 had the chance to do their first client project 2 weeks ago. Luckily, I was the project manager of our first project and in this blog post I will be sharing with you our experience and some of the lessons I learned as a project manager. In case you are not...

How to create a Pareto chart?

For those who aren’t familiar with Pareto principle which is also known as 80/20 rule, the idea is that by doing 20% of the work you can generate 80% of the benefit of doing the entire job – therefore businesses frequently use it to solve problems so they can...

Tableau Server Structure

This week we were introduced to Tableau Server by Ravi. We started by understanding the structure of Tableau Server, as shown below: The way I understand it, we have 4 levels: Level 1: Sites Sites are like partitions or hosts. There is no communication between...

Dashboard Project 2: Exasol Database

On Friday DS14 were given a task at 9:00AM to create a dashboard via an external database, Exasol. The task was to sketch our dashboard on a piece of paper by only looking at the fields in the metadata (as we were not allowed to interact with the data beforehand),...