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명 이상의 취업준비생 및 주니어 멘토링 및 강의
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.
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 :)
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!