The Business Intelligence Analyst Course 2025
All LevelsBusinessBusiness Analysis

The Business Intelligence Analyst Course 2025

The skills you need to become a BI Analyst - Statistics, Database theory, SQL, Tableau – Everything is included

Created by 365 Careers, 365 Team
22.5 hours
Video Content
469
Lectures
248,462
Students
4.5
Rating
4.5
(248,462 students enrolled)

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 Content

52 sections • 469 lectures • 23:04:26 total length

Part 1: Introduction

2 lectures • 03:52

What Does the Course Cover03:38
Download All Resources00:14

Intro to Data and Data Science - The Different Data Science Fields

7 lectures • 38:57

Why Are There So Many Business and Data Science Buzzwords?05:21
Analysis vs Analytics03:50
Intro to Business Analytics, Data Analytics, and Data Science06:39
Intro to Business Analytics, Data Analytics, and Data Science5 questions
Adding Business Intelligence (BI), Machine Learning (ML), and AI to the Picture09:11
+6 more lectures

Intro to Data and Data Science - The Relationship between Different Fields

1 lectures • 07:19

When are Traditional data, Big Data, BI, Traditional Data Science and ML applied07:19
When are Traditional data, Big Data, BI, Traditional Data Science and ML applied1 question

Intro to Data and Data Science - What is the Purpose of each Data Science Field

1 lectures • 04:44

Why do we Need each of these Disciplines?04:44
Why do we Need each of these Disciplines?1 question

Intro to Data and Data Science - Common Data Science Techniques

12 lectures • 59:56

Traditional Data: Techniques08:13
Traditional Data: Techniques1 question
Traditional Data: Real-life Examples01:44
Big Data: Techniques04:26
Big Data: Techniques1 question
+14 more lectures

Intro to Data and Data Science - Common Data Science Tools

1 lectures • 05:51

Programming Languages & Software Employed in Data Science - All the Tools Needed05:51
Programming Languages & Software Employed in Data Science - All the Tools Needed4 questions

Intro to Data and Data Science - Data Science Career Paths

1 lectures • 03:29

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

Intro to Data and Data Science - Dispelling Common Misconceptions

1 lectures • 04:10

Dispelling common Misconceptions04:10
Dispelling common Misconceptions1 question

Part 2: Statistics - Population and Sample

1 lectures • 04:02

Population vs sample04:02
Population and Sample2 questions

Statistics - Descriptive Statistics

22 lectures • 47:59

Types of Data04:33
Types of data2 questions
Levels of Measurement03:43
Levels of measurement2 questions
Categorical Variables - Visualization Techniques04:52
+27 more lectures

Statistics - Practical Example: Descriptive Statistics

2 lectures • 16:18

Practical Example16:15
Practical Example Exercise00:03

Statistics - Inferential Statistics Fundamentals

8 lectures • 21:53

Introduction01:00
What is a Distribution04:33
What is a Distribution1 question
The Normal Distribution03:54
The Normal Distribution1 question
+9 more lectures

Statistics - Inferential Statistics: Confidence Intervals

15 lectures • 44:25

What are Confidence Intervals?02:41
What are Confidence Intervals?1 question
Confidence Intervals; Population Variance Known; z-score08:01
Confidence Intervals; Population Variance Known; z-score Exercise00:03
Confidence interval clarifications04:38
+13 more lectures

Statistics - Practical Example: Inferential Statistics

2 lectures • 10:08

Practical Example: Inferential Statistics10:05
Practical Example: Inferential Statistics Exercise00:03

Statistics - Hypothesis Testing

15 lectures • 48:24

The Null vs Alternative Hypothesis05:51
Further Reading on Null and Alternative Hypothesis01:16
The Null vs Alternative Hypothesis3 questions
Rejection Region and Significance Level07:05
Rejection Region and Significance Level2 questions
+15 more lectures

Statistics - Practical Example: Hypothesis Testing

2 lectures • 07:19

Practical Example: Hypothesis Testing07:16
Practical Example: Hypothesis Testing Exercise00:03

Part 3: Relational Database Theory & Introduction to SQL

10 lectures • 43:49

Why use SQL?03:17
Why use SQL?2 questions
Why use MySQL?01:57
Why use MySQL?1 question
Introducing Databases04:44
+15 more lectures

SQL - Install and get to know MySQL

10 lectures • 40:05

Installing MySQL Workbench and Server10:42
Installing Visual C00:21
Installing MySQL on macOS and Unix systems01:24
The Client-Server Model00:00
Linking GUI with the MySQL Server02:34
+5 more lectures

SQL - Best SQL Practices

2 lectures • 09:46

Coding Tips and Best Practices - I05:34
Coding Tips and Best Practices - I1 question
Coding Tips and Best Practices - II04:12
Coding Tips and Best Practices - II2 questions

SQL - Loading the 'employees' Database

2 lectures • 02:42

Loading the 'employees' Database02:05
Loading the 'employees' Database00:37

SQL - Practical Application of the SQL SELECT Statement

60 lectures • 01:19:55

Using SELECT - FROM04:57
Using SELECT - FROM - Exercise00:04
Using SELECT - FROM - Solution00:01
SQL Coding Exercises07:26
CODING EXERCISES - the 'employees_10' Database00:24
+84 more lectures

SQL - Expanding on MySQL Aggregate Functions

15 lectures • 11:15

Applying COUNT()04:01
Applying COUNT() - Exercise00:04
Applying COUNT() - Solution00:01
Applying COUNT() - Exercise #11 question
Applying SUM()01:30
+16 more lectures

SQL - SQL JOINs

36 lectures • 01:16:37

What are JOINs?04:23
What are JOINs? - Exercise 100:13
What are JOINs? - Exercise 200:14
The Functionality of INNER JOIN - Part I06:02
The Functionality of INNER JOIN - Part II05:33
+41 more lectures

SQL - SQL Subqueries

10 lectures • 17:13

SQL Subqueries with IN Embedded Inside WHERE04:31
SQL Subqueries with IN Embedded Inside WHERE - Exercise00:05
SQL Subqueries with IN Embedded Inside WHERE - Solution00:04
SQL Subqueries with IN Embedded Inside WHERE - Exercise #11 question
SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE03:42
+8 more lectures

SQL - Stored Routines

19 lectures • 48:33

Defining Stored Routines03:25
Defining Stored Routines1 question
Create Stored Procedures with MySQL Syntax04:32
An Example of Stored Procedures Part I02:45
An Example of Stored Procedures Part II04:48
+16 more lectures

SQL - The CASE Statement

7 lectures • 07:21

The SQL CASE Statement05:57
The SQL CASE Statement - Exercise 100:14
THE SQL CASE Statement - Solution 100:07
THE SQL CASE Statement - Exercise 200:14
THE SQL CASE Statement - Solution 200:24
+5 more lectures

SQL - Window Functions

28 lectures • 01:11:37

Introduction to MySQL Window Functions01:58
The ROW_NUMBER() Ranking Window Function and the Relevant MySQL Syntax09:11
The ROW_NUMBER Ranking Window Function - Exercise00:24
The ROW_NUMBER Ranking Window Function - Solution00:06
The ROW_NUMBER() Ranking Window Function - Exercise #11 question
+40 more lectures

SQL Common Table Expressions (CTEs)

9 lectures • 26:30

MySQL Common Table Expressions - Introduction06:59
An Alternative Solution to the Same Task01:53
An Alternative Solution to the Same Task-Exercise00:54
An Alternative Solution to the Same Task-Solution00:46
An Alternative Solution to the Same Task - Exercise #11 question
+9 more lectures

SQL Temporary Tables

7 lectures • 16:59

MySQL Temporary Tables - Introduction03:08
MySQL Temporary Tables in Action05:12
MySQL Temporary Tables in Action-Exercise00:10
MySQL Temporary Tables in Action-Solution00:07
MySQL Temporary Tables - Exercise #11 question
+8 more lectures

Part 4: Introduction to Tableau

5 lectures • 25:23

Why Use Tableau: Make Your Data Make an Impact04:23
Let's Download Tableau Public02:03
Connecting Data in Tableau02:19
Exploring Tableau's Interface09:26
Let's Create our first Chart in Tableau!07:12

Tableau - Tableau functionalities

8 lectures • 26:30

Duplicating a Sheet02:49
Creating a Table05:23
Creating Custom Fields02:28
Creating a Custom Field and Adding Calculations to a Table03:41
Adding Totals and Subtotals02:03
+3 more lectures

Tableau - The Tableau Exercise

12 lectures • 43:39

Introduction to the Exercise02:05
Let's Create a Dashboard - Visualizing the Three Charts We Want to Create01:56
Using Joins in Tableau06:10
Performing a Numbers Check - Attempt #103:48
Blending Data in Tableau05:49
+7 more lectures

Part 5: Combining SQL and Tableau - Introduction

4 lectures • 13:56

Introduction to Software Integration05:20
Combining SQL and Tableau04:51
Loading the Database03:22
Loading the Database00:23

Combining SQL and Tableau - Problem 1

8 lectures • 27:10

Problem 1: Task05:33
Problem 1: Task - Text00:05
Important clarification!00:50
Problem 1: Solution in SQL04:41
Problem 1: Solution in SQL - Code00:05
+4 more lectures

Combining SQL and Tableau - Problem 2

5 lectures • 13:57

Problem 2: Task03:49
Problem 2: Task - Text00:05
Problem 2: Solution in SQL03:43
Problem 2: Solution in SQL - Code00:12
Chart 2: Visualizing the Solution in Tableau06:08
+1 more lectures

Combining SQL and Tableau - Problem 3

5 lectures • 10:47

Problem 3: Task02:21
Problem 3: Task - Text00:07
Problem 3: Solution in SQL03:14
Problem 3: Solution in SQL - Code00:09
Chart 3: Visualizing the Solution in Tableau04:56
+1 more lectures

Combining SQL and Tableau - Problem 4

5 lectures • 09:20

Problem 4: Task02:45
Problem 4: Task - Text00:13
Problem 4: Solution in SQL02:47
Problem 4: Solution in SQL - Code00:13
Chart 4: Visualizing the Solution in Tableau03:22

Combining SQL and Tableau - Problem 5

1 lectures • 06:04

Problem 5: Organizing Charts 1-4 into a Beautiful Dashboard06:04

Part 6: Introduction to Programming with Python

7 lectures • 29:34

A 5-minute explanation of Programming05:04
A 5-minute explanation of Programming2 questions
Why use Python?05:11
Why Use Python?2 questions
Why use Jupyter?03:29
+6 more lectures

Python - Python Variables and Data Types

6 lectures • 28:31

Python Variables04:52
Python Coding Exercises02:40
Python Variables - Exercise #11 question
Python Variables - Exercise #21 question
Python Variables - Exercise #31 question
+18 more lectures

Python - Python Syntax Fundamentals

7 lectures • 15:13

The Arithmetic Operators of Python03:23
The Arithmetic Operators in Python - Exercise #11 question
The Arithmetic Operators in Python - Exercise #21 question
The Arithmetic Operators in Python - Exercise #31 question
The Arithmetic Operators in Python - Exercise #41 question
+25 more lectures

Python - Other Python Operators

2 lectures • 07:45

Python's Comparison Operators02:10
Python's Comparison Operators - Exercise #11 question
Python's Comparison Operators - Exercise #21 question
Python's Comparison Operators - Exercise #31 question
Python's Comparison Operators - Exercise #41 question
+9 more lectures

Python - Conditional Statements

4 lectures • 27:44

Getting to know the IF Statement06:13
The IF Statement - Exercise #11 question
The IF Statement - Exercise #21 question
Getting to know the IF Statement1 question
Adding an ELSE statement05:37
+6 more lectures

Python - Functions

7 lectures • 29:25

How to Define a Function in Python04:19
How to Create a Function with a Parameter07:58
How to Create a Function with a Parameter - Exercise #11 question
How to Create a Function with a Parameter - Exercise #21 question
Define a Function in Another Way05:29
+17 more lectures

Python - Python Sequences

5 lectures • 34:49

Introduction to Lists08:18
Introduction to Lists - Exercise #11 question
Introduction to Lists - Exercise #21 question
Introduction to Lists - Exercise #31 question
Introduction to Lists - Exercise #41 question
+29 more lectures

Python - Using Iterations

8 lectures • 40:48

Using For Loops05:40
Using For Loops - Exercise #11 question
Using For Loops - Exercise #21 question
Using For Loops1 question
Using While Loops and Incrementing05:10
+17 more lectures

Python - Advanced Python tools

4 lectures • 12:56

Introduction to Object Oriented Programming (OOP)05:00
Introduction to Object Oriented Programming (OOP)2 questions
Using Modules and Packages01:05
Using Modules and Packages2 questions
What is the Standard Library?02:47
+3 more lectures

Part 7: Integration - Software Integration

5 lectures • 29:38

Getting Started with Data, Servers, Clients, Requests, and Responses04:43
Getting Started with Data, Servers, Clients, Requests, and Responses2 questions
Getting Started with Data Connectivity, APIs, and Endpoints07:05
Getting Started with Data Connectivity, APIs, and Endpoints2 questions
Become Better Acquainted with APIs08:05
+5 more lectures

Integration - What is contained in this Course?

3 lectures • 10:14

Solving a Business Exercise with Python, SQL, and Tableau04:08
Presenting the Task: Absenteeism at Work02:48
Presenting the Data Set03:18
Presenting the Data Set1 question

Integration - Data Preprocessing Step by Step

32 lectures • 01:29:08

How is the Content in the Next Sections Organized?01:28
How to Import the Data Set in Python03:23
Exploring the Data Set05:53
Programming vs the Rest of the World03:27
A Brief Summary of Regression Analysis01:50
+27 more lectures

Integration - Integrating Python and SQL

11 lectures • 46:09

How to Use the 'absenteeism_module' in Python - Part I03:50
How to Use the 'absenteeism_module' in Python - Part II06:23
Creating the 'predicted_outputs' Database in MySQL06:37
Importing 'pymysql' in Python02:44
Creating a Connection and Cursor02:54
+6 more lectures

Integration - Using Tableau to Analyze the Predicted Outputs

7 lectures • 24:29

EXERCISE - Age vs Probability00:14
Using Tableau to Analyze Age vs Probability08:49
EXERCISE - Reasons vs Probability00:15
Using Tableau to Analyze Reasons vs Probability07:49
EXERCISE - Transportation Expense vs Probability00:22
+2 more lectures

Description

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!

Who this course is for:

  • Beginners to programming and data science
  • Students eager to learn about job opportunities in the field of data science
  • Candidates willing to boost their resume by learning how to combine the knowledge of Statistics, SQL, and Tableau in a real-world working environment
  • SQL Programmers who want to develop business reasoning and apply their knowledge to the solution of various business tasks
  • People interested in a Business Intelligence Analyst career

This course includes:

  • 22.5 hours on-demand video
  • 178 articles
  • 251 downloadable resources
  • Access on mobile and TV
  • Full lifetime access
  • Certificate of completion

Instructors

365 Careers

365 Team

Students also download

Explore related courses to expand your learning journey.