Dang-Uy

Nguyen

Click Icon for LinkedIn

Welcome

Data Analyst

This website is to showcase my skills, achievements, and portfolio as I navigate through my career. Here you will find my resume, my contact information, and a collection of my projects (scroll down to see) .

Please feel free to contact me via email, number or connect with me on LinkedIn. Thank you for visiting!

Projects

Welcome to my portfolio of projects.

Please click the image to view the project.

Comparative Quality of Life Analysis: Baltimore City vs. Baltimore County Children

Cleaned datasets using Microsoft Excel and Python in Jupyter Notebook to optimize for analysis
Utilized Python in Jupyter Notebook to visualize data through graphs and bar charts
Applied Python for statistical calculations and array creation
Presented analysis and insights via Google Slides to communicate results to stakeholders

Multifactorial Analysis of Patient No-Show Rates

Wrote DAX formulas in Microsoft Power BI to create new No-Show_Percentage column, Age_Bracket column, and No-Show_Percentage by neighborhood measurement
Visualized data and integrated them into an interactive dashboard for hospital clients
Summarized insights found from dashboard

Seattle AirBnB Tableau Project

Utilized Tableau to create interactive data visualizations using Seattle AirBnb data
Designed a dashboard by integrating multiple visualizations
Presented dashboard to client with interest in owning an AirBnb property in Seattle with market insights and recommendations

Bike Sales Dashboard

Utilized Microsoft Excel to prepare and clean raw bike sale data.
Constructed multiple Pivot Tables of cleaned data.
Created visualizations of bar charts and line graphs based on Pivot Tables
Integrated the visualizations and slicers in a dashboard
Presented dashboard to bike shop owners with insights on their bike sales and their customers.

Layoff Data Cleaning Project in SQL

Utilized SQL to clean data about company layoffs to optimize for analysis
Removed duplicate data, standardized the data, remove blank/null values, and deleted any unnecessary rows and columns
Wrote queries, delete, insert, update, join statements to perform data cleaning tasks

Data Professional Survey Dashboard

Leveraged Microsoft Power BI's Power Query to transform data and prepare for visualizations
Utilized Power BI to visualize data through tree map, stacked bar chart, cards, gauges, donut chart, and stacked column chart
Presented dashboard to client with interest in a career in data

Collaborated in a Team of 4 to Develop Mobile Parking Payment Database System

Designed SQL database schema including table creation and sample data insertion
Developed two functionalities using PL/SQL
- Feature 5: Identify and list all vehicles with active parking sessions at their designated zone
- Feature 8: Procedure to terminate a parking session with session ID and current timestamp inputs

Project