I have always wanted to create a lottery generator, either in Excel, Python, or R. I managed to find this tutorial (first published in 2011) on YouTube which creates a lottery generator using Microsoft Excel and basic VBA code. This tutorial is really well explained, and I was able to create a lottery generator in no time at all.
The image below is my version of the tutorial above. This has been updated though beacause the lottery now lets you pick from 59 numbers, than the original 49.
However, I wanted to create a euromillions generator which is based on chosing from five numbers (between 1 to 50), and two numbers (from 1 to 12) called Lucky Stars. This means that a number can appear twice on one ticket, therefore a modification of the excel spreadsheet neeeded to consider this.
The above is possible to do which requires creating a second rand() column based on the Lucky Stars numbers. The tweak to the VBA requires linking the lucky numbers to the columns in the generator tab using the following code to produce the numbers :
I’ll use this generator to produce some statistics based on actual lotto results.
Data analyst positions require some knowledge of Power BI or Tableau as a way to visualise your data. Typically I used Maps and reports to outline my research, but pivotting into a Data role, it is necessary to learn a visualisation tool so that your data output can be seen by others. Power BI is a microsoft product which is used by many companies, and whilst the software is free to download, publishing your work requires a licence. In contrast, Tableau has a paid and free (public) option so users can get to grips with learning the software and publishing (for free!) a dashboard. So I decided to finally try and create a Tableau Public dashboard using a tutorial published on youtube shown below. Credit to Nestor Adrianzen for publishing this content.
Here is the result of my Tableau Public dashboard.
I love coding, but I have always stuck to R as my master language because I felt so comfortable with it. Although I did learn python during the lockdown of 2020 and upload projects using it to my Github last year, I have tended not to use it that much and I really did need a refresher in it. Whilst more people sign up to coursera or udemy, I have found the courses are freecodecamp to be quite solid in their teaching, Therefore, I have began the Data analysis for Python certificate.
Alongside this, I am refreshing my basic GCSE maths, therefore I thought it was be quite cool to code python alongside this. Today I have uploaded the first of my jupyter notebooks (there are more to come!)
The following link is the one to the github repo containing the first notebook.