Data Analyst / Product Analyst Portfolio

Building analytics tools that turn messy data into clear decisions.

I build analytics projects using SQL, Python, Streamlit, Tableau, JavaScript, and dashboard design to help stakeholders understand trends, risks, and opportunities.

View Projects Download Resume GitHub
Data pipeline illustration showing extract, clean, analyze, and visualize workflow
SQL Excel Python Streamlit Tableau Power BI Pandas Plotly JavaScript
4+ Analytics Projects
6,000+ Healthcare Encounters Analyzed
SQL + Python Analysis Workflow
Dashboards Streamlit & Tableau

About Me

I’m an aspiring data/product analyst focused on building practical analytics tools and dashboards. My projects combine business questions, data cleaning, KPI design, visualization, and technical implementation.

Portrait of Andy Nguyen

How I Approach Analytics Projects

My projects follow a practical analytics workflow from raw data to stakeholder-ready insights.

01

Define the Question

Start with the business problem, user need, or decision the dashboard should support.

02

Prepare the Data

Clean, join, validate, and structure the data so metrics are reliable and repeatable.

03

Build Metrics

Define KPIs, filters, cohorts, and logic clearly so stakeholders know what each number means.

04

Visualize Insights

Create dashboards, charts, and tables that make trends, risks, and opportunities easier to understand.

Featured Projects

Selected analytics projects focused on dashboards, automation, SQL, and product insights.

⭐ Featured Project
Live Dashboard Case Study

Patient Outcomes Product Analytics Dashboard

Patient Outcomes Product Analytics Dashboard preview

Built an interactive healthcare analytics dashboard using Synthea synthetic patient data to explore patient cohorts, utilization, conditions, medications, claim cost trends, and readmission proxy logic.

  • Defined KPI logic for utilization, readmission proxy, active conditions, and claim cost.
  • Built stakeholder-facing dashboard pages for executive overview, risk, treatment patterns, and data exploration.
  • Documented metric definitions, SQL analysis, and QA workflow.
Python Streamlit Pandas Plotly SQL Synthea
Live Dashboard Case Study + Code
🚚 Operations Analytics
Live Dashboard Tableau

Specimen Shipment Integrity & Exception Risk Analysis

Specimen Shipment Integrity dashboard preview

Tableau dashboard analyzing shipment delays, cold-chain exceptions, equipment failures, route risk, and disruption cost patterns.

  • Built KPI views for delay risk, exception frequency, cost impact, and operational performance.
  • Designed visuals to help identify high-risk shipment conditions and disruption drivers.
Tableau Excel Operations Analytics
Dashboard Link GitHub Repo
🤖 Analytics Automation
GitHub Repo Code Project

Discord Game Session Analytics Bot

Discord Game Session Analytics Bot preview

Discord analytics bot for tracking multiplayer game sessions, player performance, win rates, streaks, and leaderboard standings.

  • Built interactive session workflows using buttons, dropdowns, and slash commands.
  • Used persistent JSON storage and Google Sheets logging for ongoing performance tracking.
Node.js Discord.js Google Sheets API JSON
GitHub Repo
🎲 Product Analytics
GitHub Repo Expanding

Catan Analytics Dashboard

Catan Analytics Dashboard preview

Dashboard concept for analyzing Catan/Colonist.io performance, placements, dice roll outcomes, probability variance, and player-level trends.

  • Modeled expected vs. actual dice outcomes to evaluate probability-based “luck” patterns.
  • Built a foundation for product-style game analytics using Next.js and JavaScript.
Next.js JavaScript Analytics
GitHub Repo

🚧 Work in Progress

Projects I am actively improving, expanding, or preparing for future portfolio updates.

🏋️ Performance Analytics
Work in Progress Tableau

Athlete Performance, Recovery & Injury Analysis

Athlete performance and injury risk dashboard preview

Expanding an athlete performance dashboard focused on training load, recovery indicators, injury risk patterns, and sport-level readiness trends.

Tableau Excel Sports Analytics Risk Analysis
🏥 Healthcare Analytics
Work in Progress

Patient Outcomes Dashboard Enhancements

Patient outcomes dashboard enhancement preview

Improving the healthcare dashboard with procedure analysis, observation trends, provider-level metrics, additional cohort filters, and stronger QA validation.

Python Streamlit SQL Healthcare Data

🛠️ Skills

Analytics

SQL, KPI design, cohort analysis, dashboard design, data storytelling

Tools

Tableau, Streamlit, Pandas, Plotly, Excel, MySQL Workbench

Technical

Python, JavaScript, Node.js, Next.js, GitHub, Google Sheets API

Interested in my work?

Explore my GitHub projects, view live dashboards, or connect with me on LinkedIn.

View GitHub Connect on LinkedIn