Introduction to BigQuery (SQL) for Beginners

This is a course for PMs who want to utilize data. This course covers the entire process of utilizing data in the PM role, including the flow of work from day 1 of a job change through the start and end of a project. It is an introductory data course that covers data-driven thinking, logical thinking, metric definition, log design, experiment design, creating a data culture, and more, to help you develop critical thinking skills. Although created as a course for PMs, it is structured with content that data analysts would also find beneficial (in fact, many analysts have taken the course). In addition, many people in marketing, design, and business planning roles are also taking the course.

We conduct app log analysis using data from Google Analytics 4 and Firebase. It includes useful content for practical use, such as arrays, window functions, funnels, retention, Google Sheets, and more.

This is a lecture for those who want to consistently write a technical blog. Starting is easy, but trying to do it consistently leads to many trials and errors. This lecture compiles what I've tried and the know-how gained from operating a technical blog for over 7 years. It contains all my 7 years of experience, including SEO, technical blog writing strategies, writing process, etc.

Let's learn together about Columnar Storage, which allows you to conveniently handle both structured and unstructured data provided by GCP and allows for a free table format, and BigQuery, a universal database.

This is a course for PMs who want to utilize data. This course covers the entire process of utilizing data in the PM role, including the flow of work from day 1 of a job change through the start and end of a project. It is an introductory data course that covers data-driven thinking, logical thinking, metric definition, log design, experiment design, creating a data culture, and more, to help you develop critical thinking skills. Although created as a course for PMs, it is structured with content that data analysts would also find beneficial (in fact, many analysts have taken the course). In addition, many people in marketing, design, and business planning roles are also taking the course.

This is a specific and practical course for Google Analytics beginners. Instead of focusing on fragmented features, you can learn the practical analysis process using GA4 by conducting scenario-based analysis. It is continuously being updated to match the latest GA4 revisions!

Make the most of relational database systems!

Easy and fun SQL stories learned from professional instructors! Lectures are conducted systematically and step-by-step for beginners. We offer opportunities to learn with sufficient repetition through a 3-step learning process.

Learn various features of Looker Studio (formerly Google Data Studio) using GA4 demo data. This includes explanations and hands-on practice with Looker Studio's visualization elements. In particular, marketers and planners who are not familiar with SQL can learn easy ways to integrate and use BigQuery data with Looker Studio. You can learn methods to create dashboards using Looker Studio.

As you work through more difficult Leetcode SQL problems, you'll learn how to apply multiple grammar rules to a single problem.

We cover the data literacy required to become an organization/individual that handles data well, as well as the basic theory of data visualization. Build a solid foundation to utilize data “well.”

This is a special lecture that can lay the theoretical foundation to simultaneously prepare for the Microsoft AZ-900 certification, and as the latest content reflecting the scope of questions as of May 2025, by providing content related to core data concepts, Azure's relational data, Azure's non-relational data, and Azure's analytical workloads in a form combining theory and practice, it can be utilized as a meaningful educational opportunity to not only obtain the certification but also take the first step towards becoming a data professional.

For those who feel overwhelmed preparing for the SQLD exam, this is a comprehensive course that analyzes the entire Norang-i scope, organizes necessary theory, conducts practice-focused classes, and solves all problems systematically. With short, concise clips and topic-based segmented structure, you can build skills that work directly in the exam room.

You can learn to use GA4 immediately in practice while creating essential reports for GA4 utilization. You can learn specific examples of what reports to create and how to create them for data analysis. For practical analysis, the installation and usage of Microsoft Clarity, a heatmap tool, is also explained together.

This course teaches MS-SQL through baseball/company databases.

Learn how modern data teams leverage dbt. Build maintainable analytics models and validated data pipelines hands-on. Master core concepts of analytics engineering with a practical focus. This course is for those who want to take their data career to the next level 🚀

By implementing various practical data analysis cases using SQL, you can simultaneously improve your data analysis and SQL utilization skills.

Data Analysis that Determines Online MD Performance! Learn essential data analysis and strategy formulation techniques necessary for MDs to maximize sales and profit in the e-commerce market.

This is a guide course for beginners who are taking their first steps into Oracle. We will teach you the basics of user creation, table creation, and queries.

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

This course is designed to help you learn the core functions of FastAPI, as well as the entire process of web service development. Through this course, we will help you become a FastAPI expert developer needed in the field.

Analyzing customers, markets, and revenue patterns—you no longer need to learn it yourself. Just ask AI, and expert-level analysis and strategies are completed in an instant!