Learn Data Analysis With Sql And Tableau (2 Courses In 1)

Improve your Business Analytical Skills and Data Visualization in SQL and Tableau

What you'll learn
Understand Relational database Terminology
Install and Use MS SQL Server and Tableau
Learn SQL commands and functions needed for Select queries
Create complex queries for data analysis
Load data into Tableau application to start data visualization
Create professional diagrams and graphs for data analysis
Create dashboard in Tableau for reporting and presentation
Requirements
Windows Operating System
Description
As most of the business data stored in relational databases, learning SQL is essential for anyone wants to be a data analyst or scientist. SQL is the main tool used to manipulate data in relational databases, so mastering SQL is necessary to perform deep data analyses. This course teaches you SQL from scratch till writing complex queries. The course starts with you from the basic to the advanced level. In the beginning you will learn simple SELECT statement to retrieve data and after that increase the level of complexity step by step till learning to build complex queries. using the most important functions, such as: aggregation and date functions at your queries. Furthermore, you will learn joining multiple tables at your queries to retrieve the data you need for your analyses. You will learn sales, customers and inventory analysis. Before that, you learn how to install and use Microsoft SQL Server and Northwind database. In the next section, you will learn about data visualization and using Tableau to create insightful diagrams and charts. You will learn installing Tableau and be comfortable with creating varied diagrams, dashboards and stories and use them for business data analyses. You will learn how to import SELECT results in SQL Server into Tableau and use these data to create insightful diagrams. These diagrams can be very handy in data and business analysis. Enroll in this course to valuable knowledge to yours!  

Overview

Section 1: Introduction

Lecture 1 Introduction to the Course

Lecture 2 What you will learn from this course

Lecture 3 Control the pace of a lesson

Lecture 4 What you will learn in this section

Lecture 5 What is a Relational Database

Lecture 6 How tables are linked in a relational database

Lecture 7 Types of Relationships between Tables

Lecture 8 What is RDBMS

Section 2: Install and use Microsoft SQL Server

Lecture 9 What you will learn in this section

Lecture 10 Install MS SQL Server and Management Studio

Lecture 11 Introduction to SQL Server Management Studio

Lecture 12 Download and Create Northwind Database

Lecture 13 Introduction to Northwind Database

Lecture 14 Course Rating

Section 3: Introduction to SQL Queries

Lecture 15 What is SQL

Lecture 16 Introduction to Select Query

Lecture 17 Using AND and OR operators with Where condition

Lecture 18 Sorting obtained data using ORDER BY

Lecture 19 IN and NOT IN operators

Lecture 20 Wildcards

Lecture 21 A Wildcards learning resource

Lecture 22 Tables Joins in SQL

Lecture 23 Inner Join

Lecture 24 Left Outer Join

Lecture 25 Right Outer Join

Lecture 26 Full Outer Join

Lecture 27 Self Join

Lecture 28 Sub queries

Lecture 29 Aggregation Functions

Lecture 30 Using Group By

Lecture 31 Using Having Condition

Lecture 32 String Functions

Lecture 33 A String Functions learning resource

Lecture 34 Date Functions

Lecture 35 A Date Functions learning resource

Lecture 36 Conversion Functions

Lecture 37 Section Review

Lecture 38 Course Rating

Section 4: Data Analysis Part-1 (Products and Inventory)

Lecture 39 Section Overview

Lecture 40 Task 1: Find the top 10 purchased products by name

Lecture 41 Task 1 Code Solution

Lecture 42 Task 2: Find the product that has the second highest unit price

Lecture 43 Task 2 Code Solution

Lecture 44 Task 3: Use DENS_RANK() to rank the sold products in each city in the USA

Lecture 45 Task 3 Code Solution

Lecture 46 Task 4: Find the products that were shipped late to customers

Lecture 47 Task 4 Code Solution

Lecture 48 Case Statement

Lecture 49 Task 5: Use Case Statement to classify products based on their stock level

Lecture 50 Task 5 Code Solution

Lecture 51 Task 6: Find number of orders per product

Lecture 52 Task 6 Code Solution

Lecture 53 UNION and UNION ALL Operators

Lecture 54 Common Table Expression (CTE)

Lecture 55 Task 7: Create a list of products with the current and future required stock

Lecture 56 Task 7 Code Solution

Lecture 57 Course Rating

Section 5: Data Analysis Part-2 (Sales and Customers)

Lecture 58 Section Overview

Lecture 59 Task 1a: Find number of orders, revenue and AVG revenue per order in year 2017

Lecture 60 Task 1a Code Solution

Lecture 61 Task 1b: Find the top 10 valuable customers for the business in 2018

Lecture 62 Task 1b Code Solution

Lecture 63 Task 2: Find the products generated total sales greater than $30000

Lecture 64 Task 2 Code Solution

Lecture 65 Task 3: Classify customers into 3 levels based on contribution to total sale

Lecture 66 Task 3 Code Solution

Lecture 67 Task 4: Find customers that generated a total sales amount greater than average

Lecture 68 Task 4 Code Solution

Lecture 69 Task 5: Find the sales volume per customer for each year

Lecture 70 Task 5 Code Solution

Lecture 71 Task 6: Find customers that didn't place orders in the last 20 months

Lecture 72 Task 6 Code Solution

Lecture 73 Task 7: Find the number of orders per customer

Lecture 74 Task 7 Code Solution

Lecture 75 Task 8: Find the customer contributed to the third highest sales volume

Lecture 76 Task 8 Code Solution Part - 1

Lecture 77 Task 8 Code Solution Part - 2

Lecture 78 Task 9: Find duration in days between every two orders for each customer

Lecture 79 Task 9 Code Solution

Lecture 80 Task 10: Sales data analysis in time series part 1

Lecture 81 Task 10: Sales data analysis in time series part 2

Lecture 82 Task 11: Find the number of orders in each month using Case Statement

Lecture 83 Task 11 Code Solution

Lecture 84 Task12: Find the number of orders per date, week and day in 2017

Lecture 85 Task 12 Code Solution

Lecture 86 Task 13: Find the revenue and revenue percentage per customer

Lecture 87 Task 13 Code Solution

Lecture 88 Course Rating

Section 6: Data Analysis Part-3 (Employees and Staff)

Lecture 89 Section Overview

Lecture 90 Task 1: Find the employees that achieved highest sales volumes and their bonus

Lecture 91 Task 1 Code Solution

Lecture 92 Task 2: Find the number of employees per title for each city

Lecture 93 Task 2 Code Solution

Lecture 94 Task 3: List the company's employees and their work duration in years

Lecture 95 Task 3 Code Solution

Lecture 96 Task 4: Find the employees older than 70 years old

Lecture 97 Task 4 Code Solution

Section 7: Learn Data Visualization from A to Z with Tableau

Lecture 98 Introduction to the Course

Lecture 99 Introduction to Data Visualization

Lecture 100 Installing Tableau Public

Lecture 101 Overview on Tableau Work Environment

Lecture 102 Connecting to Data Sources

Lecture 103 Options of Data Connection in Tableau Professional

Section 8: Learn Tableau Basics

Lecture 104 Create Your First Diagram

Lecture 105 Add Formatting to Diagrams

Lecture 106 Create a Treemap Chart

Lecture 107 Homework 1

Lecture 108 Homework 1 Solution

Lecture 109 Create Calculated Fields

Lecture 110 Add Filters to Diagrams

Lecture 111 Types of Aggregation Measures

Lecture 112 Homework 2

Section 9: Managing and Preparing Data in Tableau

Lecture 113 Use Data Interpreter for data cleaning

Lecture 114 Pivot and Unpivot Operators

Lecture 115 Pivot data and change data types

Lecture 116 Create a bar chart

Lecture 117 Managing Metadata (Renaming and Hiding Data Fields)

Lecture 118 Managing Metadata (Grouping Fields in Folders and Hierarchies)

Section 10: Introduction to Data Granularity

Lecture 119 Introduction to Granularity

Lecture 120 Time Series Data Analysis

Lecture 121 Introduction to Data Bins

Lecture 122 Create Bins in Tableau

Lecture 123 Homework 3

Lecture 124 Homework 3 Solution

Section 11: Creating a Dashboard and Story

Lecture 125 What is a Dashboard

Lecture 126 Create Dashboard Diagrams Part 1

Lecture 127 Create Dashboard Diagrams Part 2

Lecture 128 Create a Dashboard

Lecture 129 Interpret the KPI's

Lecture 130 A Story Definition

Lecture 131 Create a Story

Section 12: Creating Maps in Tableau

Lecture 132 Introduction to the Business Problem and Data Preparation

Lecture 133 Universities Data Analysis using Maps

Lecture 134 Students Data Analysis using Maps

Lecture 135 Deal with Unknown Spatial Data

Section 13: Joining and Blending Data in Tableau

Lecture 136 Introduction to Tables Join

Lecture 137 Join Tables in Tableau

Lecture 138 Blending Definition in Tableau

Lecture 139 Blend Data in Tableau Part 1

Lecture 140 Blend Data in Tableau Part 2

Section 14: Groups, Sets, and Parameters

Lecture 141 Definition of Groups and Sets in Tableau

Lecture 142 Create a Group in Tableau

Lecture 143 Create the Constant Set in Tableau

Lecture 144 Create a Dynamic Set in Tableau

Lecture 145 Combine Sets in Tableau

Lecture 146 Use Quick Table Calculation Feature

Lecture 147 Add a Table Calculation

Lecture 148 Create and Use Parameters in Tableau

Section 15: Use Data Analytics Features in Tableau

Lecture 149 Add a Reference Line in Tableau

Lecture 150 Scatter Plot Analysis in Tableau

Lecture 151 Use Forecast Algorithm in Tableau

Lecture 152 Use Cluster Algorithm in Tableau

Section 16: The Project (Delayed Flights Analyses)

Lecture 153 Overview on the Business Problem Data

Lecture 154 Arrival Flights per Airline

Lecture 155 Percentage of Arrival and Delayed Flights

Lecture 156 Percentage of Delayed Flights in Time Series

Lecture 157 Percentage of Delayed Flights per State (Map Chart)

Lecture 158 The Project Homework

Those who need to learn to create complex SQL queries and professional data diagrams and charts for data analysis