Library

Course: Integrating SQL and Tableau with Real Life Practical Examples

Integrating SQL and Tableau with Real Life Practical Examples

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
  • Self-Paced
About this Course

Business Intelligence comprises of several skills. SQL and Tableau integration is one of the six essential skills a business intelligence analyst must posses.

Learning a programming language is meaningless without putting it to use. That’s why integrating SQL and Tableau, and performing several real-life Business Intelligence tasks is the main focus of this course.

Basic knowledge
  • A basic knowledge in SQL (My SQL) and Tableau is required
  • You’ll need to install MySQL and Tableau Public
What you will learn
  • Use SQL to create, design, and manipulate SQL databases
  • Extract data from a database writing your own queries
  • Create powerful professional visualisations in Tableau
  • Combine SQL and Tableau to visualise data from the source
  • Solve real-world business analysis tasks in SQL and Tableau
Curriculum
Number of Lectures: 17
Total Duration: 01:10:43
Introduction
  • Lesson 1: Introduction to Software Integration  
  • Lesson 2: Combining SQL and Tableau  
  • Lesson 3: Loading the Database  

    Please click on the link below to access and download the employee_mod database.


    https://1drv.ms/u/s!Ap6j469MCj71hEoH8J3RwDCPZXKw


Real Life Practical Task 1
  • Lesson 1: Task 1 Description  
  • Lesson 2: Task 1 Solution is SQL  
  • Lesson 3: Exporting your Output from SQL and Loading it in Tableau  
  • Lesson 4: Visualising Task 1 Solution in Tableau Part 1  
  • Lesson 5: Visualising Task 1 Solution in Tableau Part 2  
Real Life Practical Task 2
  • Lesson 1: Task 2 Description  
  • Lesson 2: Task 2 Solution in SQL  
  • Lesson 3: Visualising Task 2 Solution in Tableau  
Real Life Practical Task 3
  • Lesson 1: Task 3 Description  
  • Lesson 2: Task 3 Solution in SQL  
  • Lesson 3: Visualising Task 3 Solution in Tableau  
Real Life Practical Task 4
  • Lesson 1: Task 4 Description  
  • Lesson 2: Task 4 Solution in SQL  
  • Lesson 3: Visualising Task 4 Solution in Tableau  
Rating
Enrolled Students
(63)
Level
Intermediate
Price
$ 10.00
Course Language
English
Reviews (0)