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.
Selected projects
Designer and developer · 2026Grid Watch
Power outage and fire weather map
The questionDo California’s power outages track fire weather, and how fast does power come back?
Analyst · 2026The case for third places
FourthSpace research study
The questionDo people need more places to meet in person, and where in Sacramento should FourthSpace start?
Analyst · 2026Where the best hires come from
Sourcing channel study
The questionWhich hiring channels bring in people who stay two years, and how should a recruiting budget split by role?
Analyst · 2026Internal mobility
Internal mobility study
The questionDo people who move inside a company stay longer, and what should Workday build so they can?
Analyst · 2026New-hire ramp time
New-hire ramp study
The questionWhy do so many new hires leave in their first two years, and what is a buddy program worth?
Analyst · 2026Skills-based hiring
Skills-based hiring study
The questionHow many jobs list a degree their own workers don’t hold, and what should Greenhouse build about it?
Developer · 2026Fish Maps
King tide and sea level rise map
The questionWhere do everyday high tides reach around the Bay at 1 to 10 ft of sea level rise?
Developer · 2026Campus IT Triage Agent
Salesforce DX / Service Cloud app
The questionHow should a campus IT request get routed, and who can check the decision later?
Developer · 2026Chain Routes
Sierra chain control map
The questionWhich Sierra passes are open right now, and what do chain controls mean for a Tahoe trip?
Author · 2025DoorDash Student DashPass Growth
Growth case study
The questionWhat would grow Student DashPass sign-ups on a college campus?
Author · 2025Spotify Podcast Gestures
Product case study
The questionWhere does podcast listening break down, and what small change fixes it?
Author · 2025MyFitnessPal Habit Formation
Product case study
The questionWhy do people stop logging, and what would keep them coming back?
Developer · 2025CareerLyAI
AI resume assessment
The questionCan 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
Data studies
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.
Tools
- SQL
- Python
- R
- Excel
- Google Sheets
- Power BI
- Jupyter
- BigQuery
- PostgreSQL
- Snowflake
- SAP S/4HANA
- SAP ERPsim
- Salesforce
- Google Analytics 4
- Microsoft Clarity
- Notion
The other sides
Hiring an analyst? Email andrew.leng.ly@gmail.com or message me on LinkedIn.