Jiao LiuBeyond numbers

Data analyst · Business thinker

Making data
mean more.

I'm Jiao Liu. I turn complex datasets into clear stories, practical insights, and decisions people can act on.

View all case studiesGet to know me ↗
Jiao Liu in London with the London Eye behind her
Based in the United StatesOpen to data opportunities

Complete portfolio · 9 projects

Analysis with a point of view.

Nine case studies spanning customer behavior, e-commerce, mobility, public data, web scraping, dashboards, and exploratory analysis.

01
Customer behavior · SQL2024

Studying Platform Analysis

A SQL investigation of how free and paid students engage, learn, subscribe, take exams, and earn certificates on the 365 learning platform.

  • SQL
  • Tableau
  • CTEs
02
E-commerce · Tableau2024

Brazil E-commerce Platform Analysis

A Tableau analysis of Olist marketplace performance across sales, customers, sellers, geography, products, payments, and reviews.

  • Tableau
  • KPI design
  • Data visualization
03
Customer retention · Python2024

Telco Customer Churn

A Python investigation into the demographic, service, satisfaction, and promotion factors associated with telecom churn.

  • Python
  • Pandas
  • Seaborn
04
Mobility · Tableau2024

London Bikes Ride

An interactive Tableau dashboard for exploring London bike-share demand by time, weather, temperature, and wind conditions.

  • Tableau
  • Parameters
  • Table calculations
05
Web scraping · Python2024

World Population Scrape

A Beautiful Soup workflow that turns a live country population table into a clean Pandas dataset and reusable CSV.

  • Python
  • Beautiful Soup
  • Requests
06
Learning analytics · Tableau2024

Customer Behavior

A Tableau dashboard translating 365 learning-platform data into decisions about engagement, retention, course performance, and paid conversion.

  • Tableau
  • Cohort analysis
  • Customer behavior
07
Public data · SQL2024

US Household Income

A complete SQL cleaning and exploratory workflow for United States household-income and geographic data.

  • SQL
  • Window functions
  • Data cleaning
08
Public health · SQL2024

World Life Expectancy

A SQL cleaning and exploration project examining life expectancy, GDP, development status, BMI, and adult mortality worldwide.

  • SQL
  • Self joins
  • Window functions
09
Web scraping · Python2024

IMDB Top 250 Scrape

A Selenium workflow that collects ranked movie details from a dynamically rendered page and prepares them for analysis.

  • Python
  • Selenium
  • Pandas

Beyond the numbers

Curious by nature.
Commercial by experience.

My background spans financial lending, procurement, executive support, and project management. It taught me to see the business question behind every dataset—and to communicate what matters.

More about Jiao

Capabilities

Tools for finding the signal.

01

Python

Pandas, NumPy, Beautiful Soup, Selenium, Matplotlib, Seaborn

02

SQL

Joins, subqueries, window functions, CTEs, cleaning and exploration

03

Visualization

Tableau, Power BI, dashboard design and data storytelling

04

Business tools

Excel, pivot tables, lookup functions and front-end development