Practical Data Analysis SQL Tableau with Real Projects

Practical Data Analysis – SQL & Tableau with Real Projects, available at $74.99, has an average rating of 4.45, with 84 lectures, 8 quizzes, based on 67 reviews, and has 409 subscribers.

You will learn about 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 This course is ideal for individuals who are Beginners who want to learn data analysis and visualization from scratch or Anyone interested in leveraging data for decision-making and insights or Students pursuing careers in data analysis, business intelligence, or data visualization It is particularly useful for Beginners who want to learn data analysis and visualization from scratch or Anyone interested in leveraging data for decision-making and insights or Students pursuing careers in data analysis, business intelligence, or data visualization.

Enroll now: Practical Data Analysis – SQL & Tableau with Real Projects

Summary

Title: Practical Data Analysis – SQL & Tableau with Real Projects

Price: $74.99

Average Rating: 4.45

Number of Lectures: 84

Number of Quizzes: 8

Number of Published Lectures: 84

Number of Published Quizzes: 8

Number of Curriculum Items: 92

Number of Published Curriculum Objects: 92

Original Price: $49.99

Quality Status: approved

Status: Live

What You Will 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 Should Attend

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

Target Audiences

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

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!

Course Curriculum

Chapter 1: Introduction and Thank you!

Lecture 1: Introduction

Chapter 2: Download SQL Server Management studio and Adventureworks database

Lecture 1: Download SQL Server Management studio and Adventureworks database

Chapter 3: What is SQL and a Relational Database?

Lecture 1: SQL, Relational Database and Entity Relationship Diagram

Lecture 2: Quick SSMS overview

Chapter 4: Beginner SQL

Lecture 1: Select, From, Where, And, Or

Lecture 2: Select, From, Where, And, Or – Questions and Answers

Lecture 3: Upper and Lower

Lecture 4: IN and NOT IN operators

Lecture 5: Distinct, Like and Order By

Chapter 5: Intermediate SQL

Lecture 1: Inner Join

Lecture 2: Left and Right Join

Lecture 3: Joins – 2 Questions and Answers

Lecture 4: Union and Union All

Chapter 6: Aggregate Functions

Lecture 1: Sum, Round and Group by

Lecture 2: Having and Practice Question

Lecture 3: Count

Lecture 4: Max and Min

Lecture 5: Average

Lecture 6: Questions on Aggregate Functions

Chapter 7: Sub Query and Common Table Expression (CTE)

Lecture 1: Sub Queries

Lecture 2: Common Table Expression (CTE)

Chapter 8: Case Statement and Flags

Lecture 1: Case When

Lecture 2: Flags

Chapter 9: Window Functions

Lecture 1: Row_number()

Lecture 2: Row Number Q and A

Lecture 3: Lead and Lag

Chapter 10: Date Functions

Lecture 1: Year, Month, Day and Get Date

Lecture 2: DateDiff

Lecture 3: DateAdd

Lecture 4: Date table

Lecture 5: Cast and Convert

Lecture 6: Joining tables on more than one condition

Lecture 7: Date Functions – Questions and Answers

Chapter 11: String Functions

Lecture 1: Concat

Lecture 2: Substring

Chapter 12: Google Sheets and Pivot Tables

Lecture 1: Google Sheets – Pivot Tables

Lecture 2: Any Questions?

Chapter 13: Adventureworks Analysis Project

Lecture 1: Countries Sales by Age Group

Lecture 2: Products Sales by Age Group

Lecture 3: Sales in USA and Australia compared

Lecture 4: Products First Reorder Date

Lecture 5: Products with high stock levels

Lecture 6: Sales on Promotion

Lecture 7: Change in value between a customers first and last purchase

Chapter 14: Profile of customers who purchased a bike

Lecture 1: Customers by commute distance and country

Lecture 2: Amount of bike purchases by salary

Lecture 3: Sales for customers with children vs no children

Lecture 4: Putting it together

Lecture 5: Additional Analysis – Next Product Purchased after Bike Part 1

Lecture 6: Additional Analysis – Next Product Purchased after Bike Part 2

Chapter 15: Create Tableau Dashboard

Lecture 1: Getting the data for Tableau

Lecture 2: Download and install Tableau Public

Lecture 3: Tableau Overview

Lecture 4: Create Dual Axies Chart

Lecture 5: Create Country sales donut chart

Lecture 6: Create stacked bar chart and grouping our data

Lecture 7: Create Sales Cards

Lecture 8: Accessories bar chart

Lecture 9: Building our dashboard

Lecture 10: Format and publish the dashboard to Tableau Public

Lecture 11: Add Additional Sheet to Dashboard – Country Sales in a Map

Lecture 12: Add Additional Sheet to Dashboard – Running Total Chart

Chapter 16: Create your Own Stock Price Tracker

Lecture 1: What well do in this section

Lecture 2: Getting our Data

Lecture 3: Connect Tableau to Data Source and Change Default Properties

Lecture 4: Build our Candlestick Chart

Lecture 5: Create our Volume and Volatility Charts

Lecture 6: Import Logos to Tableau

Lecture 7: Create Last Price and % Change Cards

Lecture 8: Put Dashboard Together

Lecture 9: Format & Publish our Dashboard

Lecture 10: Add 2 Additional Cards – One Year Low and One Year % Change

Chapter 17: More Tableau Practice – Stock Portfolio Dashboard

Lecture 1: Introduction – What you will do in this section

Lecture 2: Getting our Stock Data

Lecture 3: Download Tableau and Connect to Data Source

Instructors

Graeme Gordon
Data & Insights | SQL | Tableau | Excel | Generative AI

Rating Distribution

1 stars: 1 votes

2 stars: 1 votes

3 stars: 7 votes

4 stars: 13 votes

5 stars: 45 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!