Leonardo Deras

COVID-19
Data Exploration in SQL

Skills

- Aggregate Functions		- Converting Data Types		- Temp Tables

- Creating Views		- Joins				- CTEs

In this project I explore COVID-19 deaths and vaccination data with the purpose of creating a data visualization in Tableau to showcase the skills I acquired through my Cousera certification. I began by importing (.xlsx) Excel data into SQL then spending some time creating different views from the COVID death table. I sorted out data by highest infection rates (country), highest death counts (continent), and percent population infected over time (country). After finalizing the views, I imported data back into Excel (because Tableau Public doesn't let me do it through SQL directly) with the purpose of creating a Tableau dashboard to visualize my findings.

Nashville Housing
Data Cleaning in SQL

Skills

- Alter Table		- Substrings		- Update Table

- Parsename		- CASE Statements	- Drop Column

In this project I take raw data from a Nashville housing database and transform it in SQL to preapare it for analysis. Originally, the data came in the form of an (.xlsx) Excel file which I then imported into SQL. The purpose of this project was mainly to showcase my data cleaning skills by separating address columns, filling in NULL values, standardizing column data and deleting unused columns while experimenting with temp tables.

Tableau Projects

This link will display the Tableau Public dashboard for my COVID-19 project and for upcoming projects as well.

Contact Me

I am availabe most days from 8am - 4pm CST. 
If I'm unavailable, please leave a voicemail.

Phone: Refer to LinkedIn
E-mail: l.deras@yahoo.com
Address: 1200 Wilson Rd Conroe, TX 77301

• Linkedin
• Github

Elements

i = 0;

while (!deck.isInOrder()) {
    print 'Iteration ' + i;
    deck.shuffle();
    i++;
}

print 'It took ' + i + ' iterations to sort the deck.';