**Data Analtics Course**

Data analysis is a process of inspecting, cleansing, transforming, and modeling data with the goal of discovering useful information, informing conclusions, and supporting decision-making. Data analysis has multiple facets and approaches, encompassing diverse techniques under a variety of names, while being used in different business, science, and social science domains.

There are various data analysis tools can help us to explore the meaning behind data, we would introduce those tools from basic level spreadsheet to more advanced skill like R and Python. You will learn skills in data manipulation, data visualization, statistics basic intuitively in our training course.

Our training course outline are described below.

**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

Lesson 75: practice Exercise (1)

Lesson 76: practice Exercise (2)

Lesson 77: connection power bi

**Chapter 7: Week 6: Statistics**

Lesson 78: Descriptive Statistics

Lesson 79: Quantile

Lesson 80: Standard deviation 1

Lesson 81: Weight Statistics

Lesson 82: Chebyshev

Lesson 83: Box Line Figure

Lesson 84: Histogram

Lesson 85: Probability

Lesson 86: Bayesian

Lesson 87: Binomial Distribution

Lesson 88: Binomial Distribution 2

Lesson 89: Poisson Distribution

Lesson 90: Normal Distribution

Lesson 91: Hypothesis Test

**Chapter 8: Python**

Lesson 92: Getting Started (setting your environment)

Lesson 93: Data Type

Lesson 94: Variable

Lesson 95: Listing

Lesson 96: List Advanced

Lesson 97: Dictionary

Lesson 98: Collection

Lesson 99: Control Flow

Lesson 100: Python Control Flow Loop

Lesson 101: Python Loop Advanced

Lesson 102: Python Function

Lesson 103: Higher Order Function

Lesson 104: Third Party Package

Lesson 105: NumPy

Lesson 106: Python series

Lesson 107: data frame

Lesson 108: Python data frame lookup

Lesson 109: reads

Lesson 110: Calculating

Lesson 111: Python group by

Lesson 112: Python Pandas Association

Lesson 113: Python Pandas Multiple Index

Lesson 114: Python Pandas Text Function

Lesson 115: Python Pandas de-emphasis

Lesson 116: Python Pandas apply

Lesson 117: Python Pandas Aggregate apply

Lesson 118: Python Pandas Pivot

Lesson 119: Python connects to the database

Lesson 120: Python connects to the database 2

Lesson 121: Python Connect to Database 3

Lesson 122: Python practice markdown

Lesson 123: Python Exercise (1)

Lesson 124: Python Exercise (2)

Lesson 125: Python Exercise (3)

Lesson 126: Python Exercise (4)

Lesson 127: Python Exercise (5)

Lesson 128: Python Exercise (6)

Lesson 129: Python Exercise (7)

Lesson 130: Python Exercise (8)

Lesson 131: Python Exercise (9)

Lesson 132: Python Visualization (1)

Lesson 133: Python Visualization (2)

Lesson 134: Python Visualization (3)

Lesson 135: Python Visualization (4)

Lesson 136: Python Visualization (5)

Lesson 137: Python Visualization (6)

Lesson 138: Python Visualization (7)

Lesson 139: Python Visualization (8)

Lesson 140: Python seaborn 01

Lesson 141: Python seaborn 02

Lesson 142: Python seaborn 03

Lesson 143: Python Seaborn 04

Lesson 144: Python Seaborn 05

Lesson 145: Python seaborn 06

Lesson 146: python superset 01

Lesson 147: Python superset 02

Lesson 148: Python superset 03

Lesson 149: Python superset 04

Lesson 150: Python superset 05