Contact for queries :
banner1
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
TAKE THIS COURSE
  • FREE
  • 10 Days
8 STUDENTS ENROLLED

About WPLMS

WPLMS is the most popular Education WordPress theme. With over 12000 customers and several startups successfully running their businesses on WPLMS, it is the most powerful solution for Education websites right now.

Popular Tags

Who’s Online

There are no users currently online
top
Template Design © VibeThemes. All rights reserved.