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
Class 1: Why do you need seven weeks
Class 2: How to learn in 7 weeks?
Chapter 2: Week 1: Data Analysis Thinking
Class 3: Why Thinking Is Important
Class 4: Three Core Thinkings of Data Analysis (Structured)
Class 5: Three Core Thinkings of Data Analysis (Formulation)
Class 6: Three Core Thinking of Data Analysis (Business)
Class 7: Thinking Skills in Data Analysis (Quadrant Method)
Lesson 8: Thinking Skills in Data Analysis (Multidimensional Method)
Class 9: Thinking skills in data analysis (hypothesis)
Class 10: Thinking Skills in Data Analysis (Index Method)
Class 11: Thinking Skills in Data Analysis (28 Laws)
Class 12: Thinking Skills in Data Analysis (Comparative Method)
Class 13: Thinking Skills in Data Analysis (Funnel Method)
Class 14: How to exercise data analysis thinking during working hours
Chapter 3: Week 2: Business
Class 15: Why BusinessMatters
Class 16: Classic Business Analysis Indicator
Class 17: Marketing Indicators
Class 18: Product Operational Indicators
Class 19: User Behavior Indicators
Class 20: E-Commerce Indicator
Class 21: Traffic Indicator
Class 22: How to generate an indicator
Class 23: How to Establish a Business Analysis Framework
Class 24: Marketing Model
Class 25: AARRR Model
Class 26: User Behavior Model
Class 27: E-Commerce Model
Class 28: Traffic Model
Class 29: How to deal with various business scenarios
Class 30: How to deal with various business scenarios (small exercises)
Class 31: Data Management Business
Chapter 4: Week 3: Excel
Class 32: Why study Excel
Class 33: Text Cleaning Function
Lesson 34: Common Text Cleaning Functions Exercise
Lesson 35: Association Matching Function
Class 36: Logical Functions
Lesson 37: Calculating the Statistical Function
Lesson 38: Time Series Function
Lesson 39: Frequently Asked Questions forExcel
Class 40: Excel Tools (1)
Class 41: Excel Tools (2)
Class 42: Data Analysis with Excel (1)
Class 43: Data Analysis with Excel (2)
Chapter 5: Week 4: Data Visualization
Class 44: The Beauty of Data Visualization
Class 45: Common Chart Types and Applications
Class 46: Advanced Chart Types and Applications
Class 47: Chart Drawing
Class 48: Excel Drawing Skills
Class 49: ScatterFigure
Class 50: Auxiliary Column
Class 51: Composite Chart
Class 52: Gantt Chart (1)

Class 53: Gantt Chart (2)
Class 54: FIG target
Class 55: DuPont Analysis
Class 56: Getting Started with Power BI
Lesson 57: Power BI Basics
Class 58: Power BI Operational Skills
Class 59: Data Analysis with BI (1)
Class 60: Data Analysis with BI (2)
Class 61: Dashboard
Chapter 6: Week 5: MySQL
Class 62: MySQL Installation
Class 63: Database
Class 64: Database Practice
Class 65: SQL select
Lesson 66: SQL conditional lookup
Class 67: SQL group by
Class 68: SQL group by Advanced
Lesson 69: SQL Function
Lesson 70: SQL Subquery
Class 71: SQL join
Class 72: SQL leetcode
Class 73: SQL Load
Class 74: SQL Time
Lesson 75: SQL Exercise (1)
Class 76: SQL Exercise (2)
Lesson 77: SQL connection power bi
Chapter 7: Week 6: Statistics
Class 78: Descriptive Statistics
Class 79: Quantile
Class 80: Standard deviation1
Class 81: Weight Statistics
Class 82: Chebyshev
Class 83: Box Line Figure
Class 84: Histogram
Class 85: Probability
Class 86: Bayesian
Class 87: Binomial Distribution
Class 88: Binomial Distribution2
Class 89: Poisson Distribution
Class 90: NormalDistribution
Class 91: Hypothesis Test
Chapter 8: Week 7: Python
Class 92: Getting Started
Class 93: Data Type
Class 94: Variable
Class 95: Listing
Class 96: List Advanced
Class 97: Dictionary
Class 98: Collection
Class 99: Control Flow
Class 100: Python Control Flow Loop
Class 101: Python Loop Advanced
Class 102: Python Function
Class 103: Higher Order Function