Skip to content

analyst.andrewlengly.com :: analyst

# Andrew Leng Ly studied Management Information Systems at CSU Chico. Grid Watch, his own dataset, saves California's outage feed every 15 minutes.

designed page ......... analyst.andrewlengly.com

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.

analyst resume ........ analyst.andrewlengly.com/resume (PDF)

SELECTED PROJECTS (13)

[01] Grid Watch ...................................... andrewlengly.com/grid-watch-casestudy
     Power outage and fire weather map · Designer and developer · 2026
     the question ..... Do California’s power outages track fire weather, and how fast does
                        power come back?

[02] The case for third places ..................... andrewlengly.com/third-places-casestudy
     FourthSpace research study · Analyst · 2026
     the question ..... Do people need more places to meet in person, and where in
                        Sacramento should FourthSpace start?

[03] Where the best hires come from ........... andrewlengly.com/sourcing-channels-casestudy
     Sourcing channel study · Analyst · 2026
     the question ..... Which hiring channels bring in people who stay two years, and how
                        should a recruiting budget split by role?

[04] Internal mobility ........................ andrewlengly.com/internal-mobility-casestudy
     Internal mobility study · Analyst · 2026
     the question ..... Do people who move inside a company stay longer, and what should
                        Workday build so they can?

[05] New-hire ramp time ............................... andrewlengly.com/ramp-time-casestudy
     New-hire ramp study · Analyst · 2026
     the question ..... Why do so many new hires leave in their first two years, and what is
                        a buddy program worth?

[06] Skills-based hiring .......................... andrewlengly.com/skills-hiring-casestudy
     Skills-based hiring study · Analyst · 2026
     the question ..... How many jobs list a degree their own workers don’t hold, and what
                        should Greenhouse build about it?

[07] Fish Maps ........................................ andrewlengly.com/fish-maps-casestudy
     King tide and sea level rise map · Developer · 2026
     the question ..... Where do everyday high tides reach around the Bay at 1 to 10 ft of
                        sea level rise?

[08] Campus IT Triage Agent ........................... andrewlengly.com/campus-it-casestudy
     Salesforce DX / Service Cloud app · Developer · 2026
     the question ..... How should a campus IT request get routed, and who can check the
                        decision later?

[09] Chain Routes .................................. andrewlengly.com/chain-routes-casestudy
     Sierra chain control map · Developer · 2026
     the question ..... Which Sierra passes are open right now, and what do chain controls
                        mean for a Tahoe trip?

[10] DoorDash Student DashPass Growth ... medium.com/@andrew.leng.ly/applying-growth-strate…
     Growth case study · Author · 2025
     the question ..... What would grow Student DashPass sign-ups on a college campus?

[11] Spotify Podcast Gestures ... medium.com/design-bootcamp/pm-in-progress-a-simple-gestur…
     Product case study · Author · 2025
     the question ..... Where does podcast listening break down, and what small change fixes
                        it?

[12] MyFitnessPal Habit Formation ... medium.com/@andrew.leng.ly/pm-in-progress-strategies-…
     Product case study · Author · 2025
     the question ..... Why do people stop logging, and what would keep them coming back?

[13] CareerLyAI ........................................... career-ly-review-3i7i.vercel.app
     AI resume assessment · Developer · 2025
     the question ..... Can a resume be scored consistently enough to help someone improve
                        it?

  # Competition results
  Datafest Awarded Competitor ..................................................... Apr 2026
     American Statistical Association
  ERPsim Competition Finalist ..................................................... Mar 2026
     SAP University Alliances
  Datafest Awarded Competitor ..................................................... Apr 2025
     American Statistical Association

DATA STUDIES (9)

[01] AI and student learning ...... analyst.andrewlengly.com/studies/ai-and-student-learning
     Do coursework grades show what students remember, and what does an open AI chatbot do
     to the gap?

[02] TikTok STEM feed .................... analyst.andrewlengly.com/studies/tiktok-stem-feed
     Why TikTok’s US STEM feed trails Douyin in China, and what would make it work.

[03] Chegg after ChatGPT .............. analyst.andrewlengly.com/studies/chegg-after-chatgpt
     What Chegg should sell now that students have ChatGPT.

[04] Duolingo streaks .................... analyst.andrewlengly.com/studies/duolingo-streaks
     Do Duolingo’s streaks and leagues build language skill, or mostly daily logins?

[05] Handshake and LinkedIn ........ analyst.andrewlengly.com/studies/handshake-and-linkedin
     How Handshake can win new-grad hiring against LinkedIn and Indeed.

[06] Oura and Whoop ........................ analyst.andrewlengly.com/studies/oura-and-whoop
     Does paying for a wearable change how people live?

[07] The protein boom ........................ analyst.andrewlengly.com/studies/protein-boom
     Does the rush of high-protein products match a real gap in what people eat?

[08] The case for third places ..................... andrewlengly.com/third-places-casestudy
     Seven studies on loneliness and where people gather, and where FourthSpace should
     launch in Sacramento.

[09] Campus rec and GPA ................ analyst.andrewlengly.com/studies/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

TOOLS (16)

  analyst ............. 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

the design side ....... /machine/designer
  resume .............. designer.andrewlengly.com/resume (PDF)
the developer side .... /machine/developer
  resume .............. developer.andrewlengly.com/resume (PDF)

  # Hiring an analyst?
  email ............... andrew.leng.ly@gmail.com
  linkedin ............ linkedin.com/in/andrew-leng-ly

  Back to andrewlengly.com

# end of /machine/analyst. andrew.leng.ly@gmail.com · leave machine mode