About Me
- Hi, I’m Vincent Diep!
- The purpose of this site is to showcase the projects that I find meaningful.
- The best way to reach me is through my email : vincentdiep99@gmail.com
Data Projects
- Northwind Sales Analysis
- Analyzed 11 years of Northwind Traders sales data using SQL, writing queries with multi-table JOINs, aggregations, subqueries, and date functions to answer 5 business questions.
- Identified that 4 product categories drive 62.75% of total revenue and that underperforming products share a common trait of low unit price rather than low demand.
- Visualized findings in Google Sheets dashboards and documented analysis in a public GitHub repository with structured query files and annotated README.
- Movie Data ETL Pipeline
- ETL script made using Python.
- Database made using PostgreSQL.
- Proxy University Database
- Queries written in SQL.
- Database made using MySQL.
- Formerly hosted using PHP and HTML on CSUF server for students.
- COVID 19 Data Analysis
- Data cleaning and analysis done with R and RStudio.
- Machine Learning Models
- Utilized various machine learning models to analyze datasets.
- Models: KNN, Random Forect Classification, Decision Tree Classification, Kernel SVM,
K Means, Linear Regression, Polynomial Regression, XG Boost, Naive Bayes
Documentation Projects