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
- Understand the fundamentals of database theory
- Use SQL to create, design, and manipulate SQL databases
- Extract data from a database writing your own queries
- Create powerful professional visualizations in Tableau
- Combine SQL and Tableau to visualize data from the source
- Solve real-world business analysis tasks in SQL and Tableau
Course Curriculum
1. Part 1 Introduction | |||
1. What Does the Course Cover | 00:00:00 | ||
2. Intro to Data and Data Science - The Different Data Science Fields | |||
1. Why Are There So Many Business and Data Science Buzzwords | 00:00:00 | ||
2. Analysis vs Analytics | 00:00:00 | ||
3. Intro to Business Analytics, Data Analytics, and Data Science | 00:00:00 | ||
4. Intro to Business Analytics, Data Analytics, and Data Science | 00:00:00 | ||
5. Adding Business Intelligence (BI), Machine Learning (ML), and AI to the Picture | 00:00:00 | ||
6. Adding Business Intelligence (BI), Machine Learning (ML), and AI to the Picture | 00:00:00 | ||
7. An Overview of our Data Science Infographic | 00:00:00 | ||
Documents | 00:00:00 | ||
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 | 00:00:00 | ||
2. When are Traditional data, Big Data, BI, Traditional Data Science and ML applied | 00:00:00 | ||
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 | 00:00:00 | ||
2. Why do we Need each of these Disciplines | 00:00:00 | ||
5. Intro to Data and Data Science - Common Data Science Techniques | |||
1. Traditional Data Techniques | 00:00:00 | ||
2. Traditional Data Techniques | 00:00:00 | ||
3. Traditional Data Real-life Examples | 00:00:00 | ||
4. Big Data Techniques | 00:00:00 | ||
5. Big Data Techniques | 00:00:00 | ||
6. Big Data Real-life Examples | 00:00:00 | ||
7. Business Intelligence (BI) Techniques | 00:00:00 | ||
8. Business Intelligence (BI) Techniques | 00:00:00 | ||
9. Business Intelligence (BI) Real-life Examples | 00:00:00 | ||
10. Traditional Methods Techniques | 00:00:00 | ||
11. Traditional Methods Techniques | 00:00:00 | ||
12. Traditional Methods Real-life Examples | 00:00:00 | ||
13. Machine Learning (ML) Techniques | 00:00:00 | ||
14. Machine Learning (ML) Techniques | 00:00:00 | ||
15. Machine Learning (ML) Types of Machine Learning | 00:00:00 | ||
16. Machine Learning (ML) Types of Machine Learning | 00:00:00 | ||
17. Machine Learning (ML) Real-life Examples | 00:00:00 | ||
18. Machine Learning (ML) Real-life Examples | 00:00:00 | ||
6. Intro to Data and Data Science - Common Data Science Tools | |||
1. Programming Languages & Software Employed in Data Science – All the Tools Needed | 00:00:00 | ||
2. Programming Languages & Software Employed in Data Science – All the Tools Needed | 00:00:00 | ||
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 | 00:00:00 | ||
2. Data Science Job Positions What do they Involve and What to Look out for | 00:00:00 | ||
8. Intro to Data and Data Science - Dispelling Common Misconceptions | |||
1. Dispelling common Misconceptions | 00:00:00 | ||
2. Dispelling common Misconceptions | 00:00:00 | ||
9. Part 2 Statistics - Population and Sample | |||
1. Population vs sample | 00:00:00 | ||
2. Population and Sample | 00:00:00 | ||
10. Statistics - Descriptive Statistics | |||
1. Types of Data | 00:00:00 | ||
2. Types of data | 00:00:00 | ||
3. Levels of Measurement | 00:00:00 | ||
4. Levels of measurement | 00:00:00 | ||
5. Categorical Variables – Visualization Techniques | 00:00:00 | ||
6. Categorical variables. Visualization Techniques | 00:00:00 | ||
7. Categorical Variables Exercise | 00:00:00 | ||
8. Numerical Variables – Frequency Distribution Table | 00:00:00 | ||
9. Numerical variables. Using a frequency distribution table | 00:00:00 | ||
10. Numerical Variables Exercise | 00:00:00 | ||
11. The Histogram | 00:00:00 | ||
12. The Histogram | 00:00:00 | ||
13. Histogram Exercise | 00:00:00 | ||
14. Cross Table and Scatter Plot | 00:00:00 | ||
15. Cross Tables and Scatter Plots | 00:00:00 | ||
16. Cross Tables and Scatter Plots Exercise | 00:00:00 | ||
17. Mean, median and mode | 00:00:00 | ||
19. Skewness | 00:00:00 | ||
22. Variance | 00:00:00 | ||
24. Standard Deviation and Coefficient of Variation | 00:00:00 | ||
27. Covariance | 00:00:00 | ||
30. Correlation Coefficient | 00:00:00 | ||
11. Statistics - Practical Example Descriptive Statistics | |||
1. Practical Example | 00:00:00 | ||
2. Practical Example Exercise | 00:00:00 | ||
12. Statistics - Inferential Statistics Fundamentals | |||
1. Introduction | 00:00:00 | ||
2. What is a Distribution | 00:00:00 | ||
3. What is a Distribution | 00:00:00 | ||
4. The Normal Distribution | 00:00:00 | ||
5. The Normal Distribution | 00:00:00 | ||
6. The Standard Normal Distribution | 00:00:00 | ||
7. The Standard Normal Distribution | 00:00:00 | ||
8. The Standard Normal Distribution Exercise | 00:00:00 | ||
9. Central Limit Theorem | 00:00:00 | ||
10. Central Limit Theorem | 00:00:00 | ||
11. Standard error | 00:00:00 | ||
12. Standard error | 00:00:00 | ||
13. Estimators and Estimates | 00:00:00 | ||
14. Estimators and Estimates | 00:00:00 | ||
13. Statistics - Inferential Statistics Confidence Intervals | |||
1. What are Confidence Intervals | 00:00:00 | ||
2. What are Confidence Intervals | 00:00:00 | ||
3. Confidence Intervals; Population Variance Known; z-score | 00:00:00 | ||
4. Confidence Intervals; Population Variance Known; z-score Exercise | 00:00:00 | ||
5. Confidence interval clarifications | 00:00:00 | ||
6. Student’s T Distribution | 00:00:00 | ||
7. Student’s T Distribution | 00:00:00 | ||
8. Confidence Intervals; Population Variance Unknown; t-score | 00:00:00 | ||
9. Confidence Intervals; Population Variance Unknown; t-score Exercise | 00:00:00 | ||
10. Margin of Error | 00:00:00 | ||
11. Margin of Error | 00:00:00 | ||
12. Confidence intervals. Two means. Dependent samples | 00:00:00 | ||
13. Confidence intervals. Two means. Dependent samples Exercise | 00:00:00 | ||
14. Confidence intervals. Two means. Independent samples (Part 1) | 00:00:00 | ||
15. Confidence intervals. Two means. Independent samples (Part 1) Exercise | 00:00:00 | ||
16. Confidence intervals. Two means. Independent samples (Part 2) | 00:00:00 | ||
17. Confidence intervals. Two means. Independent samples (Part 2) Exercise | 00:00:00 | ||
18. Confidence intervals. Two means. Independent samples (Part 3) | 00:00:00 | ||
Documents | 00:00:00 | ||
14. Statistics - Practical Example Inferential Statistics | |||
1. Practical Example Inferential Statistics | 00:00:00 | ||
2. Practical Example Inferential Statistics Exercise | 00:00:00 | ||
15. Statistics - Hypothesis Testing | |||
1. The Null vs Alternative Hypothesis | 00:00:00 | ||
2. Further Reading on Null and Alternative Hypothesis | 00:00:00 | ||
3. The Null vs Alternative Hypothesis | 00:00:00 | ||
4. Rejection Region and Significance Level | 00:00:00 | ||
5. Rejection Region and Significance Level | 00:00:00 | ||
6. Type I Error and Type II Error | 00:00:00 | ||
7. Type I Error and Type II Error | 00:00:00 | ||
8. Test for the Mean. Population Variance Known | 00:00:00 | ||
9. Test for the Mean. Population Variance Known Exercise | 00:00:00 | ||
10. p-value | 00:00:00 | ||
11. p-value | 00:00:00 | ||
12. Test for the Mean. Population Variance Unknown | 00:00:00 | ||
13. Test for the Mean. Population Variance Unknown Exercise | 00:00:00 | ||
14. Test for the Mean. Dependent Samples | 00:00:00 | ||
15. Test for the Mean. Dependent Samples Exercise | 00:00:00 | ||
16. Test for the mean. Independent samples (Part 1) | 00:00:00 | ||
17. Test for the mean. Independent samples (Part 1). Exercise | 00:00:00 | ||
18. Test for the mean. Independent samples (Part 2) | 00:00:00 | ||
19. Test for the mean. Independent samples (Part 2) | 00:00:00 | ||
20. Test for the mean. Independent samples (Part 2) | 00:00:00 | ||
16. Statistics - Practical Example Hypothesis Testing | |||
1. Practical Example Hypothesis Testing | 00:00:00 | ||
2. Practical Example Hypothesis Testing Exercise | 00:00:00 | ||
Documents | 00:00:00 | ||
17. Part 3 Relational Database Theory and Introduction to SQL | |||
1. Why use SQL | 00:00:00 | ||
2. Why use SQL | 00:00:00 | ||
3. Why use MySQL | 00:00:00 | ||
4. Why use MySQL | 00:00:00 | ||
5. Introducing Databases | 00:00:00 | ||
6. Introducing Databases | 00:00:00 | ||
7. Relational Database Fundamentals | 00:00:00 | ||
8. Relational Database Fundamentals | 00:00:00 | ||
9. Comparing Databases and Spreadsheets | 00:00:00 | ||
10. Comparing Databases and Spreadsheets | 00:00:00 | ||
11. Important Database Terminology | 00:00:00 | ||
12. Important Database Terminology | 00:00:00 | ||
13. The Concept of Relational Schemas Primary Key | 00:00:00 | ||
14. The Concept of Relational Schemas Primary Key | 00:00:00 | ||
15. The Concept of Relational Schemas Foreign Key | 00:00:00 | ||
16. The Concept of Relational Schemas Foreign Key | 00:00:00 | ||
17. The Concept of Relational Schemas Unique Key and Null Values | 00:00:00 | ||
18. The Concept of Relational Schemas Unique Key | 00:00:00 | ||
19. The Concept of Relational Schemas Relationships Between Tables | 00:00:00 | ||
20. The Concept of Relational Schemas Relationships Between Tables | 00:00:00 | ||
18. SQL - Install and get to know MySQL | |||
1. Installing MySQL Workbench and Server | 00:00:00 | ||
2. Installing Visual C | 00:00:00 | ||
3. The Client-Server Model | 00:00:00 | ||
4. Linking GUI with the MySQL Server | 00:00:00 | ||
5. Creating a New User and a New Connection to it | 00:00:00 | ||
6. Familiarize Yourself with the MySQL Interface | 00:00:00 | ||
19. SQL - Best SQL Practices | |||
1. Coding Tips and Best Practices – I | 00:00:00 | ||
2. Coding Tips and Best Practices – I | 00:00:00 | ||
3. Coding Tips and Best Practices – II | 00:00:00 | ||
4. Coding Tips and Best Practices – II | 00:00:00 | ||
20. SQL - Loading the 'employees' Database | |||
1. Loading the ’employees’ Database | 00:00:00 | ||
2. Loading the ’employees’ Database | 00:00:00 | ||
2.1 The ’employees’ Database | 00:00:00 | ||
21. SQL Practical Application of the SQL SELECT Statement | |||
1. Using SELECT – FROM | 00:00:00 | ||
2. Using SELECT – FROM – Exercise | 00:00:00 | ||
3. Using SELECT – FROM – Solution | 00:00:00 | ||
4. Using WHERE | 00:00:00 | ||
5. Using WHERE – Exercise | 00:00:00 | ||
6. Using WHERE – Solution | 00:00:00 | ||
7. Using AND | 00:00:00 | ||
8. Using AND – Exercise | 00:00:00 | ||
9. Using AND – Solution | 00:00:00 | ||
10. Using OR | 00:00:00 | ||
11. Using OR – Exercise | 00:00:00 | ||
12. Using OR – Solution | 00:00:00 | ||
13. Operator Precedence and Logical Order | 00:00:00 | ||
14. Operator Precedence and Logical Order – Exercise | 00:00:00 | ||
15. Operator Precedence and Logical Order – Solution | 00:00:00 | ||
16. Using IN – NOT IN | 00:00:00 | ||
17. Using IN – NOT IN – Exercise 1 | 00:00:00 | ||
18. Using IN – NOT IN – Solution 1 | 00:00:00 | ||
19. Using IN – NOT IN – Exercise 2 | 00:00:00 | ||
20. Using IN – NOT IN – Solution 2 | 00:00:00 | ||
21. Using LIKE – NOT LIKE | 00:00:00 | ||
22. Using LIKE – NOT LIKE – Exercise | 00:00:00 | ||
23. Using LIKE – NOT LIKE – Solution | 00:00:00 | ||
24. Using Wildcard Characters | 00:00:00 | ||
25. Using Wildcard characters – Exercise | 00:00:00 | ||
26. Using Wildcard characters – Solution | 00:00:00 | ||
27. Using BETWEEN – AND | 00:00:00 | ||
28. Using BETWEEN – AND – Exercise | 00:00:00 | ||
29. Using BETWEEN – AND – Solution | 00:00:00 | ||
30. Using IS NOT NULL – IS NULL | 00:00:00 | ||
31. Using IS NOT NULL – IS NULL – Exercise | 00:00:00 | ||
32. Using IS NOT NULL – IS NULL – Solution | 00:00:00 | ||
33. Using Other Comparison Operators | 00:00:00 | ||
34. Using Other Comparison Operators – Exercise | 00:00:00 | ||
35. Using Other Comparison Operators – Solution | 00:00:00 | ||
36. Using SELECT DISTINCT | 00:00:00 | ||
37. Using SELECT DISTINCT – Exercise | 00:00:00 | ||
38. Using SELECT DISTINCT – Solution | 00:00:00 | ||
39. Getting to Know Aggregate Functions | 00:00:00 | ||
40. Getting to Know Aggregate Functions – Exercise | 00:00:00 | ||
41. Getting to Know Aggregate Functions – Solution | 00:00:00 | ||
42. Using ORDER BY | 00:00:00 | ||
43. Using ORDER BY – Exercise | 00:00:00 | ||
44. Using ORDER BY – Solution | 00:00:00 | ||
45. Using GROUP BY | 00:00:00 | ||
46. Using Aliases (AS) | 00:00:00 | ||
47. Using Aliases (AS) – Exercise | 00:00:00 | ||
49. Using HAVING | 00:00:00 | ||
52. Using WHERE vs HAVING – Part I | 00:00:00 | ||
53. Using WHERE vs HAVING – Part II | 00:00:00 | ||
56. Using LIMIT | 00:00:00 | ||
22. SQL - Expanding on MySQL Aggregate Functions | |||
1. Applying COUNT() | 00:00:00 | ||
2. Applying COUNT() – Exercise | 00:00:00 | ||
3. Applying COUNT() – Solution | 00:00:00 | ||
4. Applying SUM() | 00:00:00 | ||
5. Applying SUM() – Exercise | 00:00:00 | ||
6. Applying SUM() – Solution | 00:00:00 | ||
7. MIN() and MAX() | 00:00:00 | ||
8. MIN() and MAX() – Exercise | 00:00:00 | ||
9. MIN() and MAX() – Solution | 00:00:00 | ||
10. Applying AVG() | 00:00:00 | ||
11. Applying AVG() – Exercise | 00:00:00 | ||
12. Applying AVG() – Solution | 00:00:00 | ||
13. Rounding Numbers with ROUND() | 00:00:00 | ||
14. Rounding Numbers with ROUND() – Exercise | 00:00:00 | ||
15. Rounding Numbers with ROUND() – Solution | 00:00:00 | ||
23. SQL - SQL JOINs | |||
1. What are JOINs | 00:00:00 | ||
2. What are JOINs – Exercise 1 | 00:00:00 | ||
3. What are JOINs – Exercise 2 | 00:00:00 | ||
4. The Functionality of INNER JOIN – Part I | 00:00:00 | ||
5. The Functionality of INNER JOIN – Part II | 00:00:00 | ||
6. The Functionality of INNER JOIN – PART II – Exercise | 00:00:00 | ||
7. The Functionality of INNER JOIN – PART II – Solution | 00:00:00 | ||
8. Extra Info on Using Joins | 00:00:00 | ||
9. Duplicate Rows | 00:00:00 | ||
10. The Functionality of LEFT JOIN – Part I | 00:00:00 | ||
11. The Functionality of LEFT JOIN – Part II | 00:00:00 | ||
12. The Functionality of LEFT JOIN – Part II – Exercise | 00:00:00 | ||
13. The Functionality of LEFT JOIN – Part II – Solution | 00:00:00 | ||
14. The Functionality of RIGHT JOIN | 00:00:00 | ||
15. Differences between the New and the Old Join Syntax | 00:00:00 | ||
16. Differences between the New and the Old Join Syntax – Exercise | 00:00:00 | ||
17. Differences between the New and the Old Join Syntax – Solution | 00:00:00 | ||
18. Using JOIN and WHERE Together | 00:00:00 | ||
19. Using JOIN and WHERE Together – Exercise | 00:00:00 | ||
20. Using JOIN and WHERE Together – Solution | 00:00:00 | ||
21. The Functionality of CROSS JOIN | 00:00:00 | ||
22. The Functionality of CROSS JOIN – Exercise 1 | 00:00:00 | ||
23. The Functionality of CROSS JOIN – Solution 1 | 00:00:00 | ||
24. The Functionality of CROSS JOIN – Exercise 2 | 00:00:00 | ||
25. The Functionality of CROSS JOIN – Solution 2 | 00:00:00 | ||
26. Combining Aggregate Functions with Joins | 00:00:00 | ||
27. JOIN More than Two Tables | 00:00:00 | ||
28. JOIN More than Two Tables – Exercise | 00:00:00 | ||
29. JOIN More than Two Tables – Solution | 00:00:00 | ||
30. Top Tips for Joins | 00:00:00 | ||
31. Top Tips for Joins – Exercise | 00:00:00 | ||
32. Top Tips for Joins – Solution | 00:00:00 | ||
33. The Differences Between UNION and UNION ALL | 00:00:00 | ||
34. The Differences Between UNION and UNION ALL – Exercise | 00:00:00 | ||
35. The Differences Between UNION and UNION ALL – Solution | 00:00:00 | ||
24. SQL - SQL Subqueries | |||
1. SQL Subqueries with IN Embedded Inside WHERE | 00:00:00 | ||
2. SQL Subqueries with IN Embedded Inside WHERE – Exercise | 00:00:00 | ||
3. SQL Subqueries with IN Embedded Inside WHERE – Solution | 00:00:00 | ||
4. SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE | 00:00:00 | ||
5. SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE – Exercise | 00:00:00 | ||
6. SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE – Solution | 00:00:00 | ||
7. SQL Subqueries Nested in SELECT and FROM | 00:00:00 | ||
8. SQL Subqueries Embedded in SELECT and FROM – Exercise 1 | 00:00:00 | ||
9. SQL Subqueries Embedded in SELECT and FROM – Exercise 2 | 00:00:00 | ||
10. SQL Subqueries Nested in SELECT and FROM – Solution 2 | 00:00:00 | ||
25. SQL - Stored Routines | |||
1. Defining Stored Routines | 00:00:00 | ||
2. Defining Stored Routines | 00:00:00 | ||
3. Create Stored Procedures with MySQL Syntax | 00:00:00 | ||
4. An Example of Stored Procedures Part I | 00:00:00 | ||
5. An Example of Stored Procedures Part II | 00:00:00 | ||
6. An Example of Stored Procedures Part II – Exercise | 00:00:00 | ||
7. An Example of Stored Procedures Part II – Solution | 00:00:00 | ||
8. Creating a Procedure in MySQL Another Way | 00:00:00 | ||
9. Create Stored Procedures with an Input Parameter | 00:00:00 | ||
10. Create Stored Procedures with an Output Parameter | 00:00:00 | ||
11. Create Stored Procedures with an Output Parameter – Exercise | 00:00:00 | ||
12. Stored Procedures with an Output Parameter – Solution | 00:00:00 | ||
13. SQL Variables | 00:00:00 | ||
14. SQL Variables – Exercise | 00:00:00 | ||
15. SQL Variables – Solution | 00:00:00 | ||
16. The Benefit of User-Defined Functions in MySQL | 00:00:00 | ||
17. The Benefit of User-Defined Functions in MySQL – Exercise | 00:00:00 | ||
18. The Benefit of User-Defined Functions in MySQL – Solution | 00:00:00 | ||
19. Concluding Stored Routines | 00:00:00 | ||
20. Concluding Stored Routines | 00:00:00 | ||
26. SQL - The CASE Statement | |||
1. The SQL CASE Statement | 00:00:00 | ||
2. The SQL CASE Statement – Exercise 1 | 00:00:00 | ||
3. THE SQL CASE Statement – Solution 1 | 00:00:00 | ||
4. THE SQL CASE Statement – Exercise 2 | 00:00:00 | ||
5. THE SQL CASE Statement – Solution 2 | 00:00:00 | ||
6. THE SQL CASE Statement – Exercise 3 | 00:00:00 | ||
7. THE SQL CASE Statement – Solution 3 | 00:00:00 | ||
27. Part 4 Introduction to Tableau | |||
1. Why Use Tableau Make Your Data Make an Impact | 00:00:00 | ||
2. Let’s Download Tableau Public | 00:00:00 | ||
3. Connecting Data in Tableau | 00:00:00 | ||
4. Exploring Tableau’s Interface | 00:00:00 | ||
5. Let’s Create our first Chart in Tableau! | 00:00:00 | ||
5.2 GDP Data – Tableau Public Link | 00:00:00 | ||
Samples | 00:00:00 | ||
28. Tableau - Tableau functionalities | |||
1. Duplicating a Sheet | 00:00:00 | ||
2. Creating a Table | 00:00:00 | ||
2.1 Creating a table – Tableau Public Link | 00:00:00 | ||
3. Creating Custom Fields | 00:00:00 | ||
4. Creating a Custom Field and Adding Calculations to a Table | 00:00:00 | ||
4.2 Creating a custom field – Tableau Public Link | 00:00:00 | ||
5. Adding Totals and Subtotals | 00:00:00 | ||
5.1 Addint totals and subtotals – Tableau Public Link | 00:00:00 | ||
6. Adding a Custom Calculation | 00:00:00 | ||
6.1 Adding a custom calculation – Tableau Public Link | 00:00:00 | ||
7. Inserting a Filter | 00:00:00 | ||
7.1 Inserting a filter – Tableau Public Link | 00:00:00 | ||
8. Working with Joins in Tableau | 00:00:00 | ||
Samples | 00:00:00 | ||
29. Tableau - The Tableau Exercise | |||
1. Introduction to the Exercise | 00:00:00 | ||
2. Let’s Create a Dashboard – Visualizing the Three Charts We Want to Create | 00:00:00 | ||
3. Using Joins in Tableau | 00:00:00 | ||
4. Performing a Numbers Check – Attempt #1 | 00:00:00 | ||
4.1 Check the data – Tableau Public Link | 00:00:00 | ||
5. Blending Data in Tableau | 00:00:00 | ||
5.2 Check the data – Tableau Public Link | 00:00:00 | ||
6. Performing a Numbers Check – Attempt #2 | 00:00:00 | ||
6.1 Check the data – Tableau Public Link | 00:00:00 | ||
7. First Chart | 00:00:00 | ||
7.1 First chart – Tableau Public Link | 00:00:00 | ||
8. Second chart | 00:00:00 | ||
8.2 Second chart – Tableau Public Link | 00:00:00 | ||
9. Third Chart | 00:00:00 | ||
9.3 Third chart – Tableau Public Link | 00:00:00 | ||
10. Creating and Formatting a Dashboard | 00:00:00 | ||
10.2 Creating a dashboard – Tableau Public Link | 00:00:00 | ||
11. Adding Interactive Filters for Improved Analysis | 00:00:00 | ||
11.1 Adding a filter – Tableau Public Link | 00:00:00 | ||
30. Part 5 Combining SQL and Tableau - Introduction | |||
1. Introduction to Software Integration | 00:00:00 | ||
2. Combining SQL and Tableau | 00:00:00 | ||
3. Loading the Database | 00:00:00 | ||
4. Loading the Database | 00:00:00 | ||
4.1 The ’employees_mod’ Database | 00:00:00 | ||
Documents | 00:00:00 | ||
31. Combining SQL and Tableau - Problem 1 | |||
1. Problem 1 Task | 00:00:00 | ||
2. Problem 1 Task – Text | 00:00:00 | ||
3. Problem 1 Solution in SQL | 00:00:00 | ||
4. Problem 1 Solution in SQL – Code | 00:00:00 | ||
5. Exporting Your Output from SQL and Loading it in Tableau | 00:00:00 | ||
6. Chart 1 Visualizing the Solution in Tableau – Part I | 00:00:00 | ||
7. Chart 1 Visualizing the Solution in Tableau – Part II | 00:00:00 | ||
32. Combining SQL and Tableau - Problem 2 | |||
1. Problem 2 Task | 00:00:00 | ||
2. Problem 2 Task – Text | 00:00:00 | ||
3. Problem 2 Solution in SQL | 00:00:00 | ||
4. Problem 2 Solution in SQL – Code | 00:00:00 | ||
5. Chart 2 Visualizing the Solution in Tableau | 00:00:00 | ||
33. Combining SQL and Tableau - Problem 3 | |||
1. Problem 3 Task | 00:00:00 | ||
2. Problem 3 Task – Text | 00:00:00 | ||
3. Problem 3 Solution in SQL | 00:00:00 | ||
4. Problem 3 Solution in SQL – Code | 00:00:00 | ||
5. Chart 3 Visualizing the Solution in Tableau | 00:00:00 | ||
34. Combining SQL and Tableau - Problem 4 | |||
1. Problem 4 Task | 00:00:00 | ||
2. Problem 4 Task – Text | 00:00:00 | ||
3. Problem 4 Solution in SQL | 00:00:00 | ||
4. Problem 4 Solution in SQL – Code | 00:00:00 | ||
5. Chart 4 Visualizing the Solution in Tableau | 00:00:00 | ||
35. Combining SQL and Tableau - Problem 5 | |||
1. Problem 5 Organizing Charts 1-4 into a Beautiful Dashboard | 00:00:00 | ||
36. Part 6 Introduction to Programming with Python | |||
1. A 5-minute explanation of Programming | 00:00:00 | ||
2. A 5-minute explanation of Programming | 00:00:00 | ||
3. Why use Python | 00:00:00 | ||
4. Why Use Python | 00:00:00 | ||
5. Why use Jupyter | 00:00:00 | ||
6. Why Use Jupyter | 00:00:00 | ||
7. How to Install Python and Jupyter | 00:00:00 | ||
8. Understanding Jupyter’s Interface – Dashboard | 00:00:00 | ||
9. Understanding Jupyter’s Interface – Prerequisites for Coding | 00:00:00 | ||
10. Understanding Jupyter’s Interface | 00:00:00 | ||
Documents | 00:00:00 | ||
37. Python - Python Variables and Data Types | |||
1. Python Variables | 00:00:00 | ||
1.1 Python Variables – Resources | 00:00:00 | ||
2. Python Variables | 00:00:00 | ||
3. Understanding Numbers and Boolean Values | 00:00:00 | ||
3.1 Understanding Numbers and Boolean Values – Resources | 00:00:00 | ||
4. Understanding Numbers and Boolean Values | 00:00:00 | ||
5. Strings | 00:00:00 | ||
5.1 Strings – Resources | 00:00:00 | ||
6. Strings | 00:00:00 | ||
38. Python - Python Syntax Fundamentals | |||
1. The Arithmetic Operators of Python | 00:00:00 | ||
1.1 Arithmetic Operators – Resources | 00:00:00 | ||
2. Using Arithmetic Operators in Python | 00:00:00 | ||
3. What is the Double Equality Sign | 00:00:00 | ||
3.1 The Double Equality Sign – Resources | 00:00:00 | ||
4. What is the Double Equality Sign | 00:00:00 | ||
5. How to Reassign Values | 00:00:00 | ||
5.1 Reassign Values – Resources | 00:00:00 | ||
6. How to Reassign Values | 00:00:00 | ||
7. How to Add Comments | 00:00:00 | ||
7.1 How to Add Comments – Resources | 00:00:00 | ||
8. How to Add Comments | 00:00:00 | ||
9. Understanding Line Continuation | 00:00:00 | ||
9.1 Line Continuation – Resources | 00:00:00 | ||
10. How to Index Elements | 00:00:00 | ||
10.1 Indexing Elements – Resources | 00:00:00 | ||
11. How to Index Elements | 00:00:00 | ||
12. How to Structure Your Code with Indentation | 00:00:00 | ||
12.1 Structure Your Code with Indentation – Resources | 00:00:00 | ||
13. How to Structure Your Code with Indentation | 00:00:00 | ||
39. Python - Other Python Operators | |||
1. Python’s Comparison Operators | 00:00:00 | ||
1.1 Comparison Operators – Resources | 00:00:00 | ||
2. Python’s Comparison Operators | 00:00:00 | ||
3. Python’s Logical and Identity Operators | 00:00:00 | ||
3.1 Logical and Identity Operators – Resources | 00:00:00 | ||
4. Python’s Logical and Identity Operators | 00:00:00 | ||
40. Python - Conditional Statements | |||
1. Getting to know the IF Statement | 00:00:00 | ||
1.1 Introduction to the If Statement – Resources | 00:00:00 | ||
2. Getting to know the IF Statement | 00:00:00 | ||
3. Adding an ELSE statement | 00:00:00 | ||
3.1 Add an Else Statement – Resources | 00:00:00 | ||
4. Else if, for Brief – ELIF | 00:00:00 | ||
4.1 Else if, for Brief – Elif – Resources | 00:00:00 | ||
5. An Additional Explanation of Boolean Values | 00:00:00 | ||
5.1 A Note on Boolean Values – Resources | 00:00:00 | ||
6. An Additional Explanation of Boolean Values | 00:00:00 | ||
41. Python - Functions | |||
1. How to Define a Function in Python | 00:00:00 | ||
1.1 Defining a Function in Python – Resources | 00:00:00 | ||
2. How to Create a Function with a Parameter | 00:00:00 | ||
2.1 Creating a Function with a Parameter – Resources | 00:00:00 | ||
3. Define a Function in Another Way | 00:00:00 | ||
3.1 Another Way to Define a Function – Resources | 00:00:00 | ||
4. How to use a Function within a Function | 00:00:00 | ||
4.1 Using a Function in Another Function – Resources | 00:00:00 | ||
5. Use Conditional Statements and Functions Together | 00:00:00 | ||
5.1 Combining Conditional Statements and Functions – Resources | 00:00:00 | ||
6. How to Create Functions Which Contain a Few Arguments | 00:00:00 | ||
6.1 Creating Functions Containing a Few Arguments – Resources | 00:00:00 | ||
7. Built-In Functions in Python Worth Knowing | 00:00:00 | ||
7.1 Notable Built-In Functions in Python – Resources | 00:00:00 | ||
8. Python – Functions | 00:00:00 | ||
42. Python - Python Sequences | |||
1. Introduction to Lists | 00:00:00 | ||
1.1 Lists – Resources | 00:00:00 | ||
2. Introduction to Lists | 00:00:00 | ||
3. Using Methods in Python | 00:00:00 | ||
3.1 Help Yourself with Methods – Resources | 00:00:00 | ||
4. Using Methods in Python | 00:00:00 | ||
5. What is List Slicing | 00:00:00 | ||
5.1 List Slicing – Resources | 00:00:00 | ||
6. Working with Tuples | 00:00:00 | ||
6.1 Tuples – Resources | 00:00:00 | ||
7. Python Dictionaries | 00:00:00 | ||
7.1 Dictionaries – Resources | 00:00:00 | ||
8. Python Dictionaries | 00:00:00 | ||
43. Python - Using Iterations | |||
1. Using For Loops | 00:00:00 | ||
1.1 For Loops – Resources | 00:00:00 | ||
2. For Loops | 00:00:00 | ||
3. Using While Loops and Incrementing | 00:00:00 | ||
3.1 While Loops and Incrementing – Resources | 00:00:00 | ||
4. Use the range() Function to Create Lists | 00:00:00 | ||
4.1 Create Lists with the range() Function – Resources | 00:00:00 | ||
5. Use the range() Function to Create Lists | 00:00:00 | ||
6. Combine Conditional Statements and Loops | 00:00:00 | ||
6.1 Use Conditional Statements and Loops Together – Resources | 00:00:00 | ||
7. All In – Conditional Statements, Functions, and Loops | 00:00:00 | ||
7.1 All In – Conditional Statements, Functions, and Loops – Resources | 00:00:00 | ||
8. How to Iterate over Dictionaries | 00:00:00 | ||
8.1 Iterating over Dictionaries – Resources | 00:00:00 | ||
44. Python - Advanced Python tools | |||
1. Introduction to Object Oriented Programming (OOP) | 00:00:00 | ||
2. Introduction to Object Oriented Programming (OOP) | 00:00:00 | ||
3. Using Modules and Packages | 00:00:00 | ||
4. Using Modules and Packages | 00:00:00 | ||
5. What is the Standard Library | 00:00:00 | ||
6. What is the Standard Library | 00:00:00 | ||
7. How to Import Modules in Python | 00:00:00 | ||
8. How to Import Modules in Python | 00:00:00 | ||
45. Integration - Software Integration | |||
1. Getting Started with Data, Servers, Clients, Requests, and Responses | 00:00:00 | ||
2. Getting Started with Data, Servers, Clients, Requests, and Responses | 00:00:00 | ||
3. Getting Started with Data Connectivity, APIs, and Endpoints | 00:00:00 | ||
4. Getting Started with Data Connectivity, APIs, and Endpoints | 00:00:00 | ||
5. Become Better Acquainted with APIs | 00:00:00 | ||
6. Become Better Acquainted with APIs | 00:00:00 | ||
7. Communication through Text Files | 00:00:00 | ||
8. Communication through Text Files | 00:00:00 | ||
9. What is Software Integration and How is it Applied | 00:00:00 | ||
10. What is Software Integration and How is it Applied | 00:00:00 | ||
46. Integration - What is contained in this Course | |||
1. Solving a Business Exercise with Python, SQL, and Tableau | 00:00:00 | ||
2. Presenting the Task Absenteeism at Work | 00:00:00 | ||
3. Presenting the Data Set | 00:00:00 | ||
4. Presenting the Data Set | 00:00:00 | ||
47. Integration - Data Preprocessing Step by Step | |||
1. How is the Content in the Next Sections Organized | 00:00:00 | ||
2. How to Import the Data Set in Python | 00:00:00 | ||
3. Exploring the Data Set | 00:00:00 | ||
4. Programming vs the Rest of the World | 00:00:00 | ||
5. A Brief Summary of Regression Analysis | 00:00:00 | ||
6. The Approach we will Take to Solve this Exercise | 00:00:00 | ||
7. Dropping Variables We Don’t Need | 00:00:00 | ||
8. EXERCISE – Dropping Variables We Don’t Need | 00:00:00 | ||
9. SOLUTION – Dropping Variables We Don’t Need | 00:00:00 | ||
10. A Deeper Look at the ‘Reasons for Absence’ Column | 00:00:00 | ||
11. Splitting a Variable into Multiple Dummy Variables | 00:00:00 | ||
12. EXERCISE – Splitting a Variable into Multiple Dummy Variables | 00:00:00 | ||
13. SOLUTION – Splitting a Variable into Multiple Dummy Variables | 00:00:00 | ||
14. How to Drop a Dummy Variable from the Data Set | 00:00:00 | ||
15. A Statistical Perspective on Dummy Variables | 00:00:00 | ||
16. Categorizing the Various Reasons for Absence | 00:00:00 | ||
17. Concatenation in Python | 00:00:00 | ||
18. EXERCISE – Concatenation in Python | 00:00:00 | ||
19. SOLUTION – Concatenation in Python | 00:00:00 | ||
20. How to Reorder Columns in a DataFrame in Python | 00:00:00 | ||
21. EXERCISE – How to Reorder Columns in a DataFrame in Python | 00:00:00 | ||
22. SOLUTION – How to Reorder Columns in a DataFrame in Python | 00:00:00 | ||
23. Using Checkpoints to Ease Your Work in Jupyter | 00:00:00 | ||
23.1 Using Checkpoints | 00:00:00 | ||
24. EXERCISE – Using Checkpoints to Ease Your Work in Jupyter | 00:00:00 | ||
25. SOLUTION – Using Checkpoints to Ease Your Work in Jupyter | 00:00:00 | ||
26. Analyzing the Date Column | 00:00:00 | ||
27. Retrieving the Month Value From the Date Column | 00:00:00 | ||
28. Adding the Day of the Week Column | 00:00:00 | ||
29. EXERCISE – Dropping Columns | 00:00:00 | ||
29.1 Dropping Columns | 00:00:00 | ||
29.2 Preprocessing | 00:00:00 | ||
30. Analysis of the Next 5 Columns in DF | 00:00:00 | ||
31. Dealing with More Numerical Features which may Behave like Categorical Ones | 00:00:00 | ||
32. A Final Note on this Section | 00:00:00 | ||
32.1 Preprocessing | 00:00:00 | ||
32.2 Exercises and solutions | 00:00:00 | ||
48. Integration - Integrating Python and SQL | |||
1. How to Use the ‘absenteeism_module’ in Python – Part I | 00:00:00 | ||
1.1 The 5 files rar | 00:00:00 | ||
2. How to Use the ‘absenteeism_module’ in Python – Part II | 00:00:00 | ||
3. Creating the ‘predicted_outputs’ Database in MySQL | 00:00:00 | ||
4. Importing ‘pymysql’ in Python | 00:00:00 | ||
5. Creating a Connection and Cursor | 00:00:00 | ||
6. EXERCISE – Creating ‘df_new_obs’ | 00:00:00 | ||
7. Creating the ‘predicted_outputs’ Table in MySQL | 00:00:00 | ||
8. Executing and SQL SELECT Statement from Python | 00:00:00 | ||
9. Sending Data from Jupyter to Workbench – Part I | 00:00:00 | ||
10. Sending Data from Jupyter to Workbench – Part II | 00:00:00 | ||
11. Sending Data from Jupyter to Workbench – Part III | 00:00:00 | ||
11.1 Integration | 00:00:00 | ||
49. Integration - Using Tableau to Analyze the Predicted Outputs | |||
1. EXERCISE – Age vs Probability | 00:00:00 | ||
2. Using Tableau to Analyze Age vs Probability | 00:00:00 | ||
3. EXERCISE – Reasons vs Probability | 00:00:00 | ||
4. Using Tableau to Analyze Reasons vs Probability | 00:00:00 | ||
5. EXERCISE – Transportation Expense vs Probability | 00:00:00 | ||
6. Using Tableau to Analyze Transportation Expense vs Probability | 00:00:00 |
8 STUDENTS ENROLLED