ฝึกพูดภาษาอังกฤษด้วยเทคนิค Shadowing จากวิดีโอ: think like a business analyst in tech (3 core skills + solving case study)
กำลังสร้างบทเรียน...
1
After graduating college in 2019, I started my first job as a business analyst. (my 1st day at Spotify, 2019) I was excited but I was also really scared because I studied music business at NYU and I didn't have any direct business analytics background, so there were a lot of things I had to learn from scratch.
2
And with two and a half years of learning from my mentors, colleagues, and through my fair share of trial and errors, these are the three most important skills to have as a business analyst in tech. (1: technical skills, 2: problem solving skills, 3: strategic thinking & business sense) I'll talk about what they actually are with real case examples and how you can learn them whether you're a student or in your full time job.
3
If you're interviewing, these are also the key skills that companies are evaluating you on for a BA interview.
4
Before we get started, Thank you GlassesUSA.com for sponsoring today's video.
5
I've worn glasses since elementary school and I break them all the time.
6
Bbecause I have this really bad habit of putting it in near my pillow, causing the glasses to get bent when I wake up so I'm very priced conscious when it comes to buying glasses.
7
By cutting out the middleman, glassesUSA.com offers over 9,000 prescription glasses and sunglasses including in house brands like Muse and Amelia e, and designer brands like Rayband, Gucci and many more, at up to 70% of retail prices.
8
You can shop for all your eyewear needs online at affordable prices started at only 30 dollars with your basic prescription lenses included without leaving your home!
9
GlassUSA.com also offers a collection of advanced blue light blocking lenses as a business analyst, my eyes are basically glued to SQL and Google Sheets all day, so blue light glasses are a must for reducing my eye strain and headache.
10
Their blue light lenses also include clear prevention and UV block they also offer a risk free shopping experience with free shipping and returns, 100% money back guarantee, full refund within 14 days of delivery, no questions asked, and a 365 day product warranty.
11
If you can't decide what glasses look good for you, they also have a virtual try on tool on the website which really helps you find the right pair.
12
I literally used it to find mine.
13
You can upload a picture or take a photo where you can see what the glasses will look like on you.
14
If you're shopping for your glasses, definitely check out GlassesUSA.com!
15
And I'll leave the links of the glasses I'm wearing in the description box.
16
So, let's get it started!
17
Skill no. 1, your technical skills.
18
Especially if you want to work in tech with an analyst title, SQL is the most important than Excel Google Sheets.
19
SQL is a language that enables you to pull millions and billions of user information stored in databases to answer business questions.
20
Let's say you work at Netflix, and some of the questions that you would be asked would be things like how many monthly active users do we have per region per day?
21
Or specifically, how many monthly active users do we have per region that have finished watching Squid Game?
22
If you know SQL, you can easily pull these numbers and answer questions fast instead of having to wait for data scientists to employ for you or rely solely on dashboards.
23
How can you learn SQL?
24
So I'm going to talk about if you don't have any experience with SQL and if you have some experience.
25
If you have your experience with SQL, I would recommend starting with datacamp's class on intro to SQL.
26
This is free and you get to learn the basic SQL logics and command lines@.
27
I also love how it's super interactive so everything feels very real when you're coding on it.
28
If you have some experience with SQL or if you're preparing for a SQL text@ screen, I highly highly recommend going to leetcode or Interview Query.
29
On these websites, you will see all the SQL teg questions from companies like Facebook, Google that were actually asked during the interviews.
30
And even if you're not interviewing, I find this extremely useful just to see how SQL is used to solve real business problems at specific companies.
31
I would definitely be sure to ace the easy question and get comfortable with medium questions.
32
So aside from SQL, data wrangling skills in Excel and Google Sheets is another essential.
33
Once you pull thousands of rows of raw data at your SQL, the next step is to load the data into Excel or Google Sheets to then organize your raw data and visualize graphs there.
34
In the typical BA interview for tech companies, there's usually a take home case study where you're given a set of raw data in Excel and you have to analyze the data and extract insights.
35
And no, you don't have to know all these formulas out there!
36
In my day to day, I mainly use pivot tables, sumifs, vlookups, index/match.
37
and if anything it would just be more (sumifs vlookup pivot table index/match) advanced variations of them.
38
I think what's more important here is knowing how to solve the problem.
39
As an example, I didn't know sumif existed. (sumif??) All I knew was I wanted to sum all the rows based on a criteria.
40
I Googled exactly that and I realized sumif can help me do that.
41
So Google is going to be your best friend when it comes to data wrangling.
42
How do you learn data wrangling skills?
43
My biggest tip to learn it is to play around with the data yourself and practice.
44
If you're in an internship and even if it's not related to data, let your manager know that you like to gain data skills and would love to see if you can work on related projects or even if there's anyone you can speak to.
45
When I was doing my digital marketing internship at Roc Nation, my internship had almost nothing to do with data analysis.
46
But because I asked, I was able to get time with analysts and see how they do their analysis in Excel and how they wrangle their data and visualize things.
47
If you're working full time, the next time you get any data point, ask to see what the raw data looks like in Excel or Google sheet form.
48
And try to see how people wrangle and structure their data.
49
What I used to do was making a copy of the sheet and try to do it myself.
50
And last tip is practice.
51
The more you do it, the more you will see the pattern building your own systemic way of visualizing things.
52
Skill no. 2, problem solving skills.
53
This is about how you can break down ambiguous questions into smaller pieces in a structured way.
54
So as a business analyst, you often be asked very ambiguous questions in your job or even in your interview during the case study round.
55
A classic question is a root cause analysis which I get asked all the time at work too.
56
So get ready for this question.
57
Imagine you work at Netflix We're seeing monthly active users declining on the Netflix app.
58
Can you root cause the issue?
59
What recommendations do you have?
60
To approach any ambiguous problem, there's a general structure to problem solving that I learned from my mentors.
61
Break down the problem into smaller questions or pieces, then use data to answer your questions.
62
After that, you can consolidate your learnings into insights, and based on your insights you provide your business recommendations.
63
So the first question I'll think about is impact size.
64
How long have we been seeing this MAU decline, and what is the size of this user decline?
65
Also look at geography.
66
Are we seeing this on a global level or in a specific market?
67
And seasonality too.
68
Did we see MAU decline last year around the same time too or did it only happen this year?
69
Maybe it's a recurring pattern and related to seasonality?
70
And these are some other questions I would look into I then dive into the data to find insights for each of these questions.
71
The biggest mistake and that's what I used to do when I started was to dive straight into the data and I would drown myself in there for hours and not have a narrative and answer.
72
Let's say after you analyze data, and you may be analyzing 10 to 15 metric.
73
But when you communicate the insights in your email to your manager, or in your executive summary in your presentation, communicate them in a top-down way.
74
So I will say it like this.
75
Top-down communication is when you start with your key message and then go into your supporting details.
76
There's also a video about top-down communication like this one, and I highly recommend you to check it out.
77
How do you learn problem solving skills?
78
First tip is to watch mock case interviews.
79
I'll link some good ones down in the description box.
80
I also love seeing product managers do their mock interviews.
81
Especially these two on the Exponent channel since it's more tech driven.
82
In terms of what jobs or internship experiences that are more relevant, consulting is a big one.
83
And the secret is that's where most tech companies recruit their BA's from.
84
Internship wise, I highly recommend insights internship, analytics, or market research internships.
85
Basically internships that have something along the lines of using data to drive actionable insights.
86
Can be quantitative data or qualitative data doesn't matter.
87
What you're trying to learn here is to turn data into insights and tell a story.
88
And regardless of whether you're in school or in a full time job, the next time when someone presents, pay attention to the structure of their presentation.
89
See how they go from point A to point B to point C.
90
Think about what they did well and what you would improve on if you were the one presenting.
91
Skill no. 3, strategic thinking and business sense.
92
What sets great analysts apart from average analysts?
93
Is their ability to turn data into actionable insights to guide the business recommendation.
94
Basically, how would this specific piece of data be actionable for the business?
95
It's not about how many coding languages you know, it's about what the business could do based on the data you provide that matters most.
96
So, using our example again on...
97
We're seeing monthly active users declining on the Netflix app.
98
Can you recall the issue?
99
What recommendations do you have?
100
Previously, we align on a few questions I will answer with data.
101
But before we go analyze the data, I learned that a way to sharpen my strategic thinking is to pause and think first about the So What?
102
of getting each data points or insights are actionable.
103
Role playing helps, so imagine let's say we are the CEO of the company, how can this data help us make a decision?
104
For impacts sizing the So What? is that if it's alarge amount of users declining then we should be alarmed and come up with large scale counter-actions.
105
Also, looking at the MAU trend, if it's a spiked drop, it likely will be a one time event, perhaps a bug; if it's a gradual trend, perhaps we aren't finding values using our services; if it's a step change, perhaps we made some changes on our product and it's hurting our growth.
106
So seasonality, So What?
107
if it's a recurring trend that happens every year, there's not much we can do but will closely monitor.
108
Geography, So What?
109
if we see it on a global level, then it may be a bug in our data that's driving down the numbers everywhere.
110
And you'll be surprised that these things actually happen.
111
If it's a specific market, then perhaps our competitor launched a new feature that's taking away our users or there's a macro level trend happened in the market that we should be aware of.
112
External factors such as competition.
113
The So What? here is we should understand what it is and if it would make sense for us to build something similar or have some counter-actions.
114
Demographic, specifically aged group.
115
The So What? here is if it's happening a specific aged group, perhaps we are underserving this cohort of users and we can think of strategies to make our product and experiences more appealing to this aged group.
116
Breaking down the MAU metric, So What?
117
If it's less new users coming in, we need to think about our acquisition strategy; if it's more users turning out, we need to think about engagement strategy to retain users.
118
What's really good about doing the So What? exercise is it forces you to think strategically before you even pull the number.
119
So our insights on Netflix MAU decline was around competition and higher churn rates among 25 to 34 y/o in the US.
120
Based on the insights, what are some business recommendations you can provide?
121
Looking back at our So Whats?, you can then build upon them.
122
First, I will think about understanding the competition.
123
We can conduct user research to understand the new feature that the competitor has launched and how we can come up with appropriate counter-actions.
124
Second, double down on engagement strategies to reduce the churn among 25 to 34 y/o in the US 1. we can understand the types of content or feature that this cohort tend to consume the most and increase awareness of them.
125
For instance, we can service as a specific content on homepage, talk about the feature via email communications or do a PR announcement of a specific show.
126
Second, we can perform a cohort analysis to identify the key behaviors that make a user highly engaged.
127
For instance, is it about using a specific feature or the number of content watch or the diversity of genre they see that make them a highly engaged users?
128
Based on such, we can then take steps to encourage unengaged users to follow the behavior of engaged users to prevent churn.
129
How do you learn strategic thinking and business sense?
130
First, before you analyze any data point, pause for a second and think about the So What? of knowing the data point.
131
Why does the CEO need to know this data and what can the CEO do about it?
132
So your insights are strategic versus just plain numbers.
133
For a business sense, this is probably the harder one for me to learn, but a good tip is to have regular conversations with people outside your team, to learn how things work at your company.
134
For instance, ask the user research team, if you want to start a user research, what do you need and what is intell?
135
Ask the marketing team what tactics have been done for the engagement strategy and what worked well?
136
Talk to the product team and see how they evaluate the strength of a new feature?
137
As you become more senior in your role, you will then be the one implementing these recommendations end to end with cross functional stakeholders.
138
So it's better to know how things work from their end.
139
Hopefully this was helpful in shedding some light on the course skills of a business analysit's in tech.
140
And again, thank you glassesusa.com for sponsoring today's video.
141
You can shop my glasses in the link in the description box.
142
Thank you all for watching and I'll see you in my next video.
📺 ช่องเดียวกัน
B11
day in the life working as a business analyst | my business analysis workflow
Business EnglishWorking Adults
B21
How Tech Salaries Work 💸, AI Chat with Google UX Lead, I'm moving?| Biz Analyst Diary
Business EnglishInterview EnglishUniversity Students
B11
Living in Vietnam| my daily life back home, enjoying life outside of work🌸, reuniting with family
Travel EnglishTeensDaily Conversation
✨ วิดีโอแนะนำ
B22
12 ประโยค
Self introduction BAIRES DEV study
Business EnglishInterview EnglishUniversity Students
B2188
8 ประโยค
Cách Business Analyst tư duy để đạt mục tiêu - Lillian Chiu #businessanalyst #ielts
IELTS PrepBusiness EnglishUniversity Students
B12
57 ประโยค
Top 5 Soft Skills For 2026 | Soft Skills Training | Most Important Skills To Learn | Simplilearn
Business EnglishInterview EnglishUniversity Students
B2257 ประโยค
How I Escaped Help Desk Fast (Step-by-Step)
Business EnglishInterview EnglishUniversity Students
B23
128 ประโยค
Googleyness and Leadership Interview Question
Business EnglishInterview EnglishUniversity Students
B21
273 ประโยค
How to Start a Professional Presentation in English | Real Business Meeting Listening & Speaking
Business EnglishInterview EnglishUniversity Students
B23
63 ประโยค
How To Land Your First Junior Dev Role
Business EnglishInterview EnglishUniversity Students
C1260 ประโยค
Data Analyst Interview 2024 | SQL | POWER BI | Data Science | Mock Interview
Business EnglishInterview EnglishUniversity Students
B22
47 ประโยค
Speak Out B2. Unit 7D. BBC Street Interview. 3rd edition
Business EnglishInterview EnglishDaily Conversation
B138
12 ประโยค
Blurry: Alexandre UGC 1
Business EnglishTravel EnglishUniversity Students
B22
12 ประโยค
BCG Online Case Interview Introduction
Business EnglishInterview EnglishUniversity Students
คำศัพท์และข้อสังเกตด้านการพูดสำหรับบทเรียนนี้
บทเรียนฝึกพูดระดับ B2 นี้ใช้วิดีโอ “think like a business analyst in tech” เป็นสื่อ คำที่ถูกพูดซ้ำบ่อยที่สุด: user, Sql, skill, insights, learn วิดีโอนี้มี 142 ประโยค และ 2611 คำ สำหรับฝึกพูดตาม ช่วงที่มีเสียงพูดยาว 12:12 ผู้พูดพูดเร็ว ประมาณ 214 คำต่อนาที จึงมีการเชื่อมเสียงและลดเสียงค่อนข้างมาก 83% ของคำอยู่ใน 3,000 คำที่ใช้บ่อยที่สุดในภาษาอังกฤษ ส่วนที่เหลือควรดูไว้ก่อนเริ่มฝึก จากทั้งหมด 142 ประโยค มี 32 ประโยคเป็นคำถาม จึงเหมาะสำหรับฝึกน้ำเสียงประโยคคำถามและการตอบสั้น ๆ
คำศัพท์สำคัญในวิดีโอนี้
คำที่ยากที่สุด 15 คำในวิดีโอ พร้อมคำอ่านและความหมาย:
| คำศัพท์ | คำอ่าน | ความหมาย |
|---|---|---|
| analyze คำกริยา | /ˈæn.əˌlaɪz/ | วิเคราะห์ |
| ambiguous คำคุณศัพท์ | /æmˈbɪɡ.ju.əs/ | คลุมเครือ, กำกวม |
| lens คำนาม | /lɛnz/ | เลนส์, แว่น |
| metric คำคุณศัพท์ | /ˈmɛt.ɹɪk/ | เมตริก |
| geography คำนาม | /d͡ʒiˈɑɡɹəfi/ | ภูมิศาสตร์ |
| prescription คำนาม | /pɹəˈskɹɪp.ʃən/ | ใบสั่งยา |
| dive คำกริยา | /daɪv/ | ดำ |
| dashboard คำนาม | /ˈdæʃˌboɹd/ | แผงหน้าปัด, แผงควบคุม |
| macroeconomics คำนาม | /ˌmæk.ɹoʊˌiː.kəˈnɒ.mɪks/ | เศรษฐศาสตร์มหัพภาค |
| sharpen คำกริยา | /ˈʃɑɹpən/ | ลับ, เหลา |
| drown คำกริยา | /dɹaʊn/ | จมน้ำตาย |
| sunglasses คำนาม | แว่นกันแดด | |
| glue คำนาม | /ɡlu/ | กาว |
| consult คำกริยา | /ˈkɑnsʌlt/ | ปรึกษา, หารือ |
| consume คำกริยา | /kənˈsum/ | อุปโภค, ใช้ |
กริยาวลีที่คุณจะได้ยิน
| คำศัพท์ | คำอ่าน | ความหมาย |
|---|---|---|
| wake up คำกริยา | /ˌweɪk ˈʌp/ | ตื่น, ตื่นนอน |
ประโยคที่ควรฝึกพูดซ้ำ
ประโยคสั้น ๆ ที่สมบูรณ์จากวิดีโอ ซึ่งนำไปใช้ในบทสนทนาประจำวันได้:
- How do you learn data wrangling skills?
- Can you root cause the issue?
- What recommendations do you have?
- How do you learn problem solving skills?
- Can you recall the issue?
ไวยากรณ์ในวิดีโอนี้
โครงสร้างที่ผู้พูดใช้บ่อยที่สุด พร้อมคำพูดจริงจากวิดีโอ:
| โครงสร้าง | ในวิดีโอ |
|---|---|
| ประโยคเงื่อนไข if + อนุประโยค, will/would + กริยา — เงื่อนไขและผลลัพธ์ | if anything it would just |
| “used to” used to + กริยา — นิสัยหรือสภาพในอดีตที่ตอนนี้ไม่เป็นแล้ว | used to do |
| Passive voice be + กริยาช่อง 3 — เน้นสิ่งที่เกิดขึ้น ไม่ใช่ผู้กระทำ | would be asked · were actually asked · be asked |
| Present perfect have/has + กริยาช่อง 3 — เหตุการณ์ในอดีตที่ยังเกี่ยวข้องกับปัจจุบัน | I've worn · have finished · has launched |
การออกเสียงที่ควรระวัง
ผู้พูดใช้รูปย่อและรูปลดเสียง 30 ครั้ง เช่น you're, I'll, I'm ให้พูดแบบสั้นตามที่ได้ยิน
- เสียง “sh” และ “zh”: internship /ˈɪntɜːnʃɪp/, recommendation /ˌɹɛkəmɛnˈdeɪʃən/, actionable /ˈæk.ʃə.nə.bəl/, visualize /ˈvɪʒuəˌlaɪz/, prescription /pɹəˈskɹɪp.ʃən/
- คำยาว — ลงเสียงหนักให้ถูกพยางค์: recommendation /ˌɹɛkəmɛnˈdeɪʃən/, actionable /ˈæk.ʃə.nə.bəl/, ambiguous /æmˈbɪɡ.ju.əs/, analytics /ˌæn.əˈlɪt.ɪks/, competitor /kəmˈpɛt.ɪ.tɚ/
เสียงที่คนไทยมักออกเสียงยาก:
- เสียงท้ายคำ — ออกเสียงให้ครบ ไม่เปลี่ยนเป็นตัวสะกดแบบไทย: wrangle /ˈɹæŋɡəl/, analyze /ˈæn.əˌlaɪz/, actionable /ˈæk.ʃə.nə.bəl/, visualize /ˈvɪʒuəˌlaɪz/, ambiguous /æmˈbɪɡ.ju.əs/
- /v/ — ไม่ใช่ /w/ ให้ฟันบนแตะริมฝีปากล่าง: visualize /ˈvɪʒuəˌlaɪz/, pivot /ˈpɪv.ɪt/, evaluate /ɪˈvaljʊeɪt/, dive /daɪv/, qualitative /ˈkwɑ.ləˌteɪ.tɪv/
- /z/ — เสียงก้อง ไม่ใช่ /s/: analyze /ˈæn.əˌlaɪz/, visualize /ˈvɪʒuəˌlaɪz/, lens /lɛnz/, pause /pɔːz/, organize /ˈɔɹɡənaɪz/
วิธีฝึกกับวิดีโอนี้
- ฟังวิดีโอให้จบหนึ่งรอบโดยยังไม่ต้องพูด แล้วจดคำที่ยังไม่รู้จัก
- เริ่มที่ความเร็ว 0.75× พูดตามทีละประโยค แล้วกลับไปใช้ความเร็วปกติเมื่อเริ่มคล่อง
- อัดเสียงตัวเองแล้วเทียบกับต้นฉบับ โดยสังเกตคำอย่าง analyze, ambiguous, lens เป็นพิเศษ
เทคนิค Shadowing คืออะไร?
Shadowing เป็นเทคนิคการเรียนรู้ภาษาที่ได้รับการรับรองทางวิทยาศาสตร์ พัฒนาขึ้นสำหรับการฝึกนักแปลมืออาชีพ วิธีการนี้เรียบง่ายแต่ทรงพลัง: คุณฟังเสียงภาษาอังกฤษจากเจ้าของภาษาและพูดตามทันที — เหมือนเงาที่ตามผู้พูดด้วยช่วงเวลาห่าง 1-2 วินาที การวิจัยแสดงว่าเทคนิคนี้ปรับปรุงความแม่นยำในการออกเสียง ทำนองเสียง จังหวะ การเชื่อมเสียง การฟังเข้าใจ และความคล่องแคล่วในการพูดได้อย่างมีนัยสำคัญ