**Chapter 1: Instruction of becoming a data analyst in an efficient way -0.8% 10 hours**

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**** -8.3% 40 hours**

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

Lesson 10: Analysis with Index Method

Lesson 11: Analysis with 28 Laws

Lesson 12: Analysis with Comparative Method

Lesson 13: Analysis with Funnel Method

Lesson 14: How those method used in real life work

**Chapter 3: How analysis differ in business model -10.4% 50 Hours**

Lesson 15: why business is important to consider

Lesson 16: What Indicator matter in business analysis

Lesson 17: Using indicator to estimate Marketing

Lesson 18: Using indicator to estimate Product Operational

Lesson 19: Using indicator to estimate User Behavior

Lesson 20: Using indicator to estimate E-Commerce

Lesson 21: Using indicator to estimate Traffic

Lesson 22: crate a new indicator

Lesson 23: Build a Business Analysis Framework

Lesson 24: Introduction to Marketing Model

Lesson 25: classic AARRR Model

Lesson 26: Build a User Behavior Model

Lesson 27: Build a E-Commerce Model

Lesson 28: Build a Traffic Model

Lesson 29: Business scenarios

Lesson 30: Practice for those scenarios **-0.8% 10 Hours**

Lesson 31: Data Management In Business

**Chapter 4: Handle Data With Spreed Sheet -10.4% 50 Hours**

Lesson 32: Introduction to spreed sheet

Lesson 33: Text Cleaning

Lesson 34: Exercise for text Cleaning

Lesson 35: Matching command

Lesson 36: Logical statement in spreed sheet

Lesson 37: Statistical pre-build methods in spreed sheet

Lesson 38: Time Series in spreed sheet

Lesson 39: Frequently Asked Questions

Lesson 40: Spreed Sheet Toolkit (1)

Lesson 41: Spreed Sheet Toolkit (2)

Lesson 42: Data Analysis with spreed sheet example (1) **-0.8% 10 hours**

Lesson 43: Data Analysis with spreed sheet example (2) **-0.8% 10 hours**

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

Lesson 44:Why we care Data Visualization

Lesson 45: Fundamental Chart

Lesson 46: Advanced Chart Types

Lesson 47: Introduction to drawing tools

Lesson 48: visualization with spreed sheet based software

Lesson 49: Scatter graph

Lesson 50: strategy I — helper column