Section 1 : Intro to Data and Data Science The Different Data Science Fi
|
|
Lecture 1 | Why Are There So Many Business and Data Science Bu | 00:05:22 Duration |
|
|
Lecture 2 | Analysis vs Analytics | 00:03:51 Duration |
|
|
Lecture 3 | Intro to Business Analytics Data Analytics andData | 00:08:26 Duration |
|
|
Lecture 4 | Adding Business Intelligence (BI), Machine Learnin | 00:09:31 Duration |
|
|
Lecture 5 | An Overview of our Data Science Infographic | 00:04:03 Duration |
Section 2 : Intro to Data and Data Science The Relationship between Diff
|
|
Lecture 1 | When are Traditional data, Big Data, BI, Tradition | 00:07:19 Duration |
Section 3 : Intro to Data and Data Science What is the Purpose of each D
|
|
Lecture 1 | Why do we Need each of these Disciplines | 00:04:45 Duration |
Section 4 : Intro to Data and Data Science Common Data Science Technique
|
|
Lecture 1 | Traditional Data- Techniques | 00:08:14 Duration |
|
|
Lecture 2 | Traditional Data- Real-life Examples | 00:01:45 Duration |
|
|
Lecture 3 | Big Data- Techniques | 00:04:26 Duration |
|
|
Lecture 4 | Big Data- Real-life Examples | 00:01:32 Duration |
|
|
Lecture 5 | Business Intelligence (BI)- Techniques | 00:06:46 Duration |
|
|
Lecture 6 | Business Intelligence (BI)- Real-life Examples | 00:01:43 Duration |
|
|
Lecture 7 | Traditional Methods- Techniques | 00:09:08 Duration |
|
|
Lecture 8 | Traditional Methods- Real-life Examples | 00:02:46 Duration |
|
|
Lecture 9 | Machine Learning (ML)- Techniques | 00:06:55 Duration |
|
|
Lecture 10 | Machine Learning (ML)- Types of Machine Learning | 00:08:13 Duration |
|
|
Lecture 11 | Machine Learning (ML)- Real-life Examples | 00:02:12 Duration |
Section 5 : Intro to Data and Data Science Common Data Science Tools
|
|
Lecture 1 | Programming Languages & Software Employed in Data | 00:05:51 Duration |
Section 6 : Intro to Data and Data Science Data Science Career Paths
|
|
Lecture 1 | Data Science Job Positions- What do they Involve a | 00:03:29 Duration |
Section 7 : Intro to Data and Data Science Dispelling Common Misconcepti
|
|
Lecture 1 | Dispelling common Misconceptions | 00:04:10 Duration |
Section 8 : Part 2 Statistics PopulationandSample
|
|
Lecture 1 | Population vs sample | 00:04:02 Duration |
Section 9 : Statistics Descriptive Statistics
|
|
Lecture 1 | Types of Data | 00:04:33 Duration |
|
|
Lecture 2 | Levels of Measurement | 00:03:44 Duration |
|
|
Lecture 3 | Categorical Variables - Visualization Techniques | 00:04:53 Duration |
|
|
Lecture 4 | Numerical Variables - Frequency Distribution Table | 00:03:10 Duration |
|
|
Lecture 5 | The Histogram | 00:02:14 Duration |
|
|
Lecture 6 | Cross Table and Scatter Plot | 00:04:44 Duration |
|
|
Lecture 7 | Mean, median and mode | 00:04:20 Duration |
|
|
Lecture 8 | Skewness | 00:02:38 Duration |
|
|
Lecture 9 | Variance | 00:05:55 Duration |
|
|
Lecture 10 | Standard Deviation and Coefficient of Variation | 00:04:41 Duration |
|
|
Lecture 11 | Covariance | 00:03:24 Duration |
|
|
Lecture 12 | Correlation Coefficient | 00:03:18 Duration |
Section 10 : Statistics Practical ExampleDescriptive Statistics
|
|
Lecture 1 | Practical Example |
Section 11 : StatisticsInferentialStatisticsFundamentals
|
|
Lecture 1 | Introduction | 00:01:01 Duration |
|
|
Lecture 2 | What is a Distribution | 00:04:33 Duration |
|
|
Lecture 3 | The Normal Distribution | 00:03:54 Duration |
|
|
Lecture 4 | The Standard Normal Distribution | 00:03:31 Duration |
|
|
Lecture 5 | Central Limit Theorem | 00:04:20 Duration |
|
|
Lecture 6 | Standard error | 00:01:27 Duration |
|
|
Lecture 7 | Estimators and Estimates | 00:03:08 Duration |
Section 12 : StatisticsInferentialStatisticsConfidenceIntervals
|
|
Lecture 1 | What are Confidence Intervals | 00:02:42 Duration |
|
|
Lecture 2 | Confidence Intervals; Population Variance Known; z | 00:08:02 Duration |
|
|
Lecture 3 | Confidence interval clarifications | 00:04:39 Duration |
|
|
Lecture 4 | Student's T Distribution | 00:03:23 Duration |
|
|
Lecture 5 | Confidence Intervals; Population Variance Unknown; | 00:04:37 Duration |
|
|
Lecture 6 | Margin of Error | 00:04:53 Duration |
|
|
Lecture 7 | Confidence intervals. Two means. Dependent samples | 00:06:04 Duration |
|
|
Lecture 8 | Confidence intervals. Two means. Independent sampl | 00:04:31 Duration |
|
|
Lecture 9 | Confidence intervals. Two means. Independent sampl | 00:03:58 Duration |
|
|
Lecture 10 | Confidence intervals. Two means. Independent sampl | 00:01:27 Duration |
Section 13 : Statistics Practical ExampleInferentialStatistics
|
|
Lecture 1 | Practical Example- Inferential Statistics | 00:10:06 Duration |
Section 14 : StatisticsHypothesisTesting
|
|
Lecture 1 | The Null vs Alternative Hypothesis | 00:05:52 Duration |
|
|
Lecture 2 | Rejection Region and Significance Level | 00:07:06 Duration |
|
|
Lecture 3 | Type I Error and Type II Error | 00:04:14 Duration |
|
|
Lecture 4 | Test for the Mean. Population Variance Known | 00:06:35 Duration |
|
|
Lecture 5 | p-value | 00:04:49 Duration |
|
|
Lecture 6 | Test for the Mean. Dependent Samples | 00:05:18 Duration |
|
|
Lecture 7 | Test for the mean. Independent samples (Part 1) | 00:04:22 Duration |
|
|
Lecture 8 | Test for the mean. Independent samples (Part 2) | 00:04:27 Duration |
Section 15 : Statistics Practical ExampleHypothesisTesting
|
|
Lecture 1 | Practical Example- Hypothesis Testing | 00:07:16 Duration |
Section 16 : Part 3 RelationalDatabaseTheory&IntroductiontoSQL
|
|
Lecture 1 | Why use SQL | 00:03:18 Duration |
|
|
Lecture 2 | Why use MySQL | 00:01:57 Duration |
|
|
Lecture 3 | Introducing Databases | 00:04:44 Duration |
|
|
Lecture 4 | Relational Database Fundamentals | 00:04:51 Duration |
|
|
Lecture 5 | Comparing Databases and Spreadsheets | 00:07:05 Duration |
|
|
Lecture 6 | Important Database Terminology | 00:04:17 Duration |
|
|
Lecture 7 | The Concept of Relational Schemas- Primary Key | |
|
|
Lecture 8 | The Concept of Relational Schemas- Foreign Key | 00:04:59 Duration |
|
|
Lecture 9 | The Concept of Relational Schemas- Unique Key and | 00:03:08 Duration |
|
|
Lecture 10 | The Concept of Relational Schemas- Relationships | 00:04:39 Duration |
Section 17 : SQLInstallandgettoknowMySQL
|
|
Lecture 1 | Installing MySQL Workbench and Server | 00:10:49 Duration |
|
|
Lecture 2 | Linking GUI with the MySQL Server | 00:02:34 Duration |
|
|
Lecture 3 | Creating a New User and a New Connection to it | 00:06:18 Duration |
|
|
Lecture 4 | Familiarize Yourself with the MySQL Interface | 00:05:09 Duration |
Section 18 : SQL Best SQLPractices
|
|
Lecture 1 | Coding Tips and Best Practices - I. | 00:05:34 Duration |
|
|
Lecture 2 | Coding Tips and Best Practices - II | 00:04:12 Duration |
Section 19 : SQL PracticalApplicationoftheSQLSELECTStatement
|
|
Lecture 1 | Using SELECT - FROM | 00:04:57 Duration |
|
|
Lecture 2 | Using WHERE | 00:02:30 Duration |
|
|
Lecture 3 | Using AND | 00:02:14 Duration |
|
|
Lecture 4 | Using OR | 00:03:36 Duration |
|
|
Lecture 5 | Operator Precedence and Logical Order | 00:03:36 Duration |
|
|
Lecture 6 | Using IN - NOT IN | 00:03:12 Duration |
|
|
Lecture 7 | Using LIKE - NOT LIKE | 00:03:36 Duration |
|
|
Lecture 8 | Using IS NOT NULL - IS NULL | 00:01:38 Duration |
|
|
Lecture 9 | Using Other Comparison Operators | 00:04:30 Duration |
|
|
Lecture 10 | Using SELECT DISTINCT | 00:02:06 Duration |
|
|
Lecture 11 | Getting to Know Aggregate Functions | 00:05:25 Duration |
|
|
Lecture 12 | Using ORDER BY | 00:03:46 Duration |
|
|
Lecture 13 | Using GROUP BY | 00:06:00 Duration |
|
|
Lecture 14 | Using Aliases (AS) | 00:02:09 Duration |
|
|
Lecture 15 | Using HAVING | 00:03:26 Duration |
|
|
Lecture 16 | Using WHERE vs HAVING - Part I | |
|
|
Lecture 17 | Using WHERE vs HAVING - Part II | 00:03:08 Duration |
|
|
Lecture 18 | Using LIMIT | 00:04:52 Duration |
Section 20 : SQL ExpandingonMySQLAggregateFunctions
|
|
Lecture 1 | Applying COUNT( | 00:04:01 Duration |
|
|
Lecture 2 | Applying SUM() | 00:01:31 Duration |
|
|
Lecture 3 | MIN() and MAX() | 00:01:15 Duration |
|
|
Lecture 4 | Applying AVG() | 00:01:58 Duration |
|
|
Lecture 5 | Rounding Numbers with ROUND() | 00:02:06 Duration |
Section 21 : SQL SQL JOINs
|
|
Lecture 1 | What are JOINs | 00:04:23 Duration |
|
|
Lecture 2 | The Functionality of INNER JOIN - Part I | 00:06:03 Duration |
|
|
Lecture 3 | The Functionality of INNER JOIN - Part II | 00:05:34 Duration |
|
|
Lecture 4 | Extra Info on Using Joins | 00:04:10 Duration |
|
|
Lecture 5 | Duplicate Rows | 00:04:21 Duration |
|
|
Lecture 6 | The Functionality of LEFT JOIN - Part I | 00:04:31 Duration |
|
|
Lecture 7 | The Functionality of LEFT JOIN - Part II | 00:05:46 Duration |
|
|
Lecture 8 | The Functionality of RIGHT JOIN | 00:04:31 Duration |
|
|
Lecture 9 | Differences between the New and the Old Join Synta | 00:04:18 Duration |
|
|
Lecture 10 | Using JOIN and WHERE Together | 00:02:54 Duration |
|
|
Lecture 11 | The Functionality of CROSS JOIN | 00:07:42 Duration |
|
|
Lecture 12 | Combining Aggregate Functions with Joins | |
|
|
Lecture 13 | JOIN More than Two Tables | 00:04:27 Duration |
|
|
Lecture 14 | The Differences Between UNION and UNION ALL | 00:05:45 Duration |
Section 22 : SQL SQL Subqueries
|
|
Lecture 1 | SQL Subqueries with IN Embedded Inside WHERE | 00:04:32 Duration |
|
|
Lecture 2 | SQL Subqueries with EXISTS-NOT EXISTS Embedded Ins | 00:03:43 Duration |
|
|
Lecture 3 | SQL Subqueries Nested in SELECT and FROM | 00:07:57 Duration |
Section 23 : SQL Stored Routines
|
|
Lecture 1 | Defining Stored Routines | 00:03:26 Duration |
|
|
Lecture 2 | Create Stored Procedures with MySQL Syntax | 00:04:32 Duration |
|
|
Lecture 3 | An Example of Stored Procedures Part I | 00:04:32 Duration |
|
|
Lecture 4 | An Example of Stored Procedures Part II | 00:04:49 Duration |
|
|
Lecture 5 | Creating a Procedure in MySQL Another Way | 00:03:19 Duration |
|
|
Lecture 6 | Create Stored Procedures with an Input Parameter | 00:03:54 Duration |
|
|
Lecture 7 | Create Stored Procedures with an Output Parameter | 00:03:20 Duration |
|
|
Lecture 8 | SQL Variables | 00:06:50 Duration |
|
|
Lecture 9 | The Benefit of User-Defined Functions in MySQL | 00:06:14 Duration |
|
|
Lecture 10 | Concluding Stored Routines | 00:03:55 Duration |
Section 24 : SQL The CASE Statement
|
|
Lecture 1 | The SQL CASE Statement | 00:05:57 Duration |
Section 25 : Part 4 Introduction to Tableau
|
|
Lecture 1 | Why Use Tableau- Make Your Data Make an Impact | 00:04:23 Duration |
|
|
Lecture 2 | Let's Download Tableau Public | 00:02:03 Duration |
|
|
Lecture 3 | Connecting Data in Tableau | 00:01:04 Duration |
|
|
Lecture 4 | Let's Create our first Chart in Tableau! | 00:07:12 Duration |
Section 26 : Tableau Tableau functionalities
|
|
Lecture 1 | Duplicating a Sheet | 00:02:49 Duration |
|
|
Lecture 2 | Creating a Table | 00:04:49 Duration |
|
|
Lecture 3 | Creating Custom Fields | 00:02:29 Duration |
|
|
Lecture 4 | Creating a Custom Field and Adding Calculations to | 00:03:41 Duration |
|
|
Lecture 5 | Adding Totals and Subtotals | 00:02:03 Duration |
|
|
Lecture 6 | Adding a Custom Calculation | 00:03:12 Duration |
|
|
Lecture 7 | Inserting a Filter | 00:02:21 Duration |
|
|
Lecture 8 | Working with Joins in Tableau | 00:04:33 Duration |
|
|
Lecture 9 | Working with Joins in Tableau | 00:04:33 Duration |
Section 27 : Tableau The Tableau Exercise
|
|
Lecture 1 | Introduction to the Exercise | 00:02:06 Duration |
|
|
Lecture 2 | Let's Create a Dashboard - Visualizing the Three C | |
|
|
Lecture 3 | Using Joins in Tableau | 00:05:16 Duration |
|
|
Lecture 4 | Performing a Numbers Check - Attempt #1 | 00:03:49 Duration |
|
|
Lecture 5 | Blending Data in Tableau | 00:05:49 Duration |
|
|
Lecture 6 | Performing a Numbers Check - Attempt #2 | 00:03:41 Duration |
|
|
Lecture 7 | First Chart | 00:04:05 Duration |
|
|
Lecture 8 | Second Chart | 00:03:07 Duration |
|
|
Lecture 9 | Third Chart | 00:02:39 Duration |
|
|
Lecture 10 | Creating and Formatting a Dashboard | 00:04:26 Duration |
|
|
Lecture 11 | Adding Interactive Filters for Improved Analysis | 00:03:55 Duration |
|
|
Lecture 12 | Interactive Filters - fix | 00:01:38 Duration |
Section 28 : Part 5CombiningSQLandTableau Introduction
|
|
Lecture 1 | Introduction to Software Integration | 00:05:20 Duration |
|
|
Lecture 2 | Combining SQL and Tableau | 00:04:51 Duration |
|
|
Lecture 3 | Loading the Database | 00:01:24 Duration |
Section 29 : CombiningSQLandTableauProblem 1
|
|
Lecture 1 | Problem 1- Task | 00:03:16 Duration |
|
|
Lecture 2 | Problem 1- Solution in SQL | 00:04:42 Duration |
|
|
Lecture 3 | Exporting Your Output from SQL and Loading it in T | 00:04:13 Duration |
|
|
Lecture 4 | Chart 1- Visualizing the Solution in Tableau - Pa | 00:06:18 Duration |
|
|
Lecture 5 | Chart 1- Visualizing the Solution in Tableau - Par | 00:05:25 Duration |
Section 30 : CombiningSQLandTableauProblem 2
|
|
Lecture 1 | Problem 2- Task | 00:03:50 Duration |
|
|
Lecture 2 | Problem 2- Solution in SQL | 00:03:43 Duration |
|
|
Lecture 3 | Chart 2- Visualizing the Solution in Tableau | 00:06:09 Duration |
Section 31 : CombiningSQLandTableauProblem 3
|
|
Lecture 1 | Problem 3- Task | 00:02:21 Duration |
|
|
Lecture 2 | Problem 3- Solution in SQL | 00:03:15 Duration |
|
|
Lecture 3 | Chart 3- Visualizing the Solution in Tableau | 00:04:57 Duration |
Section 32 : Combining SQL andTableauProblem 4
|
|
Lecture 1 | Problem 4- Task | 00:02:46 Duration |
|
|
Lecture 2 | Problem 4- Solution in SQL | 00:02:48 Duration |
|
|
Lecture 3 | Chart 4- Visualizing the Solution in Tableau | 00:03:22 Duration |
Section 33 : CombiningSQLandTableauProblem 5
|
|
Lecture 1 | Problem 5- Organizing Charts 1-4 into a Beautiful | 00:06:04 Duration |
Section 34 : Part 6 Introduction toProgrammingwithPython
|
|
Lecture 1 | A 5-minute explanation of Programming | 00:05:04 Duration |
|
|
Lecture 2 | Why use Python | 00:05:11 Duration |
|
|
Lecture 3 | Why use Jupyter | 00:03:29 Duration |
|
|
Lecture 4 | How to Install Python and Jupyter | 00:06:49 Duration |
|
|
Lecture 5 | Understanding Jupyter’s Interface – Dashboard | 00:03:16 Duration |
|
|
Lecture 6 | Understanding Jupyter’s Interface – Prerequisites | 00:06:15 Duration |
|
|
Lecture 7 | Python 2 vs Python 3 | 00:02:47 Duration |
Section 35 : Python Python Variables andData Types
|
|
Lecture 1 | Python Variables | 00:04:52 Duration |
|
|
Lecture 2 | Understanding Numbers and Boolean Values | 00:03:06 Duration |
|
|
Lecture 3 | Strings | 00:05:44 Duration |
Section 36 : PythonPythonSyntaxFundamentals
|
|
Lecture 1 | The Arithmetic Operators of Python | 00:03:24 Duration |
|
|
Lecture 2 | What is the Double Equality Sign | 00:01:34 Duration |
|
|
Lecture 3 | How to Reassign Values | 00:01:08 Duration |
|
|
Lecture 4 | How to Add Comments | 00:01:25 Duration |
|
|
Lecture 5 | Understanding Line Continuation | 00:00:50 Duration |
|
|
Lecture 6 | How to Index Elements | 00:01:18 Duration |
|
|
Lecture 7 | How to Structure Your Code with Indentation | 00:01:45 Duration |
Section 37 : Python Other Python Operators
|
|
Lecture 1 | Python's Comparison Operators | 00:02:10 Duration |
|
|
Lecture 2 | Python's Logical and Identity Operator | 00:05:36 Duration |
Section 38 : Python Conditional Statements
|
|
Lecture 1 | Getting to know the IF Statement | 00:03:04 Duration |
|
|
Lecture 2 | Adding an ELSE statement | 00:02:39 Duration |
|
|
Lecture 3 | Else if, for Brief – ELIF | 00:05:33 Duration |
|
|
Lecture 4 | An Additional Explanation of Boolean Values | 00:02:13 Duration |
Section 39 : Python Functions
|
|
Lecture 1 | How to Define a Function in Python | 00:02:03 Duration |
|
|
Lecture 2 | How to Create a Function with a Paramete | 00:03:49 Duration |
|
|
Lecture 3 | Define a Function in Another Way | 00:02:35 Duration |
|
|
Lecture 4 | How to use a Function within a Function | 00:01:49 Duration |
|
|
Lecture 5 | Use Conditional Statements and Functions Together | 00:03:07 Duration |
|
|
Lecture 6 | How to Create Functions Which Contain a Few Argume | 00:01:14 Duration |
|
|
Lecture 7 | Built-In Functions in Python Worth Knowing | 00:03:56 Duration |
Section 40 : Python Python Sequences
|
|
Lecture 1 | Introduction to Lists | 00:04:02 Duration |
|
|
Lecture 2 | Using Methods in Python | 00:03:22 Duration |
|
|
Lecture 3 | What is List Slicing | 00:04:31 Duration |
|
|
Lecture 4 | Working with Tuples | 00:03:13 Duration |
|
|
Lecture 5 | Python Dictionaries | 00:04:04 Duration |
Section 41 : Python Using Iterations
|
|
Lecture 1 | Using For Loops | 00:02:27 Duration |
|
|
Lecture 2 | Using While Loops and Incrementing | 00:02:27 Duration |
|
|
Lecture 3 | Use the range() Function to Create Lists | 00:02:23 Duration |
|
|
Lecture 4 | Combine Conditional Statements and Loops | 00:03:06 Duration |
|
|
Lecture 5 | All In – Conditional Statements, Functions, and Lo | 00:02:27 Duration |
|
|
Lecture 6 | How to Iterate over Dictionaries | 00:03:08 Duration |
