Practical Data Analysis - SQL & Tableau with Real Projects

Focused View

Graeme Gordon

8:13:03

70 View

1. Introduction and Thank you!

1. Introduction.mp4

01:23

2. Download SQL Server Management studio and Adventureworks database

1. Download SQL Server Management studio and Adventureworks database.mp4

05:02

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.mp4

02:45

2. Quick SSMS overview.mp4

02:45

4. Beginner SQL

1.1 SQL and Tableau course -6-14.pdf

1. Select, From, Where, And, Or.mp4

05:06

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

03:36

3.1 SQL and Tableau course -15-23.pdf

3. Upper and Lower.mp4

02:19

4. IN and NOT IN operators.mp4

02:07

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

6. Distinct, Like and Order By.mp4

05:29

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.mp4

03:38

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

3. Left and Right Join.mp4

02:36

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

5. Joins - 2 Questions and Answers.mp4

04:34

6.1 SQL and Tableau course -33-38.pdf

6. Union and Union All.mp4

02:53

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.mp4

03:29

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

3. Having and Practice Question.mp4

03:56

4.1 SQL and Tableau course -44-48.pdf

4. Count.mp4

02:26

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

6. Max and Min.mp4

02:49

7. Average.mp4

03:45

8. Questions on Aggregate Functions.mp4

05:30

7. Sub Query and Common Table Expression (CTE)

1.1 SQL and Tableau course -49-54.pdf

1. Sub Queries.mp4

04:55

2. Common Table Expression (CTE).mp4

05:12

8. Case Statement and Flags

1.1 SQL and Tableau course -55-57.pdf

1. Case When.mp4

03:53

2.1 SQL and Tableau course -58-60.pdf

2. Flags.mp4

04:19

9. Window Functions

1.1 SQL and Tableau course -61-67.pdf

1. Row number().mp4

03:42

2. Row Number Q and A.mp4

03:53

3. Lead and Lag.mp4

04:38

10. Date Functions

1.1 Data Types.docx

1.2 SQL and Tableau course -68-73.pdf

1. Year, Month, Day and Get Date.mp4

01:44

2. DateDiff.mp4

02:26

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

4. DateAdd.mp4

03:47

5. Date table.mp4

01:05

6.1 SQL and Tableau course -74-77.pdf

6. Cast and Convert.mp4

02:26

7. Joining tables on more than one condition.mp4

01:55

8. Date Functions - Questions and Answers.mp4

07:46

11. String Functions

1.1 SQL and Tableau course -78-81.pdf

1. Concat.mp4

03:13

2. Substring.mp4

02:30

12. Google Sheets and Pivot Tables

1. Google Sheets - Pivot Tables.mp4

08:45

2. Any Questions.mp4

00:15

13. Adventureworks Analysis Project

1. Countries Sales by Age Group.mp4

13:21

2. Products Sales by Age Group.mp4

10:51

3. Sales in USA and Australia compared.mp4

07:27

4. Products First Reorder Date.mp4

10:57

5. Products with high stock levels.mp4

10:16

6. Sales on Promotion.mp4

04:40

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

08:40

14. Profile of customers who purchased a bike

1. Customers by commute distance and country.mp4

13:27

2. Amount of bike purchases by salary.mp4

08:35

3. Sales for customers with children vs no children.mp4

11:18

4. Putting it together.mp4

06:26

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

13:17

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

10:52

15. Create Tableau Dashboard

1. Getting the data for Tableau.mp4

06:50

2. Download and install Tableau Public.mp4

02:46

3. Tableau Overview.mp4

04:22

4. Create Dual Axies Chart.mp4

05:38

5. Create Country sales donut chart.mp4

06:02

6. Create stacked bar chart and grouping our data.mp4

06:19

7. Create Sales Cards.mp4

06:21

8. Accessories bar chart.mp4

03:39

9.1 logo.zip

9. Building our dashboard.mp4

11:28

10. Format and publish the dashboard to Tableau Public.mp4

11:34

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

04:40

12. Add Additional Sheet to Dashboard - Running Total Chart.mp4

07:22

16. Create your Own Stock Price Tracker

1. What well do in this section.mp4

00:30

2. Getting our Data.mp4

03:45

3. Connect Tableau to Data Source and Change Default Properties.mp4

02:12

4. Build our Candlestick Chart.mp4

09:14

5. Create our Volume and Volatility Charts.mp4

04:13

6. Import Logos to Tableau.mp4

03:09

7. Create Last Price and % Change Cards.mp4

07:07

8. Put Dashboard Together.mp4

12:06

9. Format & Publish our Dashboard.mp4

14:47

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

11:57

17. More Tableau Practice - Stock Portfolio Dashboard

1. Introduction - What you will do in this section.mp4

00:46

2. Getting our Stock Data.mp4

06:18

3. Download Tableau and Connect to Data Source.mp4

03:57

4. Create Cards for Stock Value and ProfitLoss.mp4

12:03

5. Create Donut Donut.mp4

05:27

6. 3 Month Trend Charts and Stock Overview.mp4

09:53

7. 3 Month Portfolio Value chart.mp4

02:04

8. Performance % of Each Stock.mp4

04:58

9. Individual Stock Chart and Parameter.mp4

09:22

10. Building our Tableau Dashboard.mp4

09:40

11. Publishing our Dashboard.mp4

02:33

12. Formatting our Tableau Dashboard.mp4

17:22

Description

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

What You'll Learn?

SQL Server - Beginner to Intermediate. You will install and use SQL Server Management Studio
Write complex queries to extract data from a database - No prior experience required
Understand Relational Databases and Entity Relationship Diagrams
Do a Customer Profile on Adventureworks database including Google Sheets Pivot Tables and dual axies charts
Build Two Tableau Dashboards
Create Calculated Fields and a Period Parameter in Tableau
Publish your Tableau Dashboards Online so they can be accessed anywhere

Who is this for?

Beginners who want to learn data analysis and visualization from scratch

Anyone interested in leveraging data for decision-making and insights

Students pursuing careers in data analysis, business intelligence, or data visualization

What You Need to Know?

No prior experience required, although basic knowledge of databases and data analysis concepts would be helpful

You will need access to a windows computer with internet connection

More details

Description
Thanks for your interest in this hands-on course for SQL and Tableau! In this comprehensive course, you will learn how to effectively analyze and visualize data using two of the most popular tools in the field of data science - SQL and Tableau.
Whether you're a beginner looking to dive into the world of data analysis or an experienced professional looking to enhance your skills, this course is designed to cater to all levels of learners. With a practical, hands-on approach, you'll gain the confidence to apply SQL and Tableau to real-world data scenarios.
In the SQL section, you'll start with the fundamentals, learning how to write basic queries using SQLÂ Server Management Studio.
Please note: Mac Users will need to install Azure Data Studio and Docker to be able to access SQLÂ Server. If you want to learn SQL on Mac, please see my other course which uses MySQL Workbench.
You'll gain expertise in querying databases, filtering and sorting data, and performing advanced operations such as joins, subqueries, window functions and aggregations.
You will then ask questions of the data and visualize the output in Google Sheets using pivot tables and charts to help identify trends.
In the Tableau section, you'll learn how to create interactive dashboards. You'll start with the basics, including connecting to data sources and creating visualizations using the drag and drop feature. You'll then move on to advanced topics such as calculated fields, sets and parameters. You'll also learn how to create dynamic and interactive visualizations that can be shared with others.
Throughout the course, you'll work on practical exercises to reinforce your learning. You'll gain real experience in data analysis and visualization, and build a portfolio of work to showcase your skills to potential employers.
By the end of this course, you'll have a strong foundation in SQL and Tableau, and be able to confidently analyze and visualize data for business intelligence, reporting, and decision-making purposes. Join us on this exciting journey to become a data analysis and visualization expert!
Course Features:

Comprehensive coverage of SQL and Tableau, from fundamentals to more advanced topics
Practical, hands-on approach with real-world projects and exercises
Step-by-step guidance and demonstrations
Portfolio-building opportunities
Access to course materials and updates for lifetime
Q&A support from the instructor
Certificate of completion

Don't miss this opportunity to become proficient in SQL and Tableau and unlock the power of data analysis and visualization. Enroll now and take your data skills to the next level!
Who this course is for:
Beginners who want to learn data analysis and visualization from scratch
Anyone interested in leveraging data for decision-making and insights
Students pursuing careers in data analysis, business intelligence, or data visualization

User Reviews

Rating

average 0

Total votes0

Focused display

I am a self taught Data and Insights Analyst with over 4 years experience working with data. I use SQL, Tableau and Microsoft Excel at an advanced level in my job every day and want to share my skills and teach how I would have wanted to learn these topics which can help you become a data analyst quickly. I aim to make my courses practical so you are getting real experience and getting a feel for what the job will be like. It is the best way to learn in my opinion. Please get in touch if you have any questions.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.