Data Analyst Portfolio Project | Tableau Visualization | Project 2/4

Today we continue our Data Analyst Portfolio Project Series. In this project we will be taking some of the SQL queries we worked on in the first project and creating visualizations in Tableau.

LINKS:

____________________________________________

SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________

RESOURCES:

Coursera Courses:

Udemy Courses:

*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________

SUPPORT MY CHANNEL - PATREON/MERCH

____________________________________________

Websites:
____________________________________________

*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*

0:00 Introduction
0:55 Downloading Tableau
2:44 Getting Data from SQL
9:05 Importing Data into Tableau
10:41 Building Our Visualizations
43:30 Building Our Dashboard
48:45 How to Share Dashboard

[varinderjitkaur]

Hi Alex, i learned alot from you. i started my journey about 6 months ago, i wanted to change my career in more data analytics role and this portfolio project really helped me to implement my skills. i used to know Basic SQL but my making these projects really got me hands-on and my confidence also increased with practice. three days ago i joined a new company with the role i was hoping to get in. Really thankful to you and appreciate you for all you do. Peace✨

[RemotePossibilities]

Another super-helpful video Alex! Here are more timestamps, for people (like me) interested in specific data-vizes:
17:50 Column chart (viz #2)
24:15 Map (#3)
32:00 Time series (#4)

[Major_Data]

Dude, all jokes aside, you are providing a public service with these videos. Thanks for all your hard work.

Have to wait until tonight to tackle this one, but I can't wait.

[kavishshah]

Thanks a lot Alex sir for providing such great projects.
One thing I'd like to add is:

In the 3rd query we just need to add one line 'WHERE continent IS NOT NULL' in order to remove all the 'continents' from 'location column'. If we do not do this we will get 11 unknowns in the 'map' sheet.
Although after doing this, we will get two unknows, which we can alter by clicking on '2 unknowns' --> 'Edit Locations' --> Micronesia (Federated States of Micronesia) & Timor (Timor Leste).

Hope this might help someone.

[zaqa]

I really appreciate these long form example videos! It's extremely helpful to get a glimpse of an analyst's process as you work through a task like this.

[alexluevano]

Hey Alex! Alex here. Just wanted to let you know, I started watching your videos around January and you inspired me a lot. Since college I have had a certain atraction to data and programming (already knew some R and VBA and I thought SQL was so cool) and since already have an engineering background, you helped me realize I wanted to focus my career to a data analyst/engineer path. So I started learning a lot on my own.
Yesterday, I landed a data analyst promotion focused on product integrity at my job and couldn't be happier. Thank you Alex, you do an awesome job at inspiring people! Keep it up!

[jonathannali]

I have had a few Tableau Tutorials, but after this video, I can confidently say I know what I am doing.
Let's agree Alex is the best teacher there is!!!

[tushararora]

Just wanna say you have no idea how addictive your videos are even considering the fact they are informational and it always feels like an elder brother is telling these things
Great great great!!🙏🙏

[vjay]

Thank you so much for this tutorial and the previous one on SQL. I went from knowing nothing about SQL and Tableau to publishing this dashboard by following along with your presentation. I now have an oil and gas SQL project I'm working on independently. I hope to publish my first independently created dashboard pretty soon.

[christophersun]

If you get blanks instead of "NULL" in excel after pasting the data over as seen at 06:25 of the video, you can select the entire portion you just pasted (should already be selected right after pasting) then go to "home" ribbon, select "Find & Select", "Go To Special", "Blanks". This will then select all blanks in your previous selection. Then type in what you want all the blanks to say such as "0". Then CTL + Enter and it will put whatever you had typed into all blanks

[arcaneknight]

Perfect! I just went through part 1 this past weekend. I'm excited to see parts 3 and 4. Here's to all of us improving our careers soon! Thanks, Alex!!

[marcd.]

Your honesty and transparency helps us more than you can imagine. Thank you Alex!

[cwalkie]

This was honestly amazing thank you. I've been teaching myself SQL, Python, Excel, and Tableau through Udemy courses my employer pays and i really enjoyed this project!

[davidk]

Most important lesson for me here is, I can circumvent the process of data wrangling in Tableau by using SQL to prepare the data first and use Tableau for its primary use:visualization! Thanks for the lesson.

[candacedillon]

This one was much easier than I expected!! After all the bumps I've encountered with everything prior to this, you have taught me so much more than any course I've taken! As I'm following along, I'm asking myself, "What else can I do?" "Why is Alex doing this and what provoked him to make these choices?" I can't tell you how much I appreciate what you've done. I know you have a busy life and data analytics is very time consuming, so for you to work full time and you have your own personal life, this is amazing that you can do this too! I was feeling so defeated after the Google course but you've just reignited my hopes! (I was a trucker for the past 13 years. It's like a cult. Nobody wants to hire you as soon as they find out you were a trucker. Trucking will always take you back but for me, it was like a living nightmare. All the hours worked without pay.. All the holidays missed, missing my children's lives.... I pray I can find my way into a data analyst position and leave the trucking cult behind.)

[Tales.of.Irshad]

Sir, I cant Thank you enough for this wonderful tour. I have paid for a lot of courses but haven't got any kind of energy and motivation like this. Stay blessed.

[mansiupadhyay]

With your brilliant tutorial, I was able to complete my first project in Tableau. Surely would make some more. You made it so fascinating. I loved every part of the video. Learned so much. Truly now more motivated to become a Data Analyst. Thank YOU ALEX.

[phoebekibe]

Amazing video! The part where you mentioned you didn't take 1 and 1/2 hrs to make the whole dashboard is encouraging to hear as a beginner. You really demystified the whole process of being a data analyst. Thank you Alex!

[MAP]

You were wondering if you were going to fast. One, I've never used Tableau and was able to follow, and it looks great. Two, it's on YouTube, and we can rewind/rewatch whatever we want. Great job, and the fact that you're doing this for free is mind blowing! Congrats and thank you!

[elumelusabina]

Thank you, Alex. This has given me some very good confidence boost, and I am so glad I stumbled on your page. You have been doing amazing work for a lot of people, and I'm one of your beneficiaries. Thank you.🎉