10 Sections
88 Lessons
Lifetime
Expand all sections
Collapse all sections
PART 1: INTRODUCTION
1
1.1
1. Before we start!.
Part 2. All about data analytics concepts
Trong mỗi bài học sẽ có file pdf đính kèm ở dưới video nha ^^
8
2.1
1. Why do we talk more about Data Analytics
2.2
2. Data types & Big Data concept
2.3
3. 4 stages of Big Data Analytics
2.4
4. 8 phases of Data Analytics Maturity
2.5
5. Data Science and Business Intelligence
2.6
6. 4 steps in Data Analysis process
2.7
7. Data journey in company
2.8
8. 3 mistakes to avoid when learning data analysis
Part 3. Statistics
16
3.1
1. Statistics introduction
3.2
2. The big picture of statistics
3.3
3. Sampling methods
3.4
4. Data types in data analytics
3.5
5. Introduction to descriptive statistics
3.6
6. Measures of central tendency
3.7
7. Measures of variability
3.8
8. Measures of correlation
3.9
9. Percentiles
3.10
10. Statistical graphs Histogram
3.11
11. Statistical graphs Boxplot
3.12
12. Statistical graphs Scatter plot
3.13
13. Summary
3.14
14. Take a mini quiz (Câu hỏi) và đáp án)
3.15
15 Practice Statistics.docx và xlsx
3.16
16. Solution The Practice of Statistics
Part 4. Problem solving strategy in data analysis
9
4.1
1. Introduction
4.2
2. 5 steps of problem solving strategy in data analysis
4.3
3. How to define the problem (1)
4.4
4. How to define the problem (2)
4.5
5. Disaggregate the problem
4.6
6. How to prioritize & analyze data
4.7
7. Summary & evaluation
4.8
8. Communication of insights
4.9
9. Take a mini quiz (Câu hỏi và đáp án)
Part 5. Practical SQL For Data Analysis
13
5.1
0 Set up SQL Server & Restore databas (Mac)
5.2
0 Set up SQL Server & Restore databas (Win)
5.3
1. Introduction
5.4
2. Top SQL concepts you must know (1)
5.5
3. Top SQL concepts you must know (2)
5.6
4. Review
5.7
5. Introduce the database
5.8
6. Basic SQL queries for beginners (1)
5.9
7. Basic SQL queries for beginners (2)
5.10
8. Conquer SQL challenges to practice your skills (1)
5.11
9. Conquer SQL challenges to practice your skills (2)
5.12
10. Conquer SQL challenges to practice your skills (3)
5.13
11. Finalize results and next actions
Part 6. Build interactive dashboard with Excel
15
6.1
1. Introduction
6.2
2. 5 steps to build effective dashboards
6.3
3. About the project
6.4
4. How to identify valuable dashboard metrics
6.5
5. Sketch out the draft layout of the dashboard
6.6
6. Build Overview dashboard (1)
6.7
7. Build Overview dashboard (2)
6.8
8. Build Overview dashboard (3)
6.9
9. Build Overview dashboard (4)
6.10
10. Build Overview dashboard (5)
6.11
11. Define metrics & sketch the product dashboard layout
6.12
12. Build Product dashboard (1)
6.13
13. Build Product dashboard (2)
6.14
14. Build Product dashboard (3)
6.15
15 Set up interactive control for dashboard
Part 7. New journey begins
2
7.1
7.1 Define the next action plan
7.2
7.2 You did it!.docx
Part 8. New part. Capstone project 1
8
8.1
1. Introduction to new project
8.2
2. Practice. Apply problem solving strategy – Define problem
8.3
3. Practice. Apply problem solving strategy – Problem disaggregation
8.4
4. Introduction to SQL project
8.5
5. SQL challenge #1
8.6
6. SQL challenge #2
8.7
7. SQL challenge #3
8.8
8. SQL challenge #4
Part 9. New part. Capstone project 2
15
9.1
1. Introduction to Data visualization project
9.2
2. 2 main objectives of the dashboard
9.3
3. 2 types of dashboard
9.4
4. The ultimate guide to defining
9.5
5. Extract data from SQL database
9.6
6. Use pivot table to calculate business metrics (1)
9.7
7. Use pivot table to calculate business metrics (2)
9.8
8. Build dashboard (1)
9.9
9. Build dashboard (2)
9.10
10. Introduction to Detail dashboard
9.11
11. Pivot table for Detail dashboard (1)
9.12
12. Pivot table for Detail dashboard (2)
9.13
13. Build Detail dashboard (1)
9.14
14. Build Detail dashboard (2)
9.15
15. Project completion
RECORDING
1
10.1
Recording – Meeting room – Phương pháp xác định Bus…board metrics – MazHocData Community 15.11.2024
Khóa Học DATA ANALYTICS 101 Maz Học Data 2025 (Chuẩn Gốc NEW)
Search
This content is protected, please
login
and enroll in the course to view this content!
Trang Chủ
khóa học
Tìm kiếm
Tìm kiếm
Account
Chào mừng bạn đến với Khóa Học Rẻ! <3
Continue with
Google
Bạn quên mật khẩu?
Ghi nhớ trình duyệt
Bạn chưa có tài khoản?
Đăng ký ngay
Đăng ký tài khoản mới
Continue with
Google
Bạn đã có tài khoản?
Đăng nhập ngay
Modal title
Main Content
