Melvin Quashie | Data Anlayst

Melvin Quashie

Data Anlayst

Based in Accra, Ghana

About

I am a dedicated data enthusiast looking to be hired, with a strong self-taught background in SQL, Excel, Tableau, and Python for data analysis. I possess a keen interest in uncovering meaningful insights from datasets and leveraging various tools to extract actionable information. My self-driven learning approach has equipped me with a solid foundation in manipulating data and generating valuable visualizations. I am enthusiastic about utilizing my skills to drive informed decision-making through comprehensive data analysis.

Skills

Projects

SQL Analysis on Video Game Ratings

Given the Video Game Ratings and Reviews Dataset from Kaggle, I carry out exploratory to get meaningful insights and prepare an interactive dashboard that filters out by the year and the video game platform. More information can be found in the README.md on GitHub.

Premier League 2022/2023 Season Data Analysis

With 2 datasets retrieved from Kaggle, 2022-2023 Football Player Stats & Premier League Stats 2022-2023, and using PostgreSQL explorer, meaningful insights such as the points and goal distribution across the league were found. More information can be found in the README.md file on GitHub.

Consumer Behavior and Shopping Habits

Given the history of consumers, using Jupyter Notebooks, exploratory data analysis was carried out to gain insights into purchase patterns, subscriptions & loyalty, shipping preferences and others.

Experience

2020 - Present

Service advisor at CFAO Ghana PLC

Received jobs directly from customers for the machine and equipment workshop. Prepared estimates and invoices as well as inputted and manipulated data to gain insights into customer and vehicle history.

Education

2015-2019

Mechanical Engineering at Ashesi University

Besides studying Mechanical core subjects such as Material Science and Thermodynamics, I also studied Engineering Statistics and Calculus at a University level. I also got some experience using Python.

2022

SQL for Data Analysis from Udacity

Studied concepts and carried out numerous examples and quizzes on the practical use of PostgreSQL. - General statements. - Entity relationship diagrams. - JOINS. - Aggregations. - Date functions. - Subqueries and Temporary tables. - Common Table Expressions. - Data cleaning tools. - Window functions. - Unions.