Portfolio

Tech Stack: SQL, PostgreSQL, window function, sub-queries, join

Applied basic and advanced queries to analyze the data
Gained valuable insights to compile strategic recommendations from a large dataset

Tech Stack: SQL, PostgreSQL, relational database, DML, DDL, Normalized Database Migration

Investigated provided data model for potential errors (lack of normalization, consistency rules, and proper indexing)
Created a new, normalized database using DDL based on the denormalized one that is provided
Wrote DML queries to migrate the data from the denormalized schema to their normalized schema

Tech Stack: Jupyter Notebook, Pandas, Numpy, Matplotlib, Seaborn, Data Wrangling, Data Exploration (EDA), Data Visualization

During this Udacity project, I investigated TMDB movie dataset which contains information about 10,000 movies. After data analysis steps of data wrangling, and EDA, I provided some useful insights about the data set through answering these following questions with visualizations:

Which genres are most popular overtime ?
What are time series of top 5 movie genres?
What are factors associated with revenue levels?

SQL Chinook Music Database Queries - Powerpoint Presentation

Tech Stack: SQL, SQLite, Aggregation, Sub-queries

In this project, I pulled data using SQL queries from Udacity’s Chinook music store database to answer and build visualization into Powerpoint Presentation.

Youtube Data Visualization Dashboard

Tech Stack: Tableau, Calculated fields, Filter, Sheet Views, Dashboard, Parameters, Functions

In this project, I created visualizations to reveal insights from YouTube video data set. Data visualizations include a Tableau dashboard and relevant worksheets that highlight patterns, such as tag trending and interactions of users with various categories.

NYSE Dataset Investigation - Excel file

Tech Stack: Excel (PivotTable, VLOOKUP, MATCH, INDEX, Data validation, Descriptive Statistics), PowerPoint

During this project, I analyzed New York Stock Exchange data using Summary Statistics and communicated findings with visualizations. The main goals for this project is to:

create a dashboard for Profit and Loss Statement populating automatically with each selected company
create a financial forecast model with three scenarios (best case, base case, and weak case).

Certificates

SQL Nanodegree (Issued by Udacity)
Business Analytics Nanodegree (Issued by Udacity)
Data Analytics with Pandas and Python (Issued by Udemy)
Python Data Structure (Issued by Coursera)
Data Visualization (Issued by Kaggle)
Using Databases with Python (Issued by Coursera)