Setting up a server with Amazon RDS

I have been using my computer to store my data when working with PostgreSQL up until now. To get experience with using a cloud-based server setup I am going to create and connect to a server provided through Amazon Web Services (AWS). Continue reading “Setting up a server with Amazon RDS”


Tourists Visiting Brazil – Part 1

Undeniably discouraged from my previous romp in creating my own  I decided to pull my next data set from Kaggle. Kaggle is a website that hosts competitions for machine learning. When I’m more experienced I’d like to jump in and try one. For now, I went over to the data set collection they have there. After spending a couple weeks visiting Italy, I was in the mood for tourism data. My choice was the Tourists Visiting Brazil data set which contains lots of fun information about tourism to Brazil from 1989 to 2015.  I downloaded the CSV file, and got to work.

Continue reading “Tourists Visiting Brazil – Part 1”

French Word Frequency – Part 1

I decided to jump in and start working on my first project. In my last post I said I was going to use Microsoft SQL Server. However, based on some advice I ended downloading and using PostgreSQL, an open source application, because enterprises like things to be free as much as I do. It had a windows installer and my only problem with installation was with
the port it was trying to listen to, but a quick google solved that. Continue reading “French Word Frequency – Part 1”

Blog to demonstrate technical skills

In the past month I have started learning skills for a future career in data analysis. I completed my Bachelor degree in Psychological Science at the University of Queensland. In contrast to many of my peers, I enjoyed the large statistics component. My favourite part of completing my thesis was extracting meaning from the data I collected, using SPSS.

Since I would like to work in analysing data in the future, I decided to supplement my statistical knowledge with practical computer Continue reading “Blog to demonstrate technical skills”