Business Intelligence Analyst Course

Module Resources 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Download All Resources

Relational Database Theory and Introduction to SQL 10 Topics

Expand

Lesson Content

0% Complete 0/10 Steps

Why use SQL?

Why use MySQL?

Introducing Databases

Relational Database Fundamentals

Comparing Databases and Spreadsheets

Important Database Terminology

The Concept of Relational Schemas: Primary Key

The Concept of Relational Schemas: Foreign Key

The Concept of Relational Schemas: Unique Key and Null Values

The Concept of Relational Schemas: Relationships Between Tables

SQL – Install and get to know MySQL 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

Installing MySQL Workbench and Server

Installing Visual C

Installing MySQL on macOS and Unix systems

The Client-Server Model

Linking GUI with the MySQL Server

Read me!!!

Creating a New User and a New Connection to it

Familiarize Yourself with the MySQL Interface

SQL – Best SQL Practices 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

Coding Tips and Best Practices – I

Coding Tips and Best Practices – II

SQL – Loading the ’employees’ Database 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Loading the ’employees’ Database

SQL – Pratical Application of the SQL SELECT Statement 58 Topics

Expand

Lesson Content

0% Complete 0/58 Steps

Using SELECT – FROM

Using SELECT – FROM – Exercise

Using SELECT – FROM – Solution

Using WHERE

Using WHERE – Exercise

Using WHERE – Solution

Operator Precedence and Logical Order

Operator Precedence and Logical Order – Exercise

Operator Precedence and Logical Order – Solution

Using IN – NOT IN

Using IN – NOT IN – Exercise 1

Using IN – NOT IN – Solution 1

Using IN – NOT IN – Exercise 2

Using IN – NOT IN – Solution 2

1 of 3

SQL – Expanding on MySQL Aggregate Functions 15 Topics

Expand

Lesson Content

0% Complete 0/15 Steps

Applying COUNT()

Applying COUNT() – Exercise

Applying COUNT() – Solution

Applying SUM()

Applying SUM() – Exercise

Applying SUM() – Solution

MIN() and MAX()

MIN() and MAX() – Exercise

MIN() and MAX() – Solution

Applying AVG()

Applying AVG() – Exercise

Applying AVG() – Solution

Rounding Numbers with ROUND()

Rounding Numbers with ROUND() – Exercise

Rounding Numbers with ROUND() – Solution

SQL – SQL JOINs 36 Topics

Expand

Lesson Content

0% Complete 0/36 Steps

What are JOINs?

What are JOINs? – Exercise 1

What are JOINs? – Exercise 2

The Functionality of INNER JOIN – Part I

The Functionality of INNER JOIN – Part II

The Functionality of INNER JOIN – PART II – Exercise

The Functionality of INNER JOIN – PART II – Solution

Extra Info on Using Joins

Duplicate Rows

The Functionality of LEFT JOIN – Part I

The Functionality of LEFT JOIN – Part II

The Functionality of LEFT JOIN – Part II – Exercise

The Functionality of LEFT JOIN – Part II – Solution

The Functionality of RIGHT JOIN

Differences between the New and the Old Join Syntax

Differences between the New and the Old Join Syntax – Exercise

Differences between the New and the Old Join Syntax – Solution

Using JOIN and WHERE Together

Important – Prevent Error Code: 1055!

Using JOIN and WHERE Together – Exercise

1 of 2

SQL – SQL Subqueries 10 Topics

Expand

Lesson Content

0% Complete 0/10 Steps

SQL Subqueries with IN Embedded Inside WHERE

SQL Subqueries with IN Embedded Inside WHERE – Exercise

SQL Subqueries with IN Embedded Inside WHERE – Solution

SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE

SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE – Exercise

SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE – Solution

SQL Subqueries Nested in SELECT and FROM

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 – Stored Routines 19 Topics

Expand

Lesson Content

0% Complete 0/19 Steps

Defining Stored Routines

Create Stored Procedures with MySQL Syntax

An Example of Stored Procedures Part I

An Example of Stored Procedures Part II

An Example of Stored Procedures Part II – Exercise

An Example of Stored Procedures Part II – Solution

Creating a Procedure in MySQL Another Way

Create Stored Procedures with an Input Parameter

Create Stored Procedures with an Output Parameter

Create Stored Procedures with an Output Parameter – Exercise

Stored Procedures with an Output Parameter – Solution

SQL Variables

SQL Variables – Exercise

SQL Variables – Solution

The Benefit of User-Defined Functions in MySQL

Error Code: 1418.

The Benefit of User-Defined Functions in MySQL – Exercise

The Benefit of User-Defined Functions in MySQL – Solution

Concluding Stored Routines

SQL – The CASE Statement 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

The SQL CASE Statement

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

Introduction to Tableau 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Why Use Tableau : Make your Data Make an Impact

Let’s Download Tableau Public

Connecting Data in Tableau

Exploring Tableau’s Interface

Let’s Create our first Chart in Tableau!

Tableau – Tableau functionalities 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

Duplicating a Sheet

Creating a Table

Creating Custom Fields

Creating a Custom Field and Adding Calculations to a Table

Adding Totals and Subtotals

Adding a Custom Calculation

Inserting a Filter

Working with Joins in Tableau

Tableau – The Tableau Exercise 12 Topics

Expand

Lesson Content

0% Complete 0/12 Steps

Introduction to the Exercise

Let’s Create a Dashboard – Visualizing the Three Charts We Want to Create

Using Joins in Tableau

Performing a Numbers Check – Attempt #1

Blending Data in Tableau

Performing a Numbers Check – Attempt #2

First Chart

Second Chart

Third Chart

Creating and Formatting a Dashboard

Adding Interactive Filters for Improved Analysis

Interactive Filters – fix

Combining SQL and Tableau – Introduction 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

Introduction to Software Integration

Combining SQL and Tableau

Loading the Database

Combining SQL and Tableau – Problem 1 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

Problem 1: Task

Problem 1: Task – Text

Important clarification!

Problem 1: Solution in SQL

Problem 1: Solution in SQL – Code

Exporting Your Output from SQL and Loading it in Tableau

Chart 1: Visualizing the Solution in Tableau – Part I

Chart 1: Visualizing the Solution in Tableau – Part II

Combining SQL and Tableau – Problem 2 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Problem 2: Task

Problem 2: Task – Text

Problem 2: Solution in SQL

Problem 2: Solution in SQL – Code

Chart 2: Visualizing the Solution in Tableau

Combining SQL and Tableau – Problem 3 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Problem 3: Task

Problem 3: Task – Text

Problem 3: Solution in SQL

Problem 3: Solution in SQL – Code

Chart 3: Visualizing the Solution in Tableau

Combining SQL and Tableau – Problem 4 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Problem 4: Task

Problem 4: Task – Text

Problem 4: Solution in SQL

Problem 4: Solution in SQL – Code

Chart 4: Visualizing the Solution in Tableau

Combining SQL and Tableau – Problem 5 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Problem 5: Organizing Charts 1-4 into a Beautiful Dashboard

Business Intelligence Analyst Course

Module Content

Cart