Practical Data Analysis – SQL & Tableau with Real Projects

سرفصل های دوره

Hands-On Learning of SQL & Tableau and how they're used by a Data Analyst with Real Examples & Exercises

1. Introduction and Thank you!

1. Introduction

2. Download SQL Server Management studio and Adventureworks database

1. Download SQL Server Management studio and Adventureworks database

3. What is SQL and a Relational Database

1.1 erd.zip

1.2 SQL and Tableau course -1-6.pdf

1. SQL, Relational Database and Entity Relationship Diagram

2. Quick SSMS overview

4. Beginner SQL

1.1 SQL and Tableau course -6-14.pdf

1. Select, From, Where, And, Or

2. Select, From, Where, And, Or - Questions and Answers

3.1 SQL and Tableau course -15-23.pdf

3. Upper and Lower

4. IN and NOT IN operators

5. Show all columns for customers who are from New York, London or Mumbai using IN.html

6. Distinct, Like and Order By

7. Show all Customers with Last Name Yang, Lin or Alvarez using the IN operator.html

5. Intermediate SQL

1.1 SQL and Tableau course -24-32.pdf

1. Inner Join

2. Show All Columns from the Sales and Customer table.html

3. Left and Right Join

4. Show all customers and their orders, even if they made no orders.html

5. Joins - 2 Questions and Answers

6.1 SQL and Tableau course -33-38.pdf

6. Union and Union All

7. Show all Employees and Customers.html

6. Aggregate Functions

1.1 SQL and Tableau course -39-43.pdf

1. Sum, Round and Group by

2. Show the sum of all orders on each day.html

3. Having and Practice Question

4.1 SQL and Tableau course -44-48.pdf

4. Count

5. Count how many distinct customers there were on each day.html

6. Max and Min

7. Average

8. Questions on Aggregate Functions

7. Sub Query and Common Table Expression (CTE)

1.1 SQL and Tableau course -49-54.pdf

1. Sub Queries

2. Common Table Expression (CTE)

8. Case Statement and Flags

1.1 SQL and Tableau course -55-57.pdf

1. Case When

2.1 SQL and Tableau course -58-60.pdf

2. Flags

9. Window Functions

1.1 SQL and Tableau course -61-67.pdf

1. Row number()

2. Row Number Q and A

3. Lead and Lag

10. Date Functions

1.1 Data Types.docx

1.2 SQL and Tableau course -68-73.pdf

1. Year, Month, Day and Get Date

2. DateDiff

3. Show the difference in months between each order and todays date.html

4. DateAdd

5. Date table

6.1 SQL and Tableau course -74-77.pdf

6. Cast and Convert

7. Joining tables on more than one condition

8. Date Functions - Questions and Answers

11. String Functions

1.1 SQL and Tableau course -78-81.pdf

1. Concat

2. Substring

12. Google Sheets and Pivot Tables

1. Google Sheets - Pivot Tables

2. Any Questions

13. Adventureworks Analysis Project

1. Countries Sales by Age Group

2. Products Sales by Age Group

3. Sales in USA and Australia compared

4. Products First Reorder Date

5. Products with high stock levels

6. Sales on Promotion

7. Change in value between a customers first and last purchase

14. Profile of customers who purchased a bike

1. Customers by commute distance and country

2. Amount of bike purchases by salary

3. Sales for customers with children vs no children

4. Putting it together

5. Additional Analysis - Next Product Purchased after Bike Part 1

6. Additional Analysis - Next Product Purchased after Bike Part 2

15. Create Tableau Dashboard

1. Getting the data for Tableau

2. Download and install Tableau Public

3. Tableau Overview

4. Create Dual Axies Chart

5. Create Country sales donut chart

6. Create stacked bar chart and grouping our data

7. Create Sales Cards

8. Accessories bar chart

9.1 logo.zip

9. Building our dashboard

10. Format and publish the dashboard to Tableau Public

11. Add Additional Sheet to Dashboard - Country Sales in a Map

12. Add Additional Sheet to Dashboard - Running Total Chart

16. Create your Own Stock Price Tracker

1. What well do in this section

2. Getting our Data

3. Connect Tableau to Data Source and Change Default Properties

4. Build our Candlestick Chart

5. Create our Volume and Volatility Charts

6. Import Logos to Tableau

7. Create Last Price and % Change Cards

8. Put Dashboard Together

9. Format & Publish our Dashboard

10. Add 2 Additional Cards - One Year Low and One Year % Change

17. More Tableau Practice - Stock Portfolio Dashboard

1. Introduction - What you will do in this section

2. Getting our Stock Data

3. Download Tableau and Connect to Data Source

4. Create Cards for Stock Value and ProfitLoss

5. Create Donut Donut

6. 3 Month Trend Charts and Stock Overview

7. 3 Month Portfolio Value chart

8. Performance % of Each Stock

9. Individual Stock Chart and Parameter

10. Building our Tableau Dashboard

11. Publishing our Dashboard

12. Formatting our Tableau Dashboard

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training