Skip to content

Andrew Leng Ly, Analyst

The analyst side · Based in Sacramento, CA.

I studied Management Information Systems at CSU Chico and placed 3rd regionally in the SAP ERPsim competition.

Grid Watch below is my own dataset. It saves California's outage feed every 15 minutes, and the case study shows the math behind each number.

  • Sacramento County seen from an angle as a field of low slate blocks on a near-black ground. Glowing towers rise over the 36 lonely neighborhoods with little nearby to gather, taller and shifting from violet to pink to amber where more lonely adults live. The largest block of towers sits in south Sacramento
    Analyst · 2026

    The case for third places

    FourthSpace research study

    The question

    Do people need more places to meet in person, and where in Sacramento should FourthSpace start?

  • Six grids of 100 dots, one per hiring channel, with blue dots for hires still employed after two years. The first grid, referrals, is the most filled
    Analyst · 2026

    Where the best hires come from

    Sourcing channel study

    The question

    Which hiring channels bring in people who stay two years, and how should a recruiting budget split by role?

  • Nine columns of dots that rise from left to right, one per year since a last promotion, turning blue from the third year on
    Analyst · 2026

    Internal mobility

    Internal mobility study

    The question

    Do people who move inside a company stay longer, and what should Workday build so they can?

  • Eleven columns of dots for attrition by years at the company. The first three, in blue, stand far taller than the rest
    Analyst · 2026

    New-hire ramp time

    New-hire ramp study

    The question

    Why do so many new hires leave in their first two years, and what is a buddy program worth?

  • Eight grids of 100 dots, one per occupation, with blue dots for workers who hold no bachelor’s degree. Most grids are half blue or more
    Analyst · 2026

    Skills-based hiring

    Skills-based hiring study

    The question

    How many jobs list a degree their own workers don’t hold, and what should Greenhouse build about it?

  • Fish Maps 3D map of San Francisco Bay with tide gauge markers and flooding at 5 feet of sea level rise
    Developer · 2026

    Fish Maps

    King tide and sea level rise map

    The question

    Where do everyday high tides reach around the Bay at 1 to 10 ft of sea level rise?

  • Salesforce case record beside an agent chat that finds a WiFi guide and opens a laptop ticket
    Developer · 2026

    Campus IT Triage Agent

    Salesforce DX / Service Cloud app

    The question

    How should a campus IT request get routed, and who can check the decision later?

  • Chain Routes 3D terrain map of Sierra passes with chain control status along each highway
    Developer · 2026

    Chain Routes

    Sierra chain control map

    The question

    Which Sierra passes are open right now, and what do chain controls mean for a Tahoe trip?

  • DoorDash logo wearing a graduation cap
    Author · 2025

    DoorDash Student DashPass Growth

    Growth case study

    The question

    What would grow Student DashPass sign-ups on a college campus?

  • Spotify logo with a hand cursor tapping it
    Author · 2025

    Spotify Podcast Gestures

    Product case study

    The question

    Where does podcast listening break down, and what small change fixes it?

  • MyFitnessPal logo on blue beside half of the Duolingo owl on green
    Author · 2025

    MyFitnessPal Habit Formation

    Product case study

    The question

    Why do people stop logging, and what would keep them coming back?

  • CareerLyAI resume review with an overall score of 78 out of 100 and four category scores
    Developer · 2025

    CareerLyAI

    AI resume assessment

    The question

    Can a resume be scored consistently enough to help someone improve it?

  • Apr 2026Datafest Awarded CompetitorAmerican Statistical Association
  • Mar 2026ERPsim Competition FinalistSAP University Alliances
  • Apr 2025Datafest Awarded CompetitorAmerican Statistical Association
  • AI and student learning

    Do coursework grades show what students remember, and what does an open AI chatbot do to the gap?

  • TikTok STEM feed

    Why TikTok’s US STEM feed trails Douyin in China, and what would make it work.

  • Chegg after ChatGPT

    What Chegg should sell now that students have ChatGPT.

  • Duolingo streaks

    Do Duolingo’s streaks and leagues build language skill, or mostly daily logins?

  • Handshake and LinkedIn

    How Handshake can win new-grad hiring against LinkedIn and Indeed.

  • Oura and Whoop

    Does paying for a wearable change how people live?

  • The protein boom

    Does the rush of high-protein products match a real gap in what people eat?

  • The case for third places

    Seven studies on loneliness and where people gather, and where FourthSpace should launch in Sacramento.

  • Campus rec and GPA

    Do students who use the rec center keep better grades and stay enrolled? Chico State is the example.

All studies and the method they share
  • SQL
  • Python
  • R
  • Excel
  • Google Sheets
  • Power BI
  • Jupyter
  • BigQuery
  • PostgreSQL
  • Snowflake
  • SAP S/4HANA
  • SAP ERPsim
  • Salesforce
  • Google Analytics 4
  • Microsoft Clarity
  • Notion