Portfolio

A number of projects that I've done over the last year, that showcase the skills I've learned through my data analytics modules. This portfolio includes projects that I've completed using Python, SQL, R, Microsoft Excel and Microsoft Power BI.

The Best Selling Video Games

For my Excel project, I decided to look at a video games dataset that dealt with the most popular/most sold games from the 1980s all the way up until 2020. In this short project, I used basic formulas to get a basic idea or some of the figures I was wondering about. As well as this, I implemented both Vlookup functions and Pivot Tables, which initially I always found the most difficult in using Excel. Finally, I added some basic visuals.

Techniques Used:
Basic Excel Functions, VLookup Functions, Pivot Tables, Basic Excel Visualisations.

Reviewing Footballer Data

For my R project, I decided to look at shooting-related statistics for Premier League players this season, implementing data cleaning, feature engineering, descriptive statistics, inferential statistics, visualisations and machine learning.

Techniques Used:
Data Cleaning, Feature Engineering, Descriptive Statistics, Inferential Statistics, Visualisations, Supervised Machine Learning.

A Look at Housing Data

This project showcases my use of data cleaning, feature engineering, descriptive statistics and machine learning through Python while analysing a housing dataset.

Techniques Used:
Data Cleaning, Feature Engineering, Descriptive Statistics, Supervised Machine Learning, Unsupervised Machine Learning.

Reviewing Students Data

For my SQL project, I decided to look at a student data set - containing info such as their college grades, stress levels and expected salaries. I started by implementing data cleaning through Jupyter Notebooks before using basic functions to get information on the students.

Techniques Used:
Data Cleaning, SQL Table Creation, SQL Basic Functions.

Blackbird Analytics with Power BI

This repository hosts a Power BI project designed to provide a comprehensive overview of Blackbird, a US-based wholesaler. This Power BI file is intended to provide information and guidance for the managers of Blackbird. This project leverages Power BI to visualise and analyse data related to Orders Data, Sales and Product Analysis, Geographical Insights, and Operational Insights.

Techniques Used:
Interactive Dashboards, Visualisations, Q&A Tools.