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

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

Requirements

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

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. There are many guides online for this and I suggest you try it before enrolling to ensure it works on your version of Mac.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 topicsPractical, hands-on approach with real-world projects and exercisesStep-by-step guidance and demonstrationsPortfolio-building opportunitiesAccess to course materials and updates for lifetimeQ&A support from the instructorCertificate of completionDon'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!

Overview

Section 1: Introduction and Thank you!

Lecture 1 Introduction

Section 2: Download SQL Server Management studio and Adventureworks database

Lecture 2 Download SQL Server Management studio and Adventureworks database

Section 3: What is SQL and a Relational Database?

Lecture 3 SQL, Relational Database and Entity Relationship Diagram

Lecture 4 Quick SSMS overview

Section 4: Beginner SQL

Lecture 5 Select, From, Where, And, Or

Lecture 6 Select, From, Where, And, Or - Questions and Answers

Lecture 7 Upper and Lower

Lecture 8 IN and NOT IN operators

Lecture 9 Distinct, Like and Order By

Section 5: Intermediate SQL

Lecture 10 Inner Join

Lecture 11 Left and Right Join

Lecture 12 Joins - 2 Questions and Answers

Lecture 13 Union and Union All

Section 6: Aggregate Functions

Lecture 14 Sum, Round and Group by

Lecture 15 Having and Practice Question

Lecture 16 Count

Lecture 17 Max and Min

Lecture 18 Average

Lecture 19 Questions on Aggregate Functions

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

Lecture 20 Sub Queries

Lecture 21 Common Table Expression (CTE)

Section 8: Case Statement and Flags

Lecture 22 Case When

Lecture 23 Flags

Section 9: Window Functions

Lecture 24 Row_number()

Lecture 25 Row Number Q and A

Lecture 26 Lead and Lag

Section 10: Date Functions

Lecture 27 Year, Month, Day and Get Date

Lecture 28 DateDiff

Lecture 29 DateAdd

Lecture 30 Date table

Lecture 31 Cast and Convert

Lecture 32 Joining tables on more than one condition

Lecture 33 Date Functions - Questions and Answers

Section 11: String Functions

Lecture 34 Concat

Lecture 35 Substring

Section 12: Google Sheets and Pivot Tables

Lecture 36 Google Sheets - Pivot Tables

Lecture 37 Any Questions?

Section 13: Adventureworks Analysis Project

Lecture 38 Countries' Sales by Age Group

Lecture 39 Products' Sales by Age Group

Lecture 40 Sales in USA and Australia compared

Lecture 41 Products First Reorder Date

Lecture 42 Products with high stock levels

Lecture 43 Sales on Promotion

Lecture 44 Change in value between a customers' first and last purchase

Section 14: Profile of customers who purchased a bike

Lecture 45 Customers by commute distance and country

Lecture 46 Amount of bike purchases by salary

Lecture 47 Sales for customers with children vs no children

Lecture 48 Putting it together

Lecture 49 Additional Analysis - Next Product Purchased after Bike Part 1

Lecture 50 Additional Analysis - Next Product Purchased after Bike Part 2

Section 15: Create Tableau Dashboard

Lecture 51 Getting the data for Tableau

Lecture 52 Download and install Tableau Public

Lecture 53 Tableau Overview

Lecture 54 Create Dual Axies Chart

Lecture 55 Create Country sales donut chart

Lecture 56 Create stacked bar chart and grouping our data

Lecture 57 Create Sales Cards

Lecture 58 Accessories bar chart

Lecture 59 Building our dashboard

Lecture 60 Format and publish the dashboard to Tableau Public

Lecture 61 Add Additional Sheet to Dashboard - Country Sales in a Map

Lecture 62 Add Additional Sheet to Dashboard - Running Total Chart

Section 16: Create your Own Stock Price Tracker

Lecture 63 What we'll do in this section

Lecture 64 Getting our Data

Lecture 65 Connect Tableau to Data Source and Change Default Properties

Lecture 66 Build our Candlestick Chart

Lecture 67 Create our Volume and Volatility Charts

Lecture 68 Import Logos to Tableau

Lecture 69 Create Last Price and % Change Cards

Lecture 70 Put Dashboard Together

Lecture 71 Format & Publish our Dashboard

Lecture 72 Add 2 Additional Cards - One Year Low and One Year % Change

Section 17: More Tableau Practice - Stock Portfolio Dashboard

Lecture 73 Introduction - What you will do in this section

Lecture 74 Getting our Stock Data

Lecture 75 Download Tableau and Connect to Data Source

Lecture 76 Create Cards for Stock Value and Profit/Loss

Lecture 77 Create Donut Donut

Lecture 78 3 Month Trend Charts and Stock Overview

Lecture 79 3 Month Portfolio Value chart

Lecture 80 Performance % of Each Stock

Lecture 81 Individual Stock Chart and Parameter

Lecture 82 Building our Tableau Dashboard

Lecture 83 Publishing our Dashboard

Lecture 84 Formatting our Tableau Dashboard

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