Aileen McDonald

CodeClan

Aileen works as an instructor at CodeClan, Scotland’s digital skills academy, teaching on the data analysis course. She has a passion for all things data and being able to convert spreadsheets into insights and value for organisations. She is particularly interested in data in the third sector and has volunteered data skills to local Scottish charities, as well as being a DataKindUK volunteer. Aileen previously worked as a trainee actuary in a pensions and investment consultancy and qualified as an Associate of the IFoA. She also worked as an Analytical Consultant at a customer analytics consultancy.

11:55 - 13:25

Wednesday 12 May

How to use - Tableau

Tableau is one of the leading tools for building interactive dashboards. This is a practical workshop aimed at those who have no/little experience in Tableau. Starting with some fake service user data held in spreadsheets we will work through building an interactive dashboard that looks to answer some key questions for a social change organisation. The aim is by presenting the data in an engaging and easy to read format the organisation can more easily gain insights leading to making data driven decisions. 

 

If you ever find yourself producing the same graphs over and over again in Excel for reports, then this workshop could be for you.

 

If you plan to follow along (which is definitely encouraged) please download the Tableau Public programme before the workshop (https://public.tableau.com/en-us/s/download). If it is possible, a 2 screen/device set up is optimal (one screen to watch the workshop and another to follow on your own Tableau programme) but it is definitely not a necessity!

15:25 - 16:55

Wednesday 12 May

How to use - Excel

Are you looking to increase your confidence in using Excel, and get quick insights from your data to answer organisational questions? This workshop will cover data layout, sorting, filtering and basic data manipulation. We’ll also look at basic formulas, making charts, and tips for designing your spreadsheets to make them easy to follow.

 

If it is possible a 2 screen/device set up is optimal (one screen to watch the workshop and another to follow on your own Excel) but it is definitely not a necessity!