Alex Zheng.

Data analyst portfolio

Data, dashboards, and QA.

I use SQL, Power BI, spreadsheets, web analytics, and systems analysis to clean data, answer practical questions, and plan how information should move through a system.

View projects Download resume Contact

Selected work

Projects built around useful analysis and clean data.

LobbyPick Analytics Power BI dashboard with KPI cards and bar charts.

01 / SQL and Power BI

LobbyPick Analytics

I used a 28-game sample from LobbyPick to practice SQL analysis and build a one-page Power BI dashboard.

Analysis
Filtered and grouped games by genre, session length, player limits, spending level, mobile support, and private servers.
Dashboard
KPI cards, bar charts, and a session-length slicer.
Tools
SQL, Power BI, CSV data, basic DAX
Case study GitHub ↗
EarnVerity directory homepage showing search and category structure

02 / Structured records and QA

EarnVerity

I organize and review information across 72 earning and financial platforms so the directory stays consistent and easy to compare.

Data work
Reviewed categories, eligibility, payout details, fees, disclosures, and duplicate records.
Quality checks
Verified links and corrected incomplete or inconsistent entries.
Tools
Excel, Google Sheets, structured content files, GitHub
Case study Live site ↗
WorthMyTime shift calculator and job value interface

03 / Calculation and web analytics

WorthMyTime

I built a calculator that compares jobs and gigs after commute time, estimated taxes, and recurring work costs are included.

Data work
Structured inputs and comparison results around pay, time, taxes, and costs.
Testing
Checked calculation behavior, input validation, mobile layouts, and GA4 events.
Tools
JavaScript, Google Analytics 4, GitHub, Cloudflare Pages
Case study Live site ↗
Crow's Foot ERD for the Indie Game Release Information System showing Account, Developer, Game, Release, Comment, and Report entities.

04 / Systems analysis and data modeling

Indie Game Release Information System

CIS 270 Final Project

I planned a proposed system for upcoming indie game releases, including developer submissions, visitor search, moderation, reports, notifications, and the data behind those workflows.

Analysis
Requirements, problem definition, feasibility, budget, and project scheduling.
System design
Context, Level 0, and Level 1 DFDs plus a Crow's Foot ERD.
Tools
Draw.io, Microsoft Word, Microsoft PowerPoint
Case study

Skills

Tools I use for analysis and QA.

Data quality

  • Data cleaning
  • Validation
  • Categorization
  • Record standardization

Analysis & BI

  • SQL
  • Power BI
  • Google Analytics 4
  • Data visualization
  • Data modeling

Tools

  • Excel
  • Google Sheets
  • CSV data
  • Git and GitHub

QA

  • Structured review
  • Error detection
  • Cross-device testing
  • Issue documentation

Additional experience

Detail-focused review work.

Structured content QA

Multimedia annotation review

I review labels, timestamps, transcription, speaker information, and formatting against detailed project rules. The work requires consistent checks and clear issue documentation.

Project source material is confidential, so it is not shown publicly.

Resume

Data analyst resume.

Focused on SQL, Power BI, data quality, reporting, GA4, and QA.

Download PDF Download DOCX Contact