Inflearn brand logo image
Inflearn brand logo image
Inflearn brand logo image
Business & Marketing

/

Project & Product Management

The Problem Definition for Data Analysis That SQL Lectures Don't Teach

Learn the problem definition and hypothesis formulation process, core competencies for data analysis!

(4.0) 2 reviews

111 learners

  • platter
서비스기획
데이터분석
데이터분석가
그로스해킹
product-management
Data literacy

Reviews from Early Learners

What you will learn!

  • Problem Definition Process Necessary for Data Analysis

  • The Essentials of Data Analysis Before SQL

  • Problem Definition Know-how for PM/PO/PA


Are you learning SQL from scratch for data analysis?
What you really need for data analysis is not tools, but the ability to ‘ define problems and establish hypotheses ’.



The core competency of data analysis is with the field gross PM.

Learn how to define problems and develop hypotheses.

When I first became interested in data, I was overwhelmed by tools like SQL, Python, R, statistical theories, and machine learning. I was anxious, so I took classes, studied, and obtained certifications, but I was still stuck. However, I realized while analyzing data in the field and improving products/services through it. The most important thing for data analysis is not tools, skills, or difficult theories, but defining the problem you want to find the answer to through analysis and designing a hypothesis for it .

So this lecture is designed for those who are learning technologies like SQL for data analysis at this very moment and have missed the most important problem definition and hypothesis design. Without difficult terms or tools, I will tell you what you really need to do for data analysis !

I recommend this to these people!

😥

This is my first time doing data analysis
New~Junior Analyst or PM/PO

😎

Beyond writing queries, discovering problems
Anyone who wants to grow into an analyst who verifies hypotheses

Do you have any concerns like this?

I learned SQL, but what do I do now?
I don't know what to do.

I learned SQL, but I have no experience with interviews and portfolios.
I keep getting dropped from feedback.

Am I an analyst?
I don't know if you are a SQL query writer.

What skills are most needed for an analyst?
I want to know and learn.


SQL is just a tool,
What an analyst really needs is a problem definition .

There are many things that are said to be necessary for the work of an analyst, such as SQL, Python, R, statistics, machine learning/deep learning, etc., but these are only tools and means. What is really necessary to grow into a data analyst who discovers and defines problems in a product, verifies hypotheses, and grows the product through this is not JOIN and Sub Query, but the ability to define problems and design hypotheses for analysis!

💡 This lecture!

  • Anyone can listen without prior knowledge of data analysis or statistics.
  • The entire process of data analysis is explained step by step with real-life examples.
  • Rather than studying or researching, we provide perspectives, mindsets, and know-how suitable for a business environment.

#1.
Defining the problem

Before we start writing queries, let's go through the process of defining what question we really want to answer.

#2.
Hypothesis establishment and
Priority Decision

Is there anything we already know to solve the problem we have defined? And do we really need to analyze all of it? We will look at the process of designing hypotheses and prioritizing numerous hypotheses.

#3.
Designing an Analysis Task

Do you really need to write SQL queries to analyze the problems and hypotheses you have defined? And what numbers should you derive? Let's look at the things to consider when designing an analysis task.

#4.
Interpretation of results and
Developing an action plan

How should we interpret the numbers derived from the analysis? And is our work finished once we have analyzed it? Let’s take a look at the key tasks that must be taken care of after the analysis.

#5.
PM/PO/PA
For those who wish

Are advanced SQL skills necessary for PM/PO and PA who analyze data to grow products? Why do we analyze data in the first place? Let’s take a look at the core context of our data work.


Expected Questions Q&A 💬

Q. Can you teach me SQL?

This course will not explain SQL! Instead, I will explain the process of defining a problem and establishing a hypothesis, which is essential for data analysis. If you learn SQL, Python, or R based on this, you will be able to grow faster!

Q. As an analyst, isn’t technology important?

Isn't analysis ultimately a method or process for finding answers to our questions? If the problem we want to find answers to is unclear, no matter how advanced the query is or how difficult the statistical theory is, will we be able to find the right answer?

Q. So, are you saying that I shouldn't learn SQL or other tools?

Of course, defining a problem and establishing a hypothesis does not mean that analysis is done! I think that if you understand the process of defining a problem and establishing a hypothesis covered in this class well and then learn and master the necessary tools and instruments, you will be on your way to success!

✔️ Things to note before taking the class

  • Benefits of this course only
    • Those who leave a review of the course will receive a discount coupon for other courses that open in the future!
    • Join the open KakaoTalk room to receive ongoing Q&A, upcoming lectures and special sessions, and updated lecture materials first!
  • Note
    • For questions related to the lecture, we will answer them as soon as we check them. For frequently asked questions, we will provide additional videos in the future.
    • The copyright of all materials used in the lecture belongs to the lecture creator. However, if you want to organize and share what you have learned on your personal blog, etc., please be sure to share the link to this lecture!

Recommended for
these people

Who is this course right for?

  • PMs/Planners: Data is needed too, they say... Should I learn SQL first?

  • For those who find data analysis difficult despite learning SQL

  • Those who blindly learn SQL first for data analysis.

Hello
This is

576

Learners

29

Reviews

1

Answers

4.3

Rating

2

Courses

사수 없이 시작하고 성장하는 기획자, PM/PO, 분석가를 위한
역량 개발 실험실 플래터 워크랩을 운영하고 있습니다.
서비스 기획, 프로덕트 매니징, 프로덕트 데이터 분석의 지식과 노하우를 나눕니다.


- <성장하는 PM을 위한 프로덕트 매니저 가이드> 저
- <전략적 사용자 행동분석> 저
- 네이버 클라우드, 우아한형제들 등 기업 및 기관 강의 다수
- 300명 이상의 취업준비생 및 주니어 멘토링 및 강의


브런치 : https://brunch.co.kr/@539insight
뉴스레터:  https://maily.so/platter.worklab

Curriculum

All

12 lectures ∙ (2hr 54min)

Published: 
Last updated: 

Reviews

All

2 reviews

4.0

2 reviews

  • youndahyekor1252님의 프로필 이미지
    youndahyekor1252

    Reviews 1

    Average Rating 3.0

    3

    100% enrolled

    I took this course because I felt that I lacked data capabilities in the process of transitioning from a service planner to a PM. This is an introductory course that will teach you what kind of mindset and direction to approach effectively.

    • yangyumi3066님의 프로필 이미지
      yangyumi3066

      Reviews 1

      Average Rating 5.0

      5

      42% enrolled

      I am an 8-year developer. I changed my job to PM and while looking for materials, I came across this course. SQL is essential for data analysis, and I can already write queries, but I always had trouble deciding how to view which figures. This is because I had to come up with a solution based on the data. I wanted to find a basis for explaining the data that I thought was important to others. While taking this course, I learned how to define the problem first for data analysis, and I got answers to which indicators to look at, how the results should be generated, and how to interpret them. This is a good course for those who are already PMs and those who are preparing for it :)

      • platter
        Instructor

        Thank you for your thoughtful review :) In the future, in addition to the examples provided in this lecture, I will add other analysis examples covered in the product to make the process from defining the problem to deriving an action plan more vivid!

    $38.50

    platter's other courses

    Check out other courses by the instructor!

    Similar courses

    Explore other courses in the same field!