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 excel 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 -0.8% 10 hours
Lesson 1: Why do you need seven weeks
Lesson 2: How to learn in 7 weeks?

Chapter 2: Data Analysis Thinking -8.3% 40 hours
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 -10.4% 50 Hours
Lesson 15: Why Business Matters
Lesson 16:Lessonic 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) -0.8% 10 Hours
Lesson 31: Data Management Business

Chapter 4: Excel -10.4% 50 Hours
Lesson 32: Why study Excel
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 Excel
Lesson 40: Excel Tools (1)
Lesson 41: Excel Tools (2)
Lesson 42: Data Analysis with Excel (1)  -0.8% 10 hours
Lesson 43: Data Analysis with Excel (2)  -0.8% 10 hours

Chapter 5: Data Visualization -10.4%  50 hours
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: Excel 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)  -0.8% 10 Hours
Lesson 60: Data Analysis with BI (2)  -0.8% 10 Hours
Lesson 61: Dashboard

Chapter 6: MySQL -10.4% 50 hours
Lesson 62: MySQL Installation
Lesson 63: Database
Lesson 64: Database Practice
Lesson 65: SQL select
Lesson 66: SQL conditional lookup
Lesson 67: SQL group by
Lesson 68: SQL group by Advanced
Lesson 69: SQL Function
Lesson 70: SQL Subquery
Lesson 71: SQL join
Lesson 72: SQL leetcode
Lesson 73: SQL Load
Lesson 74: SQL Time
Lesson 75: SQL Exercise (1)  -0.8% 10 Hours
Lesson 76: SQL Exercise (2)  -0.8% 10 Hours
Lesson 77: SQL connection power bi

Chapter 7: Week 6: Statistics -10.4% 50 hours
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  -23% 110 hours
Lesson 92: Getting Started
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 time 105: numpy
Lesson 106: Python series
Lesson 107: dataframe
Lesson 108: Python dataframe lookup
Lesson 109: read_csv
Lesson 110: Calculating
Lesson 111: Python groupby 1
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