After graduating with a music business degree from NYU in 2019, the speaker started as a business analyst without direct experience in the field. They learned essential skills over two and a half years, which they believe are crucial for a business analyst in tech: SQL for data analysis, data wrangling with Excel/Google Sheets, and problem-solving skills. They also discuss the importance of strategic thinking and business sense, turning data into actionable insights. The video is sponsored by GlassesUSA.com, which offers affordable prescription glasses online. The speaker provides tips on learning these skills through courses, practice, and engaging with cross-functional stakeholders.
Here are the key facts extracted from the text:
1. The speaker graduated from college in 2019.
2. The speaker started their first job as a business analyst.
3. The speaker studied music business at NYU.
4. The speaker had no direct business analytics background.
5. The speaker learned from mentors, colleagues, and trial and errors.
6. GlassesUSA.com offers over 9,000 prescription glasses and sunglasses.
7. GlassesUSA.com offers a risk-free shopping experience with free shipping and returns.
8. The speaker recommends DataCamp's class on intro to SQL for learning SQL.
9. The speaker recommends Lead Code or Interview Query for practicing SQL.
10. The speaker uses pivot tables, IFs, VLOOKUPs, INDEX MATCH, and SUMIF in their day-to-day work.
11. The speaker recommends playing around with data to learn data wrangling skills.
12. The speaker recommends watching case interviews to learn problem-solving skills.
13. The speaker recommends internships in consulting, analytics, or market research to learn problem-solving skills.
14. The speaker recommends practicing problem-solving skills by turning data into insights and telling a story.
15. The speaker recommends role-playing to sharpen strategic thinking.
16. The speaker recommends thinking about the "so what" of knowing a data point to make insights actionable.
17. The speaker recommends having regular conversations with people outside your team to learn how things work at your company.
Note: I excluded opinions and focused on extracting factual information from the text.