Data Analytics Course

Chapter 1: How to become a data analyst in seven weeks
Lesson 1: Why do you need seven weeks
Lesson 2: How to learn in 7 weeks?

Chapter 2: Data Analysis Thinking
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
Lesson 15: Why Business Matters
Lesson 16:Classic 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)
Lesson 31: Data Management Business

Chapter 4: Fundamental data analysis method via spreadsheet
Lesson 32: The necessity of data analysis via spreadsheet
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 spreadsheet
Lesson 40: Useful spreadsheet Tools (tips) help analysis (1)
Lesson 41: Spreadsheet Tools (tips) help analysis  (2)
Lesson 42: Data Analysis exercise with spreadsheet (1)
Lesson 43: Data Analysis exercise with spreadsheet (2)

Chapter 5: Data Visualization
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: 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)
Lesson 60: Data Analysis with BI (2)
Lesson 61: Dashboard

Chapter 6: Advanced data analysis method via RDBMS
Lesson 62: Set your RDBMS environment
Lesson 63: Database introduction
Lesson 64: Database Practice
Lesson 65: select commands
Lesson 66: conditional lookup commands
Lesson 67: group by commands
Lesson 68: group by Advanced commands
Lesson 69: Other Function
Lesson 70: Subquery commands
Lesson 71: join commands
Lesson 72: leetcode commands
Lesson 73: Load commands
Lesson 74: Time commands