Data Analytics Course

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