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

Рет қаралды 753,953

Күн бұрын

📖 my business analytics online course (5000+ students currently!) (pre-recorded online course, watch and enroll anytime!) www.pressplay.cc/link/CC46B569
/ 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: www.datacamp.com/courses/intr...
LeetCode: leetcode.com/
InterviewQuery: 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 ;) ): • A Data-Driven Case Stu...
Top-Down Communications: • TALK LIKE A CONSULTANT...
[MOCK INTERVIEWS - my favorites!]
Facebook PM interview (setting metrics/watch time decline) • Meta/Facebook Product ...
Google PM interview (improving Headspace) • Google Product Manager...
Case Study Framework: • Case Interview 101 - W...
McKinsey mock interview: • Video
⏳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: lillian.chiu.nyc@gmail.com
🎁 discount codes:
ClassPass (get 14 day free with 43 credits with my link): 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): www.sayweee.com/en/account/re...
👋 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!

Пікірлер: 436

@lydanghuong3597 2 жыл бұрын

I love the way you integrate specific business case into your explanation, it’s so insightful and easy to follow. Thank you

@keifer7813 2 жыл бұрын

I felt like I was lacking business problem solving skills because I just focused on getting good at SQL lol. This is just what I needed. Thank you!

@betosfilm 2 жыл бұрын

In my 5 years experience as BI analyst, 90% of the time we just develop the reports, we don't do business insights. That part is done generally by the person who requested the report which usually knows more the business area. ***I have to add, that I was referring to the BI role, which is different from the BA. Although very often used for the same, the BI focus on descriptive analysis, while BA are more about predictive analysis. Therefore it makes sense the difference in the work experience that I commented.

@LillianChiu101 Жыл бұрын

super interesting! not sure if this is a spotify thing, but our projects are generally super collaborative and teams rarely work in silo. so I’d come up with my insights first, present it to the team who requested it, they will come with the specific 'tactics', then we build out the strategy together bc I'd also need to evaluate the results of the strategy down the line. there is a edge case though - there are times when an insight we see relates to multiple teams and becomes a cross-functional project. in that case, I'd have to be the one that gather every team's 'tactics' and collectively build a 'strategy' with them together. the weighing on how much analysis vs strategy depends on the company and your specific team's place in the org

@samubhandari2809 Жыл бұрын

Hii.. do we have to study maths in business analytics? if yes what types of maths will it be? please reply.. I am so stucked here.. I am so confused about whether I should do my bachelors in business analytics or not

@Meiaixin Жыл бұрын

@@samubhandari2809 I am learning Data Analytics through Google Coursera. I have been researching through youtube and other websites and it seems that the type of math you will need to learn would be Arithmetic, Algebra, Probability, and Statistics.

@samubhandari2809 Жыл бұрын

@@Meiaixin Thank you so much for replying ❤️ I have a one more question if u can please do reply, data analytics and business analytics they are similar right? do we have to study the same thing in both of the courses ?

@bridgetalagha 11 ай бұрын

@@samubhandari2809 Data Analytics is the broad profession that involves analyzing data to solve problems.... The specific area where we then apply Data Analytics is what would then determine if we'd call the profession: Business Analytics, Healthcare Analytics etc So, gaining specialized knowledge of the domain in which we want to apply Data Analytics to is what qualifies you to call yourself a professional in the streamlined field. As a Data Analyst or Data Scientist, you can work in Business, Agriculture, Healthcare etc. You analyze Data to solve problems. However, as a Business Analyst, you'd get extra trainings in the field of business; such as, understating key business metrics, knowing how to analyze sales data to predict future sales. As a Financial Analyst: In addition to understanding statistical analysis (Data analysis), you'd learn how to use statistics like standard deviation to determine the risk of an investment option over the other. As a Healthcare Data Analyst: You'll use data science to predict the outcome of a drug treatment. You can also conduct prescriptive analysis so as to prescribe which drug combination would be best for treating a disease. You could also develop an AI algorithm that matches people that need organ transplant with organ donors faster. The summary is that Data Analytics is the core and studying it would give you a broad perspectives of the different use cases of solving real world problems with Data. On the other hand, studying Business Analytics would make you a more specialized as a Data Scientist that is efficient at solving business problems with data. Your choice on what course to study finally depends on your interests. Do you want to keep your options open? If yes, consider studying Data Analytics. Do you want to stand out from the pool of people that generally refer to themselves as Data Analyst? If yes, then get extra knowledge of a specific domain and pursue a career in the path (so studying Business Analytics would be great in this case, but not necessarily so). I said it's not necessarily so because you can have a degree in Data Analytics and with the knowledge, build a portfolio only around use cases for Business. Take extra lessons on how to use Data to solve business problems and apply for Business Analytics roles. Your degree in Data Analytics would still be a huge plus in the mind of recruiters because you have a foundation. On the other hand, if you had a degree in Business Analytics, it might not be directly related to applying for roles as a Healthcare Data Analyst. Yet, it's not bad, provided you learn how to analyze clinical data and build a portfolio around it. You'd still be a better candidate than others who doesn't have a related degree. Finally, if your goal is to strictly work in Business settings, you want to be an entrepreneur or work in Management Consulting or strategy consulting, just study Business Analytics. But if you're exploring the world of tech and would love to keep your options widely open, then study Data Analytics. I hope this response helps. P.S: My battery was low while typing this and I wasn't sure I'd see this comment again when next I open KZfaq. Please pardon any typo errors that might appear in this writing and interpret each paragraphs with logic. Cheers ❤ Benita Alagha.

@faalihmyusa1720 Жыл бұрын

I've been feeling a bit unmotivated lately and I don't know why. I was just trying to scroll through KZfaq, found your video, and surprisingly I felt better. I feel more excited and try to implement the tips you explain in this video. Thank you for sharing your insight. I like content like this and I hope you will share a business analyst case study for us to study together!

@mirach274 Жыл бұрын

OMG thank you so much Lillian you have no idea how much positive impact you are making on us!! Sending love.

@Powerpacker07 Жыл бұрын

I know some basic of being business analyst but never or got any interest on it. I graduated year 2014. Tried many different things, jobs, part-times, until later i realized i wanted to become and pursue entrepreneurship, Hard as hell you bet but i’ve never been so complete in my life. It costs me everything but the reward is so much more. Whoever reading this i hope you get what your heart truly desire in life. Not just some work professionals who enters their room after 9-5 job and looks defeated.

@uyendao5410 10 ай бұрын

Are business analyst knowledge and skills helpful to become an entrepreneur?

@biancagador 8 ай бұрын

I needed to hear this right now

@jeykeot9872 Жыл бұрын

Hi, Lillian! I've been watching your videos since yesterday & it truly motivates me a lot. I've been doubting myself & unsure about my career path, but after watching your video, I'm honestly interested in understanding & learning about business analytics. Hope to see more of this kind of video in the future. Its very informative and thank you so much!!

@muhammadiyliamohdhutta9601 Жыл бұрын

Currently interviewing for a Data Analyst role and your video really helped me realise what I needed to get started on the case study! Thank you! 😊

@zr7974 2 жыл бұрын

Absolutely love your take! Been working as a data scientist at research labs in US top universities. The workflow and pattern, pretty much like a startup, needs those skills you brought up in the video too. How we can transform seemingly mundane everyday data into insightful information and how proper wrangling/ processing can empower the data itself have been something we must need to learn and keep working on. 一起加油！雖然BA, DA, DS,...相同職位在不同公司的詮釋可能有落差，但工作核心觀念絕對是適用於不同企業及甚至不同產業的，整理非常清楚很值得學習！Look forward to more quality content. Keep up the excellent work!

@amberyeh202 2 жыл бұрын

Hi Lillian, Thanks for sharing!! This video is super helpful in terms of understanding the essentials of business analysis. I wish I could’ve seen this video sooner before my BA interview. Really appreciated!!

@ssuyuyeh6047 2 жыл бұрын

I found this video super helpful even though I am outside the field of data analysis. These skills are applicable to every field! Thanks for sharing.

@Thestephanygil 2 жыл бұрын

This is one of the best and more practical videos I’ve seen on the subject. Thanks so much!

@kaustubhthanekar2761 Жыл бұрын

Love how structured your videos are! Absolutely admirable!

@yutungliu140 2 жыл бұрын

Hands down one of the most insightful YT videos I've watched recently! Thank you so much for sharing!

@larrychanhangpei9292 2 жыл бұрын

Video is summarised with supporting examples, ideas is categorised, such an informative video! Love it

@katon2459 Жыл бұрын

This is so detailed and in-depth. Thank you so much. It's exactly what I'm looking for when searching for a video about BA.

@camilamejia1458 Жыл бұрын

This video was extremely useful! It is the first time I see someone give real-world examples and then links for additional resources. Thank you so much! I would love to see more of these!

@ysaleung Жыл бұрын

so clear!! I'm starting a reflecting on where I want my career path to head towards and this position was suggested based on what I am passionate about. the real-life examples really help. U ARE AMAAZIING. thank you so much

@theagilebusinessanalyst 2 жыл бұрын

Hey Lillian, Thanks for the great content. Especially the part with root cause analysis I enjoyed the most. I consider this skill as crucial for Business Analysts.

@LillianChiu101 2 жыл бұрын

thank you!! yes agreed root cause analysis is one of the most common analyses I have to do and the thinking pretty much can be applied to other types of analyses. btw, I also learned that root cause analysis is commonly tested during PM interviews as well! (they call it product execution)

@saulmirandaaliaga 7 ай бұрын

This is an absolute GOLD MINE and it has several application cases. Thank you very much for making such a wonderful video!

@diretide6166 2 жыл бұрын

Incredible content. Easy to digest, step by step and chapters. Thanks Lilian !

@user-ge3op2ts5j 2 жыл бұрын

This is the best channel I've ever come across 💕 tysm for all the valuable info and tutorials that you give

@ridwikmodi2144 2 жыл бұрын

This was probably one of the best video I have come across on KZfaq. So informative and well explained, leant so much. Thank you

@izzu_1003 Жыл бұрын

You're amazing! I have been sitting on the fence about becoming a BA but through your passionate and style of explanations I found my interest definitely lies here. Thanks 👍🏾

@sandysandy8751 2 жыл бұрын

Thank you so much Lilian! For someone who's going to start a job with similar requirement, I found this video super helpful.

@ayc6191 2 жыл бұрын

Hi Lillian, thank you for making this so digestible! Always look forward to your videos :)

@khanhuyen9102 2 жыл бұрын

Hi Lillian, thank you so much for spending time making such an useful video for us, I was very ambiguous and in the midst of looking for my way, however, I found out that BA is interesting after watching your video and will spend more time researching the position. Thank you so much from the deepest of my heart! Hope that I can land a job in this area

@m2m1992 2 жыл бұрын

i've watched so many videos on youtube and i dont think i have ever came across one that is SO useful - this is extremely valuable with concrete actionable examples. I love it. Thank you so much!!!

@LillianChiu101 2 жыл бұрын

thank you so much!!

@iMsBear 2 жыл бұрын

This is so helpful!! I’ve just graduated and going into BA, you’re one of my idols!!

@evelynpham9043 2 жыл бұрын

This is such a high-quality and detailed sharing 💕 Thank you so much for great contents!

@thxruni 2 жыл бұрын

I am a BA who started out quite recently and this video was very insightful. Love your content. 💜

@Kimmy2hope Жыл бұрын

This is a super great video! Been watching a lot of analyst videos recently and this is the only one that went into the bigger thought process and effective strategies for communicating! Thank you for posting this!

@fatimafarid6073 2 жыл бұрын

This is like one of the coolest videos I've watched in months!! Extremely valuable!

@Babyk4315 2 жыл бұрын

thank you so much for this video, next year I'm planning to do business analytics in uni, I'm really glad I'm going to be taught about database application, (SQL, Python and other things) so this video was really helpful

@aldrindongarcia5173 2 жыл бұрын

Your content is very informative. It gives us a distinct view on what the roles of a business analyst. More power to you!

@francelenesigua5126 2 жыл бұрын

I really love your videos. I am a new hired BA and i am very nervous since I'm a career shifter. and with this it helps me know what to use and expect in this journey. thank you very much.

@Americanheld 2 жыл бұрын

What a fantastic video! Really went through the basics and provided links to external sources to help shore up skills. Invaluable and practical advice. Subbed and keep it up!

@lizahuang8686 2 жыл бұрын

Ive learnt a lot even tho I’m not working as a BA and the strategic thinking /so what part is so informative. Tysm for the content!🧡

@anhnguyenthingoc9504 2 жыл бұрын

Great video. I am working as a business analyst and still feel I learned a lot from this video. Thanks so much.

@lailabelhaj23 2 жыл бұрын

Thanks Lillian for these advices, I'm an IT business analyst, and I've learned from your video.

@carolineerickson3419 2 жыл бұрын

As someone who is currently attending NYU, your content is really inspiring!

@King1CurtisLOLZBros 2 жыл бұрын

Love these videos btw. So informative and helpful. Love it!

@kathywoo547 Жыл бұрын

Lillian! U really save me!! recently I have been struggling with what I should prepare to get a consulting job or become a business analyst. this video inspires me a lot

@hangvu5775 Жыл бұрын

Thank you very much, the problem solving part is truly helpful, even though I am a Economics student and I am not pursuit any job in Tech related but it also help me to reorganize my flow of brainstorming too :D

@judy2469618 2 жыл бұрын

This video is so organized and informative! I can tell from the way your present these information that you must be a very methodical person✨ Look forward to your future videos! Support from Taiwan🙌

@PhuongTran-mt5yi 2 жыл бұрын

That's awesome. After doing some research, I realise I'm pretty obsessed with market research analysts. Thanks for your sharing, it helps millions of people like me :).

@escapingsea4709 2 жыл бұрын

Thanks a lot! Your experience and explanations are really helpful! Quality content!

@vaibhavsajgure4663 Жыл бұрын

thank you for giving these type of core skills it was a really productive session to watch.

@YYLfrank Жыл бұрын

thanks the case study sharing, love the way you solve the problem and organized the issue.

@Inzpirits 2 жыл бұрын

Thanks for sharing, Lillian! It is really very informative!

@blaze6891 Жыл бұрын

Thank you so much, this helped me a lot. You explained it very clearly and precisely.

@KupoIsaiah 2 жыл бұрын

This is really good info! Good job summarizing this

@ucroshan 2 жыл бұрын

Really easy to follow the points and solid advice. Thanks and keep sharing this type of rich content.

@user-yj6ee9bk1n 2 жыл бұрын

Hello Lillian, This video is very helpful, telling me the way to build up my argument in a presentation. I learn a lot, thank you for sharing.

@almiraviani 2 жыл бұрын

I rarely seeing those detail information! thank you so much for sharing :) it means a lot! Can't wait to learn more from this! x

@jillli3966 7 ай бұрын

As a marketing analytics student, I rly need this rn.Thank you so much for sharing!

@jpjp0326 2 жыл бұрын

Thank you for sharing so many resources! Definitely useful for my data analyst interview preparation :D

@user-fi9cl3ry5w 2 жыл бұрын

this is great content. thank you for making this video and hope to see more like this!

@lilswtangel Жыл бұрын

Great content Lillian! As a fellow Business Analyst in tech (but specializing in processes & systems rather than performance and insights, I found the Lean Six Sigma methodologies invaluable to do an in-depth root cause analysis (Analyze phase as part of DMAIC), reduce waste, and deliver an optimal product/service to businesses and meeting the needs of customers.

@aaronc1689 Жыл бұрын

I was recently tasked to do a process and systems improvement in one of the departments in my company. Can you share some resources focused on P&S that helped you found most useful? Appreciate it and thank you in advance.

@samubhandari2809 Жыл бұрын

@gabriel.groppo 2 жыл бұрын

As a college student planning to pursue a career in BA this video was off the charts usefull. Please make more of those.

@LillianChiu101 2 жыл бұрын

Thank you gabriel! more to come !

@samubhandari2809 Жыл бұрын

@gabriel.groppo Жыл бұрын

@@samubhandari2809 I think there is no hard math, like calculus, but you need mathematical thinking and some statistics notion. There’s a video called “How much math I use as a data analyst”, by Luke Barousse, I think this video will help answering your questions.

@samubhandari2809 Жыл бұрын

@@gabriel.groppo Okay thank you so much

@samubhandari2809 Жыл бұрын

@@gabriel.groppo hi again.. I got confused so I am gonna ask you few more questions 🙏 is data analytics and business analytics same? or what? there is same type ko mathematics we need to study or something?

@jameswhitaker4357 2 жыл бұрын

I studied music business too! Such a cool pivot to see other people get into analytics

@jamesuche4301 Жыл бұрын

Thank you for this practical, relatable and insightful video.

@disraelichidinduezeala3489 Жыл бұрын

wasn't prepared 😅 for the amount of information coming from this video. really loved it ❤

@noorallawati5390 Жыл бұрын

You just helped me solidify my choice to develop as a BA. I am a Corporate Strategy Analyst and involved in so many things. And the company is pushing towards developing Data scientists and analysts. I just didn't feel it was right. Then I came to understand there is something called BA (my own role lol). I decided to look more into the path and came across your video. It is just what I needed =)

@Jasmine-zt8gc 2 жыл бұрын

Thanks for sharing this video, the tips are useful, and "so what" exercises are very clear !

@bkkim3571 Жыл бұрын

this was so helpful, thank you so much! I literally enjoy all of your videos! :)

@eyesofdoriss Жыл бұрын

I'm not in the BA field. But the strategic thinking techniques you mentioned is very useful for a lot of circumstances.I like it, thank you.

@nycto16 2 жыл бұрын

I am currently studying business administration and case studies are huge part of it!

@roy239 2 жыл бұрын

You’re amazing! This video is So useful and informative

@fabiolamontano5263 Жыл бұрын

i'm about to start my job in a company as a bussines research analyst and this just gave me so many tips and new insights, thank you so much for this content, definitely subscribing!

@jefflionel1024 Жыл бұрын

I'm about to apply BA this week with no experience, wish me luck I hope I make it 💀

@porushpuri 2 жыл бұрын

Thanks for creating this! Really helpful.

@HowardLinca 2 жыл бұрын

This is super helpful! Thanks for sharing!

@cswuweb 2 жыл бұрын

It's very amazing after seeing this footage. Very impressive, and insightful for my daily work in Wunderman Thompson. Cheers!!

@truchongviet6979 2 жыл бұрын

Thank you for such informative and valuable resourceful video! Especially those questions and “so what?” techniques.

@taliadalton9630 2 жыл бұрын

I found this video incredibly valuable. Thank you! I am currently interviewing for BA roles with a couple big tech companies. Your video came in perfect timing 💜

@norah_nguyen2 2 жыл бұрын

Good luck Talia 😊

@IcedLipGloss 2 жыл бұрын

good luck, i hope you get it! with a big salary increase

@samubhandari2809 Жыл бұрын

@miamercury2319 Жыл бұрын

In my 4 years experience as a BA, we never had to look into the business insights. What we, the BAs are required to do is to analyze the app/website we are working with and talk to customers and look into how to make it better for them (develop more features, take out some features, improve the user experience etc.). Then after analyzing that and taking the decision to, for example, add another feature that the customers need, we analyze how to make the best of that feature, how it should look, how it should work etc. But, most probably, we are Business Analysts in different departments in our companies xD

@papicoco5069 Жыл бұрын

working in e-commerce atm that's exactly 40% of my effort go to and the rest make sure that my stocks are released at the right time and the right amount.

@lucasferreira8229 Жыл бұрын

In this case, how do you learn what is good and bad to add to a website or be improved? I'm not in the field of Business Analysis, but I found that interesting. What do you recommend for someone just starting out?

@aoyt Жыл бұрын

She is in the business strategy group, so her focus is business insights, whereas yours sounds like it's more product focused.

@samubhandari2809 Жыл бұрын

Hii.. do we have to study maths in business analytics? if yes what types of maths will it be? please reply🙏.. I am so stucked here.. I am so confused about whether I should do my bachelors in business analytics or not

@LillianChiu101 Жыл бұрын

+1 love this! I have to look at the business insights bc im on the business strategy & operations team, so i look hollistically on the performance of the business as a whole. but yes i do the same as you, analyzing data, presenting insights, building strategies tgt with different departments. my ultimate goal is to grow the business, and not just product engagement, or PR impressions, those are done by each specific department!

@WestCoastKop 2 жыл бұрын

Really well done Lillian, great value here

@triyansubramanyam888 21 күн бұрын

I rarely comment on an educational video but this video, I couldn't resist One of the best analytical videos, great job Lillian!

@user-sc5gk6oi3j 2 жыл бұрын

this video is super helpful!!!! hope you can talk more issue about thinking or learning skills!!!

@phungsh 2 жыл бұрын

this was so so informative and helpful, thank you!!! it made me more sure and excited to pursue my msc in business analytics :D

@ughcml3114 2 жыл бұрын

probably the most insightful and informational video i've watched in a long time. great content!

@LillianChiu101 2 жыл бұрын

thank you!

@celine1196 2 жыл бұрын

I am a student in my second semester and your video let me know which subjects, skills and internship opportunities I should focus on. Thank you!

@poojasikdar3583 2 ай бұрын

Thanks Lillian - this is one of the best case studies content have seen. It was quite helpful.

@jimjimq9636 2 жыл бұрын

Slay sister Lillian. I'm starting my first real adult job as a business analyst / analyst and learning so much from your videos! I really liked your Google Sheets dashboard in your "day in the life working as a Business Analyst" video. Keep up the fabulous work. Stan queen.

@dhanyarao9560 2 жыл бұрын

This is such an insightful video. Thanks for this, Lillian. :)

@rama9373 2 жыл бұрын

Thanks for the Case Study example. I really enjoyed it.

@temitopehunga4880 Ай бұрын

Thank you, Lillian for this really insightful video. You really explained the business analysis role in a way that makes it so much less daunting.

@tobiassetiawan650 2 жыл бұрын

This content is so valuable. i thought i'm rolling on a great introductionary courses! Thank you

@narumonmaungsitong2380 2 жыл бұрын

I’m graduating next year and I want to be BA. You inspired me a lot and thanks for such a great videos.

@vaireemapp 2 жыл бұрын

Thank you for sharing and breaking this down .

@n.3004 11 ай бұрын

It's a very informative video learning more about the strategy analysis and how to think from BA on helping the company. Thanks for sharing! it's super useful!