| 1. Part 1 Introduction | |||
| 1. What Does the Course Cover.mp4 | 55.09 MB | ||
| 1. What Does the Course Cover.srt | 5.02 KB | ||
| 1.1 BI - FAQ.pdf | 1.11 MB | ||
| 2. Download All Resources.html | 666 B | ||
| 10. Statistics - Descriptive Statistics | |||
| 1. Types of Data.mp4 | 72.49 MB | ||
| 1. Types of Data.srt | 5.95 KB | ||
| 1.1 Course notes_descriptive_statistics.pdf | 482.21 KB | ||
| 10. Numerical Variables Exercise.html | 81 B | ||
| 10.1 2.4.Numerical-variables.Frequency-distribution-table-exercise.xlsx | 12.02 KB | ||
| 10.2 2.4. Numerical variables. Frequency distribution table_exercise_solution.xlsx | 13.25 KB | ||
| 11. The Histogram.mp4 | 13.8 MB | ||
| 11. The Histogram.srt | 3.01 KB | ||
| 11.1 2.5. The Histogram_lesson.xlsx | 18.63 KB | ||
| 12. The Histogram.html | 156 B | ||
| 13. Histogram Exercise.html | 81 B | ||
| 13.1 Statistics - PDF with Excel Solutions that don't visualize properly.pdf | 289.12 KB | ||
| 13.2 2.5. The Histogram_exercise_solution.xlsx | 16.83 KB | ||
| 13.3 2.5. The Histogram_exercise.xlsx | 15.5 KB | ||
| 14. Cross Table and Scatter Plot.mp4 | 39.8 MB | ||
| 14. Cross Table and Scatter Plot.srt | 6.68 KB | ||
| 14.1 2.6. Cross table and scatter plot.xlsx | 26.12 KB | ||
| 15. Cross Tables and Scatter Plots.html | 156 B | ||
| 16. Cross Tables and Scatter Plots Exercise.html | 81 B | ||
| 16.1 2.6. Cross table and scatter plot_exercise_solution.xlsx | 40.44 KB | ||
| 16.2 2.6. Cross table and scatter plot_exercise.xlsx | 16.28 KB | ||
| 17. Mean, median and mode.mp4 | 37.1 MB | ||
| 17. Mean, median and mode.srt | 5.73 KB | ||
| 17.1 2.7. Mean, median and mode_lesson.xlsx | 10.49 KB | ||
| 18. Mean, Median and Mode Exercise.html | 81 B | ||
| 18.1 2.7. Mean, median and mode_exercise_solution.xlsx | 11.35 KB | ||
| 18.2 2.7. Mean, median and mode_exercise.xlsx | 10.87 KB | ||
| 19. Skewness.mp4 | 19.44 MB | ||
| 19. Skewness.srt | 3.64 KB | ||
| 19.1 2.8. Skewness_lesson.xlsx | 34.63 KB | ||
| 2. Types of data.html | 156 B | ||
| 20. Skewness.html | 156 B | ||
| 21. Skewness Exercise.html | 81 B | ||
| 21.1 2.8. Skewness_exercise_solution.xlsx | 19.78 KB | ||
| 21.2 2.8. Skewness_exercise.xlsx | 9.49 KB | ||
| 22. Variance.mp4 | 50.96 MB | ||
| 22. Variance.srt | 7.53 KB | ||
| 22.1 2.9. Variance_lesson.xlsx | 10.08 KB | ||
| 23. Variance Exercise.html | 81 B | ||
| 23.1 2.9. Variance_exercise_solution.xlsx | 11.05 KB | ||
| 23.2 2.9. Variance_exercise.xlsx | 10.83 KB | ||
| 24. Standard Deviation and Coefficient of Variation.mp4 | 45.16 MB | ||
| 24. Standard Deviation and Coefficient of Variation.srt | 6.6 KB | ||
| 24.1 2.10. Standard deviation and coefficient of variation_lesson.xlsx | 10.97 KB | ||
| 25. Standard deviation.html | 156 B | ||
| 26. Standard Deviation and Coefficient of Variation Exercise.html | 81 B | ||
| 26.1 2.10.Standard-deviation-and-coefficient-of-variation-exercise-solution.xlsx | 12.6 KB | ||
| 26.2 2.10.Standard-deviation-and-coefficient-of-variation-exercise.xlsx | 11.61 KB | ||
| 27. Covariance.mp4 | 27.51 MB | ||
| 27. Covariance.srt | 4.92 KB | ||
| 27.1 2.11. Covariance_lesson.xlsx | 24.92 KB | ||
| 28. Covariance.html | 156 B | ||
| 29. Covariance Exercise.html | 81 B | ||
| 29.1 2.11. Covariance_exercise_solution.xlsx | 29.51 KB | ||
| 29.2 2.11. Covariance_exercise.xlsx | 20.23 KB | ||
| 3. Levels of Measurement.mp4 | 54.36 MB | ||
| 3. Levels of Measurement.srt | 4.54 KB | ||
| 30. Correlation Coefficient.mp4 | 29.38 MB | ||
| 30. Correlation Coefficient.srt | 4.71 KB | ||
| 30.1 2.12. Correlation_lesson.xlsx | 24.99 KB | ||
| 31. Correlation Coefficient.html | 156 B | ||
| 32. Correlation Coefficient Exercise.html | 81 B | ||
| 32.1 2.12. Correlation_exercise.xlsx | 29.3 KB | ||
| 32.2 2.12. Correlation_exercise_solution.xlsx | 29.48 KB | ||
| 4. Levels of measurement.html | 156 B | ||
| 5. Categorical Variables - Visualization Techniques.mp4 | 36.62 MB | ||
| 5. Categorical Variables - Visualization Techniques.srt | 6.3 KB | ||
| 5.1 2.3. Categorical variables. Visualization techniques_lesson.xlsx | 30.58 KB | ||
| 6. Categorical variables. Visualization Techniques.html | 156 B | ||
| 7. Categorical Variables Exercise.html | 81 B | ||
| 7.1 2.3. Categorical variables. Visualization techniques_exercise_solution.xlsx | 51.11 KB | ||
| 7.2 Statistics - PDF with Excel Solutions that don't visualize properly.pdf | 289.12 KB | ||
| 7.3 2.3. Categorical variables. Visualization techniques_exercise.xlsx | 15.24 KB | ||
| 8. Numerical Variables - Frequency Distribution Table.mp4 | 25.83 MB | ||
| 8. Numerical Variables - Frequency Distribution Table.srt | 4.36 KB | ||
| 8.1 2.4. Numerical variables. Frequency distribution table_lesson.xlsx | 11.44 KB | ||
| 9. Numerical variables. Using a frequency distribution table.html | 156 B | ||
| 11. Statistics - Practical Example Descriptive Statistics | |||
| 1. Practical Example.mp4 | 160.47 MB | ||
| 1. Practical Example.srt | 20.78 KB | ||
| 1.1 2.13. Practical example. Descriptive statistics_lesson.xlsx | 146.51 KB | ||
| 2. Practical Example Exercise.html | 81 B | ||
| 2.1 2.13.Practical-example.Descriptive-statistics-exercise.xlsx | 120.28 KB | ||
| 2.2 2.13.Practical-example.Descriptive-statistics-exercise-solution.xlsx | 156.22 KB | ||
| 12. Statistics - Inferential Statistics Fundamentals | |||
| 1. Introduction.mp4 | 15.49 MB | ||
| 1. Introduction.srt | 1.63 KB | ||
| 1.1 Course notes_inferential statistics.pdf | 382.32 KB | ||
| 10. Central Limit Theorem.html | 156 B | ||
| 11. Standard error.mp4 | 22.75 MB | ||
| 11. Standard error.srt | 2.02 KB | ||
| 12. Standard error.html | 156 B | ||
| 13. Estimators and Estimates.mp4 | 47.86 MB | ||
| 13. Estimators and Estimates.srt | 3.71 KB | ||
| 14. Estimators and Estimates.html | 156 B | ||
| 2. What is a Distribution.mp4 | 61.66 MB | ||
| 2. What is a Distribution.srt | 5.85 KB | ||
| 2.1 3.2. What is a distribution_lesson.xlsx | 19.46 KB | ||
| 2.2 Course notes_inferential statistics.pdf | 382.32 KB | ||
| 3. What is a Distribution.html | 156 B | ||
| 4. The Normal Distribution.mp4 | 49.9 MB | ||
| 4. The Normal Distribution.srt | 4.9 KB | ||
| 5. The Normal Distribution.html | 156 B | ||
| 6. The Standard Normal Distribution.mp4 | 22.5 MB | ||
| 6. The Standard Normal Distribution.srt | 3.94 KB | ||
| 6.1 3.4. Standard normal distribution_lesson.xlsx | 10.38 KB | ||
| 7. The Standard Normal Distribution.html | 156 B | ||
| 8. The Standard Normal Distribution Exercise.html | 81 B | ||
| 8.1 3.4.Standard-normal-distribution-exercise.xlsx | 11.99 KB | ||
| 8.2 3.4.Standard-normal-distribution-exercise-solution.xlsx | 24.04 KB | ||
| 9. Central Limit Theorem.mp4 | 62.91 MB | ||
| 9. Central Limit Theorem.srt | 5.63 KB | ||
| 13. Statistics - Inferential Statistics Confidence Intervals | |||
| 1. What are Confidence Intervals.mp4 | 49.95 MB | ||
| 1. What are Confidence Intervals.srt | 3.26 KB | ||
| 10. Margin of Error.mp4 | 47.19 MB | ||
| 10. Margin of Error.srt | 6.15 KB | ||
| 11. Margin of Error.html | 156 B | ||
| 12. Confidence intervals. Two means. Dependent samples.mp4 | 70.45 MB | ||
| 12. Confidence intervals. Two means. Dependent samples.srt | 8.03 KB | ||
| 12.1 3.13. Confidence intervals. Two means. Dependent samples_lesson.xlsx | 10.47 KB | ||
| 13. Confidence intervals. Two means. Dependent samples Exercise.html | 82 B | ||
| 13.1 3.13. Confidence intervals. Two means. Dependent samples_exercise_solution.xlsx | 14.24 KB | ||
| 13.2 3.13. Confidence intervals. Two means. Dependent samples_exercise.xlsx | 13.74 KB | ||
| 14. Confidence intervals. Two means. Independent samples (Part 1).mp4 | 28.77 MB | ||
| 14. Confidence intervals. Two means. Independent samples (Part 1).srt | 6.07 KB | ||
| 14.1 3.14. Confidence intervals. Two means. Independent samples (Part 1)_lesson.xlsx | 9.83 KB | ||
| 15. Confidence intervals. Two means. Independent samples (Part 1) Exercise.html | 82 B | ||
| 15.1 3.14. Confidence intervals. Two means. Independent samples (Part 1)_exercise_solution.xlsx | 10.12 KB | ||
| 15.2 3.14. Confidence intervals. Two means. Independent samples (Part 1)_exercise.xlsx | 9.83 KB | ||
| 16. Confidence intervals. Two means. Independent samples (Part 2).mp4 | 26.84 MB | ||
| 16. Confidence intervals. Two means. Independent samples (Part 2).srt | 4.51 KB | ||
| 16.1 3.15. Confidence intervals. Two means. Independent samples (Part 2)_lesson.xlsx | 9.52 KB | ||
| 17. Confidence intervals. Two means. Independent samples (Part 2) Exercise.html | 82 B | ||
| 17.1 3.15. Confidence intervals. Two means. Independent samples (Part 2)_exercise.xlsx | 9.17 KB | ||
| 17.2 3.15. Confidence intervals. Two means. Independent samples (Part 2)_exercise_solution.xlsx | 9.79 KB | ||
| 18. Confidence intervals. Two means. Independent samples (Part 3).mp4 | 19.91 MB | ||
| 18. Confidence intervals. Two means. Independent samples (Part 3).srt | 1.96 KB | ||
| 2. What are Confidence Intervals.html | 156 B | ||
| 3. Confidence Intervals; Population Variance Known; z-score.mp4 | 78.19 MB | ||
| 3. Confidence Intervals; Population Variance Known; z-score.srt | 9.8 KB | ||
| 3.1 3.9. Population variance known, z-score_lesson.xlsx | 11.21 KB | ||
| 3.2 3.9.The-z-table.xlsx | 25.58 KB | ||
| 4. Confidence Intervals; Population Variance Known; z-score Exercise.html | 81 B | ||
| 4.1 3.9. Population variance known, z-score_exercise.xlsx | 10.83 KB | ||
| 4.2 3.9.The-z-table.xlsx | 25.58 KB | ||
| 4.3 3.9. Population variance known, z-score_exercise_solution.xlsx | 11.16 KB | ||
| 5. Confidence interval clarifications.mp4 | 57.03 MB | ||
| 5. Confidence interval clarifications.srt | 5.41 KB | ||
| 6. Student's T Distribution.mp4 | 35.39 MB | ||
| 6. Student's T Distribution.srt | 4.13 KB | ||
| 7. Student's T Distribution.html | 156 B | ||
| 8. Confidence Intervals; Population Variance Unknown; t-score.mp4 | 32.19 MB | ||
| 8. Confidence Intervals; Population Variance Unknown; t-score.srt | 5.71 KB | ||
| 8.1 3.11. Population variance unknown, t-score_lesson.xlsx | 10.78 KB | ||
| 8.2 3.11. The t-table.xlsx | 15.85 KB | ||
| 9. Confidence Intervals; Population Variance Unknown; t-score Exercise.html | 82 B | ||
| 9.1 3.11. The t-table.xlsx | 15.85 KB | ||
| 9.2 3.11. Population variance unknown, t-score_exercise.xlsx | 10.62 KB | ||
| 9.3 3.11. Population variance unknown, t-score_exercise_solution.xlsx | 11.1 KB | ||
| 14. Statistics - Practical Example Inferential Statistics | |||
| 1. Practical Example Inferential Statistics.mp4 | 102.64 MB | ||
| 1. Practical Example Inferential Statistics.srt | 13.64 KB | ||
| 1.1 3.17. Practical example. Confidence intervals_lesson.xlsx | 1.74 MB | ||
| 2. Practical Example Inferential Statistics Exercise.html | 82 B | ||
| 2.1 3.17.Practical-example.Confidence-intervals-exercise.xlsx | 1.73 MB | ||
| 2.2 3.17.Practical-example.Confidence-intervals-exercise-solution.xlsx | 1.82 MB | ||
| 15. Statistics - Hypothesis Testing | |||
| 1. The Null vs Alternative Hypothesis.mp4 | 92.08 MB | ||
| 1. The Null vs Alternative Hypothesis.srt | 6.97 KB | ||
| 1.1 Course notes_hypothesis_testing.pdf | 656.44 KB | ||
| 10. p-value.mp4 | 55.93 MB | ||
| 10. p-value.srt | 5.03 KB | ||
| 10.1 Online p-value calculator.pdf | 1.15 MB | ||
| 11. p-value.html | 156 B | ||
| 12. Test for the Mean. Population Variance Unknown.mp4 | 40.18 MB | ||
| 12. Test for the Mean. Population Variance Unknown.srt | 5.73 KB | ||
| 12.1 4.6.Test-for-the-mean.Population-variance-unknown-lesson.xlsx | 14.54 KB | ||
| 13. Test for the Mean. Population Variance Unknown Exercise.html | 82 B | ||
| 13.1 4.6.Test-for-the-mean.Population-variance-unknown-exercise-solution.xlsx | 12.63 KB | ||
| 13.2 4.6. Test-for-the-mean.Population-variance-unknown-exercise.xlsx | 11.34 KB | ||
| 14. Test for the Mean. Dependent Samples.mp4 | 50.41 MB | ||
| 14. Test for the Mean. Dependent Samples.srt | 6.26 KB | ||
| 14.1 4.7. Test for the mean. Dependent samples_lesson.xlsx | 9.79 KB | ||
| 15. Test for the Mean. Dependent Samples Exercise.html | 82 B | ||
| 15.1 4.7. Test for the mean. Dependent samples_exercise_solution.xlsx | 14.4 KB | ||
| 15.2 4.7. Test for the mean. Dependent samples_exercise.xlsx | 12.8 KB | ||
| 16. Test for the mean. Independent samples (Part 1).mp4 | 29.97 MB | ||
| 16. Test for the mean. Independent samples (Part 1).srt | 5.51 KB | ||
| 16.1 4.8. Test for the mean. Independent samples (Part 1)_lesson.xlsx | 9.63 KB | ||
| 17. Test for the mean. Independent samples (Part 1). Exercise.html | 82 B | ||
| 17.1 4.8.Test-for-the-mean.Independent-samples-Part-1-exercise-solution.xlsx | 11.25 KB | ||
| 17.2 4.8.Test-for-the-mean.Independent-samples-Part-1-exercise.xlsx | 10.77 KB | ||
| 18. Test for the mean. Independent samples (Part 2).mp4 | 36.37 MB | ||
| 18. Test for the mean. Independent samples (Part 2).srt | 5.14 KB | ||
| 18.1 4.9. Test for the mean. Independent samples (Part 2)_lesson.xlsx | 9.31 KB | ||
| 19. Test for the mean. Independent samples (Part 2).html | 156 B | ||
| 2. Further Reading on Null and Alternative Hypothesis.html | 2.29 KB | ||
| 20. Test for the mean. Independent samples (Part 2).html | 82 B | ||
| 20.1 4.9.Test-for-the-mean.Independent-samples-Part-2-exercise-2.xlsx | 10.54 KB | ||
| 20.2 4.9.Test-for-the-mean.Independent-samples-Part-2-exercise-2-solution.xlsx | 11.39 KB | ||
| 3. The Null vs Alternative Hypothesis.html | 156 B | ||
| 4. Rejection Region and Significance Level.mp4 | 82.53 MB | ||
| 4. Rejection Region and Significance Level.srt | 8.69 KB | ||
| 4.1 Course notes_hypothesis_testing.pdf | 656.44 KB | ||
| 5. Rejection Region and Significance Level.html | 156 B | ||
| 6. Type I Error and Type II Error.mp4 | 43.96 MB | ||
| 6. Type I Error and Type II Error.srt | 5.67 KB | ||
| 7. Type I Error and Type II Error.html | 156 B | ||
| 8. Test for the Mean. Population Variance Known.mp4 | 54.27 MB | ||
| 8. Test for the Mean. Population Variance Known.srt | 8.14 KB | ||
| 8.1 4.4. Test for the mean. Population variance known_lesson.xlsx | 10.96 KB | ||
| 9. Test for the Mean. Population Variance Known Exercise.html | 82 B | ||
| 9.1 4.4. Test for the mean. Population variance known_exercise_solution.xlsx | 11.22 KB | ||
| 9.2 4.4. Test for the mean. Population variance known_exercise.xlsx | 11.03 KB | ||
| 16. Statistics - Practical Example Hypothesis Testing | |||
| 1. Practical Example Hypothesis Testing.mp4 | 69.38 MB | ||
| 1. Practical Example Hypothesis Testing.srt | 8.49 KB | ||
| 1.1 4.10.Hypothesis-testing-section-practical-example.xlsx | 51.71 KB | ||
| 2. Practical Example Hypothesis Testing Exercise.html | 82 B | ||
| 2.1 4.10.Hypothesis-testing-section-practical-example-exercise.xlsx | 43.38 KB | ||
| 2.2 4.10.Hypothesis-testing-section-practical-example-exercise-solution.xlsx | 44.04 KB | ||
| 17. Part 3 Relational Database Theory & Introduction to SQL | |||
| 1. Why use SQL.mp4 | 70.06 MB | ||
| 1. Why use SQL.srt | 4.58 KB | ||
| 10. Comparing Databases and Spreadsheets.html | 156 B | ||
| 11. Important Database Terminology.mp4 | 90.5 MB | ||
| 11. Important Database Terminology.srt | 6.01 KB | ||
| 12. Important Database Terminology.html | 156 B | ||
| 13. The Concept of Relational Schemas Primary Key.mp4 | 42.91 MB | ||
| 13. The Concept of Relational Schemas Primary Key.srt | 6.97 KB | ||
| 14. The Concept of Relational Schemas Primary Key.html | 156 B | ||
| 15. The Concept of Relational Schemas Foreign Key.mp4 | 43.96 MB | ||
| 15. The Concept of Relational Schemas Foreign Key.srt | 6.73 KB | ||
| 16. The Concept of Relational Schemas Foreign Key.html | 156 B | ||
| 17. The Concept of Relational Schemas Unique Key and Null Values.mp4 | 24.52 MB | ||
| 17. The Concept of Relational Schemas Unique Key and Null Values.srt | 4.38 KB | ||
| 18. The Concept of Relational Schemas Unique Key.html | 156 B | ||
| 19. The Concept of Relational Schemas Relationships Between Tables.mp4 | 41.67 MB | ||
| 19. The Concept of Relational Schemas Relationships Between Tables.srt | 6.18 KB | ||
| 2. Why use SQL.html | 156 B | ||
| 20. The Concept of Relational Schemas Relationships Between Tables.html | 156 B | ||
| 3. Why use MySQL.mp4 | 29.3 MB | ||
| 3. Why use MySQL.srt | 2.76 KB | ||
| 4. Why use MySQL.html | 156 B | ||
| 5. Introducing Databases.mp4 | 102.86 MB | ||
| 5. Introducing Databases.srt | 6.71 KB | ||
| 6. Introducing Databases.html | 156 B | ||
| 7. Relational Database Fundamentals.mp4 | 107.7 MB | ||
| 7. Relational Database Fundamentals.srt | 6.68 KB | ||
| 8. Relational Database Fundamentals.html | 156 B | ||
| 9. Comparing Databases and Spreadsheets.mp4 | 156.77 MB | ||
| 9. Comparing Databases and Spreadsheets.srt | 10.39 KB | ||
| 18. SQL - Install and get to know MySQL | |||
| 1. Installing MySQL Workbench and Server.mp4 | 99.1 MB | ||
| 1. Installing MySQL Workbench and Server.srt | 12.65 KB | ||
| 2. Installing Visual C.html | 818 B | ||
| 3. Installing MySQL on macOS and Unix systems.html | 2.64 KB | ||
| 4. The Client-Server Model.html | 30 B | ||
| 4.1 The Client-Server Model.pdf | 556.9 KB | ||
| 5. Linking GUI with the MySQL Server.mp4 | 19.23 MB | ||
| 5. Linking GUI with the MySQL Server.srt | 3.36 KB | ||
| 6. Read me!!!.html | 1 KB | ||
| 7. Creating a New User and a New Connection to it.mp4 | 47.7 MB | ||
| 7. Creating a New User and a New Connection to it.srt | 6.73 KB | ||
| 8. Familiarize Yourself with the MySQL Interface.mp4 | 40.25 MB | ||
| 8. Familiarize Yourself with the MySQL Interface.srt | 6.35 KB | ||
| 19. SQL - Best SQL Practices | |||
| 1. Coding Tips and Best Practices - I.mp4 | 37.83 MB | ||
| 1. Coding Tips and Best Practices - I.srt | 6.71 KB | ||
| 1.1 MySQL_Workbench_Shortcuts.pdf | 515.23 KB | ||
| 2. Coding Tips and Best Practices - I.html | 156 B | ||
| 3. Coding Tips and Best Practices - II.mp4 | 29.68 MB | ||
| 3. Coding Tips and Best Practices - II.srt | 4.95 KB | ||
| 4. Coding Tips and Best Practices - II.html | 156 B | ||
| 2. Intro to Data and Data Science - The Different Data Science Fields | |||
| 1. Why Are There So Many Business and Data Science Buzzwords.mp4 | 81.39 MB | ||
| 1. Why Are There So Many Business and Data Science Buzzwords.srt | 6.62 KB | ||
| 2. Analysis vs Analytics.mp4 | 53.5 MB | ||
| 2. Analysis vs Analytics.srt | 5.07 KB | ||
| 3. Intro to Business Analytics, Data Analytics, and Data Science.mp4 | 64.47 MB | ||
| 3. Intro to Business Analytics, Data Analytics, and Data Science.srt | 10.63 KB | ||
| 3.1 365_DataScience_Diagram.pdf | 323.08 KB | ||
| 4. Intro to Business Analytics, Data Analytics, and Data Science.html | 156 B | ||
| 5. Adding Business Intelligence (BI), Machine Learning (ML), and AI to the Picture.mp4 | 108.96 MB | ||
| 5. Adding Business Intelligence (BI), Machine Learning (ML), and AI to the Picture.srt | 11.87 KB | ||
| 5.1 365_DataScience_Diagram.pdf | 323.08 KB | ||
| 5.2 365_DataScience.png | 7.24 MB | ||
| 6. Adding Business Intelligence (BI), Machine Learning (ML), and AI to the Picture.html | 156 B | ||
| 7. An Overview of our Data Science Infographic.mp4 | 67.82 MB | ||
| 7. An Overview of our Data Science Infographic.srt | 5.1 KB | ||
| 7.1 365_DataScience.png | 7.23 MB | ||
| 8. An Overview of our Data Science Infographic.html | 156 B | ||
| 20. SQL - Loading the 'employees' Database | |||
| 1. Loading the 'employees' Database.mp4 | 18.99 MB | ||
| 1. Loading the 'employees' Database.srt | 2.72 KB | ||
| 1.1 employees_db.pdf | 178.82 KB | ||
| 2. Loading the 'employees' Database.html | 930 B | ||
| 2.1 The 'employees' database.html | 121 B | ||
| 2.2 employees_db.pdf | 178.82 KB | ||
| 21. SQL - Practical Application of the SQL SELECT Statement | |||
| 1. Using SELECT - FROM.mp4 | 35.93 MB | ||
| 1. Using SELECT - FROM.srt | 5.79 KB | ||
| 10. Using OR.mp4 | 33.22 MB | ||
| 10. Using OR.srt | 3.92 KB | ||
| 11. Using OR - Exercise.html | 85 B | ||
| 12. Using OR - Solution.html | 248 B | ||
| 13. Operator Precedence and Logical Order.mp4 | 32.07 MB | ||
| 13. Operator Precedence and Logical Order.srt | 4.35 KB | ||
| 14. Operator Precedence and Logical Order - Exercise.html | 92 B | ||
| 15. Operator Precedence and Logical Order - Solution.html | 265 B | ||
| 16. Using IN - NOT IN.mp4 | 32.12 MB | ||
| 16. Using IN - NOT IN.srt | 3.77 KB | ||
| 17. Using IN - NOT IN - Exercise 1.html | 140 B | ||
| 18. Using IN - NOT IN - Solution 1.html | 234 B | ||
| 19. Using IN - NOT IN - Exercise 2.html | 118 B | ||
| 2. Using SELECT - FROM - Exercise.html | 149 B | ||
| 20. Using IN - NOT IN - Solution 2.html | 245 B | ||
| 21. Using LIKE - NOT LIKE.mp4 | 36.09 MB | ||
| 21. Using LIKE - NOT LIKE.srt | 4.41 KB | ||
| 22. Using LIKE - NOT LIKE - Exercise.html | 427 B | ||
| 23. Using LIKE - NOT LIKE - Solution.html | 733 B | ||
| 24. Using Wildcard Characters.mp4 | 9.87 MB | ||
| 24. Using Wildcard Characters.srt | 2.43 KB | ||
| 25. Using Wildcard characters - Exercise.html | 219 B | ||
| 26. Using Wildcard characters - Solution.html | 462 B | ||
| 27. Using BETWEEN - AND.mp4 | 16.46 MB | ||
| 27. Using BETWEEN - AND.srt | 2.38 KB | ||
| 28. Using BETWEEN - AND - Exercise.html | 335 B | ||
| 29. Using BETWEEN - AND - Solution.html | 1013 B | ||
| 3. Using SELECT - FROM - Solution.html | 314 B | ||
| 30. Using IS NOT NULL - IS NULL.mp4 | 13.95 MB | ||
| 30. Using IS NOT NULL - IS NULL.srt | 1.95 KB | ||
| 31. Using IS NOT NULL - IS NULL - Exercise.html | 85 B | ||
| 32. Using IS NOT NULL - IS NULL - Solution.html | 230 B | ||
| 33. Using Other Comparison Operators.mp4 | 41.22 MB | ||
| 33. Using Other Comparison Operators.srt | 5.11 KB | ||
| 34. Using Other Comparison Operators - Exercise.html | 269 B | ||
| 35. Using Other Comparison Operators - Solution.html | 507 B | ||
| 36. Using SELECT DISTINCT.mp4 | 15.63 MB | ||
| 36. Using SELECT DISTINCT.srt | 2.6 KB | ||
| 37. Using SELECT DISTINCT - Exercise.html | 355 B | ||
| 38. Using SELECT DISTINCT - Solution.html | 154 B | ||
| 39. Getting to Know Aggregate Functions.mp4 | 43.61 MB | ||
| 39. Getting to Know Aggregate Functions.srt | 6.65 KB | ||
| 4. Using WHERE.mp4 | 21.97 MB | ||
| 4. Using WHERE.srt | 3.01 KB | ||
| 40. Getting to Know Aggregate Functions - Exercise.html | 262 B | ||
| 41. Getting to Know Aggregate Functions - Solution.html | 375 B | ||
| 42. Using ORDER BY.mp4 | 41.29 MB | ||
| 42. Using ORDER BY.srt | 4.12 KB | ||
| 43. Using ORDER BY - Exercise.html | 106 B | ||
| 44. Using ORDER BY - Solution.html | 186 B | ||
| 45. Using GROUP BY.mp4 | 53.56 MB | ||
| 45. Using GROUP BY.srt | 6.88 KB | ||
| 46. Using Aliases (AS).mp4 | 21.28 MB | ||
| 46. Using Aliases (AS).srt | 2.69 KB | ||
| 47. Using Aliases (AS) - Exercise.html | 303 B | ||
| 48. Using Aliases (AS) - Solution.html | 344 B | ||
| 49. Using HAVING.mp4 | 33.03 MB | ||
| 49. Using HAVING.srt | 4.05 KB | ||
| 5. Using WHERE - Exercise.html | 93 B | ||
| 50. Using HAVING - Exercise.html | 814 B | ||
| 51. Using HAVING - Solution.html | 629 B | ||
| 52. Using WHERE vs HAVING - Part I.mp4 | 34.88 MB | ||
| 52. Using WHERE vs HAVING - Part I.srt | 4.83 KB | ||
| 53. Using WHERE vs HAVING - Part II.mp4 | 24.82 MB | ||
| 53. Using WHERE vs HAVING - Part II.srt | 3.97 KB | ||
| 54. Using WHERE vs HAVING - Part II - Exercise.html | 199 B | ||
| 55. Using WHERE vs HAVING - Part II - Solution.html | 370 B | ||
| 56. Using LIMIT.mp4 | 47.25 MB | ||
| 56. Using LIMIT.srt | 5.87 KB | ||
| 57. Using LIMIT - Exercise.html | 65 B | ||
| 58. Using LIMIT - Solution.html | 171 B | ||
| 6. Using WHERE - Solution.html | 221 B | ||
| 7. Using AND.mp4 | 16.73 MB | ||
| 7. Using AND.srt | 2.52 KB | ||
| 8. Using AND - Exercise.html | 78 B | ||
| 9. Using AND - Solution.html | 241 B | ||
| 22. SQL - Expanding on MySQL Aggregate Functions | |||
| 1. Applying COUNT().mp4 | 27.38 MB | ||
| 1. Applying COUNT().srt | 4.95 KB | ||
| 10. Applying AVG().mp4 | 13.52 MB | ||
| 10. Applying AVG().srt | 2.52 KB | ||
| 11. Applying AVG() - Exercise.html | 102 B | ||
| 12. Applying AVG() - Solution.html | 237 B | ||
| 13. Rounding Numbers with ROUND().mp4 | 16.8 MB | ||
| 13. Rounding Numbers with ROUND().srt | 2.62 KB | ||
| 14. Rounding Numbers with ROUND() - Exercise.html | 145 B | ||
| 15. Rounding Numbers with ROUND() - Solution.html | 247 B | ||
| 2. Applying COUNT() - Exercise.html | 123 B | ||
| 3. Applying COUNT() - Solution.html | 158 B | ||
| 4. Applying SUM().mp4 | 10.52 MB | ||
| 4. Applying SUM().srt | 1.86 KB | ||
| 5. Applying SUM() - Exercise.html | 117 B | ||
| 6. Applying SUM() - Solution.html | 237 B | ||
| 7. MIN() and MAX().mp4 | 10.28 MB | ||
| 7. MIN() and MAX().srt | 1.53 KB | ||
| 8. MIN() and MAX() - Exercise.html | 128 B | ||
| 9. MIN() and MAX() - Solution.html | 352 B | ||
| 23. SQL - SQL JOINs | |||
| 1. What are JOINs.mp4 | 42.19 MB | ||
| 1. What are JOINs.srt | 5.11 KB | ||
| 10. The Functionality of LEFT JOIN - Part I.mp4 | 50.81 MB | ||
| 10. The Functionality of LEFT JOIN - Part I.srt | 5.72 KB | ||
| 11. The Functionality of LEFT JOIN - Part II.mp4 | 54.87 MB | ||
| 11. The Functionality of LEFT JOIN - Part II.srt | 6.87 KB | ||
| 12. The Functionality of LEFT JOIN - Part II - Exercise.html | 441 B | ||
| 13. The Functionality of LEFT JOIN - Part II - Solution.html | 599 B | ||
| 14. The Functionality of RIGHT JOIN.mp4 | 32.22 MB | ||
| 14. The Functionality of RIGHT JOIN.srt | 32.23 MB | ||
| 15. Differences between the New and the Old Join Syntax.mp4 | 32 MB | ||
| 15. Differences between the New and the Old Join Syntax.srt | 32.02 MB | ||
| 16. Differences between the New and the Old Join Syntax - Exercise.html | 192 B | ||
| 17. Differences between the New and the Old Join Syntax - Solution.html | 942 B | ||
| 18. Using JOIN and WHERE Together.mp4 | 25.18 MB | ||
| 18. Using JOIN and WHERE Together.srt | 3.47 KB | ||
| 19. Important – Prevent Error Code 1055!.html | 3.17 KB | ||
| 2. What are JOINs - Exercise 1.html | 1.26 KB | ||
| 20. Using JOIN and WHERE Together - Exercise.html | 165 B | ||
| 21. Using JOIN and WHERE Together - Solution.html | 525 B | ||
| 22. The Functionality of CROSS JOIN.mp4 | 89.87 MB | ||
| 22. The Functionality of CROSS JOIN.srt | 9.89 KB | ||
| 23. The Functionality of CROSS JOIN - Exercise 1.html | 150 B | ||
| 24. The Functionality of CROSS JOIN - Solution 1.html | 407 B | ||
| 25. The Functionality of CROSS JOIN - Exercise 2.html | 162 B | ||
| 26. The Functionality of CROSS JOIN - Solution 2.html | 413 B | ||
| 27. Combining Aggregate Functions with Joins.mp4 | 22.14 MB | ||
| 27. Combining Aggregate Functions with Joins.srt | 2.83 KB | ||
| 28. JOIN More than Two Tables.mp4 | 41.44 MB | ||
| 28. JOIN More than Two Tables.srt | 4.83 KB | ||
| 29. JOIN More than Two Tables - Exercise.html | 105 B | ||
| 3. What are JOINs - Exercise 2.html | 1.36 KB | ||
| 30. JOIN More than Two Tables - Solution.html | 1.72 KB | ||
| 31. Top Tips for Joins.mp4 | 50.91 MB | ||
| 31. Top Tips for Joins.srt | 6.84 KB | ||
| 32. Top Tips for Joins - Exercise.html | 93 B | ||
| 33. Top Tips for Joins - Solution.html | 322 B | ||
| 34. The Differences Between UNION and UNION ALL.mp4 | 47.69 MB | ||
| 34. The Differences Between UNION and UNION ALL.srt | 6.42 KB | ||
| 35. The Differences Between UNION and UNION ALL - Exercise.html | 167 B | ||
| 36. The Differences Between UNION and UNION ALL - Solution.html | 1.07 KB | ||
| 4. The Functionality of INNER JOIN - Part I.mp4 | 42.29 MB | ||
| 4. The Functionality of INNER JOIN - Part I.srt | 6.78 KB | ||
| 5. The Functionality of INNER JOIN - Part II.mp4 | 67.09 MB | ||
| 5. The Functionality of INNER JOIN - Part II.srt | 6.6 KB | ||
| 6. The Functionality of INNER JOIN - PART II - Exercise.html | 140 B | ||
| 7. The Functionality of INNER JOIN - PART II - Solution.html | 443 B | ||
| 8. Extra Info on Using Joins.mp4 | 43.89 MB | ||
| 8. Extra Info on Using Joins.srt | 5 KB | ||
| 9. Duplicate Rows.mp4 | 46.53 MB | ||
| 9. Duplicate Rows.srt | 5.13 KB | ||
| 24. SQL - SQL Subqueries | |||
| 1. SQL Subqueries with IN Embedded Inside WHERE.mp4 | 37.45 MB | ||
| 1. SQL Subqueries with IN Embedded Inside WHERE.srt | 5.03 KB | ||
| 10. SQL Subqueries Nested in SELECT and FROM - Solution 2.html | 15 B | ||
| 10.1 Subqueries SELECT FROM Solution.sql | 1.85 KB | ||
| 2. SQL Subqueries with IN Embedded Inside WHERE - Exercise.html | 138 B | ||
| 3. SQL Subqueries with IN Embedded Inside WHERE - Solution.html | 522 B | ||
| 4. SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE.mp4 | 29.78 MB | ||
| 4. SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE.srt | 4.16 KB | ||
| 5. SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE - Exercise.html | 175 B | ||
| 6. SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE - Solution.html | 573 B | ||
| 7. SQL Subqueries Nested in SELECT and FROM.mp4 | 71.66 MB | ||
| 7. SQL Subqueries Nested in SELECT and FROM.srt | 8.58 KB | ||
| 8. SQL Subqueries Embedded in SELECT and FROM - Exercise 1.html | 402 B | ||
| 9. SQL Subqueries Embedded in SELECT and FROM - Exercise 2.html | 1.02 KB | ||
| 25. SQL - Stored Routines | |||
| 1. Defining Stored Routines.mp4 | 29.93 MB | ||
| 1. Defining Stored Routines.srt | 4.41 KB | ||
| 10. Create Stored Procedures with an Output Parameter.mp4 | 32.51 MB | ||
| 10. Create Stored Procedures with an Output Parameter.srt | 4.07 KB | ||
| 11. Create Stored Procedures with an Output Parameter - Exercise.html | 152 B | ||
| 12. Stored Procedures with an Output Parameter - Solution.html | 931 B | ||
| 13. SQL Variables.mp4 | 54.57 MB | ||
| 13. SQL Variables.srt | 7.39 KB | ||
| 14. SQL Variables - Exercise.html | 299 B | ||
| 15. SQL Variables - Solution.html | 156 B | ||
| 16. The Benefit of User-Defined Functions in MySQL.mp4 | 48.75 MB | ||
| 16. The Benefit of User-Defined Functions in MySQL.srt | 7.32 KB | ||
| 17. Error Code 1418..html | 2.84 KB | ||
| 18. The Benefit of User-Defined Functions in MySQL - Exercise.html | 432 B | ||
| 19. The Benefit of User-Defined Functions in MySQL - Solution.html | 1.57 KB | ||
| 2. Defining Stored Routines.html | 156 B | ||
| 20. Concluding Stored Routines.mp4 | 27.14 MB | ||
| 20. Concluding Stored Routines.srt | 4.69 KB | ||
| 21. Concluding Stored Routines.html | 156 B | ||
| 3. Create Stored Procedures with MySQL Syntax.mp4 | 34.25 MB | ||
| 3. Create Stored Procedures with MySQL Syntax.srt | 5.73 KB | ||
| 4. An Example of Stored Procedures Part I.mp4 | 23.96 MB | ||
| 4. An Example of Stored Procedures Part I.srt | 3.31 KB | ||
| 5. An Example of Stored Procedures Part II.mp4 | 42.14 MB | ||
| 5. An Example of Stored Procedures Part II.srt | 6.14 KB | ||
| 6. An Example of Stored Procedures Part II - Exercise.html | 114 B | ||
| 7. An Example of Stored Procedures Part II - Solution.html | 704 B | ||
| 8. Creating a Procedure in MySQL Another Way.mp4 | 32.44 MB | ||
| 8. Creating a Procedure in MySQL Another Way.srt | 3.59 KB | ||
| 9. Create Stored Procedures with an Input Parameter.mp4 | 64.5 MB | ||
| 9. Create Stored Procedures with an Input Parameter.srt | 7.55 KB | ||
| 26. SQL - The CASE Statement | |||
| 1. The SQL CASE Statement.mp4 | 59.43 MB | ||
| 1. The SQL CASE Statement.srt | 6.86 KB | ||
| 2. The SQL CASE Statement - Exercise 1.html | 362 B | ||
| 3. THE SQL CASE Statement - Solution 1.html | 720 B | ||
| 4. THE SQL CASE Statement - Exercise 2.html | 376 B | ||
| 5. THE SQL CASE Statement - Solution 2.html | 1.76 KB | ||
| 6. THE SQL CASE Statement - Exercise 3.html | 411 B | ||
| 7. THE SQL CASE Statement - Solution 3.html | 744 B | ||
| 27. Part 4 Introduction to Tableau | |||
| 1. Why Use Tableau Make Your Data Make an Impact.mp4 | 39.21 MB | ||
| 1. Why Use Tableau Make Your Data Make an Impact.srt | 4.76 KB | ||
| 2. Let's Download Tableau Public.mp4 | 28.38 MB | ||
| 2. Let's Download Tableau Public.srt | 2.21 KB | ||
| 3. Connecting Data in Tableau.mp4 | 14.28 MB | ||
| 3. Connecting Data in Tableau.srt | 2.57 KB | ||
| 3.1 GDP Data.xls | 155.5 KB | ||
| 4. Exploring Tableau's Interface.mp4 | 52.12 MB | ||
| 4. Exploring Tableau's Interface.srt | 10.78 KB | ||
| 4.1 GDP Data.xls | 155.5 KB | ||
| 5. Let's Create our first Chart in Tableau!.mp4 | 58.97 MB | ||
| 5. Let's Create our first Chart in Tableau!.srt | 7.85 KB | ||
| 5.1 GDP Data - Tableau Public Link.html | 144 B | ||
| 5.2 GDP Data.xls | 155.5 KB | ||
| 28. Tableau - Tableau functionalities | |||
| 1. Duplicating a Sheet.mp4 | 25.32 MB | ||
| 1. Duplicating a Sheet.srt | 3.24 KB | ||
| 1.1 GDP Data.xls | 155.5 KB | ||
| 2. Creating a Table.mp4 | 25.94 MB | ||
| 2. Creating a Table.srt | 6.11 KB | ||
| 2.1 Creating a table - Tableau Public Link.html | 151 B | ||
| 2.2 Tesla sales data.xlsx | 2.75 MB | ||
| 3. Creating Custom Fields.mp4 | 17.21 MB | ||
| 3. Creating Custom Fields.srt | 2.85 KB | ||
| 3.1 Tableau operators.pdf | 121.83 KB | ||
| 3.2 Tesla sales data.xlsx | 2.75 MB | ||
| 4. Creating a Custom Field and Adding Calculations to a Table.mp4 | 29.7 MB | ||
| 4. Creating a Custom Field and Adding Calculations to a Table.srt | 4.58 KB | ||
| 4.1 Creating a custom field - Tableau Public Link.html | 157 B | ||
| 4.2 Tesla sales data.xlsx | 2.75 MB | ||
| 5. Adding Totals and Subtotals.mp4 | 20.89 MB | ||
| 5. Adding Totals and Subtotals.srt | 2.03 KB | ||
| 5.1 Addint totals and subtotals - Tableau Public Link.html | 150 B | ||
| 5.2 Tesla sales data.xlsx | 2.75 MB | ||
| 6. Adding a Custom Calculation.mp4 | 36.48 MB | ||
| 6. Adding a Custom Calculation.srt | 3.78 KB | ||
| 6.1 Adding a custom calculation - Tableau Public Link.html | 154 B | ||
| 7. Inserting a Filter.mp4 | 27.62 MB | ||
| 7. Inserting a Filter.srt | 2.67 KB | ||
| 7.1 Inserting a filter - Tableau Public Link.html | 155 B | ||
| 8. Working with Joins in Tableau.mp4 | 45.12 MB | ||
| 8. Working with Joins in Tableau.srt | 5.32 KB | ||
| 8.1 13. Types of Joins.xlsx | 56.39 KB | ||
| 29. Tableau - The Tableau Exercise | |||
| 1. Introduction to the Exercise.mp4 | 28.48 MB | ||
| 1. Introduction to the Exercise.srt | 2.53 KB | ||
| 1.1 Audiobook reviews.xlsx | 266.85 KB | ||
| 1.2 Audiobook sales.xlsx | 1.87 MB | ||
| 10. Creating and Formatting a Dashboard.mp4 | 31.83 MB | ||
| 10. Creating and Formatting a Dashboard.srt | 5.29 KB | ||
| 10.1 Audiobook sales.xlsx | 1.87 MB | ||
| 10.2 Audiobook reviews.xlsx | 266.85 KB | ||
| 10.3 Creating a dashboard - Tableau Public Link.html | 151 B | ||
| 11. Adding Interactive Filters for Improved Analysis.mp4 | 31.65 MB | ||
| 11. Adding Interactive Filters for Improved Analysis.srt | 4.86 KB | ||
| 11.1 Adding a filter - Tableau Public Link.html | 155 B | ||
| 11.2 Audiobook reviews.xlsx | 266.85 KB | ||
| 11.3 Audiobook sales.xlsx | 1.87 MB | ||
| 12. Interactive Filters - fix.mp4 | 12.48 MB | ||
| 12. Interactive Filters - fix.srt | 1.94 KB | ||
| 2. Let's Create a Dashboard - Visualizing the Three Charts We Want to Create.mp4 | 23.46 MB | ||
| 2. Let's Create a Dashboard - Visualizing the Three Charts We Want to Create.srt | 2.3 KB | ||
| 3. Using Joins in Tableau.mp4 | 45.55 MB | ||
| 3. Using Joins in Tableau.srt | 7.02 KB | ||
| 3.1 Audiobook sales.xlsx | 1.87 MB | ||
| 3.2 Audiobook reviews.xlsx | 266.85 KB | ||
| 4. Performing a Numbers Check - Attempt #1.mp4 | 25.04 MB | ||
| 4. Performing a Numbers Check - Attempt #1.srt | 4.61 KB | ||
| 4.1 Audiobook reviews.xlsx | 266.85 KB | ||
| 4.2 Audiobook sales.xlsx | 1.87 MB | ||
| 4.3 Check the data - Tableau Public Link.html | 150 B | ||
| 5. Blending Data in Tableau.mp4 | 32.31 MB | ||
| 5. Blending Data in Tableau.srt | 6.51 KB | ||
| 5.1 Audiobook reviews.xlsx | 266.85 KB | ||
| 5.2 Check the data - Tableau Public Link.html | 143 B | ||
| 5.3 Audiobook sales.xlsx | 1.87 MB | ||
| 6. Performing a Numbers Check - Attempt #2.mp4 | 28.59 MB | ||
| 6. Performing a Numbers Check - Attempt #2.srt | 5.15 KB | ||
| 6.1 Check the data - Tableau Public Link.html | 143 B | ||
| 6.2 Audiobook reviews.xlsx | 266.85 KB | ||
| 6.3 Audiobook sales.xlsx | 1.87 MB | ||
| 7. First Chart.mp4 | 27.23 MB | ||
| 7. First Chart.srt | 4.75 KB | ||
| 7.1 Audiobook sales.xlsx | 1.87 MB | ||
| 7.2 First chart - Tableau Public Link.html | 148 B | ||
| 7.3 Audiobook reviews.xlsx | 266.85 KB | ||
| 8. Second Chart.mp4 | 17.07 MB | ||
| 8. Second Chart.srt | 3.86 KB | ||
| 8.1 Audiobook sales.xlsx | 1.87 MB | ||
| 8.2 Audiobook reviews.xlsx | 266.85 KB | ||
| 8.3 Second chart - Tableau Public Link.html | 149 B | ||
| 9. Third Chart.mp4 | 15.25 MB | ||
| 9. Third Chart.srt | 3.3 KB | ||
| 9.1 Audiobook sales.xlsx | 1.87 MB | ||
| 9.2 Audiobook reviews.xlsx | 266.85 KB | ||
| 9.3 Third chart - Tableau Public Link.html | 148 B | ||
| 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 | 126.75 MB | ||
| 1. When are Traditional data, Big Data, BI, Traditional Data Science and ML applied.srt | 8.99 KB | ||
| 1.1 365_DataScience.png | 7.23 MB | ||
| 2. When are Traditional data, Big Data, BI, Traditional Data Science and ML applied.html | 156 B | ||
| 30. Part 5 Combining SQL and Tableau - Introduction | |||
| 1. Introduction to Software Integration.mp4 | 92.71 MB | ||
| 1. Introduction to Software Integration.srt | 7.08 KB | ||
| 2. Combining SQL and Tableau.mp4 | 83.91 MB | ||
| 2. Combining SQL and Tableau.srt | 6.23 KB | ||
| 3. Loading the Database.mp4 | 28.87 MB | ||
| 3. Loading the Database.srt | 4 KB | ||
| 4. Loading the Database.html | 621 B | ||
| 4.1 employees_mod_db.pdf | 129.65 KB | ||
| 4.2 The 'employees_mod' database.html | 125 B | ||
| 31. Combining SQL and Tableau - Problem 1 | |||
| 1. Problem 1 Task.mp4 | 33.81 MB | ||
| 1. Problem 1 Task.srt | 7.13 KB | ||
| 1.1 employees_mod_db.pdf | 129.65 KB | ||
| 2. Problem 1 Task - Text.html | 149 B | ||
| 3. Important clarification!.html | 1.37 KB | ||
| 4. Problem 1 Solution in SQL.mp4 | 43.18 MB | ||
| 4. Problem 1 Solution in SQL.srt | 5.62 KB | ||
| 5. Problem 1 Solution in SQL - Code.html | 370 B | ||
| 6. Exporting Your Output from SQL and Loading it in Tableau.mp4 | 31.55 MB | ||
| 6. Exporting Your Output from SQL and Loading it in Tableau.srt | 5.05 KB | ||
| 7. Chart 1 Visualizing the Solution in Tableau - Part I.mp4 | 41.15 MB | ||
| 7. Chart 1 Visualizing the Solution in Tableau - Part I.srt | 7.46 KB | ||
| 8. Chart 1 Visualizing the Solution in Tableau - Part II.mp4 | 45.58 MB | ||
| 8. Chart 1 Visualizing the Solution in Tableau - Part II.srt | 6.8 KB | ||
| 32. Combining SQL and Tableau - Problem 2 | |||
| 1. Problem 2 Task.mp4 | 29.02 MB | ||
| 1. Problem 2 Task.srt | 4.64 KB | ||
| 2. Problem 2 Task - Text.html | 162 B | ||
| 3. Problem 2 Solution in SQL.mp4 | 39.65 MB | ||
| 3. Problem 2 Solution in SQL.srt | 4.28 KB | ||
| 4. Problem 2 Solution in SQL - Code.html | 740 B | ||
| 5. Chart 2 Visualizing the Solution in Tableau.mp4 | 49.36 MB | ||
| 5. Chart 2 Visualizing the Solution in Tableau.srt | 7.33 KB | ||
| 33. Combining SQL and Tableau - Problem 3 | |||
| 1. Problem 3 Task.mp4 | 13.3 MB | ||
| 1. Problem 3 Task.srt | 2.84 KB | ||
| 2. Problem 3 Task - Text.html | 167 B | ||
| 3. Problem 3 Solution in SQL.mp4 | 33.26 MB | ||
| 3. Problem 3 Solution in SQL.srt | 3.88 KB | ||
| 4. Problem 3 Solution in SQL - Code.html | 502 B | ||
| 5. Chart 3 Visualizing the Solution in Tableau.mp4 | 40.5 MB | ||
| 5. Chart 3 Visualizing the Solution in Tableau.srt | 5.81 KB | ||
| 34. Combining SQL and Tableau - Problem 4 | |||
| 1. Problem 4 Task.mp4 | 23.75 MB | ||
| 1. Problem 4 Task.srt | 3.6 KB | ||
| 2. Problem 4 Task - Text.html | 325 B | ||
| 3. Problem 4 Solution in SQL.mp4 | 30.34 MB | ||
| 3. Problem 4 Solution in SQL.srt | 3.14 KB | ||
| 4. Problem 4 Solution in SQL - Code.html | 697 B | ||
| 5. Chart 4 Visualizing the Solution in Tableau.mp4 | 22.72 MB | ||
| 5. Chart 4 Visualizing the Solution in Tableau.srt | 3.78 KB | ||
| 35. Combining SQL and Tableau - Problem 5 | |||
| 1. Problem 5 Organizing Charts 1-4 into a Beautiful Dashboard.mp4 | 56.2 MB | ||
| 1. Problem 5 Organizing Charts 1-4 into a Beautiful Dashboard.srt | 6.69 KB | ||
| 36. Part 6 Introduction to Programming with Python | |||
| 1. A 5-minute explanation of Programming.mp4 | 58.53 MB | ||
| 1. A 5-minute explanation of Programming.srt | 6.9 KB | ||
| 10. Understanding Jupyter's Interface.html | 156 B | ||
| 11. Python 2 vs Python 3.mp4 | 11.28 MB | ||
| 11. Python 2 vs Python 3.srt | 3.31 KB | ||
| 11.1 Python Introduction - Course Notes.pdf | 2.03 MB | ||
| 2. A 5-minute explanation of Programming.html | 156 B | ||
| 3. Why use Python.mp4 | 75.08 MB | ||
| 3. Why use Python.srt | 6.96 KB | ||
| 4. Why Use Python.html | 156 B | ||
| 5. Why use Jupyter.mp4 | 44.3 MB | ||
| 5. Why use Jupyter.srt | 4.64 KB | ||
| 6. Why Use Jupyter.html | 156 B | ||
| 7. How to Install Python and Jupyter.mp4 | 51.01 MB | ||
| 7. How to Install Python and Jupyter.srt | 8.84 KB | ||
| 8. Understanding Jupyter’s Interface – Dashboard.mp4 | 13.79 MB | ||
| 8. Understanding Jupyter’s Interface – Dashboard.srt | 3.73 KB | ||
| 9. Understanding Jupyter’s Interface – Prerequisites for Coding.mp4 | 30.59 MB | ||
| 9. Understanding Jupyter’s Interface – Prerequisites for Coding.srt | 7.79 KB | ||
| 9.1 Jupyter_Shortcuts.pdf | 589.59 KB | ||
| 37. Python - Python Variables and Data Types | |||
| 1. Python Variables.mp4 | 25.3 MB | ||
| 1. Python Variables.srt | 6.05 KB | ||
| 1.1 Variables - Lecture_Py3.ipynb | 3.61 KB | ||
| 1.2 Variables - Exercise_Py3.ipynb | 2.23 KB | ||
| 1.3 Python Introduction - Course Notes.pdf | 2.03 MB | ||
| 1.4 Variables - Solution_Py3.ipynb | 3.79 KB | ||
| 2. Python Variables.html | 156 B | ||
| 3. Understanding Numbers and Boolean Values.mp4 | 17.06 MB | ||
| 3. Understanding Numbers and Boolean Values.srt | 3.68 KB | ||
| 3.1 Numbers and Boolean Values - Solution_Py3.ipynb | 3.23 KB | ||
| 3.2 Numbers and Boolean Values - Lecture_Py3.ipynb | 3.36 KB | ||
| 3.3 Numbers and Boolean Values - Exercise_Py3.ipynb | 2.29 KB | ||
| 4. Understanding Numbers and Boolean Values.html | 156 B | ||
| 5. Strings.mp4 | 50.65 MB | ||
| 5. Strings.srt | 14.55 KB | ||
| 5.1 Strings - Solution_Py3.ipynb | 5.45 KB | ||
| 5.2 Strings - Lecture_Py3.ipynb | 7.56 KB | ||
| 5.3 Strings - Exercise_Py3.ipynb | 2.61 KB | ||
| 6. Strings.html | 156 B | ||
| 38. Python - Python Syntax Fundamentals | |||
| 1. The Arithmetic Operators of Python.mp4 | 18.92 MB | ||
| 1. The Arithmetic Operators of Python.srt | 4.11 KB | ||
| 1.1 Arithmetic Operators - Exercise_Py3.ipynb | 2.62 KB | ||
| 1.2 Arithmetic Operators - Lecture_Py3.ipynb | 3.53 KB | ||
| 1.3 Arithmetic Operators - Solution_Py3.ipynb | 4.24 KB | ||
| 10. How to Index Elements.mp4 | 5.93 MB | ||
| 10. How to Index Elements.srt | 1.7 KB | ||
| 10.1 Indexing Elements - Lecture_Py3.ipynb | 1.32 KB | ||
| 10.2 Indexing Elements - Solution_Py3.ipynb | 2.17 KB | ||
| 10.3 Indexing Elements - Exercise_Py3.ipynb | 1.35 KB | ||
| 11. How to Index Elements.html | 156 B | ||
| 12. How to Structure Your Code with Indentation.mp4 | 13.15 MB | ||
| 12. How to Structure Your Code with Indentation.srt | 4.68 KB | ||
| 12.1 Structure Your Code with Indentation - Lecture_Py3.ipynb | 958 B | ||
| 12.2 Structure Your Code with Indentation - Exercise_Py3.ipynb | 956 B | ||
| 12.3 Structure Your Code with Indentation - Solution_Py3.ipynb | 1.5 KB | ||
| 13. How to Structure Your Code with Indentation.html | 156 B | ||
| 2. Using Arithmetic Operators in Python.html | 156 B | ||
| 3. What is the Double Equality Sign.mp4 | 5.99 MB | ||
| 3. What is the Double Equality Sign.srt | 1.82 KB | ||
| 3.1 The Double Equality Sign - Lecture_Py3.ipynb | 1.45 KB | ||
| 3.2 The Double Equality Sign - Exercise_Py3.ipynb | 838 B | ||
| 3.3 The Double Equality Sign - Solution_Py3.ipynb | 1.14 KB | ||
| 4. What is the Double Equality Sign.html | 156 B | ||
| 5. How to Reassign Values.mp4 | 4 MB | ||
| 5. How to Reassign Values.srt | 1.29 KB | ||
| 5.1 Reassign Values - Lecture_Py3.ipynb | 3.08 KB | ||
| 5.2 Reassign Values - Exercise_Py3.ipynb | 1.67 KB | ||
| 5.3 Reassign Values - Solution_Py3.ipynb | 2.12 KB | ||
| 6. How to Reassign Values.html | 156 B | ||
| 7. How to Add Comments.mp4 | 11.26 MB | ||
| 7. How to Add Comments.srt | 3.87 KB | ||
| 7.1 Add Comments - Lecture_Py3.ipynb | 1.03 KB | ||
| 8. How to Add Comments.html | 156 B | ||
| 9. Understanding Line Continuation.mp4 | 2.35 MB | ||
| 9. Understanding Line Continuation.srt | 1.13 KB | ||
| 9.1 Line Continuation - Solution_Py3.ipynb | 1.5 KB | ||
| 9.2 Line Continuation - Exercise_Py3.ipynb | 1.14 KB | ||
| 9.3 Line Continuation - Lecture_Py3.ipynb | 779 B | ||
| 39. Python - Other Python Operators | |||
| 1. Python's Comparison Operators.mp4 | 10.18 MB | ||
| 1. Python's Comparison Operators.srt | 2.47 KB | ||
| 1.1 Comparison Operators - Lecture_Py3.ipynb | 2.53 KB | ||
| 1.2 Comparison Operators - Solution_Py3.ipynb | 2.41 KB | ||
| 1.3 Comparison Operators - Exercise_Py3.ipynb | 1.61 KB | ||
| 2. Python's Comparison Operators.html | 156 B | ||
| 3. Python's Logical and Identity Operators.mp4 | 30.06 MB | ||
| 3. Python's Logical and Identity Operators.srt | 5.77 KB | ||
| 3.1 Logical and Identity Operators - Solution_Py3.ipynb | 3.43 KB | ||
| 3.2 Logical and Identity Operators - Exercise_Py3.ipynb | 2.41 KB | ||
| 3.3 Logical and Identity Operators - Lecture_Py3.ipynb | 5.86 KB | ||
| 4. Python's Logical and Identity Operators.html | 156 B | ||
| 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 | 87.45 MB | ||
| 1. Why do we Need each of these Disciplines.srt | 6.5 KB | ||
| 2. Why do we Need each of these Disciplines.html | 156 B | ||
| 40. Python - Conditional Statements | |||
| 1. Getting to know the IF Statement.mp4 | 23.24 MB | ||
| 1. Getting to know the IF Statement.srt | 7.6 KB | ||
| 1.1 Introduction to the If Statement - Exercise_Py3.ipynb | 1.53 KB | ||
| 1.2 Introduction to the If Statement - Lecture_Py3.ipynb | 1.14 KB | ||
| 1.3 Introduction to the If Statement - Solution_Py3.ipynb | 2.19 KB | ||
| 2. Getting to know the IF Statement.html | 156 B | ||
| 3. Adding an ELSE statement.mp4 | 23.28 MB | ||
| 3. Adding an ELSE statement.srt | 6.28 KB | ||
| 3.1 Add an Else Statement - Exercise_Py3.ipynb | 1.02 KB | ||
| 3.2 Add an Else Statement - Solution_Py3.ipynb | 1.4 KB | ||
| 3.3 Add an Else Statement - Lecture_Py3.ipynb | 1.76 KB | ||
| 4. Else if, for Brief – ELIF.mp4 | 53.35 MB | ||
| 4. Else if, for Brief – ELIF.srt | 13.19 KB | ||
| 4.1 Else If, for Brief - Elif - Solution_Py3.ipynb | 2.4 KB | ||
| 4.2 Else If, for Brief - Elif - Exercise_Py3.ipynb | 1.75 KB | ||
| 4.3 Else If, for Brief - Elif - Lecture_Py3.ipynb | 3.24 KB | ||
| 5. An Additional Explanation of Boolean Values.mp4 | 19.99 MB | ||
| 5. An Additional Explanation of Boolean Values.srt | 6.21 KB | ||
| 5.1 A Note on Boolean Values - Lecture_Py3.ipynb | 791 B | ||
| 6. An Additional Explanation of Boolean Values.html | 156 B | ||
| 41. Python - Functions | |||
| 1. How to Define a Function in Python.mp4 | 14.75 MB | ||
| 1. How to Define a Function in Python.srt | 5.32 KB | ||
| 1.1 Defining a Function in Python - Lecture_Py3.ipynb | 868 B | ||
| 2. How to Create a Function with a Parameter.mp4 | 38.09 MB | ||
| 2. How to Create a Function with a Parameter.srt | 8.98 KB | ||
| 2.1 Creating a Function with a Parameter - Solution_Py3.ipynb | 1.79 KB | ||
| 2.2 Creating a Function with a Parameter - Exercise_Py3.ipynb | 1.16 KB | ||
| 2.3 Creating a Function with a Parameter - Lecture_Py3.ipynb | 1.59 KB | ||
| 3. Define a Function in Another Way.mp4 | 25.24 MB | ||
| 3. Define a Function in Another Way.srt | 6.42 KB | ||
| 3.1 Another Way to Define a Function - Solution_Py3.ipynb | 1.98 KB | ||
| 3.2 Another Way to Define a Function - Exercise_Py3.ipynb | 1.24 KB | ||
| 3.3 Another Way to Define a Function - Lecture_Py3.ipynb | 3.29 KB | ||
| 4. How to use a Function within a Function.mp4 | 8.13 MB | ||
| 4. How to use a Function within a Function.srt | 2.03 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 | 1015 B | ||
| 4.3 Using a Function in another Function - Exercise_Py3.ipynb | 1.04 KB | ||
| 5. Use Conditional Statements and Functions Together.mp4 | 15.69 MB | ||
| 5. Use Conditional Statements and Functions Together.srt | 3.51 KB | ||
| 5.1 Combining Conditional Statements and Functions - Solution_Py3.ipynb | 1.65 KB | ||
| 5.2 Combining Conditional Statements and Functions - Exercise_Py3.ipynb | 1.06 KB | ||
| 5.3 Combining Conditional Statements and Functions - Lecture_Py3.ipynb | 1.29 KB | ||
| 6. How to Create Functions Which Contain a Few Arguments.mp4 | 14.71 MB | ||
| 6. How to Create Functions Which Contain a Few Arguments.srt | 3 KB | ||
| 6.1 Creating Functions Containing a Few Arguments - Lecture_Py3.ipynb | 1.72 KB | ||
| 7. Built-In Functions in Python Worth Knowing.mp4 | 22.02 MB | ||
| 7. Built-In Functions in Python Worth Knowing.srt | 4.21 KB | ||
| 7.1 Notable Built-In Functions in Python - Lecture_Py3.ipynb | 4.51 KB | ||
| 7.2 Notable Built-In Functions in Python - Solution_Py3.ipynb | 5.52 KB | ||
| 7.3 Notable Built-In Functions in Python - Exercise_Py3.ipynb | 3.66 KB | ||
| 8. Python - Functions.html | 156 B | ||
| 42. Python - Python Sequences | |||
| 1. Introduction to Lists.mp4 | 37.79 MB | ||
| 1. Introduction to Lists.srt | 9.83 KB | ||
| 1.1 Lists - Lecture_Py3.ipynb | 2.7 KB | ||
| 1.2 Lists - Exercise_Py3.ipynb | 2.14 KB | ||
| 1.3 Lists - Solution_Py3.ipynb | 3.18 KB | ||
| 2. Introduction to Lists.html | 156 B | ||
| 3. Using Methods in Python.mp4 | 37.61 MB | ||
| 3. Using Methods in Python.srt | 8.36 KB | ||
| 3.1 Help Yourself with Methods - Lecture_Py3.ipynb | 4.39 KB | ||
| 3.2 Help Yourself with Methods - Exercise_Py3.ipynb | 1.91 KB | ||
| 3.3 Help Yourself with Methods - Solution_Py3.ipynb | 12.83 KB | ||
| 4. Using Methods in Python.html | 156 B | ||
| 5. What is List Slicing.mp4 | 30.78 MB | ||
| 5. What is List Slicing.srt | 5.55 KB | ||
| 5.1 List Slicing - Exercise_Py3.ipynb | 2.79 KB | ||
| 5.2 List Slicing - Solution_Py3.ipynb | 4.26 KB | ||
| 5.3 List Slicing - Lecture_Py3.ipynb | 5.02 KB | ||
| 6. Working with Tuples.mp4 | 29.49 MB | ||
| 6. Working with Tuples.srt | 6.92 KB | ||
| 6.1 Tuples - Solution_Py3.ipynb | 4.61 KB | ||
| 6.2 Tuples - Lecture_Py3.ipynb | 2.91 KB | ||
| 6.3 Tuples - Exercise_Py3.ipynb | 2.07 KB | ||
| 7. Python Dictionaries.mp4 | 41.7 MB | ||
| 7. Python Dictionaries.srt | 8.43 KB | ||
| 7.1 Dictionaries - Exercise_Py3.ipynb | 2.92 KB | ||
| 7.2 Dictionaries - Solution_Py3.ipynb | 6.16 KB | ||
| 7.3 Dictionaries - Lecture_Py3.ipynb | 4.35 KB | ||
| 8. Python Dictionaries.html | 156 B | ||
| 43. Python - Using Iterations | |||
| 1. Using For Loops.mp4 | 23.59 MB | ||
| 1. Using For Loops.srt | 6.58 KB | ||
| 1.1 For Loops - Solution_Py3.ipynb | 1.8 KB | ||
| 1.2 For Loops - Exercise_Py3.ipynb | 1.28 KB | ||
| 1.3 For Loops - Lecture_Py3.ipynb | 1.26 KB | ||
| 2. For Loops.html | 156 B | ||
| 3. Using While Loops and Incrementing.mp4 | 28.43 MB | ||
| 3. Using While Loops and Incrementing.srt | 5.9 KB | ||
| 3.1 While Loops and Incrementing - Exercise_Py3.ipynb | 1.12 KB | ||
| 3.2 While Loops and Incrementing - Lecture_Py3.ipynb | 1.08 KB | ||
| 3.3 While Loops and Incrementing - Solution_Py3.ipynb | 1.75 KB | ||
| 4. Use the range() Function to Create Lists.mp4 | 25.79 MB | ||
| 4. Use the range() Function to Create Lists.srt | 7.66 KB | ||
| 4.1 Create Lists with the range() Function - Exercise_Py3.ipynb | 1.45 KB | ||
| 4.2 Create Lists with the range() Function - Solution_Py3.ipynb | 2.25 KB | ||
| 4.3 Create Lists with the range() Function - Lecture_Py3.ipynb | 1.34 KB | ||
| 5. Use the range() Function to Create Lists.html | 156 B | ||
| 6. Combine Conditional Statements and Loops.mp4 | 27.77 MB | ||
| 6. Combine Conditional Statements and Loops.srt | 7.46 KB | ||
| 6.1 Use Conditional Statements and Loops Together - Lecture_Py3.ipynb | 1.95 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 | 2.96 KB | ||
| 7. All In – Conditional Statements, Functions, and Loops.mp4 | 9.5 MB | ||
| 7. All In – Conditional Statements, Functions, and Loops.srt | 7.05 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.62 KB | ||
| 8. How to Iterate over Dictionaries.mp4 | 29.64 MB | ||
| 8. How to Iterate over Dictionaries.srt | 7.93 KB | ||
| 8.1 Iterating over Dictionaries - Exercise_Py3.ipynb | 2.19 KB | ||
| 8.2 Iterating over Dictionaries - Solution_Py3.ipynb | 2.87 KB | ||
| 8.3 Iterating over Dictionaries - Lecture_Py3.ipynb | 1.08 KB | ||
| 44. Python - Advanced Python tools | |||
| 1. Introduction to Object Oriented Programming (OOP).mp4 | 33.59 MB | ||
| 1. Introduction to Object Oriented Programming (OOP).srt | 6.1 KB | ||
| 2. Introduction to Object Oriented Programming (OOP).html | 156 B | ||
| 3. Using Modules and Packages.mp4 | 8.51 MB | ||
| 3. Using Modules and Packages.srt | 1.26 KB | ||
| 4. Using Modules and Packages.html | 156 B | ||
| 5. What is the Standard Library.mp4 | 18.04 MB | ||
| 5. What is the Standard Library.srt | 3.56 KB | ||
| 6. What is the Standard Library.html | 156 B | ||
| 7. How to Import Modules in Python.mp4 | 19.93 MB | ||
| 7. How to Import Modules in Python.srt | 4.81 KB | ||
| 8. How to Import Modules in Python.html | 156 B | ||
| 45. Part 7 Integration - Software Integration | |||
| 1. Getting Started with Data, Servers, Clients, Requests, and Responses.mp4 | 69.07 MB | ||
| 1. Getting Started with Data, Servers, Clients, Requests, and Responses.srt | 5.93 KB | ||
| 10. What is Software Integration and How is it Applied.html | 156 B | ||
| 2. Getting Started with Data, Servers, Clients, Requests, and Responses.html | 156 B | ||
| 3. Getting Started with Data Connectivity, APIs, and Endpoints.mp4 | 104.16 MB | ||
| 3. Getting Started with Data Connectivity, APIs, and Endpoints.srt | 8.54 KB | ||
| 4. Getting Started with Data Connectivity, APIs, and Endpoints.html | 156 B | ||
| 5. Become Better Acquainted with APIs.mp4 | 115.63 MB | ||
| 5. Become Better Acquainted with APIs.srt | 10.39 KB | ||
| 6. Become Better Acquainted with APIs.html | 156 B | ||
| 7. Communication through Text Files.mp4 | 60.33 MB | ||
| 7. Communication through Text Files.srt | 5.47 KB | ||
| 8. Communication through Text Files.html | 156 B | ||
| 9. What is Software Integration and How is it Applied.mp4 | 63.73 MB | ||
| 9. What is Software Integration and How is it Applied.srt | 6.71 KB | ||
| 46. Integration - What is contained in this Course | |||
| 1. Solving a Business Exercise with Python, SQL, and Tableau.mp4 | 52.31 MB | ||
| 1. Solving a Business Exercise with Python, SQL, and Tableau.srt | 5.46 KB | ||
| 2. Presenting the Task Absenteeism at Work.mp4 | 39.07 MB | ||
| 2. Presenting the Task Absenteeism at Work.srt | 3.74 KB | ||
| 3. Presenting the Data Set.mp4 | 40.88 MB | ||
| 3. Presenting the Data Set.srt | 4.15 KB | ||
| 4. Presenting the Data Set.html | 156 B | ||
| 47. Integration - Data Preprocessing Step by Step | |||
| 1. How is the Content in the Next Sections Organized.html | 2.44 KB | ||
| 1.1 data_preprocessing_homework.pdf | 134.47 KB | ||
| 1.2 df_preprocessed.csv | 29.11 KB | ||
| 1.3 Absenteeism_data.csv | 32.05 KB | ||
| 10. A Deeper Look at the 'Reasons for Absence' Column.mp4 | 40.56 MB | ||
| 10. A Deeper Look at the 'Reasons for Absence' Column.srt | 5.85 KB | ||
| 11. Splitting a Variable into Multiple Dummy Variables.mp4 | 81.14 MB | ||
| 11. Splitting a Variable into Multiple Dummy Variables.srt | 10.2 KB | ||
| 12. EXERCISE - Splitting a Variable into Multiple Dummy Variables.html | 129 B | ||
| 13. SOLUTION - Splitting a Variable into Multiple Dummy Variables.html | 116 B | ||
| 14. How to Drop a Dummy Variable from the Data Set.html | 2.34 KB | ||
| 15. A Statistical Perspective on Dummy Variables.mp4 | 13.76 MB | ||
| 15. A Statistical Perspective on Dummy Variables.srt | 1.7 KB | ||
| 16. Categorizing the Various Reasons for Absence.mp4 | 74.56 MB | ||
| 16. Categorizing the Various Reasons for Absence.srt | 10.02 KB | ||
| 17. Concatenation in Python.mp4 | 38.75 MB | ||
| 17. Concatenation in Python.srt | 5.07 KB | ||
| 18. EXERCISE - Concatenation in Python.html | 189 B | ||
| 19. SOLUTION - Concatenation in Python.html | 142 B | ||
| 2. How to Import the Data Set in Python.mp4 | 23.09 MB | ||
| 2. How to Import the Data Set in Python.srt | 3.99 KB | ||
| 20. How to Reorder Columns in a DataFrame in Python.mp4 | 14.05 MB | ||
| 20. How to Reorder Columns in a DataFrame in Python.srt | 1.82 KB | ||
| 21. EXERCISE - How to Reorder Columns in a DataFrame in Python.html | 167 B | ||
| 22. SOLUTION - How to Reorder Columns in a DataFrame in Python.html | 471 B | ||
| 23. Using Checkpoints to Ease Your Work in Jupyter.mp4 | 25.71 MB | ||
| 23. Using Checkpoints to Ease Your Work in Jupyter.srt | 3.64 KB | ||
| 23.1 Absenteeism Exercise - Preprocessing - df_reason_mod.ipynb | 4.82 KB | ||
| 24. EXERCISE - Using Checkpoints to Ease Your Work in Jupyter.html | 137 B | ||
| 25. SOLUTION - Using Checkpoints to Ease Your Work in Jupyter.html | 117 B | ||
| 26. Analyzing the Date Column.mp4 | 57.27 MB | ||
| 26. Analyzing the Date Column.srt | 8.43 KB | ||
| 27. Retrieving the Month Value From the Date Column.mp4 | 47.79 MB | ||
| 27. Retrieving the Month Value From the Date Column.srt | 7.97 KB | ||
| 28. Adding the Day of the Week Column.mp4 | 27.98 MB | ||
| 28. Adding the Day of the Week Column.srt | 4.47 KB | ||
| 29. EXERCISE - Dropping Columns.html | 1.21 KB | ||
| 29.1 Absenteeism Exercise - Preprocessing - ChP - df_date_reason_mod.ipynb | 7.33 KB | ||
| 29.2 Absenteeism Exercise - Removing the Date Column - SOLUTION.ipynb | 8.33 KB | ||
| 3. Exploring the Data Set.mp4 | 61.84 MB | ||
| 3. Exploring the Data Set.srt | 7.04 KB | ||
| 30. Analysis of the Next 5 Columns in DF.mp4 | 29.56 MB | ||
| 30. Analysis of the Next 5 Columns in DF.srt | 4.34 KB | ||
| 31. Dealing with More Numerical Features which may Behave like Categorical Ones.mp4 | 39.61 MB | ||
| 31. Dealing with More Numerical Features which may Behave like Categorical Ones.srt | 5.67 KB | ||
| 32. A Final Note on this Section.mp4 | 21.61 MB | ||
| 32. A Final Note on this Section.srt | 2.47 KB | ||
| 32.1 Absenteeism Exercise - EXERCISES and SOLUTIONS.ipynb | 4.13 KB | ||
| 32.2 Absenteeism Exercise - Preprocessing LECTURES.ipynb | 7.61 MB | ||
| 4. Programming vs the Rest of the World.mp4 | 27.83 MB | ||
| 4. Programming vs the Rest of the World.srt | 4.05 KB | ||
| 5. A Brief Summary of Regression Analysis.html | 2.84 KB | ||
| 6. The Approach we will Take to Solve this Exercise.mp4 | 20.16 MB | ||
| 6. The Approach we will Take to Solve this Exercise.srt | 2.8 KB | ||
| 7. Dropping Variables We Don't Need.mp4 | 61.69 MB | ||
| 7. Dropping Variables We Don't Need.srt | 7.81 KB | ||
| 8. EXERCISE - Dropping Variables We Don't Need.html | 866 B | ||
| 9. SOLUTION - Dropping Variables We Don't Need.html | 113 B | ||
| 48. Integration - Integrating Python and SQL | |||
| 1. How to Use the 'absenteeism_module' in Python - Part I.mp4 | 25.44 MB | ||
| 1. How to Use the 'absenteeism_module' in Python - Part I.srt | 4.76 KB | ||
| 1.1 Absenteeism Exercise - Integration.ipynb | 62.35 KB | ||
| 1.2 model.original | 1.01 KB | ||
| 1.3 absenteeism_module.py | 6.62 KB | ||
| 1.4 Absenteeism_new_data.csv | 1.87 KB | ||
| 1.5 scaler.original | 1.86 KB | ||
| 10. Sending Data from Jupyter to Workbench - Part II.mp4 | 58.23 MB | ||
| 10. Sending Data from Jupyter to Workbench - Part II.srt | 7.65 KB | ||
| 11. Sending Data from Jupyter to Workbench - Part III.mp4 | 32.83 MB | ||
| 11. Sending Data from Jupyter to Workbench - Part III.srt | 3.33 KB | ||
| 11.1 predicted_outputs.sql | 655 B | ||
| 11.2 The INSERT Statement.sql | 2.59 KB | ||
| 11.3 Multiple INSERT Statements.sql | 3.99 KB | ||
| 11.4 Absenteeism_predictions.csv | 1.58 KB | ||
| 11.5 Absenteeism Exercise - Integration.ipynb | 66.31 KB | ||
| 2. How to Use the 'absenteeism_module' in Python - Part II.mp4 | 54.33 MB | ||
| 2. How to Use the 'absenteeism_module' in Python - Part II.srt | 7.53 KB | ||
| 3. Creating the 'predicted_outputs' Database in MySQL.mp4 | 58.91 MB | ||
| 3. Creating the 'predicted_outputs' Database in MySQL.srt | 7.9 KB | ||
| 4. Importing 'pymysql' in Python.mp4 | 19.05 MB | ||
| 4. Importing 'pymysql' in Python.srt | 3.39 KB | ||
| 5. Creating a Connection and Cursor.mp4 | 20.97 MB | ||
| 5. Creating a Connection and Cursor.srt | 3.53 KB | ||
| 6. EXERCISE - Creating 'df_new_obs'.html | 322 B | ||
| 7. Creating the 'predicted_outputs' Table in MySQL.mp4 | 52.46 MB | ||
| 7. Creating the 'predicted_outputs' Table in MySQL.srt | 5.98 KB | ||
| 8. Executing and SQL SELECT Statement from Python.mp4 | 25.35 MB | ||
| 8. Executing and SQL SELECT Statement from Python.srt | 3.69 KB | ||
| 9. Sending Data from Jupyter to Workbench - Part I.mp4 | 76.28 MB | ||
| 9. Sending Data from Jupyter to Workbench - Part I.srt | 7.84 KB | ||
| 49. Integration - Using Tableau to Analyze the Predicted Outputs | |||
| 1. EXERCISE - Age vs Probability.html | 385 B | ||
| 1.1 Absenteeism_predictions.csv | 2.1 KB | ||
| 2. Using Tableau to Analyze Age vs Probability.mp4 | 56.5 MB | ||
| 2. Using Tableau to Analyze Age vs Probability.srt | 10.01 KB | ||
| 3. EXERCISE - Reasons vs Probability.html | 397 B | ||
| 4. Using Tableau to Analyze Reasons vs Probability.mp4 | 59.3 MB | ||
| 4. Using Tableau to Analyze Reasons vs Probability.srt | 9.54 KB | ||
| 5. EXERCISE - Transportation Expense vs Probability.html | 553 B | ||
| 6. Using Tableau to Analyze Transportation Expense vs Probability.mp4 | 40.63 MB | ||
| 6. Using Tableau to Analyze Transportation Expense vs Probability.srt | 7.21 KB | ||
| 7. Completing 100%.html | 1.87 KB | ||
| 5. Intro to Data and Data Science - Common Data Science Techniques | |||
| 1. Traditional Data Techniques.mp4 | 138.4 MB | ||
| 1. Traditional Data Techniques.srt | 10.62 KB | ||
| 10. Traditional Methods Techniques.mp4 | 111.63 MB | ||
| 10. Traditional Methods Techniques.srt | 111.65 MB | ||
| 11. Traditional Methods Techniques.html | 156 B | ||
| 12. Traditional Methods Real-life Examples.mp4 | 42.85 MB | ||
| 12. Traditional Methods Real-life Examples.srt | 3.58 KB | ||
| 13. Machine Learning (ML) Techniques.mp4 | 99.27 MB | ||
| 13. Machine Learning (ML) Techniques.srt | 8.73 KB | ||
| 14. Machine Learning (ML) Techniques.html | 156 B | ||
| 15. Machine Learning (ML) Types of Machine Learning.mp4 | 125.05 MB | ||
| 15. Machine Learning (ML) Types of Machine Learning.srt | 10.51 KB | ||
| 16. Machine Learning (ML) Types of Machine Learning.html | 156 B | ||
| 17. Machine Learning (ML) Real-life Examples.mp4 | 36.85 MB | ||
| 17. Machine Learning (ML) Real-life Examples.srt | 2.9 KB | ||
| 18. Machine Learning (ML) Real-life Examples.html | 156 B | ||
| 2. Traditional Data Techniques.html | 156 B | ||
| 3. Traditional Data Real-life Examples.mp4 | 29.96 MB | ||
| 3. Traditional Data Real-life Examples.srt | 2.24 KB | ||
| 4. Big Data Techniques.mp4 | 75.47 MB | ||
| 4. Big Data Techniques.srt | 5.67 KB | ||
| 5. Big Data Techniques.html | 156 B | ||
| 6. Big Data Real-life Examples.mp4 | 22.06 MB | ||
| 6. Big Data Real-life Examples.srt | 1.88 KB | ||
| 7. Business Intelligence (BI) Techniques.mp4 | 89.85 MB | ||
| 7. Business Intelligence (BI) Techniques.srt | 8.63 KB | ||
| 8. Business Intelligence (BI) Techniques.html | 156 B | ||
| 9. Business Intelligence (BI) Real-life Examples.mp4 | 29.52 MB | ||
| 9. Business Intelligence (BI) Real-life Examples.srt | 2.13 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 | 103.39 MB | ||
| 1. Programming Languages & Software Employed in Data Science - All the Tools Needed.srt | 7.29 KB | ||
| 2. Programming Languages & Software Employed in Data Science - All the Tools Needed.html | 156 B | ||
| 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 | 54.34 MB | ||
| 1. Data Science Job Positions What do they Involve and What to Look out for.srt | 4.49 KB | ||
| 2. Data Science Job Positions What do they Involve and What to Look out for.html | 156 B | ||
| 8. Intro to Data and Data Science - Dispelling Common Misconceptions | |||
| 1. Dispelling common Misconceptions.mp4 | 72.72 MB | ||
| 1. Dispelling common Misconceptions.srt | 5.29 KB | ||
| 2. Dispelling common Misconceptions.html | 156 B | ||
| 9. Part 2 Statistics - Population and Sample | |||
| 1. Population vs sample.mp4 | 58.08 MB | ||
| 1. Population vs sample.srt | 5.47 KB | ||
| 1.1 Statistics Glossary.xlsx | 20.26 KB | ||
| 1.2 Course notes_descriptive_statistics.pdf | 482.21 KB | ||
| 2. Population and Sample.html | 156 B | ||
| ▲ 1024 total files | |||
The Business Intelligence Analyst Course 2021
The skills you need to become a BI Analyst – Statistics, Database theory, SQL, Tableau – Everything is included
Upload provided by FreeAllCourse
What you'll learn?
# Become an expert in Statistics, SQL, Tableau, and problem solving
# Boost your resume with in-demand skills
# Gather, organize, analyze and visualize data
# Use data for improved business decision-making
# Present information in the form of metrics, KPIs, reports, and dashboards
# Perform quantitative and qualitative business analysis
# Analyze current and historical data
# Discover how to find trends, market conditions, and research competitor positioning
Description:
Created by 365 Careers
Last updated 11/2020
English
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 503.7 MB | freecoursewb | 1 week | 20 | 11 | |
| 784.3 MB | freecoursewb | 1 week | 18 | 6 | |
| 2.2 GB | freecoursewb | 1 week | 0 | 0 | |
| 3.7 GB | freecoursewb | 1 week | 0 | 0 | |
| 3.3 GB | freecoursewb | 1 week | 24 | 16 |
All Comments