think like a business analyst in tech (3 core skills + solving case study)

📖 my business analytics online course (5000+ students currently!) (pre-recorded online course, watch and enroll anytime!) https://www.pressplay.cc/link/CC46B569 http://instagram.com/lillian__chiu One of the most common questions I get asked is "what skills do I need to become a business analyst?" Back in 2019, I started my career as the youngest business analyst at Spotify (since I started right out of college). As glitzy as that sounds, this was also the period in my life when I experienced the most crippling case of imposter syndrome; Self-doubt became my reality and quite frankly, I felt 'less than' my peers at work. This video compiles the three key skills I wish I had known when I first started out on my Business Analyst journey. Whether you're a new grad looking to start a career as a BA or someone who’s looking to transition into a BA role, I know that the first time trying something new can seem scary, but the one guarantee in life is that nothing stays “first” forever. To those of you thinking of embarking on your BA journey, I'm cheering for you! More [career chat] vids to come, lmk what topics you want me to ~deep dive~ into. -Lillian 📖 resources mentioned [SQL] DataCamp Intro to SQL: https://www.datacamp.com/courses/introduction-to-sql LeetCode: https://leetcode.com/ InterviewQuery: https://www.interviewquery.com/ [PROBLEM SOLVING] DoorDash Case Study (I know in this video it's for a data analyst role, but the same case was also sent to BA candidates ;) ): https://www.youtube.com/watch?v=c88-PtRC9AQ Top-Down Communications: https://www.youtube.com/watch?v=ppokRtCeuyI [MOCK INTERVIEWS - my favorites!] Facebook PM interview (setting metrics/watch time decline) https://www.youtube.com/watch?v=se6Soyi2k0U Google PM interview (improving Headspace) https://www.youtube.com/watch?v=BNuRsv_42jc Case Study Framework: https://www.youtube.com/watch?v=6R5bT4cJh0A McKinsey mock interview: https://www.youtube.com/watch?v=psuKyBsH1oo ⏳timestamp: 00:00 - my beginnings 00:35 - GlassesUSA.com Presentation 02:07 - Skill #1: technical skills 02:47 - how to learn SQL 03:33 - data wrangling 04:24 - how to learn data wrangling 05:16 - Skill #2: problem solving skills 05:34 - CASE STUDY! 06:33 - top-down communications 06:58 - how to learn problem solving skills 07:12 - relevant jobs and internships 07:53 - Skill #3: strategic thinking & business sense 08:23 - the 'So What' exercise 10:18 - business recommendations 11:11 - how to learn strategic thinking & business sense 📧 business inquiries: [email protected] 🎁 discount codes: ClassPass (get 14 day free with 43 credits with my link): https://classpass.com/refer/SB2113FK29 (you can book Barry's Bootcamp through it too!) Weee! (where I get all my asian groceries, $20 off your first 2 orders): https://www.sayweee.com/en/account/referral/landing?t=1&referral_id=7839145&lang=en&utm_source=copyLink 👋 social: IG - @lillian__chiu 👩🏻 about me: I’m Lillian and I am a 25 y/o Taiwanese working as a business analyst. I moved to the U.S. 6 years ago for college and in my videos you will find me sharing my [early career] stories in tech, navigating through life in my 20s, and building my home away from home. disclaimer: all opinions are my own are don't reflect my employers #businessanalyst #workintech FTC: thank you GlassesUSA.com for sponsoring this video!