Data Portfolio Projects

This repo consists of data analyst portfolio project that I haved worked and currently working on.

I'm currently exploring SQL, Tableau, R, Google Cloud and Python.

List of Projects:

1. Covid Data Analysis

• Used SQL to analyze Covid related data from https://ourworldindata.org/covid-deaths
• Techniques used: Join, CTE's, Temp Tables, Windows Funcions, Aggregate Functions, Creating Views, Converting Data Types

2. Covid Data Visualization

• Used SQL to create queries for visualization
• Used Tableau to visualize analysis in Covid Data Analysis Project
• Dashboard can be found here.

3. Nashville House Data Cleaning

• Used SQL to clean Nashville House Data
• Technique used: Joins, Alter, Update, CTEs, Case

4. Amazon Web Scraping

• Used Python to scrape data from an Amazon Product Page
• Export data scraped into a csv file

5. GDSC Excel Workshop

• Intermediate Workshop on Excel for individuals want to maximize their Excel speed
• With a video to go over the sheet

6. Intern Search Statistics

• Summarized statistics of own personal job search for summer 2022
• Cleaned data using Excel
• SQL Techniques used: Join, Temp Tables, Window Functions, Aggregate Functions
• Used Tableau to visualize finding

7. Google Maps Query Visualization

• Performe geospatial queries against a Google BigQuery Table
• Present visual interface for the queries and the results using Google Maps Platform's Maps JavaScript API
• Technologies/Languages Used: Google Cloud Console, JavaScript, SQL, HTML, CSS