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