Course Overview
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:
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 enrol today. The only regret you will have is that you didn’t find this course sooner!
FAQ
FAQ area empty
Course curriculum
Chương 1 Part 1: Introduction 2 bài · 4 phút
Chương 2 Intro to Data and Data Science - The Different Data Science Fields 11 bài · 39 phút
- Why Are There So Many Business and Data Science Buzzwords? Học thử 5:21
- Analysis vs Analytics Học thử 3:50
- Intro to Business Analytics, Data Analytics, and Data Science Học thử 6:39
- Intro to Business Analytics, Data Analytics, and Data Science Học thử
- Adding Business Intelligence (BI), Machine Learning (ML), and AI to the Picture Học thử 9:11
-
Adding Business Intelligence (BI), Machine Learning (ML), and AI to the Picture
-
Traditional AI vs. Generative AI 4:44
-
More Examples of Generative AI 5:09
-
More Examples of Generative AI
-
An Overview of our Data Science Infographic 4:03
-
An Overview of our Data Science Infographic
Chương 3 Intro to Data and Data Science - The Relationship between Different Fields 2 bài · 7 phút
-
When are Traditional data, Big Data, BI, Traditional Data Science and ML applied 7:19
-
When are Traditional data, Big Data, BI, Traditional Data Science and ML applied
Chương 4 Intro to Data and Data Science - What is the Purpose of each Data Science Field 2 bài · 5 phút
-
Why do we Need each of these Disciplines? 4:44
-
Why do we Need each of these Disciplines?
Chương 5 Intro to Data and Data Science - Common Data Science Techniques 19 bài · 60 phút
-
Traditional Data: Techniques 8:13
-
Traditional Data: Techniques
-
Traditional Data: Real-life Examples 1:44
-
Big Data: Techniques 4:26
-
Big Data: Techniques
-
Big Data: Real-life Examples 1:32
-
Business Intelligence (BI): Techniques 6:45
-
Business Intelligence (BI): Techniques
-
Business Intelligence (BI): Real-life Examples 1:42
-
Traditional Methods: Techniques 9:08
-
Traditional Methods: Techniques
-
Traditional Methods: Real-life Examples 3:55
-
Machine Learning (ML): Techniques 6:55
-
Machine Learning (ML): Techniques
-
Machine Learning (ML): Types of Machine Learning 8:05
-
Machine Learning (ML): Types of Machine Learning
-
Machine Learning (ML): Evolution and Latest Trends 5:20
-
Machine Learning (ML): Real-life Examples 2:11
-
Machine Learning (ML): Real-life Examples
Chương 6 Intro to Data and Data Science - Common Data Science Tools 2 bài · 6 phút
-
Programming Languages & Software Employed in Data Science - All the Tools Needed 5:51
-
Programming Languages & Software Employed in Data Science - All the Tools Needed
Chương 7 Intro to Data and Data Science - Data Science Career Paths 2 bài · 3 phút
-
Data Science Job Positions: What do they Involve and What to Look out for? 3:29
-
Data Science Job Positions: What do they Involve and What to Look out for?
Chương 8 Intro to Data and Data Science - Dispelling Common Misconceptions 3 bài · 4 phút
-
Dispelling common Misconceptions 4:10
-
Dispelling common Misconceptions
-
Internal Transfer: Data Science Fundamentals Interview
Chương 9 Part 2: Statistics - Population and Sample 2 bài · 4 phút
-
Population vs sample 4:02
-
Population and Sample
Chương 10 Statistics - Descriptive Statistics 32 bài · 47 phút
-
Types of Data 4:33
-
Types of data
-
Levels of Measurement 3:43
-
Levels of measurement
-
Categorical Variables - Visualization Techniques 4:52
-
Categorical variables. Visualization Techniques
-
Categorical Variables Exercise
-
Numerical Variables - Frequency Distribution Table 3:09
-
Numerical variables. Using a frequency distribution table
-
Numerical Variables Exercise
-
The Histogram 2:14
-
The Histogram
-
Histogram Exercise
-
Cross Table and Scatter Plot 4:44
-
Cross Tables and Scatter Plots
-
Cross Tables and Scatter Plots Exercise
-
Mean, median and mode 4:20
-
Mean, Median and Mode Exercise
-
Skewness 2:37
-
Skewness
-
Skewness Exercise
-
Variance 5:55
-
Variance Exercise
-
Standard Deviation and Coefficient of Variation 4:40
-
Standard deviation
-
Standard Deviation and Coefficient of Variation Exercise
-
Covariance 3:23
-
Covariance
-
Covariance Exercise
-
Correlation Coefficient 3:17
-
Correlation Coefficient
-
Correlation Coefficient Exercise
Chương 11 Statistics - Practical Example: Descriptive Statistics 2 bài · 16 phút
-
Practical Example 16:15
-
Practical Example Exercise
Chương 12 Statistics - Inferential Statistics Fundamentals 14 bài · 22 phút
-
Introduction 1:00
-
What is a Distribution 4:33
-
What is a Distribution
-
The Normal Distribution 3:54
-
The Normal Distribution
-
The Standard Normal Distribution 3:30
-
The Standard Normal Distribution
-
The Standard Normal Distribution Exercise
-
Central Limit Theorem 4:20
-
Central Limit Theorem
-
Standard error 1:26
-
Standard error
-
Estimators and Estimates 3:07
-
Estimators and Estimates
Chương 13 Statistics - Inferential Statistics: Confidence Intervals 18 bài · 44 phút
-
What are Confidence Intervals? 2:41
-
What are Confidence Intervals?
-
Confidence Intervals; Population Variance Known; z-score 8:01
-
Confidence Intervals; Population Variance Known; z-score Exercise
-
Confidence interval clarifications 4:38
-
Student's T Distribution 3:22
-
Student's T Distribution
-
Confidence Intervals; Population Variance Unknown; t-score 4:36
-
Confidence Intervals; Population Variance Unknown; t-score Exercise
-
Margin of Error 4:52
-
Margin of Error
-
Confidence intervals. Two means. Dependent samples 6:04
-
Confidence intervals. Two means. Dependent samples Exercise
-
Confidence intervals. Two means. Independent samples (Part 1) 4:31
-
Confidence intervals. Two means. Independent samples (Part 1) Exercise
-
Confidence intervals. Two means. Independent samples (Part 2) 3:57
-
Confidence intervals. Two means. Independent samples (Part 2) Exercise
-
Confidence intervals. Two means. Independent samples (Part 3) 1:27
Chương 14 Statistics - Practical Example: Inferential Statistics 2 bài · 10 phút
-
Practical Example: Inferential Statistics 10:05
-
Practical Example: Inferential Statistics Exercise
Chương 15 Statistics - Hypothesis Testing 20 bài · 47 phút
-
The Null vs Alternative Hypothesis 5:51
-
Further Reading on Null and Alternative Hypothesis
-
The Null vs Alternative Hypothesis
-
Rejection Region and Significance Level 7:05
-
Rejection Region and Significance Level
-
Type I Error and Type II Error 4:14
-
Type I Error and Type II Error
-
Test for the Mean. Population Variance Known 6:34
-
Test for the Mean. Population Variance Known Exercise
-
P-value 4:13
-
P-value
-
Test for the Mean. Population Variance Unknown 4:48
-
Test for the Mean. Population Variance Unknown Exercise
-
Test for the Mean. Dependent Samples 5:18
-
Test for the Mean. Dependent Samples Exercise
-
Test for the mean. Independent samples (Part 1) 4:22
-
Test for the mean. Independent samples (Part 1). Exercise
-
Test for the mean. Independent samples (Part 2) 4:26
-
Test for the mean. Independent samples (Part 2)
-
Test for the mean. Independent samples (Part 2)
Chương 16 Statistics - Practical Example: Hypothesis Testing 2 bài · 7 phút
-
Practical Example: Hypothesis Testing 7:16
-
Practical Example: Hypothesis Testing Exercise
Chương 17 Part 3: Relational Database Theory & Introduction to SQL 21 bài · 44 phút
-
Why use SQL? 3:17
-
Why use SQL?
-
Why use MySQL? 1:57
-
Why use MySQL?
-
Introducing Databases 4:44
-
Introducing Databases
-
Relational Database Fundamentals 4:51
-
Relational Database Fundamentals
-
Comparing Databases and Spreadsheets 7:05
-
Comparing Databases and Spreadsheets
-
Important Database Terminology 4:16
-
Important Database Terminology
-
The Concept of Relational Schemas: Primary Key 4:57
-
The Concept of Relational Schemas: Primary Key
-
The Concept of Relational Schemas: Foreign Key 4:59
-
The Concept of Relational Schemas: Foreign Key
-
The Concept of Relational Schemas: Unique Key and Null Values 3:08
-
The Concept of Relational Schemas: Unique Key
-
The Concept of Relational Schemas: Relationships Between Tables 4:40
-
The Concept of Relational Schemas: Relationships Between Tables
-
Mentoring Session on Relational Database Theory
Chương 18 SQL - Install and get to know MySQL 10 bài · 38 phút
-
Installing MySQL Workbench and Server 10:42
-
Installing Visual C
-
Installing MySQL on macOS and Unix systems
-
The Client-Server Model
-
Linking GUI with the MySQL Server 2:35
-
Read me!!!
-
Creating a New User and a New Connection to it 6:18
-
Familiarize Yourself with the MySQL Interface 4:54
-
SQL Fundamentals - MySQL Session and Databases 8:31
-
SQL Fundamentals - DROP, CREATE, SELECT, INSERT, DELETE 4:36
Chương 19 SQL - Best SQL Practices 4 bài · 10 phút
-
Coding Tips and Best Practices - I 5:34
-
Coding Tips and Best Practices - I
-
Coding Tips and Best Practices - II 4:12
-
Coding Tips and Best Practices - II
Chương 20 SQL - Loading the 'employees' Database 2 bài · 2 phút
-
Loading the 'employees' Database 2:05
-
Loading the 'employees' Database
Chương 21 SQL - Practical Application of the SQL SELECT Statement 89 bài · 1 giờ 16 phút
-
Using SELECT - FROM 4:57
-
Using SELECT - FROM - Exercise
-
Using SELECT - FROM - Solution
-
SQL Coding Exercises 7:26
-
CODING EXERCISES - the 'employees_10' Database
-
SELECT - FROM - Exercise #1
-
SELECT - FROM - Exercise #2
-
SELECT - FROM - Exercise #3
-
SELECT - FROM - Exercise #4
-
Using WHERE 2:30
-
Using WHERE - Exercise
-
Using WHERE - Solution
-
SELECT - Using WHERE - Exercise #1
-
Using AND 2:14
-
Using AND - Exercise
-
Using AND - Solution
-
SELECT - Using AND - Exercise #1
-
Using OR 3:35
-
Using OR - Exercise
-
Using OR - Solution
-
SELECT - Using OR - Exercise #1
-
Operator Precedence and Logical Order 3:34
-
Operator Precedence and Logical Order - Exercise
-
Operator Precedence and Logical Order - Solution
-
Operator Precedence and Logical Order - Exercise #1
-
Using IN - NOT IN 3:12
-
Using IN - NOT IN - Exercise 1
-
Using IN - NOT IN - Solution 1
-
Using IN - NOT IN - Exercise 2
-
Using IN - NOT IN - Solution 2
-
SELECT - Using IN - NOT IN - Exercise #1
-
SELECT - Using IN - NOT IN - Exercise #2
-
Using LIKE - NOT LIKE 3:36
-
Using LIKE - NOT LIKE - Exercise
-
Using LIKE - NOT LIKE - Solution
-
SELECT - Using LIKE - NOT LIKE - Exercise #1
-
SELECT - Using LIKE - NOT LIKE - Exercise #2
-
SELECT - Using LIKE - NOT LIKE - Exercise #3
-
Using Wildcard Characters 1:44
-
Using Wildcard characters - Exercise
-
Using Wildcard characters - Solution
-
Using Wildcard characters - Exercise #1
-
Using Wildcard characters - Exercise #2
-
Using BETWEEN - AND 2:19
-
Using BETWEEN - AND - Exercise
-
Using BETWEEN - AND - Solution
-
SELECT - Using BETWEEN - AND - Exercise #1
-
SELECT - Using BETWEEN - AND - Exercise #2
-
SELECT - Using BETWEEN - AND - Exercise #3
-
Using IS NOT NULL - IS NULL 1:37
-
Using IS NOT NULL - IS NULL - Exercise
-
Using IS NOT NULL - IS NULL - Solution
-
SELECT - Using IS NOT NULL - IS NULL - Exercise #1
-
Using Other Comparison Operators 4:30
-
Using Other Comparison Operators - Exercise
-
Using Other Comparison Operators - Solution
-
SELECT - Using Other Comparison Operators - Exercise #1
-
SELECT - Using Other Comparison Operators - Exercise #2
-
Using SELECT DISTINCT 2:05
-
Using SELECT DISTINCT - Exercise
-
Using SELECT DISTINCT - Solution
-
SELECT DISTINCT - Exercise #2
-
Getting to Know Aggregate Functions 5:24
-
Getting to Know Aggregate Functions - Exercise
-
Getting to Know Aggregate Functions - Solution
-
Getting to Know Aggregate Functions - Exercise #1
-
Getting to Know Aggregate Functions - Exercise #2
-
Using ORDER BY 3:46
-
Using ORDER BY - Exercise
-
Using ORDER BY - Solution
-
SELECT - Using ORDER BY - Exercise #1
-
Using GROUP BY 6:00
-
Using Aliases (AS) 2:08
-
Using Aliases (AS) - Exercise
-
Using Aliases (AS) - Solution
-
SELECT - Using Aliases (AS) - Exercise #1
-
Using HAVING 3:26
-
Using HAVING - Exercise
-
Using HAVING - Solution
-
SELECT - Using HAVING - Exercise #1
-
Using WHERE vs HAVING - Part I 4:03
-
Using WHERE vs HAVING - Part II 3:08
-
Using WHERE vs HAVING - Part II - Exercise
-
Using WHERE vs HAVING - Part II - Solution
-
SELECT - Using WHERE vs HAVING - Exercise #1
-
Using LIMIT 4:51
-
Using LIMIT - Exercise
-
Using LIMIT - Solution
-
SELECT - Using LIMIT - Exercise #1
Chương 22 SQL - Expanding on MySQL Aggregate Functions 21 bài · 11 phút
-
Applying COUNT() 4:01
-
Applying COUNT() - Exercise
-
Applying COUNT() - Solution
-
Applying COUNT() - Exercise #1
-
Applying SUM() 1:30
-
Applying SUM() - Exercise
-
Applying SUM() - Solution
-
Applying SUM() - Exercise #1
-
MIN() and MAX() 1:15
-
MIN() and MAX() - Exercise
-
MIN() and MAX() - Solution
-
MIN() and MAX() - Exercise #1
-
MIN() and MAX() - Exercise #2
-
Applying AVG() 1:58
-
Applying AVG() - Exercise
-
Applying AVG() - Solution
-
Applying AVG() - Exercise #1
-
Rounding Numbers with ROUND() 1:57
-
Rounding Numbers with ROUND() - Exercise
-
Rounding Numbers with ROUND() - Solution
-
Applying ROUND() - Exercise #1
Chương 23 SQL - SQL JOINs 46 bài · 1 giờ 12 phút
-
What are JOINs? 4:23
-
What are JOINs? - Exercise 1
-
What are JOINs? - Exercise 2
-
The Functionality of INNER JOIN - Part I 6:02
-
The Functionality of INNER JOIN - Part II 5:33
-
The Functionality of INNER JOIN - PART II - Exercise
-
The Functionality of INNER JOIN - PART II - Solution
-
INNER JOIN - Exercise #1
-
Extra Info on Using Joins 4:09
-
Duplicate Rows 4:21
-
The Functionality of LEFT JOIN - Part I 4:31
-
The Functionality of LEFT JOIN - Part II 5:46
-
The Functionality of LEFT JOIN - Part II - Exercise
-
The Functionality of LEFT JOIN - Part II - Solution
-
LEFT JOIN - Exercise #1
-
The Functionality of RIGHT JOIN 4:30
-
RIGHT JOIN - Exercise #1
-
Differences between the New and the Old Join Syntax 4:17
-
Differences between the New and the Old Join Syntax - Exercise
-
Differences between the New and the Old Join Syntax - Solution
-
Differences between the New and the Old Join Syntax - Exercise #1
-
Using JOIN and WHERE Together 2:53
-
Important – Prevent Error Code: 1055!
-
Using JOIN and WHERE Together - Exercise
-
Using JOIN and WHERE Together - Solution
-
Using JOIN and WHERE Together - Exercise #1
-
The Functionality of CROSS JOIN 7:42
-
The Functionality of CROSS JOIN - Exercise 1
-
The Functionality of CROSS JOIN - Solution 1
-
The Functionality of CROSS JOIN - Exercise 2
-
The Functionality of CROSS JOIN - Solution 2
-
The Functionality of CROSS JOIN - Exercise #1
-
The Functionality of CROSS JOIN - Exercise #2
-
Combining Aggregate Functions with Joins 2:17
-
JOIN More than Two Tables 4:26
-
JOIN More than Two Tables - Exercise
-
JOIN More than Two Tables - Solution
-
JOIN More than Two Tables - Exercise #1
-
Top Tips for Joins 5:39
-
Top Tips for Joins - Exercise
-
Top Tips for Joins - Solution
-
Top Tips for Joins - Exercise #1
-
The Differences Between UNION and UNION ALL 5:44
-
The Differences Between UNION and UNION ALL - Exercise
-
The Differences Between UNION and UNION ALL - Solution
-
The Differences Between UNION and UNION ALL - Exercise #1
Chương 24 SQL - SQL Subqueries 13 bài · 16 phút
-
SQL Subqueries with IN Embedded Inside WHERE 4:31
-
SQL Subqueries with IN Embedded Inside WHERE - Exercise
-
SQL Subqueries with IN Embedded Inside WHERE - Solution
-
SQL Subqueries with IN Embedded Inside WHERE - Exercise #1
-
SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE 3:42
-
SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE - Exercise
-
SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE - Solution
-
SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE - Exercise #1
-
SQL Subqueries Nested in SELECT and FROM 7:56
-
SQL Subqueries Embedded in SELECT and FROM - Exercise 1
-
SQL Subqueries Embedded in SELECT and FROM - Exercise 2
-
SQL Subqueries Nested in SELECT and FROM - Solution 2
-
SQL Subqueries Nested in SELECT and FROM - Exercise #1
Chương 25 SQL - Stored Routines 21 bài · 46 phút
-
Defining Stored Routines 3:25
-
Defining Stored Routines
-
Create Stored Procedures with MySQL Syntax 4:32
-
An Example of Stored Procedures Part I 2:45
-
An Example of Stored Procedures Part II 4:48
-
An Example of Stored Procedures Part II - Exercise
-
An Example of Stored Procedures Part II - Solution
-
Creating a Procedure in MySQL Another Way 3:19
-
Create Stored Procedures with an Input Parameter 6:29
-
Create Stored Procedures with an Output Parameter 3:19
-
Create Stored Procedures with an Output Parameter - Exercise
-
Stored Procedures with an Output Parameter - Solution
-
SQL Variables 6:50
-
SQL Variables - Exercise
-
SQL Variables - Solution
-
The Benefit of User-Defined Functions in MySQL 6:14
-
Error Code: 1418.
-
The Benefit of User-Defined Functions in MySQL - Exercise
-
The Benefit of User-Defined Functions in MySQL - Solution
-
Concluding Stored Routines 3:55
-
Concluding Stored Routines
Chương 26 SQL - The CASE Statement 10 bài · 6 phút
-
The SQL CASE Statement 5:57
-
The SQL CASE Statement - Exercise 1
-
THE SQL CASE Statement - Solution 1
-
THE SQL CASE Statement - Exercise 2
-
THE SQL CASE Statement - Solution 2
-
THE SQL CASE Statement - Exercise 3
-
THE SQL CASE Statement - Solution 3
-
The SQL CASE Statement - Exercise #1
-
The SQL CASE Statement - Exercise #2
-
The SQL CASE Statement - Exercise #3
Chương 27 SQL - Window Functions 45 bài · 1 giờ 2 phút
-
Introduction to MySQL Window Functions 1:58
-
The ROW_NUMBER() Ranking Window Function and the Relevant MySQL Syntax 9:11
-
The ROW_NUMBER Ranking Window Function - Exercise
-
The ROW_NUMBER Ranking Window Function - Solution
-
The ROW_NUMBER() Ranking Window Function - Exercise #1
-
The ROW_NUMBER() Ranking Window Function - Exercise #2
-
A Note on Using Several Window Functions in a Query 2:41
-
A Note on Using Several Window Functions in a Query - Exercise
-
A Note on Using Several Window Functions in a Query - Solution
-
A Note on Using Several Window Functions - Exercise #1
-
A Note on Using Several Window Functions - Exercise #2
-
MySQL Window Functions Syntax 3:51
-
MySQL Window Functions Syntax - Exercise
-
MySQL Window Functions Syntax - Solution
-
MySQL Window Functions Syntax - Exercise #1
-
The PARTITION BY Clause vs the GROUP BY Clause 6:28
-
The PARTITION BY Clause vs the GROUP BY Clause - Exercise
-
The PARTITION BY Clause vs the GROUP BY Clause - Solution
-
The PARTITION BY Clause vs the GROUP BY Clause - Exercise #1
-
The PARTITION BY Clause vs the GROUP BY Clause - Exercise #2
-
The PARTITION BY Clause vs the GROUP BY Clause - Exercise #3
-
The MySQL RANK() and DENSE_RANK() Window Functions 7:54
-
The MySQL RANK() and DENSE_RANK() Window Functions - Exercise
-
The MySQL RANK() and DENSE_RANK() Window Functions - Solution
-
The MySQL RANK() and DENSE_RANK() Window Functions - Exercise #1
-
The MySQL RANK() and DENSE_RANK() Window Functions - Exercise #2
-
The MySQL RANK() and DENSE_RANK() Window Functions - Exercise #3
-
Working with MySQL Ranking Window Functions and Joins Together 8:26
-
Working with MySQL Ranking Window Functions and Joins Together - Exercise
-
Working with MySQL Ranking Window Functions and Joins Together - Solution
-
MySQL Ranking Window Functions and JOINs - Exercise #1
-
MySQL Ranking Window Functions and JOINs - Exercise #2
-
The LAG() and LEAD() Value Window Functions 8:35
-
The LAG() and LEAD() Value Window Functions - Exercise
-
The LAG() and LEAD() Value Window Functions - Solution
-
The LAG() and LEAD() Value Window Functions - Exercise #1
-
The LAG() and LEAD() Value Window Functions - Exercise #2
-
MySQL Aggregate Functions in the Context of Window Functions - Part I 6:13
-
MySQL Aggregate Functions in the Context of Window Functions - Part I-Exercise
-
MySQL Aggregate Functions in the Context of Window Functions - Part I-Solution
-
MySQL Aggregate Functions in the Context of Window Functions - Part II 6:47
-
MySQL Aggregate Functions in the Context of Window Functions - Part II-Exercise
-
MySQL Aggregate Functions in the Context of Window Functions - Part II-Solution
-
MySQL Aggregate Functions in the Context of Window Functions - Exercise #1
-
MySQL Aggregate Functions in the Context of Window Functions - Exercise #2
Chương 28 SQL Common Table Expressions (CTEs) 14 bài · 24 phút
-
MySQL Common Table Expressions - Introduction 6:59
-
An Alternative Solution to the Same Task 1:53
-
An Alternative Solution to the Same Task-Exercise
-
An Alternative Solution to the Same Task-Solution
-
An Alternative Solution to the Same Task - Exercise #1
-
An Alternative Solution to the Same Task - Exercise #2
-
Using Multiple Subclauses in a WITH Clause - Part I 5:32
-
Using Multiple Subclauses in a WITH Clause - Part II 5:19
-
Using Multiple Subclauses in a WITH Clause-Exercise
-
Using Multiple Subclauses in a WITH Clause-Solution
-
Referring to Common Table Expressions in a WITH Clause 3:59
-
Using Multiple Subclauses in a WITH Clause - Exercise #1
-
Using Multiple Subclauses in a WITH Clause - Exercise #2
-
Using Multiple Subclauses in a WITH Clause - Exercise #3
Chương 29 SQL Temporary Tables 13 bài · 16 phút
-
MySQL Temporary Tables - Introduction 3:08
-
MySQL Temporary Tables in Action 5:12
-
MySQL Temporary Tables in Action-Exercise
-
MySQL Temporary Tables in Action-Solution
-
MySQL Temporary Tables - Exercise #1
-
MySQL Temporary Tables - Exercise #2
-
Other Features of MySQL Temporary Tables 7:22
-
Other Features of MySQL Temporary Tables-Exercise
-
Other Features of MySQL Temporary Tables-Solution
-
MySQL Temporary Tables - Other Features - Exercise #1
-
MySQL Temporary Tables - Other Features - Exercise #2
-
MySQL Temporary Tables - Other Features - Exercise #3
-
MySQL Temporary Tables - Other Features - Exercise #4
Chương 30 Part 4: Introduction to Tableau 5 bài · 25 phút
-
Why Use Tableau: Make Your Data Make an Impact 4:23
-
Let's Download Tableau Public 2:03
-
Connecting Data in Tableau 2:19
-
Exploring Tableau's Interface 9:26
-
Let's Create our first Chart in Tableau! 7:12
Chương 31 Tableau - Tableau functionalities 8 bài · 27 phút
-
Duplicating a Sheet 2:49
-
Creating a Table 5:23
-
Creating Custom Fields 2:28
-
Creating a Custom Field and Adding Calculations to a Table 3:41
-
Adding Totals and Subtotals 2:03
-
Adding a Custom Calculation 3:12
-
Inserting a Filter 2:21
-
Working with Joins in Tableau 4:33
Chương 32 Tableau - The Tableau Exercise 12 bài · 44 phút
-
Introduction to the Exercise 2:05
-
Let's Create a Dashboard - Visualizing the Three Charts We Want to Create 1:56
-
Using Joins in Tableau 6:10
-
Performing a Numbers Check - Attempt #1 3:48
-
Blending Data in Tableau 5:49
-
Performing a Numbers Check - Attempt #2 4:02
-
First Chart 4:05
-
Second Chart 3:07
-
Third Chart 2:39
-
Creating and Formatting a Dashboard 4:26
-
Adding Interactive Filters for Improved Analysis 3:54
-
Interactive Filters - fix 1:38
Chương 33 Part 5: Combining SQL and Tableau - Introduction 4 bài · 14 phút
-
Introduction to Software Integration 5:20
-
Combining SQL and Tableau 4:51
-
Loading the Database 3:22
-
Loading the Database
Chương 34 Combining SQL and Tableau - Problem 1 9 bài · 26 phút
-
Problem 1: Task 5:33
-
Problem 1: Task - Text
-
Important clarification!
-
Problem 1: Solution in SQL 4:41
-
Problem 1: Solution in SQL - Code
-
Exporting Your Output from SQL and Loading it in Tableau 4:13
-
Chart 1: Visualizing the Solution in Tableau - Part I 6:17
-
Chart 1: Visualizing the Solution in Tableau - Part II 5:25
-
MySQL and Tableau - Task/Exercise #1
Chương 35 Combining SQL and Tableau - Problem 2 6 bài · 14 phút
-
Problem 2: Task 3:49
-
Problem 2: Task - Text
-
Problem 2: Solution in SQL 3:43
-
Problem 2: Solution in SQL - Code
-
Chart 2: Visualizing the Solution in Tableau 6:08
-
MySQL and Tableau - Task/Exercise #2
Chương 36 Combining SQL and Tableau - Problem 3 6 bài · 11 phút
-
Problem 3: Task 2:21
-
Problem 3: Task - Text
-
Problem 3: Solution in SQL 3:14
-
Problem 3: Solution in SQL - Code
-
Chart 3: Visualizing the Solution in Tableau 4:56
-
MySQL and Tableau - Task/Exercise #3
Chương 37 Combining SQL and Tableau - Problem 4 5 bài · 9 phút
-
Problem 4: Task 2:45
-
Problem 4: Task - Text
-
Problem 4: Solution in SQL 2:47
-
Problem 4: Solution in SQL - Code
-
Chart 4: Visualizing the Solution in Tableau 3:22
Chương 38 Combining SQL and Tableau - Problem 5 2 bài · 6 phút
-
Problem 5: Organizing Charts 1-4 into a Beautiful Dashboard 6:04
-
BI Team Prep Sync — Inputs for Weekly Department Update
Chương 39 Part 6: Introduction to Programming with Python 14 bài · 44 phút
-
Introduction 1:24
-
A 5-minute Explanation of Programming 5:29
-
A 5-minute explanation of Programming
-
Why use Python? 5:11
-
Why Use Python?
-
Why use Jupyter? 3:28
-
Why Use Jupyter?
-
How to Install Python and Jupyter 3:35
-
Intro to Using Jupyter 4:53
-
Jupyter - Working with Notebook Files 4:30
-
Understanding Jupyter's Interface
-
Jupyter - Using Shortcuts 7:24
-
Jupyter - Handling Error Messages 5:52
-
Jupyter - Restarting the Kernel 2:03
Chương 40 Python - Python Variables and Data Types 23 bài · 22 phút
-
Python Variables 3:37
-
Python Coding Exercises 2:40
-
Python Variables - Exercise #1
-
Python Variables - Exercise #2
-
Python Variables - Exercise #3
-
Python Variables - Exercise #4
-
Python Variables
-
Understanding Numbers and Boolean Values 3:05
-
Numbers and Boolean Values - Exercise #1
-
Numbers and Boolean Values - Exercise #2
-
Numbers and Boolean Values - Exercise #3
-
Numbers and Boolean Values - Exercise #4
-
Numbers and Boolean Values - Exercise #5
-
Understanding Numbers and Boolean Values
-
Strings 5:40
-
Strings - Exercise #1
-
Strings - Exercise #2
-
Strings - Exercise #3
-
Strings - Exercise #4
-
Strings - Exercise #5
-
Strings
-
Introduction to Anaconda AI 2:27
-
Using the Anaconda Assistant: Strings 4:07
Chương 41 Python - Python Syntax Fundamentals 30 bài · 11 phút
-
The Arithmetic Operators of Python 3:23
-
The Arithmetic Operators in Python - Exercise #1
-
The Arithmetic Operators in Python - Exercise #2
-
The Arithmetic Operators in Python - Exercise #3
-
The Arithmetic Operators in Python - Exercise #4
-
The Arithmetic Operators in Python - Exercise #5
-
The Arithmetic Operators in Python - Exercise #6
-
The Arithmetic Operators in Python - Exercise #7
-
The Arithmetic Operators in Python - Exercise #8
-
Using Arithmetic Operators in Python
-
What is the Double Equality Sign? 1:33
-
What is the Double Equality Sign? - Exercise #1
-
What is the Double Equality Sign?
-
How to Reassign Values 1:08
-
How to Reassign Values - Exercise #1
-
How to Reassign Values - Exercise #2
-
How to Reassign Values - Exercise #3
-
How to Reassign Values - Exercise #4
-
How to Reassign Values
-
How to Add Comments 1:34
-
How to Add Comments
-
Understanding Line Continuation 0:49
-
Understanding Line Continuation - Exercise #1
-
How to Index Elements 1:18
-
How to Index Elements - Exercise #1
-
How to Index Elements - Exercise #2
-
How to Index Elements
-
How to Structure Your Code with Indentation 1:44
-
How to Structure Your Code with Indentation - Exercise #1
-
How to Structure Your Code with Indentation
Chương 42 Python - Other Python Operators 14 bài · 8 phút
-
Python's Comparison Operators 2:10
-
Python's Comparison Operators - Exercise #1
-
Python's Comparison Operators - Exercise #2
-
Python's Comparison Operators - Exercise #3
-
Python's Comparison Operators - Exercise #4
-
Python's Comparison Operators
-
Python's Logical and Identity Operators 5:35
-
Python's Logical and Identity Operators - Exercise #1
-
Python's Logical and Identity Operators - Exercise #2
-
Python's Logical and Identity Operators - Exercise #3
-
Python's Logical and Identity Operators - Exercise #4
-
Python's Logical and Identity Operators - Exercise #5
-
Python's Logical and Identity Operators - Exercise #6
-
Python's Logical and Identity Operators
Chương 43 Python - Conditional Statements 11 bài · 14 phút
-
Getting to know the IF Statement 3:01
-
The IF Statement - Exercise #1
-
The IF Statement - Exercise #2
-
Getting to know the IF Statement
-
Adding an ELSE statement 2:45
-
The ELSE Statement - Exercise #1
-
Else if, for Brief – ELIF 5:34
-
The ELIF Statement - Exercise #1
-
The ELIF Statement - Exercise #2
-
An Additional Explanation of Boolean Values 2:13
-
An Additional Explanation of Boolean Values
Chương 44 Python - Functions 22 bài · 19 phút
-
How to Define a Function in Python 2:02
-
How to Create a Function with a Parameter 3:49
-
How to Create a Function with a Parameter - Exercise #1
-
How to Create a Function with a Parameter - Exercise #2
-
Define a Function in Another Way 2:36
-
Define a Function in Another Way - Exercise #1
-
How to Use a Function within a Function 1:49
-
How to Use a Function within a Function - Exercise #1
-
Use Conditional Statements and Functions Together 3:06
-
Conditional Statements and Functions - Exercise #1
-
How to Create Functions Which Contain a Few Arguments 1:16
-
Built-In Functions in Python Worth Knowing 3:56
-
Built-In Function in Python Worth Knowing - Exercise #1
-
Built-In Function in Python Worth Knowing - Exercise #2
-
Built-In Function in Python Worth Knowing - Exercise #3
-
Built-In Function in Python Worth Knowing - Exercise #4
-
Built-In Function in Python Worth Knowing - Exercise #5
-
Built-In Function in Python Worth Knowing - Exercise #6
-
Built-In Function in Python Worth Knowing - Exercise #7
-
Built-In Function in Python Worth Knowing - Exercise #8
-
Built-In Function in Python Worth Knowing - Exercise #9
-
Python - Functions
Chương 45 Python - Python Sequences 34 bài · 19 phút
-
Introduction to Lists 4:02
-
Introduction to Lists - Exercise #1
-
Introduction to Lists - Exercise #2
-
Introduction to Lists - Exercise #3
-
Introduction to Lists - Exercise #4
-
Introduction to Lists - Exercise #5
-
Introduction to Lists
-
Using Methods in Python 3:19
-
Using Methods in Python - Exercise #1
-
Using Methods in Python - Exercise #2
-
Using Methods in Python - Exercise #3
-
Using Methods in Python - Exercise #4
-
Using Methods in Python
-
What is List Slicing? 4:30
-
What is List Slicing? - Exercise #1
-
What is List Slicing? - Exercise #2
-
What is List Slicing? - Exercise #3
-
What is List Slicing? - Exercise #4
-
What is List Slicing? - Exercise #5
-
What is List Slicing? - Exercise #6
-
What is List Slicing? - Exercise #7
-
Working with Tuples 3:11
-
Working with Tuples - Exercise #1
-
Working with Tuples - Exercise #2
-
Working with Tuples - Exercise #3
-
Working with Tuples - Exercise #4
-
Python Dictionaries 4:04
-
Python Dictionaries - Exercise #1
-
Python Dictionaries - Exercise #2
-
Python Dictionaries - Exercise #3
-
Python Dictionaries - Exercise #4
-
Python Dictionaries - Exercise #5
-
Python Dictionaries - Exercise #6
-
Python Dictionaries
Chương 46 Python - Using Iterations 22 bài · 26 phút
-
Using For Loops 2:56
-
Using For Loops - Exercise #1
-
Using For Loops - Exercise #2
-
Using For Loops
-
Using While Loops and Incrementing 2:25
-
Using While Loops and Incrementing - Exercise #1
-
Use the range() Function to Create Lists 3:49
-
Use the range() Function to Create Lists - Exercise - #1
-
Use the range() Function to Create Lists - Exercise - #2
-
Use the range() Function to Create Lists - Exercise - #3
-
Use the range() Function to Create Lists
-
Combine Conditional Statements and Loops 3:11
-
Conditional Statements and Loops - Exercise #1
-
Conditional Statements and Loops - Exercise #2
-
Conditional Statements and Loops - Exercise #3
-
All In – Conditional Statements, Functions, and Loops 2:27
-
All In - Conditional Statements, Functions, and Loops - Exercise #1
-
Using the Anaconda Assistant: Several Python Tools 5:56
-
How to Iterate over Dictionaries 3:07
-
How to Iterate over Dictionaries - Exercise #1
-
How to Iterate over Dictionaries - Exercise #2
-
Using the Anaconda Assistant: Dictionaries 2:22
Chương 47 Python - Advanced Python tools 9 bài · 13 phút
-
Introduction to Object Oriented Programming (OOP) 5:00
-
Introduction to Object Oriented Programming (OOP)
-
Using Modules and Packages 1:05
-
Using Modules and Packages
-
What is the Standard Library? 2:47
-
What is the Standard Library?
-
How to Import Modules in Python 4:04
-
How to Import Modules in Python
-
Practical Python at Work — Four Quick Questions
Chương 48 Part 7: Integration - Software Integration 10 bài · 30 phút
-
Getting Started with Data, Servers, Clients, Requests, and Responses 4:43
-
Getting Started with Data, Servers, Clients, Requests, and Responses
-
Getting Started with Data Connectivity, APIs, and Endpoints 7:05
-
Getting Started with Data Connectivity, APIs, and Endpoints
-
Become Better Acquainted with APIs 8:05
-
Become Better Acquainted with APIs
-
Communication through Text Files 4:20
-
Communication through Text Files
-
What is Software Integration and How is it Applied? 5:25
-
What is Software Integration and How is it Applied?
Chương 49 Integration - What is contained in this Course? 4 bài · 10 phút
-
Solving a Business Exercise with Python, SQL, and Tableau 4:08
-
Presenting the Task: Absenteeism at Work 2:48
-
Presenting the Data Set 3:18
-
Presenting the Data Set
Chương 50 Integration - Data Preprocessing Step by Step 32 bài · 1 giờ 23 phút
-
How is the Content in the Next Sections Organized?
-
How to Import the Data Set in Python 3:23
-
Exploring the Data Set 5:53
-
Programming vs the Rest of the World 3:27
-
A Brief Summary of Regression Analysis
-
The Approach we will Take to Solve this Exercise 2:17
-
Dropping Variables We Don't Need 6:27
-
EXERCISE - Dropping Variables We Don't Need
-
SOLUTION - Dropping Variables We Don't Need
-
A Deeper Look at the 'Reasons for Absence' Column 5:04
-
Splitting a Variable into Multiple Dummy Variables 8:37
-
EXERCISE - Splitting a Variable into Multiple Dummy Variables
-
SOLUTION - Splitting a Variable into Multiple Dummy Variables
-
How to Drop a Dummy Variable from the Data Set
-
A Statistical Perspective on Dummy Variables 1:28
-
Categorizing the Various Reasons for Absence 8:35
-
Concatenation in Python 4:35
-
EXERCISE - Concatenation in Python
-
SOLUTION - Concatenation in Python
-
How to Reorder Columns in a DataFrame in Python 1:43
-
EXERCISE - How to Reorder Columns in a DataFrame in Python
-
SOLUTION - How to Reorder Columns in a DataFrame in Python
-
Using Checkpoints to Ease Your Work in Jupyter 2:52
-
EXERCISE - Using Checkpoints to Ease Your Work in Jupyter
-
SOLUTION - Using Checkpoints to Ease Your Work in Jupyter
-
Analyzing the "Date" Column 7:48
-
Retrieving the Month Value From the "Date" Column 7:00
-
Adding the "Day of the Week" Column 3:36
-
EXERCISE - Dropping Columns
-
Analysis of the Next 5 Columns in DF 3:17
-
Dealing with More Numerical Features which may Behave like Categorical Ones 4:38
-
A Final Note on this Section 1:59
Chương 51 Integration - Integrating Python and SQL 11 bài · 46 phút
-
How to Use the 'absenteeism_module' in Python - Part I 3:50
-
How to Use the 'absenteeism_module' in Python - Part II 6:23
-
Creating the 'predicted_outputs' Database in MySQL 6:37
-
Importing 'pymysql' in Python 2:44
-
Creating a Connection and Cursor 2:54
-
EXERCISE - Creating 'df_new_obs'
-
Creating the 'predicted_outputs' Table in MySQL 4:52
-
Executing and SQL SELECT Statement from Python 3:04
-
Sending Data from Jupyter to Workbench - Part I 6:15
-
Sending Data from Jupyter to Workbench - Part II 6:35
-
Sending Data from Jupyter to Workbench - Part III 2:45
Chương 52 Integration - Using Tableau to Analyze the Predicted Outputs 7 bài · 23 phút
-
EXERCISE - Age vs Probability
-
Using Tableau to Analyze Age vs Probability 8:49
-
EXERCISE - Reasons vs Probability
-
Using Tableau to Analyze Reasons vs Probability 7:49
-
EXERCISE - Transportation Expense vs Probability
-
Using Tableau to Analyze Transportation Expense vs Probability 6:00
-
Completing 100%
Requirment
-
No prior experience is required. We will start from the very basics
-
You’ll need to install MySQL, Tableau Public, and Anaconda. We will show you how to do it step by step
-
Microsoft Excel 2003, 2010, 2013, 2016, or 365
Outcomes
-
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
0 Student
9 Courses
0 review