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. The cost of the entire training course is: $13000.00

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