BigQuery(SQL) 활용편(퍼널 분석, 리텐션 분석)

I am a student who completed the basic lecture. - The contents are largely 1. BIGQUERY advanced grammar 2. PM-like thinking. - 1 was what I originally wanted, so I was really satisfied. I think it is definitely something that marketers who will analyze data with GA4 should know. - 2 was something I already knew, but it is something that those who have not actually worked at a company or have worked at a company should know, so I think it will be useful for those who are not familiar with terms such as growth hacking/retention. - Outside of the lecture, what impressed me the most was that you also use Discord, continuously monitor feedback, and even provide 1:1 coaching. Regardless of the lecture fee, I can feel that you are trying to care about your students.

*𝓑𝓮𝓼𝓽 𝓢𝓠𝓛 𝓒𝓸𝓾𝓻𝓼𝓮 𝓸𝓷 𝓘𝓷𝓯𝓵𝓮𝓪𝓻𝓷 𝓲𝓷 2024* Those who have read the basic course reviews will know that this is a really, really good lecture for SQL users. 🥺ྀི Personally, Inflearn Number One~ A lecture that I would listen to even if it were twice the price Aren't there always people who have grown into wild queries by using SQL written by others in a position other than an analyst? If I were to recommend just one lecture to my past self, it would be Kyle School... Use BigQuery at your company! (I will explain in detail how to use BigQuery) I can run it by slightly modifying the conditions in the query that has been prepared, but I can't do it alone! I know how to prepare it, but I don't know how it goes through the refining process! I've been waiting for you. I will serve you properly. Buy it now🏃🏃 Then I'll hold my breath until the next part comes out (sigh~)

Thanks to Kyle, I passed the SQL Test and job interview at a domestic unicorn company! Even though I'm an experienced worker, it was my first time taking a coding test, so I was actually quite nervous, but I solved it so easily. The retention problem that you said "comes out when you put in the effort" really came out😆😆 I solved it the easiest thanks to the logic that we covered a lot in the lecture! To be honest, I don't think that "just listening will guarantee you to pass". I participated in a study group, worked hard on solving problems, analyzed other people's solutions in the lecture community, and made my own problems using the data sets you provided and solved them... I tried my best to do as much as I learned. <Tips for getting the most out of the lecture> Beginner: Just listen to the lecture Intermediate: Solve the homework yourself and practice Advanced: Use the community and don't hesitate to get 1:1 coaching (+ I got a lot of advice 1:1 and passed the job interview🤙) Also, many people don't know about the Inflearn roadmap feature, so check it out. https://www.inflearn.com/roadmaps/4639 I've received a lot of help from your blog a few years ago to this lecture, but this is my first time leaving a review. Thank you for being my mentor outside of my company, from my first job search to my work and when I changed jobs🙏 I'm looking forward to the next lecture that you announced at the end!!!

I took this course because I participated in the quick study group 💪 I was able to complete the course in a few weeks thanks to the study group:) [Course review] 1. You can experience practical data analysis : The course focuses on data analysis using BigQuery, which is not well explained in existing courses. You can learn about retention, funnel analysis, and cohort analysis, which are widely used but not well covered in other courses. I think this course is the best course to experience how to use BigQuery in the field and practical use. 2. Smooth communication with experienced lecturers The course also operates a Discord room, and another advantage is that you can communicate through the lecture community > Q&A. Compared to other courses, I felt that they tried to listen to the opinions and questions of the students, and it was good to be able to hear advice from someone with experience in data analysis. In particular, upon completion of the course, you can get a one-time consultation ticket, so it feels like you have a mentor. 3. Difficult grammar made easy! : Personally, it was hard for me to learn Windows functions on my own, but it was good that you explained it easily and that I could see how it is used in actual log data. Also, it was good that I could learn about the usage and utilization of unnest and array, which are often used in the field. 4. You can apply what you learned to data similar to the field! : It is often difficult to apply what you learned to actual data, but it was good that there was a curriculum that applied what you learned to log data similar to the field data every time you learned a technology or grammar. [Recommended for] 1. Those who want to experience SQL-based data analysis 2. Those who want to experience practical data analysis 3. Those who dream of becoming a data analyst and those preparing for a job change

Since it is a small startup and there is no data analyst, PMs often directly extract data through queries. However, I have not attempted retention and funnel analysis because the queries are complicated. Since the lecture title was about utilizing BigQuery, I took the lecture without hesitation! If you are already proficient in SELECT and JOIN to some extent, it will be easy to follow. If you are new to SQL, I recommend taking the basics class and then the utilization class. The window functions I learned here were so useful that I could use them right away in the field. I will also try retention analysis and funnel analysis soon. Thank you for opening a great lecture :)