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”
In which I start querying the data.
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.
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”
After finishing Datacamp’s Introduction to Python course I decided to jump back to SQL and practice with some real data. I was quickly pulled short with the realisation that I needed to take a couple step backs in my SQL learning and improve my understanding of databases. Khan academy had taught me about the language, but not about how I could actually use it.
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”