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

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


Homepage

https://www.udemy.com/course/learn-business-data-analysis-with-sql-and-tableau/