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