Data analytics portfolio

Qiankang Wang

Data Analytics and Decision Science professional with expertise delivering SQL-based analysis, KPI reporting, and stakeholder-facing decision support across complex operational datasets. Hands-on experience working with Oracle Database and SQL Server, with strengths in Power BI, Python/R analysis, data validation, and translating business questions into reliable insights.

Projects

Project 1

Hospital Capacity Analytics

A synthetic healthcare analytics project showing how patient-flow and capacity data can be generated, transformed, validated, modeled, and presented through dashboard-ready outputs.

Python ETLSynthetic data generationdbt SQL modelsData quality checksStreamlit dashboard

Project 2

Statistical Modelling

A grouped set of graduate modeling projects covering statistical learning and Bayesian analysis, linked to the original reports and code repositories.

Statistical learningBayesian MCMCModel comparisonModel diagnosticsR Markdown

Project 3

Computational Statistics

A computational contribution to generalized crack distribution work, focused on simulation, density evaluation, parameter estimation, EM-style routines, and goodness-of-fit computation.

SimulationRandom-number generationMaximum likelihood estimationMethod of momentsEM algorithmGoodness-of-fit testing

Portfolio data is synthetic or public-safe. For the GCR project, the page describes only my computational implementation contribution.