Skip to content
View thanhvu911's full-sized avatar

Block or report thanhvu911

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
thanhvu911/README.md

Hi, I'm Thanh Vu

Data Analyst Fellow @ EDC Lancaster County · B.A. Computer Science, Franklin & Marshall College (2026) · Microsoft Certified: Fabric Data Engineer Associate

I build data pipelines, warehouses, and BI models that turn raw public and business data into decisions people can act on.

Portfolio · LinkedIn · Email


Featured work

Project What it shows Stack
Can Mail Data Predict Housing Vacancy? Lakehouse ingestion → Dataflow Gen2 → semantic model → Power BI; tests whether USPS mail data can stand in for Census vacancy rates across 6 counties and 15 years Microsoft Fabric, Power Query M, DAX, Power BI
Grocery Transaction Data Warehouse Bronze → Silver → Gold warehouse with stored-procedure ETL, data-quality tests, and a documented star schema SQL Server, T-SQL
Lancaster Economic Indicators Dashboard Multi-fact Power BI model benchmarking Lancaster County against Pennsylvania and the U.S. on labor, GDP, and wages Power BI, DAX, BLS / BEA data
Sales Planning Analysis Galaxy-schema model comparing actual sales against plan by store, product, and region Power BI, DAX, SQL Server
RFM Customer Segmentation RFM scoring in DAX that maps customers to segments and recommended actions Power BI, DAX
Bank Transaction SQL Analysis Data validation, cleaning, and exploratory analysis in T-SQL SQL Server

Toolbox

SQL Server Python Microsoft Fabric Power BI DAX R Google Apps Script

Focus areas: ETL/ELT · dimensional modeling (star and galaxy schemas) · Medallion architecture · data quality · semantic models · BI for decision-makers

Certifications

  • Microsoft Certified: Fabric Data Engineer Associate (DP-700), 2026
  • HackerRank SQL (Advanced), 2025

Pinned Loading

  1. can-mail-data-predict-housing-vacancy can-mail-data-predict-housing-vacancy Public

    Microsoft Fabric + Power BI pipeline testing whether USPS mail data can predict Census housing vacancy (6 counties, 2010–2024).

    Power Query

  2. grocery-transaction-data-warehouse grocery-transaction-data-warehouse Public

    SQL Server data warehouse (Medallion: Bronze → Silver → Gold) with stored-procedure ETL, a star schema, and data-quality tests over 131M+ rows.

    TSQL 1

  3. lancaster-economic-indicators-dashboard lancaster-economic-indicators-dashboard Public

    Power BI dashboard benchmarking Lancaster County vs. Pennsylvania and the U.S. on jobs, GDP, and wages using BLS and BEA data.

  4. sales-planning-analysis sales-planning-analysis Public

    Power BI dashboard comparing actual sales vs. plan by store, product, and region on a galaxy-schema model (58K+ transactions).

    1

  5. decision-trees-information-theory decision-trees-information-theory Public

    CPS 372 decision-tree paper (co-written, Fall 2024) plus an AI-assisted follow-up study testing its claims on the Adult census data

    Python 1

  6. machine-learning-coursework machine-learning-coursework Public

    Machine learning coursework (CPS 360): k-means, linear and logistic regression from scratch, plus an AI-assisted review that re-checks every claim against the printed output

    Jupyter Notebook 1