BigQuery(SQL) Application (Funnel Analysis, Retention Analysis)

*𝓑𝓮𝓼𝓽 𝓢𝓠𝓛 𝓒𝓸𝓾𝓻𝓼𝓮 𝓸𝓷 𝓘𝓷𝓯𝓵𝓮𝓪𝓻𝓷 𝓲𝓷 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~)

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

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.

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!!!

Hello, Kyle School! I'm a long-time fan. I'm on my way to landing a job as a data analyst, and Kyle School has been a great help. I hope data engineering lectures will be released soon. I'm currently studying AIRFLOW, and it's my first time, so I'm struggling a lot. I've completed all the lectures, and I'm planning to create my own blog and implement GA in the process. Now, I'm going to do a deep dive and analyze the existing data. I'm currently going through a tough time preparing for a job, but thanks to Kyle School's lectures, my thoughts on how I can contribute to the company are expanding more and more. In the process, I'm dreaming and working hard today. Thank you! P.S. If you release lectures in the future, will there be a discount event for job seekers? 😭😭

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 :)

The part where you went beyond queries to provide detailed explanations with queries for various analysis methods was excellent. Actually, since I already work with SQL to some extent in my current job, I took this course just to brush up on it, but it was a valuable lecture where I could gain aha moments(?) from unexpected areas. Most of all, the funnel and cohort content was extremely good. If those concepts are vague or you want to study them in more detail, just listening to those parts alone would be sufficiently helpful. Thank you! And I'm always rooting for you, Kyle!!

Following the introduction course, I also took this practical course. I am working as a marketer, and I am very satisfied with the practical tips I received, such as funnel and retention analysis patterns, in situations where I have to analyze without data organization! My company also uses GA4+BigQuery, so it was good that I could apply it to my work right away :) I look forward to the next lecture~~