Data Literacy for PMs (Product Data Analysis)

This is an introductory BigQuery (SQL) course for beginners. I recommend it to those who are curious about how to process data. I will teach SQL from the perspective of data analysis and data engineering, rather than from a backend development perspective.

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.

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.

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.

I have packed this with everything I want to tell junior PMs/POs who are struggling due to a lack of good mentors. I will generously share various techniques and mental models used by high-performing PMs/POs.

This is a detailed and practical course for Google Analytics beginners. Rather than just covering fragmented features, you can learn the actual analysis process using GA4 through scenario-based analysis. It is continuously being updated to reflect the latest GA4 changes!

Data-driven growth hacking needed for PM, marketers, designers, operations managers, and sales positions. This one video will give you a complete understanding of the basics.

Learn SQL not through listing grammar like SELECT and WHERE, but by solving business questions like "What are recent sales?", "Who buys more?", and "What are the Top 5 products?". Practice hands-on in a free environment (BigQuery Sandbox + Looker Studio) and complete analysis results with dashboards. You can gain practical data analysis thinking along with SQL fundamentals without getting bored.

This is an introductory BigQuery (SQL) course for beginners. I recommend it to those who are curious about how to process data. I will teach SQL from the perspective of data analysis and data engineering, rather than from a backend development perspective.

I have worked at seven different small startups that had neither data analysts nor user researchers, and I've stumbled through various trials and errors. I will share the many realistic challenges a UX designer can face, along with the deep insights I gained while navigating through those difficulties.

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.

Do you want to get a job as a data analyst? Based on my experience, let's take a look at the tasks for each data role in real companies.

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.

Experimentation and A/B testing are essential skills in CRM marketing and growth marketing practice. Both PMs and POs must repeatedly conduct experiments and A/B tests in growth marketing and CRM marketing campaigns to maximize performance and efficiency. In fact, when PM and PO roles establish CRM marketing strategies based on experimentation and A/B testing, they can simultaneously achieve data-driven growth marketing performance and cost efficiency.

Repetitive pipeline management in Data Warehouses (DW), now free yourself from that painful cycle with dbt! Building on the efficiency provided by dbt, become a data analytics engineer who creates higher value through business-centric data modeling, effective data lifecycle management, and more.

[Systematization of Engineering Intuition and Intelligent Problem-Solving Methodology Roadmap] 1. Introduction: Shift in the Problem-Solving Paradigm (The Birth of the Problem Architect) The complexity of modern industry has reached a level that exceeds the cognitive capacity of individual engineers, clearly exposing the limitations of "troubleshooting," which is a simple reactive repair approach. To derive meaningful solutions in manufacturing and R&D sites where tens of thousands of variables are intertwined, it is essential to evolve into a "Problem Architect" who goes beyond solving occurring problems to eliminating the problem-generating structure itself at the design stage. This masterclass combines 40 years of engineering intuition with cutting-edge artificial intelligence technology to present specific intelligent problem-solving techniques that transform uncertainty into engineering necessity. 2. Step-by-Step Intelligent Problem-Solving Techniques (The Methodology) ① Data-Driven Causal Identification Technique: DMAIC 4.0 The traditional Six Sigma methodology—Define, Measure, Analyze, Improve, and Control—is advanced by combining it with the computational power of modern AI. Selection of Key Process Input Variables (KPIV): AI algorithms are utilized to extract key factors with actual causal relationships, rather than mere correlations, from among thousands of variables. Securing Statistical Consistency: We establish an analytical process that proves capabilities with a Process Capability Index (Cpk) of 1.33 or higher through data, realizing "zero defects through statistical necessity" rather than "accidental good products." ② Virtual Verification and Lead Time Reduction Technique: Zero-Trial Strategy To minimize physical trial and error, we introduce verification techniques in a Digital Twin environment, which perfectly replicates real-world processes in a digital space. Cost-Free Limit Testing: Optimal process conditions are derived by performing tens of thousands of simulations in a virtual environment without interrupting actual production lines or destroying prototypes. Multi-Agent System-based RCA: We apply a "time leverage" technique that innovatively shortens the lead time required for Root Cause Analysis (RCA) by deploying multiple AI agents that simultaneously perform search, reasoning, and cross-verification. ③ Logical Thinking and Knowledge Assetization Technique: Pyramid Narrative and Knowledge Graphs This is a knowledge structuring technique that ensures field problem-solving experiences do not remain in individual memories but spread as the intelligence of the entire organization. Pyramid Principle and SCQA Framework: By combining Barbara Minto's Pyramid Principle with the Situation, Complication, Question, and Answer (SCQA) structure, complex technical issues are reconstructed into logical narratives that management can immediately accept. Building Knowledge Graphs: Fragmented technical reports and drawing data are converted into a graph structure capable of real-time reasoning. Through this, an organizational learning system is established where problem-solving cases from a specific point are immediately propagated (Yokoten) to production bases worldwide. ④ Transparency-Based Decision Support Technique: Explainable AI (XAI) This technique involves verifying AI outputs based on engineering logic rather than blindly accepting them. Chain of Thought Visualization: By transparently disclosing (Glass Box) the step-by-step logical development process the AI went through to reach its final conclusion, the basis for decision-making is secured. Human-in-the-Loop Governance: AI serves as a Co-pilot suggesting optimal alternatives, while the system is designed so that the final trigger is approved by human engineering insight and ethical judgment. 3. Human-Centered Cognitive Sovereignty Acquisition Techniques As the automation rate of systems increases, active response techniques are required to prevent the decline of the cognitive capabilities of the humans operating them. Sandwich Workflow: Instead of delegating the entire work process to AI, a structural work technique is applied where humans preemptively occupy context design (Top Bun) and final value judgment (Bottom Bun) to prevent cognitive paralysis. RQTDW Learning Protocol: By mandating five stages—Read, Question, Think (confronting contradictions), Discuss (virtual debate), and Write—into the practical process, we reject simple acceptance of information and actively internalize knowledge into the brain. Intentional Cognitive Friction: To maintain a critical distance from the overly smooth answers provided by AI, an adversarial verification process using a Critique Agent is conducted. 4. Practical Application: Super-Gap Leadership for "Designing Out" Problems The ultimate maturity of problem-solving lies not in solving problems well after they occur, but in "Designing Out" the system structure so that problems cannot occur. Data Infrastructure and Autonomous Operation Design: We block the possibility of human error by building an autonomous operation system that ranges from real-time data collection to feedback loop-based correction. Organizational Intelligence: By converting individual expert know-how into standardized algorithms and knowledge graphs, we secure an upwardly standardized problem-solving capability for the entire organization. 5. Conclusion: Future Competitiveness Completed by Engineering Rigor While intelligence is manifested through AI technology, the vessel that contains that intelligence and makes it operate according to its purpose is only a rigorous and sophisticated engineering problem-solving methodology. This masterclass will move away from technology adoption that relies on luck or probability and present a path to becoming a "True AI Architect" who perfectly commands systems with data and logic. We hope you establish your status as a super-intelligent helmsman who dominates technology and eliminates problems.

This course is designed for those aiming to obtain the Data Architecture Semi-Professional (DAsP) certification. It provides a simple and systematic overview of essential exam topics, ranging from basic data architecture concepts to data modeling, data quality, and governance. The curriculum is structured to minimize complex theories and focus on frequently tested concepts, making it accessible for non-majors and beginners to learn without pressure. Build your fundamental skills in understanding data structurally while preparing for the DAsP certification.

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!

['Thought Architect' Roadmap for Translating Technical Truth into Business Value] 1. Introduction: Analysis of Constraints in Transferring Technical Truth to Business Value A significant bottleneck frequently observed across corporate sectors and engineering sites (R&D) is the phenomenon where innovative achievements, backed by massive resources and research capabilities, are discarded because they fail to overcome the 'communication threshold.' This is judged to stem from information asymmetry: a situation where management does not sufficiently perceive the depth of deep-tech, and technical personnel fail to appropriately utilize business language. This masterclass redefines the 'text-based communication competency' of engineers and scientists not as a mere administrative act of recording, but as part of a precise 'Engineering Design' process. Through this, we aim to present a mechanism by which an engineer's technical insights are transformed beyond simple records into core assets that drive the organization's strategic decision-making. 2. [Diagnosis] Analysis of Three Major Cognitive Defects Hindering Technical Communication ① Disconnection of Information Transfer due to the Curse of Knowledge This phenomenon occurs when experts become immersed in their own advanced level of knowledge and overlook the cognitive background of the information recipient. Consequently, reports centered on obscure formulas and technical acronyms are repeated, which is highly likely to result in structural losses such as loss of contact with decision-makers, delays in project approval, and failure in resource allocation. ② Value Loss due to Lack of Logical Architecture and Data Fragmentation By regarding document preparation as a simple post-hoc administrative procedure, errors of listing information without systematic design are frequently observed. These structural defects significantly damage the value of R&D achievements during the delivery process, tending to lead not only to the undervaluation of an individual engineer's capabilities but also to the loss of tangible and intangible assets for the entire organization. ③ Technical Reliability Crisis due to Deepening AI Dependency If generative AI, introduced to improve productivity, causes hallucinations without understanding the technical context, 'technical reliability'—the core value of engineering—can be seriously undermined. Utilizing AI without an accompanying logical verification system is highly likely to act as a potential system risk rather than a work efficiency tool. 3. [Prescription] Strategic Communication System for the Thought Architect ① Engineering Design of Thought for Unstructured Information A process of structuring abstract experimental data and hypotheses based on engineering system design principles is required. Bottom Line Up Front (BLUF): By placing core values and recommendations at the forefront of the document, we aim for an information structure optimized so that management can perform rapid and accurate decision-making (capital investment, mass production approval, etc.). Mutually Exclusive, Collectively Exhaustive (MECE): By adhering to principles that prevent logical overlap and omission, we ensure the logical completeness of the report by designing a seamless flow of thought. ② Global Standard Compliance and Quality Assurance Objectivity and integrity of data must be secured by internalizing standard protocols recognized by the global scientific community and global corporations. Standard Technical Reporting Structure (IMRaD): Maintain the consistency and reliability of the engineering narrative through a rigorous formal structure leading from Introduction, Methods, Results, to Discussion. 5 Principles of Sentence Quality (5C): By applying Correctness, Clarity, Conciseness, Consistency, and Completeness as quality control filters, we establish a Plain Language system that even non-experts can understand immediately. ③ S.E.E.D Prompt Architecture for Securing AI Command To operate AI not as a simple ghostwriting tool but as an assistant performing logical operations, a dedicated interface design must be involved. S.E.E.D Framework: Precisely control the quality of AI outputs by systematically structuring and inputting Situation, Expectation, Engineering Structure, and Data. Human-in-the-Loop: Establish a protocol where humans perform verification as the final approver to block the possibility of AI errors, thereby firmly maintaining technical authority. 4. [Execution] Strategies for Securing Cognitive Sovereignty and Workflow Optimization Communication competency acts as a core mechanism for preserving an engineer's cognitive functions beyond mere technical means. Responsibility-based Sandwich Workflow: Humans must perform context design (Top Bun) and final verification (Bottom Bun), delegating only the intermediate data processing (Meat) stage to AI to promote the activation of the human-unique Executive Control Network (ECN). RQTDW Learning Protocol for Knowledge Internalization: Apply the five stages of Read, Question, Think (facing contradictions), Discuss (virtual discussion), and Write to practical work to avoid simple acceptance of information and actively internalize knowledge. SIFT Model-based Precision Fact-Checking: Filter AI hallucinations and maintain technical precision through the process of Source (checking the origin), Investigate (understanding context), Find (cross-checking), and Trace. 5. Conclusion: Transition from Technical Expert to Engineering Leader The era of practitioners who simply perform given technical tasks is coming to an end. The ability to translate and communicate complex and difficult technical truths into a 'language of value' acceptable to organizations and society can be defined as a core survival strategy and a noble calling for modern engineers. Text communication is the Final Interface that projects an engineer's intellectual capacity to the outside world, beyond a simple act of recording. Through this masterclass, we expect you to prove your technical value and emerge as a powerful 'Engineering Leader' who drives organizational change. This system, which integrates 40 years of engineering insight, will become a strategic asset that completes your status as a professional.

Data Visualization Storytelling That's Perfectly Achievable with Excel Alone