The Business Intelligence Analyst Course 2024
Loại khoá học: Operations
The skills you need to become a BI Analyst - Statistics, Database theory, SQL, Tableau – Everything is included
Mô tả
Hi! Welcome to The Business Intelligence Analyst Course, the only course you need to become a BI Analyst.
We are proud to present you this one-of-a-kind opportunity. There are several online courses teaching some of the skills related to the BI Analyst profession. The truth of the matter is that none of them completely prepare you.
Our program is different than the rest of the materials available online.
It is truly comprehensive. The Business Intelligence Analyst Course comprises of several modules:
Introduction to Data and Data Science
Statistics and Excel
Database theory
SQL
Tableau
SQL + Tableau
These are the precise technical skills recruiters are looking for when hiring BI Analysts. And today, you have the chance of acquiring an invaluable advantage to get ahead of other candidates. This course will be the secret to your success. And your success is our success, so let’s make it happen!
Here are some more details of what you get with The Business Intelligence Analyst Course:
Introduction to Data and Data Science – Make sense of terms like business intelligence, traditional and big data, traditional statistical methods, machine learning, predictive analytics, supervised learning, unsupervised learning, reinforcement learning, and many more;
Statistics and Excel – Understand statistical testing and build a solid foundation. Modern software packages and programming languages are automating most of these activities, but this part of the course gives you something more valuable – critical thinking abilities;
Database theory – Before you start using SQL, it is highly beneficial to learn about the underlying database theory and acquire an understanding of why databases are created and how they can help us manage data
SQL - when you can work with SQL, it means you don’t have to rely on others sending you data and executing queries for you. You can do that on your own. This allows you to be independent and dig deeper into the data to obtain the answers to questions that might improve the way your company does its business
Tableau – one of the most powerful and intuitive data visualization tools available out there. Almost all large companies use such tools to enhance their BI capabilities. Tableau is the #1 best-in-class solution that helps you create powerful charts and dashboards
Learning a programming language is meaningless without putting it to use. That’s why we integrate SQL and Tableau, and perform several real-life Business Intelligence tasks
Sounds amazing, right?
Our courses are unique because our team works hard to:
Pre-script the entire content
Work with real-life examples
Provide easy to understand and complete explanations
Create beautiful and engaging animations
Prepare exercises, course notes, quizzes, and other materials that will enhance your course taking experience
Be there for you and provide support whenever necessary
We love teaching and we are really excited about this journey. It will get your foot in the door of an exciting and rising profession. Don’t hesitate and subscribe today. The only regret you will have is that you didn’t find this course sooner!
Bạn sẽ học được gì
Yêu cầu
Nội dung khoá học
52 sections
What Does the Course Cover
03:38
Download All Resources
00:14
Why Are There So Many Business and Data Science Buzzwords?
05:21
Analysis vs Analytics
03:50
Intro to Business Analytics, Data Analytics, and Data Science
08:26
Intro to Business Analytics, Data Analytics, and Data Science
5 questions
Adding Business Intelligence (BI), Machine Learning (ML), and AI to the Picture
09:31
Adding Business Intelligence (BI), Machine Learning (ML), and AI to the Picture
2 questions
An Overview of our Data Science Infographic
04:03
An Overview of our Data Science Infographic
1 question
When are Traditional data, Big Data, BI, Traditional Data Science and ML applied
07:19
When are Traditional data, Big Data, BI, Traditional Data Science and ML applied
1 question
Why do we Need each of these Disciplines?
04:44
Why do we Need each of these Disciplines?
1 question
Traditional Data: Techniques
08:13
Traditional Data: Techniques
1 question
Traditional Data: Real-life Examples
01:44
Big Data: Techniques
04:26
Big Data: Techniques
1 question
Big Data: Real-life Examples
01:32
Business Intelligence (BI): Techniques
06:45
Business Intelligence (BI): Techniques
4 questions
Business Intelligence (BI): Real-life Examples
01:42
Traditional Methods: Techniques
09:08
Traditional Methods: Techniques
4 questions
Traditional Methods: Real-life Examples
02:45
Machine Learning (ML): Techniques
06:55
Machine Learning (ML): Techniques
2 questions
Machine Learning (ML): Types of Machine Learning
08:13
Machine Learning (ML): Types of Machine Learning
2 questions
Machine Learning (ML): Real-life Examples
02:11
Machine Learning (ML): Real-life Examples
5 questions
Programming Languages & Software Employed in Data Science - All the Tools Needed
05:51
Programming Languages & Software Employed in Data Science - All the Tools Needed
4 questions
Data Science Job Positions: What do they Involve and What to Look out for?
03:29
Data Science Job Positions: What do they Involve and What to Look out for?
1 question
Dispelling common Misconceptions
04:10
Dispelling common Misconceptions
1 question
Population vs sample
04:02
Population and Sample
2 questions
Types of Data
04:33
Types of data
2 questions
Levels of Measurement
03:43
Levels of measurement
2 questions
Categorical Variables - Visualization Techniques
04:52
Categorical variables. Visualization Techniques
1 question
Categorical Variables Exercise
00:03
Numerical Variables - Frequency Distribution Table
03:09
Numerical variables. Using a frequency distribution table
1 question
Numerical Variables Exercise
00:03
The Histogram
02:14
The Histogram
1 question
Histogram Exercise
00:03
Cross Table and Scatter Plot
04:44
Cross Tables and Scatter Plots
1 question
Cross Tables and Scatter Plots Exercise
00:03
Mean, median and mode
04:20
Mean, Median and Mode Exercise
00:03
Skewness
02:37
Skewness
1 question
Skewness Exercise
00:03
Variance
05:55
Variance Exercise
00:03
Standard Deviation and Coefficient of Variation
04:40
Standard deviation
1 question
Standard Deviation and Coefficient of Variation Exercise
00:03
Covariance
03:23
Covariance
1 question
Covariance Exercise
00:03
Correlation Coefficient
03:17
Correlation Coefficient
1 question
Correlation Coefficient Exercise
00:03
Practical Example
16:15
Practical Example Exercise
00:03
Introduction
01:00
What is a Distribution
04:33
What is a Distribution
1 question
The Normal Distribution
03:54
The Normal Distribution
1 question
The Standard Normal Distribution
03:30
The Standard Normal Distribution
1 question
The Standard Normal Distribution Exercise
00:03
Central Limit Theorem
04:20
Central Limit Theorem
1 question
Standard error
01:26
Standard error
1 question
Estimators and Estimates
03:07
Estimators and Estimates
1 question
What are Confidence Intervals?
02:41
What are Confidence Intervals?
1 question
Confidence Intervals; Population Variance Known; z-score
08:01
Confidence Intervals; Population Variance Known; z-score Exercise
00:03
Confidence interval clarifications
04:38
Student's T Distribution
03:22
Student's T Distribution
1 question
Confidence Intervals; Population Variance Unknown; t-score
04:36
Confidence Intervals; Population Variance Unknown; t-score Exercise
00:03
Margin of Error
04:52
Margin of Error
1 question
Confidence intervals. Two means. Dependent samples
06:04
Confidence intervals. Two means. Dependent samples Exercise
00:03
Confidence intervals. Two means. Independent samples (Part 1)
04:31
Confidence intervals. Two means. Independent samples (Part 1) Exercise
00:03
Confidence intervals. Two means. Independent samples (Part 2)
03:57
Confidence intervals. Two means. Independent samples (Part 2) Exercise
00:03
Confidence intervals. Two means. Independent samples (Part 3)
01:27
Practical Example: Inferential Statistics
10:05
Practical Example: Inferential Statistics Exercise
00:03
The Null vs Alternative Hypothesis
05:51
Further Reading on Null and Alternative Hypothesis
01:16
The Null vs Alternative Hypothesis
3 questions
Rejection Region and Significance Level
07:05
Rejection Region and Significance Level
2 questions
Type I Error and Type II Error
04:14
Type I Error and Type II Error
4 questions
Test for the Mean. Population Variance Known
06:34
Test for the Mean. Population Variance Known Exercise
00:03
p-value
04:13
p-value
4 questions
Test for the Mean. Population Variance Unknown
04:48
Test for the Mean. Population Variance Unknown Exercise
00:03
Test for the Mean. Dependent Samples
05:18
Test for the Mean. Dependent Samples Exercise
00:03
Test for the mean. Independent samples (Part 1)
04:22
Test for the mean. Independent samples (Part 1). Exercise
00:03
Test for the mean. Independent samples (Part 2)
04:26
Test for the mean. Independent samples (Part 2)
1 question
Test for the mean. Independent samples (Part 2)
00:03
Practical Example: Hypothesis Testing
07:16
Practical Example: Hypothesis Testing Exercise
00:03
Why use SQL?
03:17
Why use SQL?
2 questions
Why use MySQL?
01:57
Why use MySQL?
1 question
Introducing Databases
04:44
Introducing Databases
2 questions
Relational Database Fundamentals
04:51
Relational Database Fundamentals
2 questions
Comparing Databases and Spreadsheets
07:05
Comparing Databases and Spreadsheets
2 questions
Important Database Terminology
04:17
Important Database Terminology
1 question
The Concept of Relational Schemas: Primary Key
04:55
The Concept of Relational Schemas: Primary Key
1 question
The Concept of Relational Schemas: Foreign Key
04:58
The Concept of Relational Schemas: Foreign Key
1 question
The Concept of Relational Schemas: Unique Key and Null Values
03:07
The Concept of Relational Schemas: Unique Key
1 question
The Concept of Relational Schemas: Relationships Between Tables
04:39
The Concept of Relational Schemas: Relationships Between Tables
1 question
Installing MySQL Workbench and Server
10:48
Installing Visual C
00:21
Installing MySQL on macOS and Unix systems
01:24
The Client-Server Model
00:00
Linking GUI with the MySQL Server
02:34
Read me!!!
00:44
Creating a New User and a New Connection to it
06:18
Familiarize Yourself with the MySQL Interface
04:53
SQL Fundamentals - MySQL Session and Databases
08:31
SQL Fundamentals - DROP, CREATE, SELECT, INSERT, DELETE
04:36
Coding Tips and Best Practices - I
05:34
Coding Tips and Best Practices - I
1 question
Coding Tips and Best Practices - II
04:12
Coding Tips and Best Practices - II
2 questions
Loading the 'employees' Database
02:05
Loading the 'employees' Database
00:37
Using SELECT - FROM
04:57
Using SELECT - FROM - Exercise
00:04
Using SELECT - FROM - Solution
00:01
Using WHERE
02:30
Using WHERE - Exercise
00:03
Using WHERE - Solution
00:01
Using AND
02:14
Using AND - Exercise
00:03
Using AND - Solution
00:02
Using OR
03:35
Using OR - Exercise
00:03
Using OR - Solution
00:02
Operator Precedence and Logical Order
03:34
Operator Precedence and Logical Order - Exercise
00:03
Operator Precedence and Logical Order - Solution
00:03
Using IN - NOT IN
03:12
Using IN - NOT IN - Exercise 1
00:05
Using IN - NOT IN - Solution 1
00:02
Using IN - NOT IN - Exercise 2
00:04
Using IN - NOT IN - Solution 2
00:02
Using LIKE - NOT LIKE
03:36
Using LIKE - NOT LIKE - Exercise
00:16
Using LIKE - NOT LIKE - Solution
00:05
Using Wildcard Characters
01:44
Using Wildcard characters - Exercise
00:07
Using Wildcard characters - Solution
00:03
Using BETWEEN - AND
02:19
Using BETWEEN - AND - Exercise
00:11
Using BETWEEN - AND - Solution
00:08
Using IS NOT NULL - IS NULL
01:37
Using IS NOT NULL - IS NULL - Exercise
00:03
Using IS NOT NULL - IS NULL - Solution
00:02
Using Other Comparison Operators
04:30
Using Other Comparison Operators - Exercise
00:10
Using Other Comparison Operators - Solution
00:03
Using SELECT DISTINCT
02:05
Using SELECT DISTINCT - Exercise
00:13
Using SELECT DISTINCT - Solution
00:01
Getting to Know Aggregate Functions
05:24
Getting to Know Aggregate Functions - Exercise
00:10
Getting to Know Aggregate Functions - Solution
00:02
Using ORDER BY
03:46
Using ORDER BY - Exercise
00:03
Using ORDER BY - Solution
00:01
Using GROUP BY
06:00
Using Aliases (AS)
02:08
Using Aliases (AS) - Exercise
00:10
Using Aliases (AS) - Solution
00:04
Using HAVING
03:26
Using HAVING - Exercise
00:13
Using HAVING - Solution
00:16
Using WHERE vs HAVING - Part I
04:03
Using WHERE vs HAVING - Part II
03:08
Using WHERE vs HAVING - Part II - Exercise
00:07
Using WHERE vs HAVING - Part II - Solution
00:04
Using LIMIT
04:51
Using LIMIT - Exercise
00:02
Using LIMIT - Solution
00:01
Applying COUNT()
04:01
Applying COUNT() - Exercise
00:04
Applying COUNT() - Solution
00:01
Applying SUM()
01:30
Applying SUM() - Exercise
00:05
Applying SUM() - Solution
00:01
MIN() and MAX()
01:15
MIN() and MAX() - Exercise
00:05
MIN() and MAX() - Solution
00:02
Applying AVG()
01:58
Applying AVG() - Exercise
00:04
Applying AVG() - Solution
00:01
Rounding Numbers with ROUND()
02:06
Rounding Numbers with ROUND() - Exercise
00:06
Rounding Numbers with ROUND() - Solution
00:02
What are JOINs?
04:23
What are JOINs? - Exercise 1
00:13
What are JOINs? - Exercise 2
00:14
The Functionality of INNER JOIN - Part I
06:02
The Functionality of INNER JOIN - Part II
05:33
The Functionality of INNER JOIN - PART II - Exercise
00:04
The Functionality of INNER JOIN - PART II - Solution
00:03
Extra Info on Using Joins
04:09
Duplicate Rows
04:21
The Functionality of LEFT JOIN - Part I
04:31
The Functionality of LEFT JOIN - Part II
05:46
The Functionality of LEFT JOIN - Part II - Exercise
00:13
The Functionality of LEFT JOIN - Part II - Solution
00:06
The Functionality of RIGHT JOIN
04:30
Differences between the New and the Old Join Syntax
04:17
Differences between the New and the Old Join Syntax - Exercise
00:07
Differences between the New and the Old Join Syntax - Solution
00:08
Using JOIN and WHERE Together
02:53
Important – Prevent Error Code: 1055!
01:53
Using JOIN and WHERE Together - Exercise
00:06
Using JOIN and WHERE Together - Solution
00:06
The Functionality of CROSS JOIN
07:42
The Functionality of CROSS JOIN - Exercise 1
00:05
The Functionality of CROSS JOIN - Solution 1
00:04
The Functionality of CROSS JOIN - Exercise 2
00:06
The Functionality of CROSS JOIN - Solution 2
00:04
Combining Aggregate Functions with Joins
02:17
JOIN More than Two Tables
04:26
JOIN More than Two Tables - Exercise
00:04
JOIN More than Two Tables - Solution
00:17
Top Tips for Joins
05:39
Top Tips for Joins - Exercise
00:03
Top Tips for Joins - Solution
00:03
The Differences Between UNION and UNION ALL
05:44
The Differences Between UNION and UNION ALL - Exercise
00:07
The Differences Between UNION and UNION ALL - Solution
00:10
SQL Subqueries with IN Embedded Inside WHERE
04:31
SQL Subqueries with IN Embedded Inside WHERE - Exercise
00:05
SQL Subqueries with IN Embedded Inside WHERE - Solution
00:04
SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE
03:42
SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE - Exercise
00:05
SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE - Solution
00:04
SQL Subqueries Nested in SELECT and FROM
07:56
SQL Subqueries Embedded in SELECT and FROM - Exercise 1
00:06
SQL Subqueries Embedded in SELECT and FROM - Exercise 2
00:38
SQL Subqueries Nested in SELECT and FROM - Solution 2
00:00
Defining Stored Routines
03:25
Defining Stored Routines
1 question
Create Stored Procedures with MySQL Syntax
04:32
An Example of Stored Procedures Part I
02:45
An Example of Stored Procedures Part II
04:48
An Example of Stored Procedures Part II - Exercise
00:04
An Example of Stored Procedures Part II - Solution
00:04
Creating a Procedure in MySQL Another Way
03:19
Create Stored Procedures with an Input Parameter
06:29
Create Stored Procedures with an Output Parameter
03:19
Create Stored Procedures with an Output Parameter - Exercise
00:05
Stored Procedures with an Output Parameter - Solution
00:07
SQL Variables
06:50
SQL Variables - Exercise
00:10
SQL Variables - Solution
00:02
The Benefit of User-Defined Functions in MySQL
06:14
Error Code: 1418.
01:50
The Benefit of User-Defined Functions in MySQL - Exercise
00:16
The Benefit of User-Defined Functions in MySQL - Solution
00:16
Concluding Stored Routines
03:55
Concluding Stored Routines
1 question
The SQL CASE Statement
05:57
The SQL CASE Statement - Exercise 1
00:14
THE SQL CASE Statement - Solution 1
00:07
THE SQL CASE Statement - Exercise 2
00:14
THE SQL CASE Statement - Solution 2
00:24
THE SQL CASE Statement - Exercise 3
00:15
THE SQL CASE Statement - Solution 3
00:08
Introduction to MySQL Window Functions
01:58
The ROW_NUMBER() Ranking Window Function and the Relevant MySQL Syntax
09:11
The ROW_NUMBER Ranking Window Function - Exercise
00:24
The ROW_NUMBER Ranking Window Function - Solution
00:06
A Note on Using Several Window Functions in a Query
02:41
A Note on Using Several Window Functions in a Query - Exercise
01:09
A Note on Using Several Window Functions in a Query - Solution
00:18
MySQL Window Functions Syntax
03:51
MySQL Window Functions Syntax - Exercise
00:16
MySQL Window Functions Syntax - Solution
00:04
The PARTITION BY Clause vs the GROUP BY Clause
06:28
The PARTITION BY Clause vs the GROUP BY Clause - Exercise
01:17
The PARTITION BY Clause vs the GROUP BY Clause - Solution
00:32
The MySQL RANK() and DENSE_RANK() Window Functions
07:54
The MySQL RANK() and DENSE_RANK() Window Functions - Exercise
00:44
The MySQL RANK() and DENSE_RANK() Window Functions - Solution
00:21
Working with MySQL Ranking Window Functions and Joins Together
08:26
Working with MySQL Ranking Window Functions and Joins Together - Exercise
00:40
Working with MySQL Ranking Window Functions and Joins Together - Solution
00:22
The LAG() and LEAD() Value Window Functions
08:35
The LAG() and LEAD() Value Window Functions - Exercise
00:59
The LAG() and LEAD() Value Window Functions - Solution
00:19
MySQL Aggregate Functions in the Context of Window Functions - Part I
06:13
MySQL Aggregate Functions in the Context of Window Functions - Part I-Exercise
00:12
MySQL Aggregate Functions in the Context of Window Functions - Part I-Solution
00:08
MySQL Aggregate Functions in the Context of Window Functions - Part II
06:47
MySQL Aggregate Functions in the Context of Window Functions - Part II-Exercise
01:03
MySQL Aggregate Functions in the Context of Window Functions - Part II-Solution
00:31
MySQL Common Table Expressions - Introduction
06:59
An Alternative Solution to the Same Task
01:53
An Alternative Solution to the Same Task-Exercise
00:47
An Alternative Solution to the Same Task-Solution
00:46
Using Multiple Subclauses in a WITH Clause - Part I
05:32
Using Multiple Subclauses in a WITH Clause - Part II
05:19
Using Multiple Subclauses in a WITH Clause-Exercise
00:24
Using Multiple Subclauses in a WITH Clause-Solution
00:42
Referring to Common Table Expressions in a WITH Clause
03:59
MySQL Temporary Tables - Introduction
03:08
MySQL Temporary Tables in Action
05:12
MySQL Temporary Tables in Action-Exercise
00:10
MySQL Temporary Tables in Action-Solution
00:07
Other Features of MySQL Temporary Tables
07:22
Other Features of MySQL Temporary Tables-Exercise
00:40
Other Features of MySQL Temporary Tables-Solution
00:19
Why Use Tableau: Make Your Data Make an Impact
04:23
Let's Download Tableau Public
02:03
Connecting Data in Tableau
02:19
Exploring Tableau's Interface
09:26
Let's Create our first Chart in Tableau!
07:12
Duplicating a Sheet
02:49
Creating a Table
05:23
Creating Custom Fields
02:28
Creating a Custom Field and Adding Calculations to a Table
03:41
Adding Totals and Subtotals
02:03
Adding a Custom Calculation
03:12
Inserting a Filter
02:21
Working with Joins in Tableau
04:33
Introduction to the Exercise
02:05
Let's Create a Dashboard - Visualizing the Three Charts We Want to Create
01:56
Using Joins in Tableau
06:10
Performing a Numbers Check - Attempt #1
03:48
Blending Data in Tableau
05:49
Performing a Numbers Check - Attempt #2
04:02
First Chart
04:05
Second Chart
03:07
Third Chart
02:39
Creating and Formatting a Dashboard
04:26
Adding Interactive Filters for Improved Analysis
03:54
Interactive Filters - fix
01:38
Introduction to Software Integration
05:20
Combining SQL and Tableau
04:51
Loading the Database
03:22
Loading the Database
00:23
Problem 1: Task
05:33
Problem 1: Task - Text
00:05
Important clarification!
00:50
Problem 1: Solution in SQL
04:41
Problem 1: Solution in SQL - Code
00:05
Exporting Your Output from SQL and Loading it in Tableau
04:13
Chart 1: Visualizing the Solution in Tableau - Part I
06:17
Chart 1: Visualizing the Solution in Tableau - Part II
05:25
Problem 2: Task
03:49
Problem 2: Task - Text
00:05
Problem 2: Solution in SQL
03:43
Problem 2: Solution in SQL - Code
00:12
Chart 2: Visualizing the Solution in Tableau
06:08
Problem 3: Task
02:21
Problem 3: Task - Text
00:07
Problem 3: Solution in SQL
03:14
Problem 3: Solution in SQL - Code
00:09
Chart 3: Visualizing the Solution in Tableau
04:56
Problem 4: Task
02:45
Problem 4: Task - Text
00:13
Problem 4: Solution in SQL
02:47
Problem 4: Solution in SQL - Code
00:13
Chart 4: Visualizing the Solution in Tableau
03:22
Problem 5: Organizing Charts 1-4 into a Beautiful Dashboard
06:04
A 5-minute explanation of Programming
05:04
A 5-minute explanation of Programming
2 questions
Why use Python?
05:11
Why Use Python?
2 questions
Why use Jupyter?
03:29
Why Use Jupyter?
2 questions
How to Install Python and Jupyter
06:49
Understanding Jupyter’s Interface – Dashboard
03:15
Understanding Jupyter’s Interface – Prerequisites for Coding
06:15
Understanding Jupyter's Interface
3 questions
Python 2 vs Python 3
02:46
Python Variables
04:52
Python Variables - Exercise #1
1 question
Python Variables - Exercise #2
1 question
Python Variables - Exercise #3
1 question
Python Variables - Exercise #4
1 question
Python Variables
1 question
Understanding Numbers and Boolean Values
03:05
Numbers and Boolean Values - Exercise #1
1 question
Numbers and Boolean Values - Exercise #2
1 question
Numbers and Boolean Values - Exercise #3
1 question
Numbers and Boolean Values - Exercise #4
1 question
Numbers and Boolean Values - Exercise #5
1 question
Understanding Numbers and Boolean Values
1 question
Strings
11:20
Strings - Exercise #1
1 question
Strings - Exercise #2
1 question
Strings - Exercise #3
1 question
Strings - Exercise #4
1 question
Strings - Exercise #5
1 question
Strings
3 questions
The Arithmetic Operators of Python
03:23
The Arithmetic Operators in Python - Exercise #1
1 question
The Arithmetic Operators in Python - Exercise #2
1 question
The Arithmetic Operators in Python - Exercise #3
1 question
The Arithmetic Operators in Python - Exercise #4
1 question
The Arithmetic Operators in Python - Exercise #5
1 question
The Arithmetic Operators in Python - Exercise #6
1 question
The Arithmetic Operators in Python - Exercise #7
1 question
The Arithmetic Operators in Python - Exercise #8
1 question
Using Arithmetic Operators in Python
1 question
What is the Double Equality Sign?
01:33
What is the Double Equality Sign? - Exercise #1
1 question
What is the Double Equality Sign?
1 question
How to Reassign Values
01:08
How to Reassign Values - Exercise #1
1 question
How to Reassign Values - Exercise #2
1 question
How to Reassign Values - Exercise #3
1 question
How to Reassign Values - Exercise #4
1 question
How to Reassign Values
1 question
How to Add Comments
03:20
How to Add Comments
1 question
Understanding Line Continuation
00:49
Understanding Line Continuation - Exercise #1
1 question
How to Index Elements
01:18
How to Index Elements - Exercise #1
1 question
How to Index Elements - Exercise #2
1 question
How to Index Elements
1 question
How to Structure Your Code with Indentation
03:42
How to Structure Your Code with Indentation - Exercise #1
1 question
How to Structure Your Code with Indentation
1 question
Python's Comparison Operators
02:10
Python's Comparison Operators - Exercise #1
1 question
Python's Comparison Operators - Exercise #2
1 question
Python's Comparison Operators - Exercise #3
1 question
Python's Comparison Operators - Exercise #4
1 question
Python's Comparison Operators
2 questions
Python's Logical and Identity Operators
05:35
Python's Logical and Identity Operators - Exercise #1
1 question
Python's Logical and Identity Operators - Exercise #2
1 question
Python's Logical and Identity Operators - Exercise #3
1 question
Python's Logical and Identity Operators - Exercise #4
1 question
Python's Logical and Identity Operators - Exercise #5
1 question
Python's Logical and Identity Operators - Exercise #6
1 question
Python's Logical and Identity Operators
2 questions
Getting to know the IF Statement
06:13
The IF Statement - Exercise #1
1 question
The IF Statement - Exercise #2
1 question
Getting to know the IF Statement
1 question
Adding an ELSE statement
05:37
The ELSE Statement - Exercise #1
1 question
Else if, for Brief – ELIF
11:16
The ELIF Statement - Exercise #1
1 question
The ELIF Statement - Exercise #2
1 question
An Additional Explanation of Boolean Values
04:38
An Additional Explanation of Boolean Values
1 question
How to Define a Function in Python
04:19
How to Create a Function with a Parameter
07:58
How to Create a Function with a Parameter - Exercise #1
1 question
How to Create a Function with a Parameter - Exercise #2
1 question
Define a Function in Another Way
05:29
Define a Function in Another Way - Exercise #1
1 question
How to Use a Function within a Function
01:49
How to Use a Function within a Function - Exercise #1
1 question
Use Conditional Statements and Functions Together
03:06
Conditional Statements and Functions - Exercise #1
1 question
How to Create Functions Which Contain a Few Arguments
02:48
Built-In Functions in Python Worth Knowing
03:56
Built-In Function in Python Worth Knowing - Exercise #1
1 question
Built-In Function in Python Worth Knowing - Exercise #2
1 question
Built-In Function in Python Worth Knowing - Exercise #3
1 question
Built-In Function in Python Worth Knowing - Exercise #4
1 question
Built-In Function in Python Worth Knowing - Exercise #5
1 question
Built-In Function in Python Worth Knowing - Exercise #6
1 question
Built-In Function in Python Worth Knowing - Exercise #7
1 question
Built-In Function in Python Worth Knowing - Exercise #8
1 question
Built-In Function in Python Worth Knowing - Exercise #9
1 question
Python - Functions
2 questions
Introduction to Lists
08:18
Introduction to Lists - Exercise #1
1 question
Introduction to Lists - Exercise #2
1 question
Introduction to Lists - Exercise #3
1 question
Introduction to Lists - Exercise #4
1 question
Introduction to Lists - Exercise #5
1 question
Introduction to Lists
1 question
Using Methods in Python
06:54
Using Methods in Python - Exercise #1
1 question
Using Methods in Python - Exercise #2
1 question
Using Methods in Python - Exercise #3
1 question
Using Methods in Python - Exercise#4
1 question
Using Methods in Python
1 question
What is List Slicing?
04:30
What is List Slicing? - Exercise #1
1 question
What is List Slicing? - Exercise #2
1 question
What is List Slicing? - Exercise #3
1 question
What is List Slicing? - Exercise #4
1 question
What is List Slicing? - Exercise #5
1 question
What is List Slicing? - Exercise #6
1 question
What is List Slicing? - Exercise #7
1 question
Working with Tuples
06:40
Working with Tuples - Exercise #1
1 question
Working with Tuples - Exercise #2
1 question
Working with Tuples - Exercise #3
1 question
Working with Tuples - Exercise #4
1 question
Python Dictionaries
08:27
Python Dictionaries - Exercise #1
1 question
Python Dictionaries - Exercise #2
1 question
Python Dictionaries - Exercise #3
1 question
Python Dictionaries - Exercise #4
1 question
Python Dictionaries - Exercise #5
1 question
Python Dictionaries - Exercise #6
1 question
Python Dictionaries
1 question
Using For Loops
05:40
Using For Loops - Exercise #1
1 question
Using For Loops - Exercise #2
1 question
Using For Loops
1 question
Using While Loops and Incrementing
05:10
Using While Loops and Incrementing - Exercise #1
1 question
Use the range() Function to Create Lists
06:22
Use the range() Function to Create Lists - Exercise - #1
1 question
Use the range() Function to Create Lists - Exercise - #2
1 question
Use the range() Function to Create Lists - Exercise - #3
1 question
Use the range() Function to Create Lists
1 question
Combine Conditional Statements and Loops
06:30
Conditional Statements and Loops - Exercise #1
1 question
Conditional Statements and Loops - Exercise #2
1 question
Conditional Statements and Loops - Exercise #3
1 question
All In – Conditional Statements, Functions, and Loops
02:27
All In - Conditional Statements, Functions, and Loops - Exercise #1
1 question
How to Iterate over Dictionaries
06:21
How to Iterate over Dictionaries - Exercise #1
1 question
How to Iterate over Dictionaries - Exercise #2
1 question
Introduction to Object Oriented Programming (OOP)
05:00
Introduction to Object Oriented Programming (OOP)
2 questions
Using Modules and Packages
01:05
Using Modules and Packages
2 questions
What is the Standard Library?
02:47
What is the Standard Library?
1 question
How to Import Modules in Python
04:04
How to Import Modules in Python
2 questions
Getting Started with Data, Servers, Clients, Requests, and Responses
04:43
Getting Started with Data, Servers, Clients, Requests, and Responses
2 questions
Getting Started with Data Connectivity, APIs, and Endpoints
07:05
Getting Started with Data Connectivity, APIs, and Endpoints
2 questions
Become Better Acquainted with APIs
08:05
Become Better Acquainted with APIs
2 questions
Communication through Text Files
04:20
Communication through Text Files
1 question
What is Software Integration and How is it Applied?
05:25
What is Software Integration and How is it Applied?
2 questions
Solving a Business Exercise with Python, SQL, and Tableau
04:08
Presenting the Task: Absenteeism at Work
02:48
Presenting the Data Set
03:18
Presenting the Data Set
1 question
How is the Content in the Next Sections Organized?
01:28
How to Import the Data Set in Python
03:23
Exploring the Data Set
05:53
Programming vs the Rest of the World
03:27
A Brief Summary of Regression Analysis
01:50
The Approach we will Take to Solve this Exercise
02:17
Dropping Variables We Don't Need
06:27
EXERCISE - Dropping Variables We Don't Need
00:26
SOLUTION - Dropping Variables We Don't Need
00:01
A Deeper Look at the 'Reasons for Absence' Column
05:04
Splitting a Variable into Multiple Dummy Variables
08:37
EXERCISE - Splitting a Variable into Multiple Dummy Variables
00:04
SOLUTION - Splitting a Variable into Multiple Dummy Variables
00:00
How to Drop a Dummy Variable from the Data Set
01:32
A Statistical Perspective on Dummy Variables
01:28
Categorizing the Various Reasons for Absence
08:35
Concatenation in Python
04:35
EXERCISE - Concatenation in Python
00:04
SOLUTION - Concatenation in Python
00:01
How to Reorder Columns in a DataFrame in Python
01:43
EXERCISE - How to Reorder Columns in a DataFrame in Python
00:06
SOLUTION - How to Reorder Columns in a DataFrame in Python
00:12
Using Checkpoints to Ease Your Work in Jupyter
02:52
EXERCISE - Using Checkpoints to Ease Your Work in Jupyter
00:04
SOLUTION - Using Checkpoints to Ease Your Work in Jupyter
00:00
Analyzing the "Date" Column
07:48
Retrieving the Month Value From the "Date" Column
07:00
Adding the "Day of the Week" Column
03:36
EXERCISE - Dropping Columns
00:37
Analysis of the Next 5 Columns in DF
03:17
Dealing with More Numerical Features which may Behave like Categorical Ones
04:38
A Final Note on this Section
01:59
How to Use the 'absenteeism_module' in Python - Part I
03:50
How to Use the 'absenteeism_module' in Python - Part II
06:23
Creating the 'predicted_outputs' Database in MySQL
06:37
Importing 'pymysql' in Python
02:44
Creating a Connection and Cursor
02:54
EXERCISE - Creating 'df_new_obs'
00:10
Creating the 'predicted_outputs' Table in MySQL
04:52
Executing and SQL SELECT Statement from Python
03:04
Sending Data from Jupyter to Workbench - Part I
06:15
Sending Data from Jupyter to Workbench - Part II
06:35
Sending Data from Jupyter to Workbench - Part III
02:45
EXERCISE - Age vs Probability
00:14
Using Tableau to Analyze Age vs Probability
08:49
EXERCISE - Reasons vs Probability
00:15
Using Tableau to Analyze Reasons vs Probability
07:49
EXERCISE - Transportation Expense vs Probability
00:22
Using Tableau to Analyze Transportation Expense vs Probability
06:00
Completing 100%
00:59
Viết Bình Luận
Khoá học liên quan
Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!
Get khoá học giá rẻ ngay trước khi bị fix.
Đánh giá của học viên
Bình luận khách hàng