Data Analytics Career Overview - From Skills to Interviews

Focused View

WeiChun (Marcus) Chang

2:42:51

13 View

1. Course Overview

1. Intro to the course.mp4

03:39

2. Course Materials.html

2. Analytics Roles Overview

1. Analytics Roles Breakdown.mp4

02:14

2. Marketing Analyst Scenario - Allocating Budget.mp4

03:21

3. Operation Team Scenario - Customer Service Analysis.mp4

02:39

4. People Analysis Scenario - Finding Potential Attrition.mp4

01:55

5.1 Chart type for display.html

5. Business Analyst Scenario - Building Reports & Dashboards.mp4

01:59

6. Product Analyst Scenario - Improving E-commerce Website.mp4

02:01

7. Data Scientist Scenario - Marketing Customer Segmentation.mp4

01:43

3. Analytics Tools

1. Analytics Tools Overview.mp4

02:01

2.1 My Analysis of Googles job openings.html

2. Why is SQL important.mp4

02:05

3. SQL - Select & From.mp4

01:33

4. SQL - Where.mp4

00:36

5. SQL - Group By & Aggregation.mp4

02:11

6. SQL - Order BY.mp4

01:13

7.1 ERD Explanation.html

7. SQL - Join & ERD.mp4

04:53

8. SQL - 4 Types of Join.mp4

02:14

9. SQL - Self Join.mp4

01:51

10.1 More about Window Functions.html

10. SQL - Window Functions.mp4

02:46

11.1 Resources List.html

11. SQL - Self-Learning & Portfolio Building.mp4

04:04

12.1 Tableau Public Workbook.html

12. Tableau - Business Intelligence & Visualization.mp4

01:57

13.1 Feature Engineering Explanation.html

13. PythonR - Why I need to learn PythonR.mp4

02:39

14. PythonR - Example 1.mp4

01:58

15. PythonR - Example 2.mp4

01:38

16.1 Resources List.html

16. PythonR - Resources List.mp4

02:02

4. Quantitative Analysis

1. Intro.mp4

00:33

2. Product Sense - Metrics Definition.mp4

03:39

3. Metrics Definition - Question 1.mp4

00:39

4. Metrics Definition - Answer 1.mp4

02:31

5. Metrics Definition - Question 2.mp4

00:56

6. Metrics Definition - Answer 2.mp4

02:21

7. Normalization.mp4

02:51

8. Normalization - Question 1.mp4

00:35

9. Normalization - Answer 1.mp4

01:46

10. Normalization - Question 2.mp4

00:42

11. Normalization - Answer 2.mp4

02:04

12. Product Case Practice - Question.mp4

00:56

13. Product Case Practice - Answer.mp4

04:43

14.1 Resources List (Links embedded in pictures).html

14. Recommended Resources.mp4

03:47

5. Interviews

1. Intro & Agenda.mp4

02:49

2. Self Introduction.mp4

06:13

3. Behavior Questions.mp4

03:08

4. Technical Questions - Intro.mp4

02:16

5. SQL - Question 1.mp4

01:43

6. SQL - Solution 1.mp4

02:03

7. SQL - Question 2.mp4

00:36

8. SQL - Solution 2.mp4

01:09

9. Technical Questions - Data Manipulations.mp4

02:40

10. Technical Questions - Algorithms.mp4

01:41

11. Case Interview - Intro.mp4

01:35

12. Case Interview - Question 1.mp4

00:47

13. Case Interview - Solution 1.mp4

03:03

14. Case Interview - Question 2.mp4

00:49

15. Case Interview - Solution 2.mp4

02:51

16. Case Interview - Question 3.mp4

00:42

17. Case Interview - Solution 3.mp4

04:03

18. Case Interview - Deal with Ambiguity - Question 1.mp4

00:41

19. Case Interview - Deal with Ambiguity - Solution 1.mp4

05:18

20. Case Interview - Deal with Ambiguity - Question 2.mp4

00:36

21. Case Interview - Deal with Ambiguity - Solution 2.mp4

03:09

22. Case Interview - Advanced Analytics Intro.mp4

01:49

23. Analytics Case Interview - Question 1.mp4

01:21

24. Analytics Case Interview - Solution 1.mp4

05:10

25. Analytics Case Interview - Question 2.mp4

00:33

26. Analytics Case Interview - Solution 2.mp4

02:43

27. Case Interview - Thinking Process Example 1.mp4

02:20

28.1 Clustering Explanation.html

28. Case Interview - Thinking Process Example 2.mp4

04:09

29. Case Interview - Thinking Process.mp4

02:28

30.1 Resources List.html

30. Interview Resources.mp4

02:17

31.1 An inspiring article about offer negotiation.html

31. Offer Negotiation.mp4

07:56

32.1 My LinkedIn.html

32.2 Questionnaire.html

32. Congratulations!.mp4

00:58

33.1 AB Testing.html

33. Whats Next.html

Description

A guide to your career in analytics track

What You'll Learn?

If analytics career is right for you
What tools and skills you need for getting an analytics job
To know how analytics can help you in work
Understand different analytics tools and use cases
Frequently seen mistakes during analysis
Quantitative method that can help you better in analysis
Interview questions for analytics roles
Some tips of job offers negotiation

Who is this for?

People who are interested in but new to analytics

Analytics workers who are struggle to find better methodologies for analysis

Engineers or Product Managers who would like to know more about product analysis

People from marketing or operation who would like to apply analytics in their work

What You Need to Know?

No prerequisite for coding and analysis, but requires basic statistics knowledge, i.e. mean, percentiles, and distribution

Ideally some SQL & spreadsheet knowledge would be better

More details

Description
Do you need analysis in your work? Or you want to be an analyst but don't know where to start? Many companies claim that they are data-driven and looking for analytical talents. But what is data driven and what exactly is analytical skills? Why we are already looking at numbers but still don't know what to do? Why I have required skills like SQL or Python, but still not hired?

If you have related questions like mentioned above or wonder if analytics career is right for you, this course could be right to you. This course won't teach you everything of SQL, Python, or R. But will let you know what tools or techniques you need to be an analyst. It's perfect for students or people who want to be analyst.

I'll walk you through what roles you would have chance to apply analysis, what popular tools there are in tech industry, and how the interviews would look like. I even provided the list of courses and resources that I recommend. My 5 years of experience and job searching knowledge sharing in a nutshell.

Chapters
Overview
Different roles and their scenarios of using analysis during work
Tools
Spreadsheet
SQL
Tableau
Python & R
Quantitative Analysis
Metrics Definition
Normalization
Frequently seen mistakes
Interview
Behavioral
SQL
Technical Screening
Case Interviews
Who this course is for:
People who are interested in but new to analytics
Analytics workers who are struggle to find better methodologies for analysis
Engineers or Product Managers who would like to know more about product analysis
People from marketing or operation who would like to apply analytics in their work

User Reviews

Rating

average 0

Total votes0

Focused display

Data Analysis

WeiChun (Marcus) Chang

Instructor's Courses

Over 100+ interviews with over 50 companies in 10 different countries in past 5 years of professional experience. Also an interviewer for analytics role.Analytics @ FAANG, Pre-IPO Unicorn company, and getting offers from 5 different countries.Designed and analyzed Product Development and Marketing experiments for AB testing experiment design and metrics defined, optimized company-wise workflows and saved workload by proposing and developing new tools. Self-driven as posting 700 posts and reaching 5M+ on LinkedIn in the past 5 years. Aspiring to grow data maturity with organizations, leveraging experimentation and causal inference for growth strategy.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.