Mark Anthony Mendaña
Portfolio

Data Analyst proficient in SQL, Microsoft Excel, Tableau, Power BI @MarkAnthony

Data Cleaning
In SQL

In this project we take raw housing data and transform
it in SQL Server to make it more usable for analysis

Covid19
Data Exploration

We explore the dataset with different queries to find out what is the percentage of total cases over the population, total number of deaths over population.Differences in the population size between countries are often large, and the COVID-19 death count in more populous countries tends to be higher.

Financial Analysis

This is one of the projects I've done in taking courses in Corporate Finance where I created Finance Modeling and Finance Analysis based on real investment banking.

SQL Creation Of
Company Database

With the freecodecamp tutorial I created a company database using MySQL and PopSQL. I learn how to use schema design, basic C.R.U.D operations, aggregation, nested queries, joins, keys and much more.