Hands-On Data Analysis using SQL & Tableau with Real Project

Focused View

Graeme Gordon

3:00:22

102 View

1 - Introduction and Thank you

1 - Introduction.mp4

01:07

2 - Download SQL Server Management studio and Adventureworks database

2 - Download SQL Server Management studio and Adventureworks database.mp4

03:24

3 - What is SQL and a Relational Database

3 - SQL Relational Database and Entity Relationship Diagram.mp4

02:41

3 - erd.zip

4 - Beginner SQL

4 - Select From Where And Or.mp4

05:06

5 - Select From Where And Or Questions and Answers.mp4

03:36

6 - Upper and Lower.mp4

02:14

7 - IN and NOT IN operators.mp4

02:07

8 - Distinct Like and Order By.mp4

05:27

5 - Intermediate SQL

9 - Inner Join.mp4

03:40

10 - Left and Right Join.mp4

03:04

11 - Joins 2 Questions and Answers.mp4

04:32

12 - Union and Union All.mp4

02:52

6 - Aggregate Functions

13 - Sum Round and Group by.mp4

03:29

14 - Having and Practice Question.mp4

03:54

15 - Count.mp4

02:26

16 - Max and Min.mp4

02:48

17 - Average.mp4

03:43

18 - Questions on Aggregate Functions.mp4

05:30

7 - Sub Query and Common Table Expression CTE

19 - Sub Queries.mp4

04:54

20 - Common Table Expression CTE.mp4

05:12

8 - Case Statement and Flags

21 - Case When.mp4

03:53

22 - Flags.mp4

04:19

9 - Date Functions

23 - Data-Types.docx

23 - Year Month Day and Get Date.mp4

01:44

24 - DateDiff.mp4

02:26

25 - DateAdd.mp4

03:47

26 - Date table.mp4

01:05

27 - Cast and Convert.mp4

02:23

28 - Joining tables on more than one condition.mp4

01:35

29 - Date Functions Questions and Answers.mp4

07:39

10 - String Functions

30 - Concat.mp4

03:12

31 - Substring.mp4

02:29

11 - Google Sheets and Pivot Tables

32 - Google Sheets Pivot Tables.mp4

08:45

12 - Adventureworks Analysis Project

33 - Countries sales by Age Group.mp4

12:46

34 - Products sales by Age Group.mp4

10:33

35 - Sales in USA and Australia compared.mp4

07:27

36 - Products First Reorder Date.mp4

10:57

37 - Products with high stock levels.mp4

10:16

38 - Sales on Promotion.mp4

04:40

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

08:40

Description

Learn and practice SQL and Tableau and how to use these to analyze and visualize data by working on real projects

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?

Beginner data analyst who is keen to learn sql and methods used to retrieve data from a database.

Anyone who is interested in working with data and becoming an analyst

More details

Description
Since data analytics has become such an in demand still worldwide, there has never been a better time to learn how to work with data and become a data analyst.
I have been working with data for over 4 years and I use Sql every day in my job. I want to pass this knowledge on to you by going through each topic and working with real examples. I will also go over relational databases and crow's foot entity relationship diagrams.
SQL, or Structured Query Language, is the main tool used for any data analyst and is used to execute queries and retrieve data stored in a relational database.
This course will have you writing complex queries in Sql Server Management Studio and extracting the data we have found to
Google Sheets to create a visual chart and pivot table to help us easily identify trends.
By working on a real project and getting real practice writing queries, you can fast become an expert in Sql and have something to show potential job interviewers.
You will also download and install Tableau public to learn Data Visualization by creating a dashboard with filters which would also help impress anyone looking to hire an analyst. I have added an extra section where you will build a Stock Portfolio Dashboard as well in less than 90 minutes. You can modify this to suit your own portfolio.
No experience is required and you will be guided through every step to help you understand the process of exploratory data analysis.
Please note: For the Stock Performance Dashboard I am not advising you to buy any of the stocks shown in it. It is for educational purposes only.

Enroll now to get started in your journey towards an exciting career in data science!
Who this course is for:
Beginner data analyst who is keen to learn sql and methods used to retrieve data from a database.
Anyone who is interested in working with data and becoming an analyst

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.