think like a business analyst in tech (3 core skills + solving case study)
ฝัง
- เผยแพร่เมื่อ 8 มิ.ย. 2024
- 📖 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!
![[Live] : ONE 167 วันนี้!! "ตะวันฉาย vs โจ"](http://i.ytimg.com/vi/D9_dvfIa6Ao/mqdefault.jpg)
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.
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
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
@@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.
@@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 ?
@@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 TH-cam.
Please pardon any typo errors that might appear in this writing and interpret each paragraphs with logic.
Cheers ❤
Benita Alagha.
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.
Are business analyst knowledge and skills helpful to become an entrepreneur?
I needed to hear this right now
I love the way you integrate specific business case into your explanation, it’s so insightful and easy to follow. Thank you
I've been feeling a bit unmotivated lately and I don't know why. I was just trying to scroll through TH-cam, 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!
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!
OMG thank you so much Lillian you have no idea how much positive impact you are making on us!! Sending love.
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!
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!!
Hands down one of the most insightful YT videos I've watched recently! Thank you so much for sharing!
This is one of the best and more practical videos I’ve seen on the subject. Thanks so much!
Love how structured your videos are! Absolutely admirable!
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! 😊
This is the best channel I've ever come across 💕 tysm for all the valuable info and tutorials that you give
I rarely comment on an educational video but this video, I couldn't resist
One of the best analytical videos, great job Lillian!
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!!
Video is summarised with supporting examples, ideas is categorised, such an informative video! Love it
This is an absolute GOLD MINE and it has several application cases. Thank you very much for making such a wonderful video!
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.
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!!!
thank you so much!!
This was probably one of the best video I have come across on TH-cam. So informative and well explained, leant so much. Thank you
Incredible content. Easy to digest, step by step and chapters. Thanks Lilian !
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.
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!
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.
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)
This is like one of the coolest videos I've watched in months!! Extremely valuable!
Hi Lillian, thank you for making this so digestible! Always look forward to your videos :)
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
This is such a high-quality and detailed sharing 💕 Thank you so much for great contents!
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
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.
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?
She is in the business strategy group, so her focus is business insights, whereas yours sounds like it's more product focused.
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
+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!
As a college student planning to pursue a career in BA this video was off the charts usefull. Please make more of those.
Thank you gabriel! more to come !
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
@@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.
@@gabriel.groppo Okay thank you so much
@@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?
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!
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 👍🏾
This is so helpful!! I’ve just graduated and going into BA, you’re one of my idols!!
Thank you so much Lilian! For someone who's going to start a job with similar requirement, I found this video super helpful.
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!
thank you for giving these type of core skills it was a really productive session to watch.
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
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🙌
Your content is very informative. It gives us a distinct view on what the roles of a business analyst. More power to you!
Love these videos btw. So informative and helpful. Love it!
I am a BA who started out quite recently and this video was very insightful. Love your content. 💜
Thanks Lillian - this is one of the best case studies content have seen. It was quite helpful.
probably the most insightful and informational video i've watched in a long time. great content!
thank you!
Really easy to follow the points and solid advice.
Thanks and keep sharing this type of rich content.
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.
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
thanks the case study sharing, love the way you solve the problem and organized the issue.
this was so helpful, thank you so much! I literally enjoy all of your videos! :)
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
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
Thank you so much, this helped me a lot. You explained it very clearly and precisely.
As a marketing analytics student, I rly need this rn.Thank you so much for sharing!
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.
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.
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
This is really good info! Good job summarizing this
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!
I'm about to apply BA this week with no experience, wish me luck I hope I make it 💀
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.
wasn't prepared 😅 for the amount of information coming from this video.
really loved it ❤
Thanks a lot! Your experience and explanations are really helpful! Quality content!
Great video. I am working as a business analyst and still feel I learned a lot from this video. Thanks so much.
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 💜
Good luck Talia 😊
good luck, i hope you get it! with a big salary increase
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
Thank you for this practical, relatable and insightful video.
Thanks Lillian for these advices, I'm an IT business analyst, and I've learned from your video.
Thanks for sharing, Lillian! It is really very informative!
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!🧡
Thank you for sharing so many resources! Definitely useful for my data analyst interview preparation :D
As someone who is currently attending NYU, your content is really inspiring!
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
Thanks for sharing this video, the tips are useful, and "so what" exercises are very clear !
Thanks for the Case Study example. I really enjoyed it.
I studied music business too! Such a cool pivot to see other people get into analytics
Really well done Lillian, great value here
Thanks for creating this! Really helpful.
Hey Lillian, thanks for the great video. I have a few data analyst interviews coming up and your video is really helpful!
thanks taylor - hope your interview went well!!
You’re amazing! This video is So useful and informative
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.
This content is so valuable. i thought i'm rolling on a great introductionary courses!
Thank you
this is great content. thank you for making this video and hope to see more like this!
Thank you for such informative and valuable resourceful video! Especially those questions and “so what?” techniques.
this video is super helpful!!!! hope you can talk more issue about thinking or learning skills!!!
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 :).
It's very amazing after seeing this footage. Very impressive, and insightful for my daily work in Wunderman Thompson. Cheers!!
this was so so informative and helpful, thank you!!! it made me more sure and excited to pursue my msc in business analytics :D
This is such an insightful video. Thanks for this, Lillian. :)
Very useful problem solving and presentation skills, thanks!
Your video is very straight forward to what you want to convey to the viewers. Thank you
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!
this was extremely insightful and very well-rounded video, the case study example helped a lot as well in understanding the skills
Thank you Lillian, this is very helpful.
Really detail things I want to know, great job!
Thank you so much for this video! I just got a job as a business analyst and this has helped me a lot!
Thank you for sharing and breaking this down .
This video is fantastic, thank you Lillian
It really helps me a lot. I just have a deep understanding of how to be a business analyst.
This is so insightful. Already 📖. Looking forward to more content like this. 😇
Love the video fam!! As a business analyst. 10000% agreed
lillian keep up the good work and stay strong fellow being
Another hidden jem of a content here at youtube. Thank you for sharing this to us.
This is super helpful! Thanks for sharing!
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.
Hey Lilian your vlogs of Spotify interested me so much! Thank you for sharing ♥️⚡️