Angelos Mertsemekis
Portfolio
BI/Data Analyst well versed in SQL, Python, Tableau, Power BI
Enthusiastic Data Analyst and dedicated employee with integrity, strong work ethic and great leadership skills. Skilled at Python, Mathematics and Data Science. Eager to pursue entry-level positions in the Data Analysis field.
Being highly attentive to detail, I strive for accuracy and consistency in my daily individual performance, team contributions, and task completion. Further, I offer collaboration, critical thinking and scheduling flexibility.
I graduated from University of Ioannina with a Bachelor of Science in Mathematics and I am currently studying Master of Science in Bioinformatics at Ionian University.
I have been working as a Mathematics Tutor since 2014 and in 2020 I completed my internship as Web Developer. In 2021 I was trained as a BI/Data Analyst by an IT coaching service. With the skills I acquired I completed the following projects.
In this project I explored weather data with Python
I completed this project to practise on the pandas library
In this project :
In this project I take hotel data and I create one table joining the worksheets on the keys in SQL Server. Finally I load the data on Power BI and build the report
In this project I take raw housing data and transform them in SQL Server to make them more usable for analysis.
I extract google AppStore data from the web, using the request library, and I create a DataFrame with them. Afterwards, I clean the data filling the missing values, renaming the columns and changing the datatypes. I insert the data in a table at MySQL Workbench and I create visualizations in Tableau.
In this project I ectract Covid-19 data from the website worldmeter.com and I clean them
I extracted the data using the libraries request and bs4 (BeautifulSoup)
I completed the capstone project of this certificate using Python instead of R and I created a story with conclusions and recommendations in Tableau.
In this project I downloaded the survey results, which was conducted by StackOverflow. I used the data of this survey, to find what technologies, programming languages and databases are being used by the developers/professionals of the data analysis field.
I searched for a case study in Kaggle. The main objective was to identify the profile of the typical customer for each of the three products. I examined my dataset carefully, I asked questions to solve the problem and I answered them using Python.