Please ensure Javascript is enabled for purposes of website accessibility
Hands On Data Analysis Using SQL And Tableau
0( 0 REVIEWS )
6h 22m

Gain data analysis and visualization skills with SQL and Tableau. Work on real projects and develop practical skills. Join now and start learning!

Read more.
Course Skill Level
Time Estimate
6h 22m


I am a Senior 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 ha

Only want this course? Buy this course for $199 $29 and keep lifetime access. Click here

About This Course

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

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
  • Understand relational databases and entity relationship diagrams
  • Do a customer profile on Adventureworks database including Google Sheets pivot tables and dual axis 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


  • 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

Software version used in the course:

  • SQL Server Express 2019

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 analysis – 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 do basic queries using SQL Server Management Studio. 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, creating visualizations, and building interactive dashboards. 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 and real-world projects 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 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

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!

Our Promise to You

By the end of this course, you will have learned how to use SQL and Tableau to analyze and visualize data by working on real projects.

10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today!

Course Curriculum

Section 1 - Introduction And Thank You!
Introduction To The Course 00:00:00
Section 2 - Download SQL Server Management Studio And Adventureworks Database
SSMS And Adventureworks Download 00:00:00
Section 3 - What Is SQL And A Relational Database?
SQL, Relational Database And Entity Relationship Diagram 00:00:00
Quick SSMS Overview 00:00:00
Section 4 - Beginner SQL
Select, From, Where, And, Or 00:00:00
Select, From, Where, And, Or – Questions And Answers 00:00:00
Upper And Lower 00:00:00
IN And NOT IN Operators 00:00:00
Distinct, Like And Order By 00:00:00
Section 5 - Intermediate SQL
Inner Join 00:00:00
Left And Right Join 00:00:00
Joins – 2 Questions And Answers 00:00:00
Union And Union All 00:00:00
Section 6 - Aggregate Functions
Sum, Round And Group By 00:00:00
Having And Practice Question 00:00:00
Count 00:00:00
Max And Min 00:00:00
Average 00:00:00
Questions On Aggregate Functions 00:00:00
Section 7 - Sub Query And Common Table Expression (CTE)
Sub Queries 00:00:00
Common Table Expression (CTE) 00:00:00
Section 8 - Case Statement And Flags
Case When 00:00:00
Flags 00:00:00
Section 9 - Window Functions
Row_Number() 00:00:00
Row Number Q And A 00:00:00
Lead And Lag 00:00:00
Section 10 - Date Functions
Year, Month, Day and Get Date 00:00:00
DateDiff 00:00:00
DateAdd 00:00:00
Date Table 00:00:00
Cast And Convert 00:00:00
Joining Tables On More Than One Condition 00:00:00
Date Functions – Questions And Answers 00:00:00
Section 11 - String Functions
Concat 00:00:00
Substring 00:00:00
Section 12 - Google Sheets And Pivot Tables
Google Sheets – Pivot Tables 00:00:00
Thanks And Any Question 00:00:00
Section 13 - Adventureworks Analysis Project
Countries’ Sales By Age Group 00:00:00
Products’ Sales By Age Group 00:00:00
Sales In USA And Australia Compared 00:00:00
Products First Reorder Date 00:00:00
Products With High Stock Levels 00:00:00
Sales On Promotion 00:00:00
Change In Value Between A Customers’ First And Last Purchase 00:00:00
Section 14 - Profile Of Customers Who Purchased A Bike
Customers By Commute Distance And Country 00:00:00
Amount Of Bike Purchases By Salary 00:00:00
Sales For Customers With Children Vs No Children 00:00:00
Putting It Together 00:00:00
Additional Analysis – Next Product Purchase Part 1 00:00:00
Additional Analysis – Next Product Purchase Part 2 00:00:00
Section 15 - Create Tableau Dashboard
Getting The Data For Tableau 00:00:00
Download And Install Tableau Public 00:00:00
Tableau Overview 00:00:00
Create Dual Axies Chart 00:00:00
Create Country Sales Donut Chart 00:00:00
Create Stacked Bar Chart And Grouping Our Data 00:00:00
Create Sales Cards 00:00:00
Accessories Bar Chart 00:00:00
Building Our Dashboard 00:00:00
Format And Publish The Dashboard To Tableau Public 00:00:00
Tableau Map 00:00:00
Running Total 00:00:00
Section 16 - Create Your Own Stock Performance Dashboard On Tableau
Introduction – What You Will Do In This Section 00:00:00
Section 17 - Getting Our Data
Getting Our Stock Data 00:00:00
Download Tableau And Connect To Data Source 00:00:00
Section 18 - Creating Our Charts For The Dashboard
Create Cards For Stock Value And Profit And Loss 00:00:00
Create Donut Chart 00:00:00
3 Month Trend Charts And Stock Overview 00:00:00
3 Month Portfolio Value Chart 00:00:00
Performance % Of Each Stock 00:00:00
Individual Stock Chart And Parameter 00:00:00
Section 19 - Building And Publishing Our Dashboard
Building Our Tableau Dashboard 00:00:00
Formatting Our Tableau Dashboard 00:00:00
Publishing Our Dashboard 00:00:00
Section 20 - Create Stock Price Tracker On Tableau
Getting Data 00:00:00
Connect To Data And Change Data Type 00:00:00
Candlestick Chart 00:00:00
Volume And Volatility Charts 00:00:00
Logos 00:00:00
Last Price And % Change Cards 00:00:00
Put Dashboard Together 00:00:00
Final Format And Publish 00:00:00
Additional Price Cards – One Year Low And One Year % Change 00:00:00

Are you interested in higher education?

We’re working on a service to connect learners with higher education programs, enter your name and email to join the waitlist

You’ve been added to the waitlist!

Keep an eye out for the announcement via email.

You’ll be the first to know.



Enter your Name and Email for a chance to win Lifetime Access to all courses!
Promotion ends today.



Enter your Name and Email for a chance to win Lifetime Access to all courses!
Promotion ends today.

Success! You are now entered to win lifetime access to all courses. Winners are selected at the beginning of each month. 

P.S. Look out for our exclusive sales only shown to students on our email list!