**Chapter 1: Instruction of becoming a data analyst in an efficient way**

Lesson 1: What is the general path for being a data analyst

Lesson 2: How to learn and practice in this course

**Chapter 2: How to think like a data analyst**** **

Lesson 3: the reason of why we put this in beginning

Lesson 4: Structured principle of Data Analysis

Lesson 5: Formulation principle of Data Analysis

Lesson 6: Business principle of Data Analysis

Lesson 7: Analysis with Quadrant Method

Lesson 8: Analysis with Multidimensional Method

Lesson 9: Analysis with hypothesis and Index Method

Lesson 10: Analysis with 28 Laws

Lesson 11: Analysis with Comparative Method

Lesson 12: Analysis with Funnel Method

Lesson 13: How those method used in real life work

**Chapter 3: How analysis differ in business model**

Lesson 14: why business is important to consider

Lesson 15: What Indicator matter in business analysis

Lesson 16: Using indicator to estimate Marketing

Lesson 17: Using indicator to estimate Product Operational

Lesson 18: Using indicator to estimate User Behavior

Lesson 19: Using indicator to estimate E-Commerce

Lesson 20: Using indicator to estimate Traffic

Lesson 21: crate a new indicator

Lesson 22: Build a Business Analysis Framework

Lesson 23: Introduction to Marketing Model

Lesson 24: classic AARRR Model

Lesson 25: Build a User Behavior Model

Lesson 26: Build a E-Commerce Model and a Traffic Model

Lesson 27: Business scenarios

Lesson 28: Practice for those scenarios

Lesson 29: Data Management In Business

**Chapter 4: Handle Data With Spreed Sheet **

Lesson 30: Introduction to spreed sheet

Lesson 31: Text Cleaning

Lesson 32: Exercise for text Cleaning

Lesson 33: Matching command

Lesson 34: Logical statement in spreed sheet

Lesson 35: Statistical pre-build methods in spreed sheet

Lesson 36: Time Series in spreed sheet

Lesson 37: Frequently Asked Questions

Lesson 38: Spreed Sheet Toolkit (1)

Lesson 39: Spreed Sheet Toolkit (2)

Lesson 40: Data Analysis with spreed sheet example (1)

Lesson 41: Data Analysis with spreed sheet example (2)

**Chapter 5: Data Visualization **

Lesson 42:Why we care Data Visualization

Lesson 43: Fundamental Chart

Lesson 44: Advanced Chart Types

Lesson 45: Introduction to drawing tools

Lesson 46: visualization with spreed sheet based software

Lesson 47: Scatter graph

Lesson 48: strategy I — helper column