Business Intelligence Mastery with SQL and Tableau [2-in-1]


Unlock the Power of Data: Become a Business Intelligence Expert with SQL and Tableau | Business Intelligence Essentials

What you will learn

Master SQL syntax and write complex queries to extract business insights.

Develop the skills to visualize complex data using Tableau.

Use Tableau to create interactive dashboards and reports to communicate insights effectively.

Explore and analyze large datasets to identify trends and patterns.

Discover how to clean, transform, and prepare data for analysis using SQL.

Master advanced SQL concepts like subqueries, joins, and views.

Learn how to create calculated fields and use Tableau’s data blending capabilities

Description

If you’re looking to take your career to the next level by mastering data analytics, you’re in the right place! Do you ever wonder how top companies like Amazon, Netflix, and Google make informed decisions? The answer is Business Intelligence, and this course will teach you the fundamentals of it using SQL and Tableau.

Business Intelligence Mastery with SQL and Tableau [2-in-1] is a comprehensive course that covers the essentials of Business Intelligence, equipping you with the skills to leverage data to drive business decisions.

In this course, you will:

  • Develop a deep understanding of SQL and its practical applications in extracting insights from complex data sets
  • Master Tableau to create interactive dashboards and visualize complex data with ease
  • Explore real-world case studies and practice exercises to apply your skills in practice
  • Gain a competitive edge in the job market by acquiring highly sought-after Business Intelligence skills
  • Get access to lucrative career opportunities in various domains such as finance, marketing, and operations

Business Intelligence is a key element of success in today’s data-driven world. By learning SQL and Tableau, you’ll gain a competitive edge in the job market and be able to work with data to inform business decisions.


Subscribe to latest coupons on our Telegram channel.

Throughout the course, you’ll be challenged with quizzes, exercises, and projects to cement your learning and apply your skills in practice. Our experienced instructors have designed this course to ensure that you have a solid understanding of Business Intelligence and are well-equipped to take on any data analytics challenge.

Why learn from us? Our instructors are experts in the field of Business Intelligence and have extensive experience working with SQL and Tableau. By enrolling in this course, you’ll receive personalized support and guidance throughout your learning journey.

Business Intelligence Mastery with SQL and Tableau [2-in-1] is the perfect course for anyone looking to take their career to the next level.

Enroll today and start unlocking the power of data!

English
language

Content

Introduction

Introduction
Course Resources
This is a milestone!

Installation and getting started

Installing PostgreSQL and pgAdmin in your PC
If pgAdmin is not opening…

Fundamental SQL statements

CREATE
INSERT
Import data from File
SELECT statement
SELECT DISTINCT
WHERE
Logical Operators
UPDATE
DELETE
ALTER – Part 1
ALTER – Part 2

Restore and Back-up

Restore and Back-up
Debugging restoration issues
Creating DB using CSV files
Debugging summary and Code for CSV files

Selection commands: Filtering

IN
BETWEEN
LIKE

Selection commands: Ordering

Side lecture: Commenting in SQL
ORDER BY
LIMIT

Alias

AS

Aggregate Commands

COUNT
SUM
AVERAGE
MIN & MAX

Group By Commands

GROUP BY
HAVING

Conditional Statement

CASE WHEN

JOINS

Introduction to Joins
Concepts of Joining and Combining Data
Preparing the data
Inner Join
Left Join
Right Join
Cross Join
Intersect and Intersect ALL
Except
Union

Subqueries

Subquery in WHERE clause
Subquery in FROM clause
Subquery in SELECT clause

Views and Indexes

VIEWS
INDEX

String Functions

LENGTH
UPPER LOWER
REPLACE
TRIM, LTRIM, RTRIM
CONCATENATION
SUBSTRING
LIST AGGREGATION

Mathematical Functions

CEIL & FLOOR
RANDOM
SETSEED
ROUND
POWER

Date-Time Functions

CURRENT DATE & TIME
AGE
EXTRACT

PATTERN (STRING) MATCHING

PATTERN MATCHING BASICS
ADVANCE PATTERN MATCHING – Part 1
ADVANCE PATTERN MATCHING – Part 2

Windows Functions

Introduction to Window functions
Introduction to Row number
Implementing Row number in SQL
RANK and DENSERANK
NTILE function
AVERAGE function
COUNT
SUM TOTAL
RUNNING TOTAL
LAG and LEAD

COALESCE function

COALESCE function

Data Type conversion functions

Converting Numbers/ Date to String
Converting String to Numbers/ Date

User Access Control Functions

User Access Control – Grant and Revoke
User Access Control – Drop, Alter

Nail that Interview!

Tablespace
PRIMARY KEY & FOREIGN KEY
ACID compliance
Truncate

TABLEAU

Why Tableau
Tableau Products

Installation and getting started

Installing Tableau desktop and Public
About the data
Connecting to data
Live vs Extract

Combining data to create Data model

Combining data from multiple tables
Relationships in Tableau
Joins in Tableau
Types of Joins in Tableau
Union in Tableau
Physical Logical layer and Data models
The visualization screen – Sheet

Data categorization in Tableau

Types of Data – Dimensions and Measures
Types of Data – Discreet and Continuous
Changing Data type in Tableau

Most used charts

Bar charts
Line charts
Scatterplots

Customizing charts using Marks shelf

Marks cards
Dropping Dimensions and Measures on marks card
Dropping Dimensions on Line chart
Adding marks in scatterplot

Other important charts

Text tables, heat map and highlight tables
Pie charts
Area charts
Creating custom hierarchy
Tree map
Dual combination charts
Creating Bins
Histogram

Grouping and Filtering data

Grouping Data
Filtering data
Dimension filters
Measure filters
Date-Time filters
Filter options
Types of filters and order of operation
Customizing visual filters
Sorting options

Map chart in Tableau

How to make a map chart
Considerations before making a Map chart
Marks card for customizing maps
Customizing maps using map menu
Layers in a Map
Visual toolbar on a map
Custom background images
Territories in maps
Data blending for missing geocoding

Calculations and Analytics

Calculated fields in Tableau
Functions in Tableau
Table calculations theory
Table calculations in Tableau
Understanding LOD expressions
LOD expressions examples
Analytics pane

Sets and Parameters

Understanding sets in Tableau
Creating Sets in Tableau
Parameters

Dashboard and Story

Dashboard part -1
Dashboard part – 2
Story

Appendix

Connecting to SQL data source
Connecting to cloud storage services
The final milestone!

Congratulations and about your certificate

Bonus Lecture