FreeAllCourse com Udemy The Business Intelligence Analyst Course 2021

FreeAllCourse com Udemy The Business Intelligence Analyst Course 2021

Name	[FreeAllCourse.com] Udemy - The Business Intelligence Analyst Course 2021	DOWNLOAD Copy Link
Total Size	12.0 GB
Total Files	1024
Last Seen	2024-07-22 23:56
Hash	EA2A9098A3C8064B09A6EB89FF21B120FC122487

/1. Part 1 Introduction/
1. What Does the Course Cover.mp4	57.8 MB
1. What Does the Course Cover.srt	5.1 KB
1.1 BI - FAQ.pdf	1.2 MB
2. Download All Resources.html	0.7 KB
/10. Statistics - Descriptive Statistics/
1. Types of Data.mp4	76.0 MB
1. Types of Data.srt	6.1 KB
1.1 Course notes_descriptive_statistics.pdf	493.8 KB
10. Numerical Variables Exercise.html	0.1 KB
10.1 2.4.Numerical-variables.Frequency-distribution-table-exercise.xlsx	12.3 KB
10.2 2.4. Numerical variables. Frequency distribution table_exercise_solution.xlsx	13.6 KB
11. The Histogram.mp4	14.5 MB
11. The Histogram.srt	3.1 KB
11.1 2.5. The Histogram_lesson.xlsx	19.1 KB
12. The Histogram.html	0.2 KB
13. Histogram Exercise.html	0.1 KB
13.1 Statistics - PDF with Excel Solutions that don't visualize properly.pdf	296.1 KB
13.2 2.5. The Histogram_exercise_solution.xlsx	17.2 KB
13.3 2.5. The Histogram_exercise.xlsx	15.9 KB
14. Cross Table and Scatter Plot.mp4	41.7 MB
14. Cross Table and Scatter Plot.srt	6.8 KB
14.1 2.6. Cross table and scatter plot.xlsx	26.7 KB
15. Cross Tables and Scatter Plots.html	0.2 KB
16. Cross Tables and Scatter Plots Exercise.html	0.1 KB
16.1 2.6. Cross table and scatter plot_exercise_solution.xlsx	41.4 KB
16.2 2.6. Cross table and scatter plot_exercise.xlsx	16.7 KB
17. Mean, median and mode.mp4	38.9 MB
17. Mean, median and mode.srt	5.9 KB
17.1 2.7. Mean, median and mode_lesson.xlsx	10.7 KB
18. Mean, Median and Mode Exercise.html	0.1 KB
18.1 2.7. Mean, median and mode_exercise_solution.xlsx	11.6 KB
18.2 2.7. Mean, median and mode_exercise.xlsx	11.1 KB
19. Skewness.mp4	20.4 MB
19. Skewness.srt	3.7 KB
19.1 2.8. Skewness_lesson.xlsx	35.5 KB
2. Types of data.html	0.2 KB
20. Skewness.html	0.2 KB
21. Skewness Exercise.html	0.1 KB
21.1 2.8. Skewness_exercise_solution.xlsx	20.3 KB
21.2 2.8. Skewness_exercise.xlsx	9.7 KB
22. Variance.mp4	53.4 MB
22. Variance.srt	7.7 KB
22.1 2.9. Variance_lesson.xlsx	10.3 KB
23. Variance Exercise.html	0.1 KB
23.1 2.9. Variance_exercise_solution.xlsx	11.3 KB
23.2 2.9. Variance_exercise.xlsx	11.1 KB
24. Standard Deviation and Coefficient of Variation.mp4	47.3 MB
24. Standard Deviation and Coefficient of Variation.srt	6.8 KB
24.1 2.10. Standard deviation and coefficient of variation_lesson.xlsx	11.2 KB
25. Standard deviation.html	0.2 KB
26. Standard Deviation and Coefficient of Variation Exercise.html	0.1 KB
26.1 2.10.Standard-deviation-and-coefficient-of-variation-exercise-solution.xlsx	12.9 KB
26.2 2.10.Standard-deviation-and-coefficient-of-variation-exercise.xlsx	11.9 KB
27. Covariance.mp4	28.8 MB
27. Covariance.srt	5.0 KB
27.1 2.11. Covariance_lesson.xlsx	25.5 KB
28. Covariance.html	0.2 KB
29. Covariance Exercise.html	0.1 KB
29.1 2.11. Covariance_exercise_solution.xlsx	30.2 KB
29.2 2.11. Covariance_exercise.xlsx	20.7 KB
3. Levels of Measurement.mp4	57.0 MB
3. Levels of Measurement.srt	4.7 KB
30. Correlation Coefficient.mp4	30.8 MB
30. Correlation Coefficient.srt	4.8 KB
30.1 2.12. Correlation_lesson.xlsx	25.6 KB
31. Correlation Coefficient.html	0.2 KB
32. Correlation Coefficient Exercise.html	0.1 KB
32.1 2.12. Correlation_exercise.xlsx	30.0 KB
32.2 2.12. Correlation_exercise_solution.xlsx	30.2 KB
4. Levels of measurement.html	0.2 KB
5. Categorical Variables - Visualization Techniques.mp4	38.4 MB
5. Categorical Variables - Visualization Techniques.srt	6.5 KB
5.1 2.3. Categorical variables. Visualization techniques_lesson.xlsx	31.3 KB
6. Categorical variables. Visualization Techniques.html	0.2 KB
7. Categorical Variables Exercise.html	0.1 KB
7.1 2.3. Categorical variables. Visualization techniques_exercise_solution.xlsx	52.3 KB
7.2 Statistics - PDF with Excel Solutions that don't visualize properly.pdf	296.1 KB
7.3 2.3. Categorical variables. Visualization techniques_exercise.xlsx	15.6 KB
8. Numerical Variables - Frequency Distribution Table.mp4	27.1 MB
8. Numerical Variables - Frequency Distribution Table.srt	4.5 KB
8.1 2.4. Numerical variables. Frequency distribution table_lesson.xlsx	11.7 KB
9. Numerical variables. Using a frequency distribution table.html	0.2 KB
/11. Statistics - Practical Example Descriptive Statistics/
1. Practical Example.mp4	168.3 MB
1. Practical Example.srt	21.3 KB
1.1 2.13. Practical example. Descriptive statistics_lesson.xlsx	150.0 KB
2. Practical Example Exercise.html	0.1 KB
2.1 2.13.Practical-example.Descriptive-statistics-exercise.xlsx	123.2 KB
2.2 2.13.Practical-example.Descriptive-statistics-exercise-solution.xlsx	160.0 KB
/12. Statistics - Inferential Statistics Fundamentals/
1. Introduction.mp4	16.2 MB
1. Introduction.srt	1.7 KB
1.1 Course notes_inferential statistics.pdf	391.5 KB
10. Central Limit Theorem.html	0.2 KB
11. Standard error.mp4	23.9 MB
11. Standard error.srt	2.1 KB
12. Standard error.html	0.2 KB
13. Estimators and Estimates.mp4	50.2 MB
13. Estimators and Estimates.srt	3.8 KB
14. Estimators and Estimates.html	0.2 KB
2. What is a Distribution.mp4	64.7 MB
2. What is a Distribution.srt	6.0 KB
2.1 3.2. What is a distribution_lesson.xlsx	19.9 KB
2.2 Course notes_inferential statistics.pdf	391.5 KB
3. What is a Distribution.html	0.2 KB
4. The Normal Distribution.mp4	52.3 MB
4. The Normal Distribution.srt	5.0 KB
5. The Normal Distribution.html	0.2 KB
6. The Standard Normal Distribution.mp4	23.6 MB
6. The Standard Normal Distribution.srt	4.0 KB
6.1 3.4. Standard normal distribution_lesson.xlsx	10.6 KB
7. The Standard Normal Distribution.html	0.2 KB
8. The Standard Normal Distribution Exercise.html	0.1 KB
8.1 3.4.Standard-normal-distribution-exercise.xlsx	12.3 KB
8.2 3.4.Standard-normal-distribution-exercise-solution.xlsx	24.6 KB
9. Central Limit Theorem.mp4	66.0 MB
9. Central Limit Theorem.srt	5.8 KB
/13. Statistics - Inferential Statistics Confidence Intervals/
1. What are Confidence Intervals.mp4	52.4 MB
1. What are Confidence Intervals.srt	3.3 KB
10. Margin of Error.mp4	49.5 MB
10. Margin of Error.srt	6.3 KB
11. Margin of Error.html	0.2 KB
12. Confidence intervals. Two means. Dependent samples.mp4	73.9 MB
12. Confidence intervals. Two means. Dependent samples.srt	8.2 KB
12.1 3.13. Confidence intervals. Two means. Dependent samples_lesson.xlsx	10.7 KB
13. Confidence intervals. Two means. Dependent samples Exercise.html	0.1 KB
13.1 3.13. Confidence intervals. Two means. Dependent samples_exercise_solution.xlsx	14.6 KB
13.2 3.13. Confidence intervals. Two means. Dependent samples_exercise.xlsx	14.1 KB
14. Confidence intervals. Two means. Independent samples (Part 1).mp4	30.2 MB
14. Confidence intervals. Two means. Independent samples (Part 1).srt	6.2 KB
14.1 3.14. Confidence intervals. Two means. Independent samples (Part 1)_lesson.xlsx	10.1 KB
15. Confidence intervals. Two means. Independent samples (Part 1) Exercise.html	0.1 KB
15.1 3.14. Confidence intervals. Two means. Independent samples (Part 1)_exercise_solution.xlsx	10.4 KB
15.2 3.14. Confidence intervals. Two means. Independent samples (Part 1)_exercise.xlsx	10.1 KB
16. Confidence intervals. Two means. Independent samples (Part 2).mp4	28.1 MB
16. Confidence intervals. Two means. Independent samples (Part 2).srt	4.6 KB
16.1 3.15. Confidence intervals. Two means. Independent samples (Part 2)_lesson.xlsx	9.7 KB
17. Confidence intervals. Two means. Independent samples (Part 2) Exercise.html	0.1 KB
17.1 3.15. Confidence intervals. Two means. Independent samples (Part 2)_exercise.xlsx	9.4 KB
17.2 3.15. Confidence intervals. Two means. Independent samples (Part 2)_exercise_solution.xlsx	10.0 KB
18. Confidence intervals. Two means. Independent samples (Part 3).mp4	20.9 MB
18. Confidence intervals. Two means. Independent samples (Part 3).srt	2.0 KB
2. What are Confidence Intervals.html	0.2 KB
3. Confidence Intervals; Population Variance Known; z-score.mp4	82.0 MB
3. Confidence Intervals; Population Variance Known; z-score.srt	10.0 KB
3.1 3.9. Population variance known, z-score_lesson.xlsx	11.5 KB
3.2 3.9.The-z-table.xlsx	26.2 KB
4. Confidence Intervals; Population Variance Known; z-score Exercise.html	0.1 KB
4.1 3.9. Population variance known, z-score_exercise.xlsx	11.1 KB
4.2 3.9.The-z-table.xlsx	26.2 KB
4.3 3.9. Population variance known, z-score_exercise_solution.xlsx	11.4 KB
5. Confidence interval clarifications.mp4	59.8 MB
5. Confidence interval clarifications.srt	5.5 KB
6. Student's T Distribution.mp4	37.1 MB
6. Student's T Distribution.srt	4.2 KB
7. Student's T Distribution.html	0.2 KB
8. Confidence Intervals; Population Variance Unknown; t-score.mp4	33.7 MB
8. Confidence Intervals; Population Variance Unknown; t-score.srt	5.8 KB
8.1 3.11. Population variance unknown, t-score_lesson.xlsx	11.0 KB
8.2 3.11. The t-table.xlsx	16.2 KB
9. Confidence Intervals; Population Variance Unknown; t-score Exercise.html	0.1 KB
9.1 3.11. The t-table.xlsx	16.2 KB
9.2 3.11. Population variance unknown, t-score_exercise.xlsx	10.9 KB
9.3 3.11. Population variance unknown, t-score_exercise_solution.xlsx	11.4 KB
/14. Statistics - Practical Example Inferential Statistics/
1. Practical Example Inferential Statistics.mp4	107.6 MB
1. Practical Example Inferential Statistics.srt	14.0 KB
1.1 3.17. Practical example. Confidence intervals_lesson.xlsx	1.8 MB
2. Practical Example Inferential Statistics Exercise.html	0.1 KB
2.1 3.17.Practical-example.Confidence-intervals-exercise.xlsx	1.8 MB
2.2 3.17.Practical-example.Confidence-intervals-exercise-solution.xlsx	1.9 MB
/15. Statistics - Hypothesis Testing/
1. The Null vs Alternative Hypothesis.mp4	96.6 MB
1. The Null vs Alternative Hypothesis.srt	7.1 KB
1.1 Course notes_hypothesis_testing.pdf	672.2 KB
10. p-value.mp4	58.6 MB
10. p-value.srt	5.2 KB
10.1 Online p-value calculator.pdf	1.2 MB
11. p-value.html	0.2 KB
12. Test for the Mean. Population Variance Unknown.mp4	42.1 MB
12. Test for the Mean. Population Variance Unknown.srt	5.9 KB
12.1 4.6.Test-for-the-mean.Population-variance-unknown-lesson.xlsx	14.9 KB
13. Test for the Mean. Population Variance Unknown Exercise.html	0.1 KB
13.1 4.6.Test-for-the-mean.Population-variance-unknown-exercise-solution.xlsx	12.9 KB
13.2 4.6. Test-for-the-mean.Population-variance-unknown-exercise.xlsx	11.6 KB
14. Test for the Mean. Dependent Samples.mp4	52.9 MB
14. Test for the Mean. Dependent Samples.srt	6.4 KB
14.1 4.7. Test for the mean. Dependent samples_lesson.xlsx	10.0 KB
15. Test for the Mean. Dependent Samples Exercise.html	0.1 KB
15.1 4.7. Test for the mean. Dependent samples_exercise_solution.xlsx	14.7 KB
15.2 4.7. Test for the mean. Dependent samples_exercise.xlsx	13.1 KB
16. Test for the mean. Independent samples (Part 1).mp4	31.4 MB
16. Test for the mean. Independent samples (Part 1).srt	5.6 KB
16.1 4.8. Test for the mean. Independent samples (Part 1)_lesson.xlsx	9.9 KB
17. Test for the mean. Independent samples (Part 1). Exercise.html	0.1 KB
17.1 4.8.Test-for-the-mean.Independent-samples-Part-1-exercise-solution.xlsx	11.5 KB
17.2 4.8.Test-for-the-mean.Independent-samples-Part-1-exercise.xlsx	11.0 KB
18. Test for the mean. Independent samples (Part 2).mp4	38.1 MB
18. Test for the mean. Independent samples (Part 2).srt	5.3 KB
18.1 4.9. Test for the mean. Independent samples (Part 2)_lesson.xlsx	9.5 KB
19. Test for the mean. Independent samples (Part 2).html	0.2 KB
2. Further Reading on Null and Alternative Hypothesis.html	2.3 KB
20. Test for the mean. Independent samples (Part 2).html	0.1 KB
20.1 4.9.Test-for-the-mean.Independent-samples-Part-2-exercise-2.xlsx	10.8 KB
20.2 4.9.Test-for-the-mean.Independent-samples-Part-2-exercise-2-solution.xlsx	11.7 KB
3. The Null vs Alternative Hypothesis.html	0.2 KB
4. Rejection Region and Significance Level.mp4	86.5 MB
4. Rejection Region and Significance Level.srt	8.9 KB
4.1 Course notes_hypothesis_testing.pdf	672.2 KB
5. Rejection Region and Significance Level.html	0.2 KB
6. Type I Error and Type II Error.mp4	46.1 MB
6. Type I Error and Type II Error.srt	5.8 KB
7. Type I Error and Type II Error.html	0.2 KB
8. Test for the Mean. Population Variance Known.mp4	56.9 MB
8. Test for the Mean. Population Variance Known.srt	8.3 KB
8.1 4.4. Test for the mean. Population variance known_lesson.xlsx	11.2 KB
9. Test for the Mean. Population Variance Known Exercise.html	0.1 KB
9.1 4.4. Test for the mean. Population variance known_exercise_solution.xlsx	11.5 KB
9.2 4.4. Test for the mean. Population variance known_exercise.xlsx	11.3 KB
/16. Statistics - Practical Example Hypothesis Testing/
1. Practical Example Hypothesis Testing.mp4	72.7 MB
1. Practical Example Hypothesis Testing.srt	8.7 KB
1.1 4.10.Hypothesis-testing-section-practical-example.xlsx	53.0 KB
2. Practical Example Hypothesis Testing Exercise.html	0.1 KB
2.1 4.10.Hypothesis-testing-section-practical-example-exercise.xlsx	44.4 KB
2.2 4.10.Hypothesis-testing-section-practical-example-exercise-solution.xlsx	45.1 KB
/17. Part 3 Relational Database Theory & Introduction to SQL/
1. Why use SQL.mp4	73.5 MB
1. Why use SQL.srt	4.7 KB
10. Comparing Databases and Spreadsheets.html	0.2 KB
11. Important Database Terminology.mp4	94.9 MB
11. Important Database Terminology.srt	6.2 KB
12. Important Database Terminology.html	0.2 KB
13. The Concept of Relational Schemas Primary Key.mp4	45.0 MB
13. The Concept of Relational Schemas Primary Key.srt	7.1 KB
14. The Concept of Relational Schemas Primary Key.html	0.2 KB
15. The Concept of Relational Schemas Foreign Key.mp4	46.1 MB
15. The Concept of Relational Schemas Foreign Key.srt	6.9 KB
16. The Concept of Relational Schemas Foreign Key.html	0.2 KB
17. The Concept of Relational Schemas Unique Key and Null Values.mp4	25.7 MB
17. The Concept of Relational Schemas Unique Key and Null Values.srt	4.5 KB
18. The Concept of Relational Schemas Unique Key.html	0.2 KB
19. The Concept of Relational Schemas Relationships Between Tables.mp4	43.7 MB
19. The Concept of Relational Schemas Relationships Between Tables.srt	6.3 KB
2. Why use SQL.html	0.2 KB
20. The Concept of Relational Schemas Relationships Between Tables.html	0.2 KB
3. Why use MySQL.mp4	30.7 MB
3. Why use MySQL.srt	2.8 KB
4. Why use MySQL.html	0.2 KB
5. Introducing Databases.mp4	107.9 MB
5. Introducing Databases.srt	6.9 KB
6. Introducing Databases.html	0.2 KB
7. Relational Database Fundamentals.mp4	112.9 MB
7. Relational Database Fundamentals.srt	6.8 KB
8. Relational Database Fundamentals.html	0.2 KB
9. Comparing Databases and Spreadsheets.mp4	164.4 MB
9. Comparing Databases and Spreadsheets.srt	10.6 KB
/18. SQL - Install and get to know MySQL/
1. Installing MySQL Workbench and Server.mp4	103.9 MB
1. Installing MySQL Workbench and Server.srt	13.0 KB
2. Installing Visual C.html	0.8 KB
3. Installing MySQL on macOS and Unix systems.html	2.7 KB
4. The Client-Server Model.html	0.0 KB
4.1 The Client-Server Model.pdf	570.3 KB
5. Linking GUI with the MySQL Server.mp4	20.2 MB
5. Linking GUI with the MySQL Server.srt	3.4 KB
6. Read me!!!.html	1.0 KB
7. Creating a New User and a New Connection to it.mp4	50.0 MB
7. Creating a New User and a New Connection to it.srt	6.9 KB
8. Familiarize Yourself with the MySQL Interface.mp4	42.2 MB
8. Familiarize Yourself with the MySQL Interface.srt	6.5 KB
/19. SQL - Best SQL Practices/
1. Coding Tips and Best Practices - I.mp4	39.7 MB
1. Coding Tips and Best Practices - I.srt	6.9 KB
1.1 MySQL_Workbench_Shortcuts.pdf	527.6 KB
2. Coding Tips and Best Practices - I.html	0.2 KB
3. Coding Tips and Best Practices - II.mp4	31.1 MB
3. Coding Tips and Best Practices - II.srt	5.1 KB
4. Coding Tips and Best Practices - II.html	0.2 KB
/2. Intro to Data and Data Science - The Different Data Science Fields/
1. Why Are There So Many Business and Data Science Buzzwords.mp4	85.3 MB
1. Why Are There So Many Business and Data Science Buzzwords.srt	6.8 KB
2. Analysis vs Analytics.mp4	56.1 MB
2. Analysis vs Analytics.srt	5.2 KB
3. Intro to Business Analytics, Data Analytics, and Data Science.mp4	67.6 MB
3. Intro to Business Analytics, Data Analytics, and Data Science.srt	10.9 KB
3.1 365_DataScience_Diagram.pdf	330.8 KB
4. Intro to Business Analytics, Data Analytics, and Data Science.html	0.2 KB
5. Adding Business Intelligence (BI), Machine Learning (ML), and AI to the Picture.mp4	114.3 MB
5. Adding Business Intelligence (BI), Machine Learning (ML), and AI to the Picture.srt	12.2 KB
5.1 365_DataScience_Diagram.pdf	330.8 KB
5.2 365_DataScience.png	7.6 MB
6. Adding Business Intelligence (BI), Machine Learning (ML), and AI to the Picture.html	0.2 KB
7. An Overview of our Data Science Infographic.mp4	71.1 MB
7. An Overview of our Data Science Infographic.srt	5.2 KB
7.1 365_DataScience.png	7.6 MB
8. An Overview of our Data Science Infographic.html	0.2 KB
/20. SQL - Loading the 'employees' Database/
1. Loading the 'employees' Database.mp4	19.9 MB
1. Loading the 'employees' Database.srt	2.8 KB
1.1 employees_db.pdf	183.1 KB
2. Loading the 'employees' Database.html	0.9 KB
2.1 The 'employees' database.html	0.1 KB
2.2 employees_db.pdf	183.1 KB
/21. SQL - Practical Application of the SQL SELECT Statement/
1. Using SELECT - FROM.mp4	37.7 MB
1. Using SELECT - FROM.srt	5.9 KB
10. Using OR.mp4	34.8 MB
10. Using OR.srt	4.0 KB
11. Using OR - Exercise.html	0.1 KB
12. Using OR - Solution.html	0.2 KB
13. Operator Precedence and Logical Order.mp4	33.6 MB
13. Operator Precedence and Logical Order.srt	4.5 KB
14. Operator Precedence and Logical Order - Exercise.html	0.1 KB
15. Operator Precedence and Logical Order - Solution.html	0.3 KB
16. Using IN - NOT IN.mp4	33.7 MB
16. Using IN - NOT IN.srt	3.9 KB
17. Using IN - NOT IN - Exercise 1.html	0.1 KB
18. Using IN - NOT IN - Solution 1.html	0.2 KB
19. Using IN - NOT IN - Exercise 2.html	0.1 KB
2. Using SELECT - FROM - Exercise.html	0.1 KB
20. Using IN - NOT IN - Solution 2.html	0.2 KB
21. Using LIKE - NOT LIKE.mp4	37.8 MB
21. Using LIKE - NOT LIKE.srt	4.5 KB
22. Using LIKE - NOT LIKE - Exercise.html	0.4 KB
23. Using LIKE - NOT LIKE - Solution.html	0.7 KB
24. Using Wildcard Characters.mp4	10.3 MB
24. Using Wildcard Characters.srt	2.5 KB
25. Using Wildcard characters - Exercise.html	0.2 KB
26. Using Wildcard characters - Solution.html	0.5 KB
27. Using BETWEEN - AND.mp4	17.3 MB
27. Using BETWEEN - AND.srt	2.4 KB
28. Using BETWEEN - AND - Exercise.html	0.3 KB
29. Using BETWEEN - AND - Solution.html	1.0 KB
3. Using SELECT - FROM - Solution.html	0.3 KB
30. Using IS NOT NULL - IS NULL.mp4	14.6 MB
30. Using IS NOT NULL - IS NULL.srt	2.0 KB
31. Using IS NOT NULL - IS NULL - Exercise.html	0.1 KB
32. Using IS NOT NULL - IS NULL - Solution.html	0.2 KB
33. Using Other Comparison Operators.mp4	43.2 MB
33. Using Other Comparison Operators.srt	5.2 KB
34. Using Other Comparison Operators - Exercise.html	0.3 KB
35. Using Other Comparison Operators - Solution.html	0.5 KB
36. Using SELECT DISTINCT.mp4	16.4 MB
36. Using SELECT DISTINCT.srt	2.7 KB
37. Using SELECT DISTINCT - Exercise.html	0.4 KB
38. Using SELECT DISTINCT - Solution.html	0.2 KB
39. Getting to Know Aggregate Functions.mp4	45.7 MB
39. Getting to Know Aggregate Functions.srt	6.8 KB
4. Using WHERE.mp4	23.0 MB
4. Using WHERE.srt	3.1 KB
40. Getting to Know Aggregate Functions - Exercise.html	0.3 KB
41. Getting to Know Aggregate Functions - Solution.html	0.4 KB
42. Using ORDER BY.mp4	43.3 MB
42. Using ORDER BY.srt	4.2 KB
43. Using ORDER BY - Exercise.html	0.1 KB
44. Using ORDER BY - Solution.html	0.2 KB
45. Using GROUP BY.mp4	56.2 MB
45. Using GROUP BY.srt	7.0 KB
46. Using Aliases (AS).mp4	22.3 MB
46. Using Aliases (AS).srt	2.8 KB
47. Using Aliases (AS) - Exercise.html	0.3 KB
48. Using Aliases (AS) - Solution.html	0.3 KB
49. Using HAVING.mp4	34.6 MB
49. Using HAVING.srt	4.1 KB
5. Using WHERE - Exercise.html	0.1 KB
50. Using HAVING - Exercise.html	0.8 KB
51. Using HAVING - Solution.html	0.6 KB
52. Using WHERE vs HAVING - Part I.mp4	36.6 MB
52. Using WHERE vs HAVING - Part I.srt	4.9 KB
53. Using WHERE vs HAVING - Part II.mp4	26.0 MB
53. Using WHERE vs HAVING - Part II.srt	4.1 KB
54. Using WHERE vs HAVING - Part II - Exercise.html	0.2 KB
55. Using WHERE vs HAVING - Part II - Solution.html	0.4 KB
56. Using LIMIT.mp4	49.5 MB
56. Using LIMIT.srt	6.0 KB
57. Using LIMIT - Exercise.html	0.1 KB
58. Using LIMIT - Solution.html	0.2 KB
6. Using WHERE - Solution.html	0.2 KB
7. Using AND.mp4	17.5 MB
7. Using AND.srt	2.6 KB
8. Using AND - Exercise.html	0.1 KB
9. Using AND - Solution.html	0.2 KB
/22. SQL - Expanding on MySQL Aggregate Functions/
1. Applying COUNT().mp4	28.7 MB
1. Applying COUNT().srt	5.1 KB
10. Applying AVG().mp4	14.2 MB
10. Applying AVG().srt	2.6 KB
11. Applying AVG() - Exercise.html	0.1 KB
12. Applying AVG() - Solution.html	0.2 KB
13. Rounding Numbers with ROUND().mp4	17.6 MB
13. Rounding Numbers with ROUND().srt	2.7 KB
14. Rounding Numbers with ROUND() - Exercise.html	0.1 KB
15. Rounding Numbers with ROUND() - Solution.html	0.2 KB
2. Applying COUNT() - Exercise.html	0.1 KB
3. Applying COUNT() - Solution.html	0.2 KB
4. Applying SUM().mp4	11.0 MB
4. Applying SUM().srt	1.9 KB
5. Applying SUM() - Exercise.html	0.1 KB
6. Applying SUM() - Solution.html	0.2 KB
7. MIN() and MAX().mp4	10.8 MB
7. MIN() and MAX().srt	1.6 KB
8. MIN() and MAX() - Exercise.html	0.1 KB
9. MIN() and MAX() - Solution.html	0.4 KB
/23. SQL - SQL JOINs/
1. What are JOINs.mp4	44.2 MB
1. What are JOINs.srt	5.2 KB
10. The Functionality of LEFT JOIN - Part I.mp4	53.3 MB
10. The Functionality of LEFT JOIN - Part I.srt	5.9 KB
11. The Functionality of LEFT JOIN - Part II.mp4	57.5 MB
11. The Functionality of LEFT JOIN - Part II.srt	7.0 KB
12. The Functionality of LEFT JOIN - Part II - Exercise.html	0.4 KB
13. The Functionality of LEFT JOIN - Part II - Solution.html	0.6 KB
14. The Functionality of RIGHT JOIN.mp4	33.8 MB
14. The Functionality of RIGHT JOIN.srt	33.8 MB
15. Differences between the New and the Old Join Syntax.mp4	33.6 MB
15. Differences between the New and the Old Join Syntax.srt	33.6 MB
16. Differences between the New and the Old Join Syntax - Exercise.html	0.2 KB
17. Differences between the New and the Old Join Syntax - Solution.html	0.9 KB
18. Using JOIN and WHERE Together.mp4	26.4 MB
18. Using JOIN and WHERE Together.srt	3.6 KB
19. Important – Prevent Error Code 1055!.html	3.2 KB
2. What are JOINs - Exercise 1.html	1.3 KB
20. Using JOIN and WHERE Together - Exercise.html	0.2 KB
21. Using JOIN and WHERE Together - Solution.html	0.5 KB
22. The Functionality of CROSS JOIN.mp4	94.2 MB
22. The Functionality of CROSS JOIN.srt	10.1 KB
23. The Functionality of CROSS JOIN - Exercise 1.html	0.2 KB
24. The Functionality of CROSS JOIN - Solution 1.html	0.4 KB
25. The Functionality of CROSS JOIN - Exercise 2.html	0.2 KB
26. The Functionality of CROSS JOIN - Solution 2.html	0.4 KB
27. Combining Aggregate Functions with Joins.mp4	23.2 MB
27. Combining Aggregate Functions with Joins.srt	2.9 KB
28. JOIN More than Two Tables.mp4	43.4 MB
28. JOIN More than Two Tables.srt	4.9 KB
29. JOIN More than Two Tables - Exercise.html	0.1 KB
3. What are JOINs - Exercise 2.html	1.4 KB
30. JOIN More than Two Tables - Solution.html	1.8 KB
31. Top Tips for Joins.mp4	53.4 MB
31. Top Tips for Joins.srt	7.0 KB
32. Top Tips for Joins - Exercise.html	0.1 KB
33. Top Tips for Joins - Solution.html	0.3 KB
34. The Differences Between UNION and UNION ALL.mp4	50.0 MB
34. The Differences Between UNION and UNION ALL.srt	6.6 KB
35. The Differences Between UNION and UNION ALL - Exercise.html	0.2 KB
36. The Differences Between UNION and UNION ALL - Solution.html	1.1 KB
4. The Functionality of INNER JOIN - Part I.mp4	44.3 MB
4. The Functionality of INNER JOIN - Part I.srt	6.9 KB
5. The Functionality of INNER JOIN - Part II.mp4	70.3 MB
5. The Functionality of INNER JOIN - Part II.srt	6.8 KB
6. The Functionality of INNER JOIN - PART II - Exercise.html	0.1 KB
7. The Functionality of INNER JOIN - PART II - Solution.html	0.4 KB
8. Extra Info on Using Joins.mp4	46.0 MB
8. Extra Info on Using Joins.srt	5.1 KB
9. Duplicate Rows.mp4	48.8 MB
9. Duplicate Rows.srt	5.3 KB
/24. SQL - SQL Subqueries/
1. SQL Subqueries with IN Embedded Inside WHERE.mp4	39.3 MB
1. SQL Subqueries with IN Embedded Inside WHERE.srt	5.2 KB
10. SQL Subqueries Nested in SELECT and FROM - Solution 2.html	0.0 KB
10.1 Subqueries SELECT FROM Solution.sql	1.9 KB
2. SQL Subqueries with IN Embedded Inside WHERE - Exercise.html	0.1 KB
3. SQL Subqueries with IN Embedded Inside WHERE - Solution.html	0.5 KB
4. SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE.mp4	31.2 MB
4. SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE.srt	4.3 KB
5. SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE - Exercise.html	0.2 KB
6. SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE - Solution.html	0.6 KB
7. SQL Subqueries Nested in SELECT and FROM.mp4	75.1 MB
7. SQL Subqueries Nested in SELECT and FROM.srt	8.8 KB
8. SQL Subqueries Embedded in SELECT and FROM - Exercise 1.html	0.4 KB
9. SQL Subqueries Embedded in SELECT and FROM - Exercise 2.html	1.0 KB
/25. SQL - Stored Routines/
1. Defining Stored Routines.mp4	31.4 MB
1. Defining Stored Routines.srt	4.5 KB
10. Create Stored Procedures with an Output Parameter.mp4	34.1 MB
10. Create Stored Procedures with an Output Parameter.srt	4.2 KB
11. Create Stored Procedures with an Output Parameter - Exercise.html	0.2 KB
12. Stored Procedures with an Output Parameter - Solution.html	0.9 KB
13. SQL Variables.mp4	57.2 MB
13. SQL Variables.srt	7.6 KB
14. SQL Variables - Exercise.html	0.3 KB
15. SQL Variables - Solution.html	0.2 KB
16. The Benefit of User-Defined Functions in MySQL.mp4	51.1 MB
16. The Benefit of User-Defined Functions in MySQL.srt	7.5 KB
17. Error Code 1418..html	2.9 KB
18. The Benefit of User-Defined Functions in MySQL - Exercise.html	0.4 KB
19. The Benefit of User-Defined Functions in MySQL - Solution.html	1.6 KB
2. Defining Stored Routines.html	0.2 KB
20. Concluding Stored Routines.mp4	28.5 MB
20. Concluding Stored Routines.srt	4.8 KB
21. Concluding Stored Routines.html	0.2 KB
3. Create Stored Procedures with MySQL Syntax.mp4	35.9 MB
3. Create Stored Procedures with MySQL Syntax.srt	5.9 KB
4. An Example of Stored Procedures Part I.mp4	25.1 MB
4. An Example of Stored Procedures Part I.srt	3.4 KB
5. An Example of Stored Procedures Part II.mp4	44.2 MB
5. An Example of Stored Procedures Part II.srt	6.3 KB
6. An Example of Stored Procedures Part II - Exercise.html	0.1 KB
7. An Example of Stored Procedures Part II - Solution.html	0.7 KB
8. Creating a Procedure in MySQL Another Way.mp4	34.0 MB
8. Creating a Procedure in MySQL Another Way.srt	3.7 KB
9. Create Stored Procedures with an Input Parameter.mp4	67.6 MB
9. Create Stored Procedures with an Input Parameter.srt	7.7 KB
/26. SQL - The CASE Statement/
1. The SQL CASE Statement.mp4	62.3 MB
1. The SQL CASE Statement.srt	7.0 KB
2. The SQL CASE Statement - Exercise 1.html	0.4 KB
3. THE SQL CASE Statement - Solution 1.html	0.7 KB
4. THE SQL CASE Statement - Exercise 2.html	0.4 KB
5. THE SQL CASE Statement - Solution 2.html	1.8 KB
6. THE SQL CASE Statement - Exercise 3.html	0.4 KB
7. THE SQL CASE Statement - Solution 3.html	0.7 KB
/27. Part 4 Introduction to Tableau/
1. Why Use Tableau Make Your Data Make an Impact.mp4	41.1 MB
1. Why Use Tableau Make Your Data Make an Impact.srt	4.9 KB
2. Let's Download Tableau Public.mp4	29.8 MB
2. Let's Download Tableau Public.srt	2.3 KB
3. Connecting Data in Tableau.mp4	15.0 MB
3. Connecting Data in Tableau.srt	2.6 KB
3.1 GDP Data.xls	159.2 KB
4. Exploring Tableau's Interface.mp4	54.6 MB
4. Exploring Tableau's Interface.srt	11.0 KB
4.1 GDP Data.xls	159.2 KB
5. Let's Create our first Chart in Tableau!.mp4	61.8 MB
5. Let's Create our first Chart in Tableau!.srt	8.0 KB
5.1 GDP Data - Tableau Public Link.html	0.1 KB
5.2 GDP Data.xls	159.2 KB
/28. Tableau - Tableau functionalities/
1. Duplicating a Sheet.mp4	26.5 MB
1. Duplicating a Sheet.srt	3.3 KB
1.1 GDP Data.xls	159.2 KB
2. Creating a Table.mp4	27.2 MB
2. Creating a Table.srt	6.3 KB
2.1 Creating a table - Tableau Public Link.html	0.2 KB
2.2 Tesla sales data.xlsx	2.9 MB
3. Creating Custom Fields.mp4	18.1 MB
3. Creating Custom Fields.srt	2.9 KB
3.1 Tableau operators.pdf	124.8 KB
3.2 Tesla sales data.xlsx	2.9 MB
4. Creating a Custom Field and Adding Calculations to a Table.mp4	31.1 MB
4. Creating a Custom Field and Adding Calculations to a Table.srt	4.7 KB
4.1 Creating a custom field - Tableau Public Link.html	0.2 KB
4.2 Tesla sales data.xlsx	2.9 MB
5. Adding Totals and Subtotals.mp4	21.9 MB
5. Adding Totals and Subtotals.srt	2.1 KB
5.1 Addint totals and subtotals - Tableau Public Link.html	0.2 KB
5.2 Tesla sales data.xlsx	2.9 MB
6. Adding a Custom Calculation.mp4	38.3 MB
6. Adding a Custom Calculation.srt	3.9 KB
6.1 Adding a custom calculation - Tableau Public Link.html	0.2 KB
7. Inserting a Filter.mp4	29.0 MB
7. Inserting a Filter.srt	2.7 KB
7.1 Inserting a filter - Tableau Public Link.html	0.2 KB
8. Working with Joins in Tableau.mp4	47.3 MB
8. Working with Joins in Tableau.srt	5.5 KB
8.1 13. Types of Joins.xlsx	57.7 KB
/29. Tableau - The Tableau Exercise/
1. Introduction to the Exercise.mp4	29.9 MB
1. Introduction to the Exercise.srt	2.6 KB
1.1 Audiobook reviews.xlsx	273.3 KB
1.2 Audiobook sales.xlsx	2.0 MB
10. Creating and Formatting a Dashboard.mp4	33.4 MB
10. Creating and Formatting a Dashboard.srt	5.4 KB
10.1 Audiobook sales.xlsx	2.0 MB
10.2 Audiobook reviews.xlsx	273.3 KB
10.3 Creating a dashboard - Tableau Public Link.html	0.2 KB
11. Adding Interactive Filters for Improved Analysis.mp4	33.2 MB
11. Adding Interactive Filters for Improved Analysis.srt	5.0 KB
11.1 Adding a filter - Tableau Public Link.html	0.2 KB
11.2 Audiobook reviews.xlsx	273.3 KB
11.3 Audiobook sales.xlsx	2.0 MB
12. Interactive Filters - fix.mp4	13.1 MB
12. Interactive Filters - fix.srt	2.0 KB
2. Let's Create a Dashboard - Visualizing the Three Charts We Want to Create.mp4	24.6 MB
2. Let's Create a Dashboard - Visualizing the Three Charts We Want to Create.srt	2.4 KB
3. Using Joins in Tableau.mp4	47.8 MB
3. Using Joins in Tableau.srt	7.2 KB
3.1 Audiobook sales.xlsx	2.0 MB
3.2 Audiobook reviews.xlsx	273.3 KB
4. Performing a Numbers Check - Attempt #1.mp4	26.3 MB
4. Performing a Numbers Check - Attempt #1.srt	4.7 KB
4.1 Audiobook reviews.xlsx	273.3 KB
4.2 Audiobook sales.xlsx	2.0 MB
4.3 Check the data - Tableau Public Link.html	0.2 KB
5. Blending Data in Tableau.mp4	33.9 MB
5. Blending Data in Tableau.srt	6.7 KB
5.1 Audiobook reviews.xlsx	273.3 KB
5.2 Check the data - Tableau Public Link.html	0.1 KB
5.3 Audiobook sales.xlsx	2.0 MB
6. Performing a Numbers Check - Attempt #2.mp4	30.0 MB
6. Performing a Numbers Check - Attempt #2.srt	5.3 KB
6.1 Check the data - Tableau Public Link.html	0.1 KB
6.2 Audiobook reviews.xlsx	273.3 KB
6.3 Audiobook sales.xlsx	2.0 MB
7. First Chart.mp4	28.6 MB
7. First Chart.srt	4.9 KB
7.1 Audiobook sales.xlsx	2.0 MB
7.2 First chart - Tableau Public Link.html	0.1 KB
7.3 Audiobook reviews.xlsx	273.3 KB
8. Second Chart.mp4	17.9 MB
8. Second Chart.srt	4.0 KB
8.1 Audiobook sales.xlsx	2.0 MB
8.2 Audiobook reviews.xlsx	273.3 KB
8.3 Second chart - Tableau Public Link.html	0.1 KB
9. Third Chart.mp4	16.0 MB
9. Third Chart.srt	3.4 KB
9.1 Audiobook sales.xlsx	2.0 MB
9.2 Audiobook reviews.xlsx	273.3 KB
9.3 Third chart - Tableau Public Link.html	0.1 KB
/3. Intro to Data and Data Science - The Relationship between Different Fields/
1. When are Traditional data, Big Data, BI, Traditional Data Science and ML applied.mp4	132.9 MB
1. When are Traditional data, Big Data, BI, Traditional Data Science and ML applied.srt	9.2 KB
1.1 365_DataScience.png	7.6 MB
2. When are Traditional data, Big Data, BI, Traditional Data Science and ML applied.html	0.2 KB
/30. Part 5 Combining SQL and Tableau - Introduction/
1. Introduction to Software Integration.mp4	97.2 MB
1. Introduction to Software Integration.srt	7.2 KB
2. Combining SQL and Tableau.mp4	88.0 MB
2. Combining SQL and Tableau.srt	6.4 KB
3. Loading the Database.mp4	30.3 MB
3. Loading the Database.srt	4.1 KB
4. Loading the Database.html	0.6 KB
4.1 employees_mod_db.pdf	132.8 KB
4.2 The 'employees_mod' database.html	0.1 KB
/31. Combining SQL and Tableau - Problem 1/
1. Problem 1 Task.mp4	35.4 MB
1. Problem 1 Task.srt	7.3 KB
1.1 employees_mod_db.pdf	132.8 KB
2. Problem 1 Task - Text.html	0.1 KB
3. Important clarification!.html	1.4 KB
4. Problem 1 Solution in SQL.mp4	45.3 MB
4. Problem 1 Solution in SQL.srt	5.8 KB
5. Problem 1 Solution in SQL - Code.html	0.4 KB
6. Exporting Your Output from SQL and Loading it in Tableau.mp4	33.1 MB
6. Exporting Your Output from SQL and Loading it in Tableau.srt	5.2 KB
7. Chart 1 Visualizing the Solution in Tableau - Part I.mp4	43.1 MB
7. Chart 1 Visualizing the Solution in Tableau - Part I.srt	7.6 KB
8. Chart 1 Visualizing the Solution in Tableau - Part II.mp4	47.8 MB
8. Chart 1 Visualizing the Solution in Tableau - Part II.srt	7.0 KB
/32. Combining SQL and Tableau - Problem 2/
1. Problem 2 Task.mp4	30.4 MB
1. Problem 2 Task.srt	4.8 KB
2. Problem 2 Task - Text.html	0.2 KB
3. Problem 2 Solution in SQL.mp4	41.6 MB
3. Problem 2 Solution in SQL.srt	4.4 KB
4. Problem 2 Solution in SQL - Code.html	0.7 KB
5. Chart 2 Visualizing the Solution in Tableau.mp4	51.8 MB
5. Chart 2 Visualizing the Solution in Tableau.srt	7.5 KB
/33. Combining SQL and Tableau - Problem 3/
1. Problem 3 Task.mp4	13.9 MB
1. Problem 3 Task.srt	2.9 KB
2. Problem 3 Task - Text.html	0.2 KB
3. Problem 3 Solution in SQL.mp4	34.9 MB
3. Problem 3 Solution in SQL.srt	4.0 KB
4. Problem 3 Solution in SQL - Code.html	0.5 KB
5. Chart 3 Visualizing the Solution in Tableau.mp4	42.5 MB
5. Chart 3 Visualizing the Solution in Tableau.srt	6.0 KB
/34. Combining SQL and Tableau - Problem 4/
1. Problem 4 Task.mp4	24.9 MB
1. Problem 4 Task.srt	3.7 KB
2. Problem 4 Task - Text.html	0.3 KB
3. Problem 4 Solution in SQL.mp4	31.8 MB
3. Problem 4 Solution in SQL.srt	3.2 KB
4. Problem 4 Solution in SQL - Code.html	0.7 KB
5. Chart 4 Visualizing the Solution in Tableau.mp4	23.8 MB
5. Chart 4 Visualizing the Solution in Tableau.srt	3.9 KB
/35. Combining SQL and Tableau - Problem 5/
1. Problem 5 Organizing Charts 1-4 into a Beautiful Dashboard.mp4	58.9 MB
1. Problem 5 Organizing Charts 1-4 into a Beautiful Dashboard.srt	6.9 KB
/36. Part 6 Introduction to Programming with Python/
1. A 5-minute explanation of Programming.mp4	61.4 MB
1. A 5-minute explanation of Programming.srt	7.1 KB
10. Understanding Jupyter's Interface.html	0.2 KB
11. Python 2 vs Python 3.mp4	11.8 MB
11. Python 2 vs Python 3.srt	3.4 KB
11.1 Python Introduction - Course Notes.pdf	2.1 MB
2. A 5-minute explanation of Programming.html	0.2 KB
3. Why use Python.mp4	78.7 MB
3. Why use Python.srt	7.1 KB
4. Why Use Python.html	0.2 KB
5. Why use Jupyter.mp4	46.5 MB
5. Why use Jupyter.srt	4.7 KB
6. Why Use Jupyter.html	0.2 KB
7. How to Install Python and Jupyter.mp4	53.5 MB
7. How to Install Python and Jupyter.srt	9.1 KB
8. Understanding Jupyter’s Interface – Dashboard.mp4	14.5 MB
8. Understanding Jupyter’s Interface – Dashboard.srt	3.8 KB
9. Understanding Jupyter’s Interface – Prerequisites for Coding.mp4	32.1 MB
9. Understanding Jupyter’s Interface – Prerequisites for Coding.srt	8.0 KB
9.1 Jupyter_Shortcuts.pdf	603.7 KB
/37. Python - Python Variables and Data Types/
1. Python Variables.mp4	26.5 MB
1. Python Variables.srt	6.2 KB
1.1 Variables - Lecture_Py3.ipynb	3.7 KB
1.2 Variables - Exercise_Py3.ipynb	2.3 KB
1.3 Python Introduction - Course Notes.pdf	2.1 MB
1.4 Variables - Solution_Py3.ipynb	3.9 KB
2. Python Variables.html	0.2 KB
3. Understanding Numbers and Boolean Values.mp4	17.9 MB
3. Understanding Numbers and Boolean Values.srt	3.8 KB
3.1 Numbers and Boolean Values - Solution_Py3.ipynb	3.3 KB
3.2 Numbers and Boolean Values - Lecture_Py3.ipynb	3.4 KB
3.3 Numbers and Boolean Values - Exercise_Py3.ipynb	2.3 KB
4. Understanding Numbers and Boolean Values.html	0.2 KB
5. Strings.mp4	53.1 MB
5. Strings.srt	14.9 KB
5.1 Strings - Solution_Py3.ipynb	5.6 KB
5.2 Strings - Lecture_Py3.ipynb	7.7 KB
5.3 Strings - Exercise_Py3.ipynb	2.7 KB
6. Strings.html	0.2 KB
/38. Python - Python Syntax Fundamentals/
1. The Arithmetic Operators of Python.mp4	19.8 MB
1. The Arithmetic Operators of Python.srt	4.2 KB
1.1 Arithmetic Operators - Exercise_Py3.ipynb	2.7 KB
1.2 Arithmetic Operators - Lecture_Py3.ipynb	3.6 KB
1.3 Arithmetic Operators - Solution_Py3.ipynb	4.3 KB
10. How to Index Elements.mp4	6.2 MB
10. How to Index Elements.srt	1.7 KB
10.1 Indexing Elements - Lecture_Py3.ipynb	1.3 KB
10.2 Indexing Elements - Solution_Py3.ipynb	2.2 KB
10.3 Indexing Elements - Exercise_Py3.ipynb	1.4 KB
11. How to Index Elements.html	0.2 KB
12. How to Structure Your Code with Indentation.mp4	13.8 MB
12. How to Structure Your Code with Indentation.srt	4.8 KB
12.1 Structure Your Code with Indentation - Lecture_Py3.ipynb	1.0 KB
12.2 Structure Your Code with Indentation - Exercise_Py3.ipynb	1.0 KB
12.3 Structure Your Code with Indentation - Solution_Py3.ipynb	1.5 KB
13. How to Structure Your Code with Indentation.html	0.2 KB
2. Using Arithmetic Operators in Python.html	0.2 KB
3. What is the Double Equality Sign.mp4	6.3 MB
3. What is the Double Equality Sign.srt	1.9 KB
3.1 The Double Equality Sign - Lecture_Py3.ipynb	1.5 KB
3.2 The Double Equality Sign - Exercise_Py3.ipynb	0.8 KB
3.3 The Double Equality Sign - Solution_Py3.ipynb	1.2 KB
4. What is the Double Equality Sign.html	0.2 KB
5. How to Reassign Values.mp4	4.2 MB
5. How to Reassign Values.srt	1.3 KB
5.1 Reassign Values - Lecture_Py3.ipynb	3.2 KB
5.2 Reassign Values - Exercise_Py3.ipynb	1.7 KB
5.3 Reassign Values - Solution_Py3.ipynb	2.2 KB
6. How to Reassign Values.html	0.2 KB
7. How to Add Comments.mp4	11.8 MB
7. How to Add Comments.srt	4.0 KB
7.1 Add Comments - Lecture_Py3.ipynb	1.1 KB
8. How to Add Comments.html	0.2 KB
9. Understanding Line Continuation.mp4	2.5 MB
9. Understanding Line Continuation.srt	1.2 KB
9.1 Line Continuation - Solution_Py3.ipynb	1.5 KB
9.2 Line Continuation - Exercise_Py3.ipynb	1.2 KB
9.3 Line Continuation - Lecture_Py3.ipynb	0.8 KB
/39. Python - Other Python Operators/
1. Python's Comparison Operators.mp4	10.7 MB
1. Python's Comparison Operators.srt	2.5 KB
1.1 Comparison Operators - Lecture_Py3.ipynb	2.6 KB
1.2 Comparison Operators - Solution_Py3.ipynb	2.5 KB
1.3 Comparison Operators - Exercise_Py3.ipynb	1.6 KB
2. Python's Comparison Operators.html	0.2 KB
3. Python's Logical and Identity Operators.mp4	31.5 MB
3. Python's Logical and Identity Operators.srt	5.9 KB
3.1 Logical and Identity Operators - Solution_Py3.ipynb	3.5 KB
3.2 Logical and Identity Operators - Exercise_Py3.ipynb	2.5 KB
3.3 Logical and Identity Operators - Lecture_Py3.ipynb	6.0 KB
4. Python's Logical and Identity Operators.html	0.2 KB
/4. Intro to Data and Data Science - What is the Purpose of each Data Science Field/
1. Why do we Need each of these Disciplines.mp4	91.7 MB
1. Why do we Need each of these Disciplines.srt	6.7 KB
2. Why do we Need each of these Disciplines.html	0.2 KB
/40. Python - Conditional Statements/
1. Getting to know the IF Statement.mp4	24.4 MB
1. Getting to know the IF Statement.srt	7.8 KB
1.1 Introduction to the If Statement - Exercise_Py3.ipynb	1.6 KB
1.2 Introduction to the If Statement - Lecture_Py3.ipynb	1.2 KB
1.3 Introduction to the If Statement - Solution_Py3.ipynb	2.2 KB
2. Getting to know the IF Statement.html	0.2 KB
3. Adding an ELSE statement.mp4	24.4 MB
3. Adding an ELSE statement.srt	6.4 KB
3.1 Add an Else Statement - Exercise_Py3.ipynb	1.0 KB
3.2 Add an Else Statement - Solution_Py3.ipynb	1.4 KB
3.3 Add an Else Statement - Lecture_Py3.ipynb	1.8 KB
4. Else if, for Brief – ELIF.mp4	55.9 MB
4. Else if, for Brief – ELIF.srt	13.5 KB
4.1 Else If, for Brief - Elif - Solution_Py3.ipynb	2.5 KB
4.2 Else If, for Brief - Elif - Exercise_Py3.ipynb	1.8 KB
4.3 Else If, for Brief - Elif - Lecture_Py3.ipynb	3.3 KB
5. An Additional Explanation of Boolean Values.mp4	21.0 MB
5. An Additional Explanation of Boolean Values.srt	6.4 KB
5.1 A Note on Boolean Values - Lecture_Py3.ipynb	0.8 KB
6. An Additional Explanation of Boolean Values.html	0.2 KB
/41. Python - Functions/
1. How to Define a Function in Python.mp4	15.5 MB
1. How to Define a Function in Python.srt	5.4 KB
1.1 Defining a Function in Python - Lecture_Py3.ipynb	0.9 KB
2. How to Create a Function with a Parameter.mp4	39.9 MB
2. How to Create a Function with a Parameter.srt	9.2 KB
2.1 Creating a Function with a Parameter - Solution_Py3.ipynb	1.8 KB
2.2 Creating a Function with a Parameter - Exercise_Py3.ipynb	1.2 KB
2.3 Creating a Function with a Parameter - Lecture_Py3.ipynb	1.6 KB
3. Define a Function in Another Way.mp4	26.5 MB
3. Define a Function in Another Way.srt	6.6 KB
3.1 Another Way to Define a Function - Solution_Py3.ipynb	2.0 KB
3.2 Another Way to Define a Function - Exercise_Py3.ipynb	1.3 KB
3.3 Another Way to Define a Function - Lecture_Py3.ipynb	3.4 KB
4. How to use a Function within a Function.mp4	8.5 MB
4. How to use a Function within a Function.srt	2.1 KB
4.1 Using a Function in another Function - Solution_Py3.ipynb	1.6 KB
4.2 Using a Function in another Function - Lecture_Py3.ipynb	1.0 KB
4.3 Using a Function in another Function - Exercise_Py3.ipynb	1.1 KB
5. Use Conditional Statements and Functions Together.mp4	16.4 MB
5. Use Conditional Statements and Functions Together.srt	3.6 KB
5.1 Combining Conditional Statements and Functions - Solution_Py3.ipynb	1.7 KB
5.2 Combining Conditional Statements and Functions - Exercise_Py3.ipynb	1.1 KB
5.3 Combining Conditional Statements and Functions - Lecture_Py3.ipynb	1.3 KB
6. How to Create Functions Which Contain a Few Arguments.mp4	15.4 MB
6. How to Create Functions Which Contain a Few Arguments.srt	3.1 KB
6.1 Creating Functions Containing a Few Arguments - Lecture_Py3.ipynb	1.8 KB
7. Built-In Functions in Python Worth Knowing.mp4	23.1 MB
7. Built-In Functions in Python Worth Knowing.srt	4.3 KB
7.1 Notable Built-In Functions in Python - Lecture_Py3.ipynb	4.6 KB
7.2 Notable Built-In Functions in Python - Solution_Py3.ipynb	5.7 KB
7.3 Notable Built-In Functions in Python - Exercise_Py3.ipynb	3.7 KB
8. Python - Functions.html	0.2 KB
/42. Python - Python Sequences/
1. Introduction to Lists.mp4	39.6 MB
1. Introduction to Lists.srt	10.1 KB
1.1 Lists - Lecture_Py3.ipynb	2.8 KB
1.2 Lists - Exercise_Py3.ipynb	2.2 KB
1.3 Lists - Solution_Py3.ipynb	3.3 KB
2. Introduction to Lists.html	0.2 KB
3. Using Methods in Python.mp4	39.4 MB
3. Using Methods in Python.srt	8.6 KB
3.1 Help Yourself with Methods - Lecture_Py3.ipynb	4.5 KB
3.2 Help Yourself with Methods - Exercise_Py3.ipynb	2.0 KB
3.3 Help Yourself with Methods - Solution_Py3.ipynb	13.1 KB
4. Using Methods in Python.html	0.2 KB
5. What is List Slicing.mp4	32.3 MB
5. What is List Slicing.srt	5.7 KB
5.1 List Slicing - Exercise_Py3.ipynb	2.9 KB
5.2 List Slicing - Solution_Py3.ipynb	4.4 KB
5.3 List Slicing - Lecture_Py3.ipynb	5.1 KB
6. Working with Tuples.mp4	30.9 MB
6. Working with Tuples.srt	7.1 KB
6.1 Tuples - Solution_Py3.ipynb	4.7 KB
6.2 Tuples - Lecture_Py3.ipynb	3.0 KB
6.3 Tuples - Exercise_Py3.ipynb	2.1 KB
7. Python Dictionaries.mp4	43.7 MB
7. Python Dictionaries.srt	8.6 KB
7.1 Dictionaries - Exercise_Py3.ipynb	3.0 KB
7.2 Dictionaries - Solution_Py3.ipynb	6.3 KB
7.3 Dictionaries - Lecture_Py3.ipynb	4.5 KB
8. Python Dictionaries.html	0.2 KB
/43. Python - Using Iterations/
1. Using For Loops.mp4	24.7 MB
1. Using For Loops.srt	6.7 KB
1.1 For Loops - Solution_Py3.ipynb	1.8 KB
1.2 For Loops - Exercise_Py3.ipynb	1.3 KB
1.3 For Loops - Lecture_Py3.ipynb	1.3 KB
2. For Loops.html	0.2 KB
3. Using While Loops and Incrementing.mp4	29.8 MB
3. Using While Loops and Incrementing.srt	6.0 KB
3.1 While Loops and Incrementing - Exercise_Py3.ipynb	1.1 KB
3.2 While Loops and Incrementing - Lecture_Py3.ipynb	1.1 KB
3.3 While Loops and Incrementing - Solution_Py3.ipynb	1.8 KB
4. Use the range() Function to Create Lists.mp4	27.0 MB
4. Use the range() Function to Create Lists.srt	7.8 KB
4.1 Create Lists with the range() Function - Exercise_Py3.ipynb	1.5 KB
4.2 Create Lists with the range() Function - Solution_Py3.ipynb	2.3 KB
4.3 Create Lists with the range() Function - Lecture_Py3.ipynb	1.4 KB
5. Use the range() Function to Create Lists.html	0.2 KB
6. Combine Conditional Statements and Loops.mp4	29.1 MB
6. Combine Conditional Statements and Loops.srt	7.6 KB
6.1 Use Conditional Statements and Loops Together - Lecture_Py3.ipynb	2.0 KB
6.2 Use Conditional Statements and Loops Together - Exercise_Py3.ipynb	2.1 KB
6.3 Use Conditional Statements and Loops Together - Solution_Py3.ipynb	3.0 KB
7. All In – Conditional Statements, Functions, and Loops.mp4	10.0 MB
7. All In – Conditional Statements, Functions, and Loops.srt	7.4 MB
7.1 All In - Exercise_Py3.ipynb	1.3 KB
7.2 All In - Solution_Py3.ipynb	1.9 KB
7.3 All In - Lecture_Py3.ipynb	1.7 KB
8. How to Iterate over Dictionaries.mp4	31.1 MB
8. How to Iterate over Dictionaries.srt	8.1 KB
8.1 Iterating over Dictionaries - Exercise_Py3.ipynb	2.2 KB
8.2 Iterating over Dictionaries - Solution_Py3.ipynb	2.9 KB
8.3 Iterating over Dictionaries - Lecture_Py3.ipynb	1.1 KB
/44. Python - Advanced Python tools/
1. Introduction to Object Oriented Programming (OOP).mp4	35.2 MB
1. Introduction to Object Oriented Programming (OOP).srt	6.2 KB
2. Introduction to Object Oriented Programming (OOP).html	0.2 KB
3. Using Modules and Packages.mp4	8.9 MB
3. Using Modules and Packages.srt	1.3 KB
4. Using Modules and Packages.html	0.2 KB
5. What is the Standard Library.mp4	18.9 MB
5. What is the Standard Library.srt	3.6 KB
6. What is the Standard Library.html	0.2 KB
7. How to Import Modules in Python.mp4	20.9 MB
7. How to Import Modules in Python.srt	4.9 KB
8. How to Import Modules in Python.html	0.2 KB
/45. Part 7 Integration - Software Integration/
1. Getting Started with Data, Servers, Clients, Requests, and Responses.mp4	72.4 MB
1. Getting Started with Data, Servers, Clients, Requests, and Responses.srt	6.1 KB
10. What is Software Integration and How is it Applied.html	0.2 KB
2. Getting Started with Data, Servers, Clients, Requests, and Responses.html	0.2 KB
3. Getting Started with Data Connectivity, APIs, and Endpoints.mp4	109.2 MB
3. Getting Started with Data Connectivity, APIs, and Endpoints.srt	8.7 KB
4. Getting Started with Data Connectivity, APIs, and Endpoints.html	0.2 KB
5. Become Better Acquainted with APIs.mp4	121.2 MB
5. Become Better Acquainted with APIs.srt	10.6 KB
6. Become Better Acquainted with APIs.html	0.2 KB
7. Communication through Text Files.mp4	63.3 MB
7. Communication through Text Files.srt	5.6 KB
8. Communication through Text Files.html	0.2 KB
9. What is Software Integration and How is it Applied.mp4	66.8 MB
9. What is Software Integration and How is it Applied.srt	6.9 KB
/46. Integration - What is contained in this Course/
1. Solving a Business Exercise with Python, SQL, and Tableau.mp4	54.9 MB
1. Solving a Business Exercise with Python, SQL, and Tableau.srt	5.6 KB
2. Presenting the Task Absenteeism at Work.mp4	41.0 MB
2. Presenting the Task Absenteeism at Work.srt	3.8 KB
3. Presenting the Data Set.mp4	42.9 MB
3. Presenting the Data Set.srt	4.2 KB
4. Presenting the Data Set.html	0.2 KB
/47. Integration - Data Preprocessing Step by Step/
1. How is the Content in the Next Sections Organized.html	2.5 KB
1.1 data_preprocessing_homework.pdf	137.7 KB
1.2 df_preprocessed.csv	29.8 KB
1.3 Absenteeism_data.csv	32.8 KB
10. A Deeper Look at the 'Reasons for Absence' Column.mp4	42.5 MB
10. A Deeper Look at the 'Reasons for Absence' Column.srt	6.0 KB
11. Splitting a Variable into Multiple Dummy Variables.mp4	85.1 MB
11. Splitting a Variable into Multiple Dummy Variables.srt	10.4 KB
12. EXERCISE - Splitting a Variable into Multiple Dummy Variables.html	0.1 KB
13. SOLUTION - Splitting a Variable into Multiple Dummy Variables.html	0.1 KB
14. How to Drop a Dummy Variable from the Data Set.html	2.4 KB
15. A Statistical Perspective on Dummy Variables.mp4	14.4 MB
15. A Statistical Perspective on Dummy Variables.srt	1.7 KB
16. Categorizing the Various Reasons for Absence.mp4	78.2 MB
16. Categorizing the Various Reasons for Absence.srt	10.3 KB
17. Concatenation in Python.mp4	40.6 MB
17. Concatenation in Python.srt	5.2 KB
18. EXERCISE - Concatenation in Python.html	0.2 KB
19. SOLUTION - Concatenation in Python.html	0.1 KB
2. How to Import the Data Set in Python.mp4	24.2 MB
2. How to Import the Data Set in Python.srt	4.1 KB
20. How to Reorder Columns in a DataFrame in Python.mp4	14.7 MB
20. How to Reorder Columns in a DataFrame in Python.srt	1.9 KB
21. EXERCISE - How to Reorder Columns in a DataFrame in Python.html	0.2 KB
22. SOLUTION - How to Reorder Columns in a DataFrame in Python.html	0.5 KB
23. Using Checkpoints to Ease Your Work in Jupyter.mp4	27.0 MB
23. Using Checkpoints to Ease Your Work in Jupyter.srt	3.7 KB
23.1 Absenteeism Exercise - Preprocessing - df_reason_mod.ipynb	4.9 KB
24. EXERCISE - Using Checkpoints to Ease Your Work in Jupyter.html	0.1 KB
25. SOLUTION - Using Checkpoints to Ease Your Work in Jupyter.html	0.1 KB
26. Analyzing the Date Column.mp4	60.1 MB
26. Analyzing the Date Column.srt	8.6 KB
27. Retrieving the Month Value From the Date Column.mp4	50.1 MB
27. Retrieving the Month Value From the Date Column.srt	8.2 KB
28. Adding the Day of the Week Column.mp4	29.3 MB
28. Adding the Day of the Week Column.srt	4.6 KB
29. EXERCISE - Dropping Columns.html	1.2 KB
29.1 Absenteeism Exercise - Preprocessing - ChP - df_date_reason_mod.ipynb	7.5 KB
29.2 Absenteeism Exercise - Removing the Date Column - SOLUTION.ipynb	8.5 KB
3. Exploring the Data Set.mp4	64.8 MB
3. Exploring the Data Set.srt	7.2 KB
30. Analysis of the Next 5 Columns in DF.mp4	31.0 MB
30. Analysis of the Next 5 Columns in DF.srt	4.4 KB
31. Dealing with More Numerical Features which may Behave like Categorical Ones.mp4	41.5 MB
31. Dealing with More Numerical Features which may Behave like Categorical Ones.srt	5.8 KB
32. A Final Note on this Section.mp4	22.7 MB
32. A Final Note on this Section.srt	2.5 KB
32.1 Absenteeism Exercise - EXERCISES and SOLUTIONS.ipynb	4.2 KB
32.2 Absenteeism Exercise - Preprocessing LECTURES.ipynb	8.0 MB
4. Programming vs the Rest of the World.mp4	29.2 MB
4. Programming vs the Rest of the World.srt	4.2 KB
5. A Brief Summary of Regression Analysis.html	2.9 KB
6. The Approach we will Take to Solve this Exercise.mp4	21.1 MB
6. The Approach we will Take to Solve this Exercise.srt	2.9 KB
7. Dropping Variables We Don't Need.mp4	64.7 MB
7. Dropping Variables We Don't Need.srt	8.0 KB
8. EXERCISE - Dropping Variables We Don't Need.html	0.9 KB
9. SOLUTION - Dropping Variables We Don't Need.html	0.1 KB
/48. Integration - Integrating Python and SQL/
1. How to Use the 'absenteeism_module' in Python - Part I.mp4	26.7 MB
1. How to Use the 'absenteeism_module' in Python - Part I.srt	4.9 KB
1.1 Absenteeism Exercise - Integration.ipynb	63.8 KB
1.2 model.original	1.0 KB
1.3 absenteeism_module.py	6.8 KB
1.4 Absenteeism_new_data.csv	1.9 KB
1.5 scaler.original	1.9 KB
10. Sending Data from Jupyter to Workbench - Part II.mp4	61.1 MB
10. Sending Data from Jupyter to Workbench - Part II.srt	7.8 KB
11. Sending Data from Jupyter to Workbench - Part III.mp4	34.4 MB
11. Sending Data from Jupyter to Workbench - Part III.srt	3.4 KB
11.1 predicted_outputs.sql	0.7 KB
11.2 The INSERT Statement.sql	2.6 KB
11.3 Multiple INSERT Statements.sql	4.1 KB
11.4 Absenteeism_predictions.csv	1.6 KB
11.5 Absenteeism Exercise - Integration.ipynb	67.9 KB
2. How to Use the 'absenteeism_module' in Python - Part II.mp4	57.0 MB
2. How to Use the 'absenteeism_module' in Python - Part II.srt	7.7 KB
3. Creating the 'predicted_outputs' Database in MySQL.mp4	61.8 MB
3. Creating the 'predicted_outputs' Database in MySQL.srt	8.1 KB
4. Importing 'pymysql' in Python.mp4	20.0 MB
4. Importing 'pymysql' in Python.srt	3.5 KB
5. Creating a Connection and Cursor.mp4	22.0 MB
5. Creating a Connection and Cursor.srt	3.6 KB
6. EXERCISE - Creating 'df_new_obs'.html	0.3 KB
7. Creating the 'predicted_outputs' Table in MySQL.mp4	55.0 MB
7. Creating the 'predicted_outputs' Table in MySQL.srt	6.1 KB
8. Executing and SQL SELECT Statement from Python.mp4	26.6 MB
8. Executing and SQL SELECT Statement from Python.srt	3.8 KB
9. Sending Data from Jupyter to Workbench - Part I.mp4	80.0 MB
9. Sending Data from Jupyter to Workbench - Part I.srt	8.0 KB
/49. Integration - Using Tableau to Analyze the Predicted Outputs/
1. EXERCISE - Age vs Probability.html	0.4 KB
1.1 Absenteeism_predictions.csv	2.2 KB
2. Using Tableau to Analyze Age vs Probability.mp4	59.2 MB
2. Using Tableau to Analyze Age vs Probability.srt	10.3 KB
3. EXERCISE - Reasons vs Probability.html	0.4 KB
4. Using Tableau to Analyze Reasons vs Probability.mp4	62.2 MB
4. Using Tableau to Analyze Reasons vs Probability.srt	9.8 KB
5. EXERCISE - Transportation Expense vs Probability.html	0.6 KB
6. Using Tableau to Analyze Transportation Expense vs Probability.mp4	42.6 MB
6. Using Tableau to Analyze Transportation Expense vs Probability.srt	7.4 KB
7. Completing 100%.html	1.9 KB
/5. Intro to Data and Data Science - Common Data Science Techniques/
1. Traditional Data Techniques.mp4	145.1 MB
1. Traditional Data Techniques.srt	10.9 KB
10. Traditional Methods Techniques.mp4	117.1 MB
10. Traditional Methods Techniques.srt	117.1 MB
11. Traditional Methods Techniques.html	0.2 KB
12. Traditional Methods Real-life Examples.mp4	44.9 MB
12. Traditional Methods Real-life Examples.srt	3.7 KB
13. Machine Learning (ML) Techniques.mp4	104.1 MB
13. Machine Learning (ML) Techniques.srt	8.9 KB
14. Machine Learning (ML) Techniques.html	0.2 KB
15. Machine Learning (ML) Types of Machine Learning.mp4	131.1 MB
15. Machine Learning (ML) Types of Machine Learning.srt	10.8 KB
16. Machine Learning (ML) Types of Machine Learning.html	0.2 KB
17. Machine Learning (ML) Real-life Examples.mp4	38.6 MB
17. Machine Learning (ML) Real-life Examples.srt	3.0 KB
18. Machine Learning (ML) Real-life Examples.html	0.2 KB
2. Traditional Data Techniques.html	0.2 KB
3. Traditional Data Real-life Examples.mp4	31.4 MB
3. Traditional Data Real-life Examples.srt	2.3 KB
4. Big Data Techniques.mp4	79.1 MB
4. Big Data Techniques.srt	5.8 KB
5. Big Data Techniques.html	0.2 KB
6. Big Data Real-life Examples.mp4	23.1 MB
6. Big Data Real-life Examples.srt	1.9 KB
7. Business Intelligence (BI) Techniques.mp4	94.2 MB
7. Business Intelligence (BI) Techniques.srt	8.8 KB
8. Business Intelligence (BI) Techniques.html	0.2 KB
9. Business Intelligence (BI) Real-life Examples.mp4	31.0 MB
9. Business Intelligence (BI) Real-life Examples.srt	2.2 KB
/6. Intro to Data and Data Science - Common Data Science Tools/
1. Programming Languages & Software Employed in Data Science - All the Tools Needed.mp4	108.4 MB
1. Programming Languages & Software Employed in Data Science - All the Tools Needed.srt	7.5 KB
2. Programming Languages & Software Employed in Data Science - All the Tools Needed.html	0.2 KB
/7. Intro to Data and Data Science - Data Science Career Paths/
1. Data Science Job Positions What do they Involve and What to Look out for.mp4	57.0 MB
1. Data Science Job Positions What do they Involve and What to Look out for.srt	4.6 KB
2. Data Science Job Positions What do they Involve and What to Look out for.html	0.2 KB
/8. Intro to Data and Data Science - Dispelling Common Misconceptions/
1. Dispelling common Misconceptions.mp4	76.3 MB
1. Dispelling common Misconceptions.srt	5.4 KB
2. Dispelling common Misconceptions.html	0.2 KB
/9. Part 2 Statistics - Population and Sample/
1. Population vs sample.mp4	60.9 MB
1. Population vs sample.srt	5.6 KB
1.1 Statistics Glossary.xlsx	20.8 KB
1.2 Course notes_descriptive_statistics.pdf	493.8 KB
2. Population and Sample.html	0.2 KB
Total files 1024