Hong Mai Portfolio

Data Analyst skilled in SQL, Tableau, Power BI, Python @Hong Mai

Data Cleaning in SQL

Cleaned and standardized 8,000 records from the Nashville Housing Data table in SQL Server by formatting dates, splitting addresses, converting indicators, and removing duplicates. Data is available on GitHub .

CUSTOMER SALES ANALYSIS IN POSTGRE SQL

Analyzed a database with three tables (sales, customer, product) using PostgreSQL to calculate metrics like AGV and total sales, and identify top customers, products, and regional trends with SQL techniques (GROUP BY, WITH, JOIN). Data is available on GitHub .