**Chapter 1: How to become a data analyst in seven weeks -0.8% 10 hours**

Lesson 1: Why do you need seven weeks

Lesson 2: How to learn in 7 weeks?

**Chapter 2: Data Analysis Thinking -8.3% 40 hours**

Lesson 3: Why Thinking Is Important

Lesson 4: Three Core Thinkings of Data Analysis (Structured)

Lesson 5: Three Core Thinkings of Data Analysis (Formulation)

Lesson 6: Three Core Thinking of Data Analysis (Business)

Lesson 7: Thinking Skills in Data Analysis (Quadrant Method)

Lesson 8: Thinking Skills in Data Analysis (Multidimensional Method)

Lesson 9: Thinking skills in data analysis (hypothesis)

Lesson 10: Thinking Skills in Data Analysis (Index Method)

Lesson 11: Thinking Skills in Data Analysis (28 Laws)

Lesson 12: Thinking Skills in Data Analysis (Comparative Method)

Lesson 13: Thinking Skills in Data Analysis (Funnel Method)

Lesson 14: How to exercise data analysis thinking during working hours

**Chapter 3: Business Model -10.4% 50 Hours**

Lesson 15: Why Business Matters

Lesson 16:Lessonic Business Analysis Indicator

Lesson 17: Marketing Indicators

Lesson 18: Product Operational Indicators

Lesson 19: User Behavior Indicators

Lesson 20: E-Commerce Indicator

Lesson 21: Traffic Indicator

Lesson 22: How to generate an indicator

Lesson 23: How to Establish a Business Analysis Framework

Lesson 24: Marketing Model

Lesson 25: AARRR Model

Lesson 26: User Behavior Model

Lesson 27: E-Commerce Model

Lesson 28: Traffic Model

Lesson 29: How to deal with various business scenarios

Lesson 30: How to deal with various business scenarios (small exercises) **-0.8% 10 Hours**

Lesson 31: Data Management Business

**Chapter 4: Excel -10.4% 50 Hours**

Lesson 32: Why study Excel

Lesson 33: Text Cleaning Function

Lesson 34: Common Text Cleaning Functions Exercise

Lesson 35: Association Matching Function

Lesson 36: Logical Functions

Lesson 37: Calculating the Statistical Function

Lesson 38: Time Series Function

Lesson 39: Frequently Asked Questions for Excel

Lesson 40: Excel Tools (1)

Lesson 41: Excel Tools (2)

Lesson 42: Data Analysis with Excel (1) **-0.8% 10 hours**

Lesson 43: Data Analysis with Excel (2) **-0.8% 10 hours**

**Chapter 5: Data Visualization -10.4% 50 hours**

Lesson 44: The Beauty of Data Visualization

Lesson 45: Common Chart Types and Applications

Lesson 46: Advanced Chart Types and Applications

Lesson 47: Chart Drawing

Lesson 48: Excel Drawing Skills

Lesson 49: Scatter Figure

Lesson 50: Auxiliary Column

Lesson 51: Composite Chart

Lesson 52: Gantt Chart (1)

Lesson 53: Gantt Chart (2)

Lesson 54: FIG target

Lesson 55: DuPont Analysis

Lesson 56: Getting Started with Power BI

Lesson 57: Power BI Basics

Lesson 58: Power BI Operational Skills

Lesson 59: Data Analysis with BI (1) **-0.8% 10 Hours**

Lesson 60: Data Analysis with BI (2) **-0.8% 10 Hours**

Lesson 61: Dashboard

**Chapter 6: MySQL -10.4% 50 hours**

Lesson 62: MySQL Installation

Lesson 63: Database

Lesson 64: Database Practice

Lesson 65: SQL select

Lesson 66: SQL conditional lookup

Lesson 67: SQL group by

Lesson 68: SQL group by Advanced

Lesson 69: SQL Function

Lesson 70: SQL Subquery

Lesson 71: SQL join

Lesson 72: SQL leetcode

Lesson 73: SQL Load

Lesson 74: SQL Time

Lesson 75: SQL Exercise (1) **-0.8% 10 Hours**

Lesson 76: SQL Exercise (2) **-0.8% 10 Hours**

Lesson 77: SQL connection power bi