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✨
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.
@@olaoluwaabatan2749 I could not get the excel files imported at first either. I'm not sure if you are/were experiencing the same issue I had but I ended up having to uninstall the 2022 SQL Express, install 2019 SQL Express, and install Microsoft Access Database Engine 2010.
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!
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!!🙏🙏
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.
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.
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)
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!!!
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!!
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.
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
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.
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!
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.)
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.
I had trouble pasting the 4th query into excel. I am using the online version so maybe that's it I don't know for sure. Anyway I pasted it on google sheets instead and was able to work with it there. To remove the Null values go to Edit and select find and replace, or ctrl-h on windows(sorry I don't know the shortcut for windows) type in Null, replace all with a 0 just like Alex did in excel. Rename your file Finally under file go to downloads then you can select as a xlsx.file. Posting this just in case somebody has the same issue. BTW thank you so much for the videos Alex, I am doing my capstone for google certificate and want to practice as much as I can. Your videos are of great help love the fact that you keep the mistakes in the videos seeing you troubleshooting these is a huge learning opportunity for anybody watching.
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 RUclips, 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!
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.
Alex… You are such a wonderful person. I have started watching your videos recently. I was impressed n subscribed. I want to start my career as an analyst. But it is not easy for a person with no experience. After watching your portfolio project series, I started to add them in my resume. Today I got a positive response from an interviewer. They were really curious about my portfolio projects. Thank you so much🙏
as an ex-dba and after a long gap , creating a portofilo is a very good way for me to revise my SQL knowledge. it's also a quick way to learn Tableau and understand data analyst work. Thank you Alex
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.🎉
Alex thanks a lot again…. I’m in Power BI (Learning Dax) and I’ve never touched Tableau, with your tutorial I have learned a ton, now I have a better understanding and opinion about Tableau. Great Job man!!!
First of all, I love this entire series and it's insanely helpful. But I love your commentary. I say so many of the exact same things (this doesn't look right, that's not what I wanted, etc.) it's actually really reassuring to see a pro has a similar train of thought. Thank you so much for doing this!
Yeah, this might not be a 3 hour tutorial, but it's not even less than that in terms of content. I mean, it's literally awesome when you get such mighty knowledge within this much of time. It's supercool, ineteresting and a perfect one to give a kick start to someone stuck like me, thank you so much :)
You have done grate sir, no one need to attend any tutorial of tableau ....its super easy and very helpful for beginners ...its like tutorial + real time experience..... Thank you so much sir
Alex, my dear Hero. Thanks so much for assisting me to overcome a major hurdle. I am very grateful and can't thank you enough this excellent Video. Pls trust, I'll make you very proud as I promise to go places in Visualization world with Tableau.
Thank you so much for your videos , as a Undergrad who wants to become a data analyst , it is extremely helpful. Thank you for teaching and providing this amazing tutorial
for the second query, the income was included so had to modify to below: Select location, SUM(cast(new_deaths as int)) as TotalDeathCount From PortfolioProject..CovidDeaths --Where location like '%states%' Where continent is null and location not in ('World', 'European Union', 'International') and location not like '%income%' Group by location order by TotalDeathCount desc
How about this? I'm wondering why people aren't doing this? Am I missing something here? Select Continent, SUM(cast(new_deaths as int)) AS TotalDeathCount From PortfolioProject..CovidDeaths where continent is not null GROUP BY continent order by TotalDeathCount desc
Thanks for this Alex. I sincerely appreciate your efforts in helping us out with these tutorials. Whether we use them in our portfolio, or not, there's plenty to learn about the use of Tableau. I also appreciate your explanations on why cleaning the data is so important. I know that creating the visualizations takes time, plus the added time to create these videos, so thank you for your efforts. I've gained much confidence in how to apply the basic data analysis tools through your tutorials.
Hey man.. You inspired me to also do a project with same data. But I'm writing my own queries and i will be using Power BI instead of excel for Visualization... later I'll do it in Tableau. I recently started relearning Power BI so i think it will be good practice. Interesting how you can learn by working on a project. I just completed my MS in Comp. Sc and in the market for a Data Analyst job. Such videos help alot👍
Thanks, Alex, for sharing. Many Data Analysis courses still need this fundamental point: a tutorial on How to create a Portfolio and How to handle a project.
Thank you so much!!! You can never tell how happy I am right now after watching your video. I love the part where I could publish and copy the URL. One more time, I say, thank you!
can u help me on how to insert those queries from SQL to PBI, I have tried to import using direct query but errors show up all the time and I cannot apply & close it for visualization.
Thank you Alex for all you do. It’s interesting that you keep apologizing for your goof at times in the video but I’d say its nice you’re showing that you also forget how to do certain things and that you’re also figuring out how to format the dashboard best as you teach along. I believe this will help beginners to be more confident in their ability knowing it’s okay not to have everything figured out.
Thanks a bunch for this. I just completed Google's Data Analytics course, but the Capstone was a bit of a brain twister. Going through project 1 and 2 of your series really wrapped my head around the process of analysis, more so than the technicality. This also refined my SQL skills as BigQuery speak a little different than SQL Server (I think that's what you're using?) Thanks again!
Hi Alex, have followed many tutorials in the field of Data Analytics, yours are really among the top out there. You have earned my subscription. Keep up the good work with your tutorials! Can't wait for episode 3 and 4.... but guess I'm not the only one :-)
A tip for Mac users - setup a PosgreSQL with a DBeaver. Easy to setup, easy to use and you can export the data as csv files (and other formats ofc..), no need for excel, no need to replace null with 0 manually, you can configure this while exporting the csv. Just overall much more intuitive and light to use.
As usual, I hit the like button before finishing the video because I know it's really good video. I literally can't wait for the 2 part after the first one. Thank you for the effort you put Alex
Thank you for the tutorial. It was first time dabbling in Tableau, from the installation all the way to uploading my finished dashboard. Pretty amazing. Really appreciate the time and effort you put in it - especially explaining even the smallest of things. #savingsoulsfromworkplaceembarrassment
Thank you, Alex! This portfolio project has been quite helpful for me to build on the fundamentals and concepts of analytics. I am a Business Analytics Student and m excited to see what's in store for parts 3 and 4. Appreciate your work
You the man for this! learning so much thank you for doing these tutorials, seriously so helpful and insightful for those trying to break into Data science
Hey Guys, just and fyi. When look at the population by continent, income level is also included in the data. in order to remove it in the query I just added under the where statement and location not like '%income%'
I love this kind of videos! You have mentioned that you wouldn't like to make a 3-4 hours long, extended video. For beginners would't be useful, I understand. Nevertheless, personally I would like to see those kind of videos especially regard to SQL. I think from a detailed video I would understand much deeply the details, and lift my knowledge to another level. Thank you, Alex!!
I’ve learned so much from you. I have a request for you. Kindly add caption in the upcoming videos. It will help much more to non-english speaker. Thank you so much..
Hey Alex, Just finished my second iteration working through this excellent project/video. Made WAY more sense this time around. Thanks again for all of your time and effort put into your creations. Cheers!😎
For the seconde : -- 2. Select continent, SUM(cast(new_deaths as int)) as TotalDeathCount From [Portfolio SQL Prodjects]..CovidDeaths --Where location like '%states%' Where continent is not null and location not in ('World', 'European Union', 'International') Group by continent order by TotalDeathCount desc
Hello ! Amazing video as always. At 7:00 instead of using excel we can use this sql command to replace the NULLs by 1 : SELECT location, population, COALESCE(MAX(total_cases),0) AS HighestInfectionCount, COALESCE(Max((total_cases / population)) * 100 ,0) as PercentPopulationInfected FROM CovidDeaths GROUP BY location, population ORDER BY PercentPopulationInfected DESC;
When you said time series... It brought back flashbacks to Calc 2 😩 ill never get over sigma functions... But I'm glad my prerequisite knowledge helps me understand the visualization concept of Time Series better. When I finish this it's going right to my portfolio website and LinkedIn post👍
Hello Alex! One more step is done, project is completed! First of all, Alex, Thank you so much for your courses and your time spent on it. Personally for me, your educational materials appeal to me much more than other sources I use for my education. Thank you, Thank you, Thank you :))) Just let you know, it is especially intriguing when I am working on data with approximately 2 years gap from your video and I see how much the picture is different from 2021 in the term of data. I also was curious to compare the forecast made in 2021 concerning further infection rate according to an analytical tool in Tableau, and my observation is that the projection was a little bit overestimated compared to what Globe has nowadays. I am going further to your course! Thanks Much! Best regards, Andrei
Perfect video! Just a little suggestion. If you could just make a video as to how we can compile these projects together with our resume and a basics of tableau like the one for sql would be very very helpful. Thanks Alex!
Alex this was amazing and I am sure begginer will be able to use tableau much easier because of this project Portfolio 🙌 Suggestion how about you make a video on how to make website portfolio ?
I was able to writte "continent" every time no problem... Now I have to double check xD Thank you so much!! I followed this 2 episodes and hopefully some recruiter will find them interesting. Onward to the 3º
I have a student version of Tableau, so I was able to import the databases from SSMS. At 15:13, instead of modifying the worldwide numbers in Tableau, I edited the custom SQL query in Tableau to CAST() as a decimal as seen below: SELECT SUM(new_cases) AS TotalCases, SUM(CAST(new_deaths AS BIGINT)) AS TotalDeaths, CAST(SUM(CAST(new_deaths AS BIGINT)) / SUM(new_cases) AS DECIMAL (10, 3)) * 100 AS DeathPercentage FROM PortfolioProject..CovidDeaths WHERE continent IS NOT NULL
Thanks very much for this Alex! It's hugely helpful and will be going in my portfolio for sure. You must have been knackered doing this at midnight.. ;) Greetings from Australia
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✨
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.
Thank you man! Really looking forward to the next 2 :)
@@AlexTheAnalyst Please I am having trouble loading the Excel file into Microsoft SQL server
@@olaoluwaabatan2749 I could not get the excel files imported at first either. I'm not sure if you are/were experiencing the same issue I had but I ended up having to uninstall the 2022 SQL Express, install 2019 SQL Express, and install Microsoft Access Database Engine 2010.
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!
That's great! Congratulations!
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!!🙏🙏
So glad to hear that Tushar!
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.
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.
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)
thanks
you are a live saver!
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!!!
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!!
That’s great! I’m looking forward to it too! 😁
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.
Your honesty and transparency helps us more than you can imagine. Thank you Alex!
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
Life saver!
Perfect timing, thanks!
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.
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!
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.)
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.
I had trouble pasting the 4th query into excel. I am using the online version so maybe that's it I don't know for sure. Anyway I pasted it on google sheets instead and was able to work with it there.
To remove the Null values go to Edit and select find and replace, or ctrl-h on windows(sorry I don't know the shortcut for windows) type in Null, replace all with a 0 just like Alex did in excel.
Rename your file
Finally under file go to downloads then you can select as a xlsx.file.
Posting this just in case somebody has the same issue.
BTW thank you so much for the videos Alex, I am doing my capstone for google certificate and want to practice as much as I can.
Your videos are of great help love the fact that you keep the mistakes in the videos seeing you troubleshooting these is a huge learning opportunity for anybody watching.
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 RUclips, 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!
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.
Alex… You are such a wonderful person. I have started watching your videos recently. I was impressed n subscribed. I want to start my career as an analyst. But it is not easy for a person with no experience. After watching your portfolio project series, I started to add them in my resume.
Today I got a positive response from an interviewer. They were really curious about my portfolio projects. Thank you so much🙏
That's fantastic! Make it happen and work hard!
as an ex-dba and after a long gap , creating a portofilo is a very good way for me to revise my SQL knowledge. it's also a quick way to learn Tableau and understand data analyst work. Thank you Alex
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.🎉
Thank you so much for getting me to a good starting place to create more projects as a data analyst. I do hope anyone finds this as useful as i did.
Alex thanks a lot again…. I’m in Power BI (Learning Dax) and I’ve never touched Tableau, with your tutorial I have learned a ton, now I have a better understanding and opinion about Tableau.
Great Job man!!!
Although I didn't get my 3-hour tutorial *huffs*, thanks for putting this video up in such a timely fashion! Thanks so much, Alex.
There's always one :D
@@AlexTheAnalyst I'm proud to be the anomaly.
First of all, I love this entire series and it's insanely helpful. But I love your commentary. I say so many of the exact same things (this doesn't look right, that's not what I wanted, etc.) it's actually really reassuring to see a pro has a similar train of thought. Thank you so much for doing this!
Felt similarly!
Yeah, this might not be a 3 hour tutorial, but it's not even less than that in terms of content. I mean, it's literally awesome when you get such mighty knowledge within this much of time.
It's supercool, ineteresting and a perfect one to give a kick start to someone stuck like me, thank you so much :)
You have done grate sir, no one need to attend any tutorial of tableau ....its super easy and very helpful for beginners ...its like tutorial + real time experience..... Thank you so much sir
Alex, my dear Hero. Thanks so much for assisting me to overcome a major hurdle. I am very grateful and can't thank you enough this excellent Video. Pls trust, I'll make you very proud as I promise to go places in Visualization world with Tableau.
I think data visualization is a combination of art and science. Tableau is my go to for the process.
Thank you so much for your videos , as a Undergrad who wants to become a data analyst , it is extremely helpful. Thank you for teaching and providing this amazing tutorial
for the second query, the income was included so had to modify to below:
Select location, SUM(cast(new_deaths as int)) as TotalDeathCount
From PortfolioProject..CovidDeaths
--Where location like '%states%'
Where continent is null
and location not in ('World', 'European Union', 'International')
and location not like '%income%'
Group by location
order by TotalDeathCount desc
Thank you for sharing this! very helpful, I have been looking in Google how to get rid of the income.
How about this? I'm wondering why people aren't doing this? Am I missing something here?
Select Continent, SUM(cast(new_deaths as int)) AS TotalDeathCount
From PortfolioProject..CovidDeaths
where continent is not null
GROUP BY continent
order by TotalDeathCount desc
@@shivanipal5010 I think we are getting the same result with both the above queries
@@meghanakurada7242 Yes, I feel this is much simpler and cleaner way.
In the second query, I can't get the numbers for Asia. It's on the continent, not the location. Did you all manage to get a number for that?
Thank you so much for saying how long it took you to analyze this .Made me feel so much better .
I really liked this series! I followed the video and made the tableau last year. Now I am watch it again. It is very rich in content. THANK YOU!
Thanks for this Alex. I sincerely appreciate your efforts in helping us out with these tutorials. Whether we use them in our portfolio, or not, there's plenty to learn about the use of Tableau. I also appreciate your explanations on why cleaning the data is so important. I know that creating the visualizations takes time, plus the added time to create these videos, so thank you for your efforts. I've gained much confidence in how to apply the basic data analysis tools through your tutorials.
Hey man.. You inspired me to also do a project with same data. But I'm writing my own queries and i will be using Power BI instead of excel for Visualization... later I'll do it in Tableau. I recently started relearning Power BI so i think it will be good practice. Interesting how you can learn by working on a project. I just completed my MS in Comp. Sc and in the market for a Data Analyst job. Such videos help alot👍
That's great! I am all about doing your own thing - I think you'll work harder and make it even better than I did :D
I'm greatly convinced anyone can learn anything with the right tools. Alex you are super engaging make everything easy and fun! Thank you!
Thanks, Alex, for sharing. Many Data Analysis courses still need this fundamental point: a tutorial on How to create a Portfolio and How to handle a project.
Thank you so much!!! You can never tell how happy I am right now after watching your video. I love the part where I could publish and copy the URL. One more time, I say, thank you!
You're more than welcome - good work!
I had a go in Power BI, the mapping required some research other than that it was not difficult. Thanks Alex.
can u help me on how to insert those queries from SQL to PBI, I have tried to import using direct query but errors show up all the time and I cannot apply & close it for visualization.
Thank you Alex for all you do. It’s interesting that you keep apologizing for your goof at times in the video but I’d say its nice you’re showing that you also forget how to do certain things and that you’re also figuring out how to format the dashboard best as you teach along. I believe this will help beginners to be more confident in their ability knowing it’s okay not to have everything figured out.
So glad to hear that! Thanks for watching!
Thanks a bunch for this. I just completed Google's Data Analytics course, but the Capstone was a bit of a brain twister. Going through project 1 and 2 of your series really wrapped my head around the process of analysis, more so than the technicality. This also refined my SQL skills as BigQuery speak a little different than SQL Server (I think that's what you're using?) Thanks again!
I really appreciate the simplicity of tutorials. Thank you Alex!
As a starting point, this was really helpful. From here we grow and improve what we have been able to build👏
Hi Alex, have followed many tutorials in the field of Data Analytics, yours are really among the top out there. You have earned my subscription. Keep up the good work with your tutorials! Can't wait for episode 3 and 4.... but guess I'm not the only one :-)
So glad to hear that! Thanks for watching!
Thank you Alex!! I just made my first SQL. and Tableau Project thanks to your guidance and tutorial!
Good work! :D
Brother, just want to say THANKS. You have a talent for explaining things!!!
A tip for Mac users - setup a PosgreSQL with a DBeaver. Easy to setup, easy to use and you can export the data as csv files (and other formats ofc..), no need for excel, no need to replace null with 0 manually, you can configure this while exporting the csv.
Just overall much more intuitive and light to use.
Thanks Alex for your time and support
As usual, I hit the like button before finishing the video because I know it's really good video. I literally can't wait for the 2 part after the first one. Thank you for the effort you put Alex
Same here Rosie. Has the man ever made a bad video?
@@Major_Data Haha. No doubt about it.
Thank you for the tutorial. It was first time dabbling in Tableau, from the installation all the way to uploading my finished dashboard. Pretty amazing. Really appreciate the time and effort you put in it - especially explaining even the smallest of things. #savingsoulsfromworkplaceembarrassment
Thank you Alex for all tutorials. it has really help in my new career pathway as a data Analyst
Thank you, Alex! This portfolio project has been quite helpful for me to build on the fundamentals and concepts of analytics. I am a Business Analytics Student and m excited to see what's in store for parts 3 and 4. Appreciate your work
appreciate these videos. I like the fact that there's no cuts so i can see the small mistakes
You the man for this! learning so much thank you for doing these tutorials, seriously so helpful and insightful for those trying to break into Data science
Hey Guys, just and fyi. When look at the population by continent, income level is also included in the data.
in order to remove it in the query I just added under the where statement
and location not like '%income%'
Thanks, noticed this issue as well
I came across the same problem. Thanks!
Now we are talking , Was eagerly waiting for this part!!. :D
I love this kind of videos!
You have mentioned that you wouldn't like to make a 3-4 hours long, extended video. For beginners would't be useful, I understand.
Nevertheless, personally I would like to see those kind of videos especially regard to SQL. I think from a detailed video I would understand much deeply the details, and lift my knowledge to another level.
Thank you, Alex!!
Thank you so much Alex! I've learnt so much from you and have upgraded my knowledge on Data analysis. Hoping to get a job on it soon🤞
I’ve learned so much from you. I have a request for you. Kindly add caption in the upcoming videos. It will help much more to non-english speaker. Thank you so much..
It is captioned. Might be your app or mobile/desktop
Hats off Alex these portfolio series is helping more people in the world the practical's are just amazing.
Hey Alex, Just finished my second iteration working through this excellent project/video. Made WAY more sense this time around. Thanks again for all of your time and effort put into your creations. Cheers!😎
Phewww! A long video but I stuck till the end. Thanks Alex!
Thanks, Alex, for generating a spark in my mind about the amazing world of Data Analysis.
Hey, were you able to find the datasets used for the project?
Am I the only one that would have love the 3 hours tutorial? hahaha Thank you, i had so much fun!
1.5 speed saved me from falling asleep. Thank you.
Just knocked this tutorial out. Such amazing content here.
Just wanted to say thank you for putting your time and energy into this for others.
For the seconde :
-- 2.
Select continent, SUM(cast(new_deaths as int)) as TotalDeathCount
From
[Portfolio SQL Prodjects]..CovidDeaths
--Where location like '%states%'
Where continent is not null
and location not in ('World', 'European Union', 'International')
Group by continent
order by TotalDeathCount desc
This portfolio project is amazing. I just finished part 1 and I'm really excited to start part 2. Thank you for your great work !
That's awesome! Keep up the good work :)
From where did you get data
@@prasikavijay1963 watch part1 and you'll know.
Hello ! Amazing video as always.
At 7:00 instead of using excel we can use this sql command to replace the NULLs by 1 :
SELECT
location,
population,
COALESCE(MAX(total_cases),0) AS HighestInfectionCount,
COALESCE(Max((total_cases / population)) * 100 ,0) as PercentPopulationInfected
FROM
CovidDeaths
GROUP BY
location,
population
ORDER BY
PercentPopulationInfected DESC;
When you said time series... It brought back flashbacks to Calc 2 😩 ill never get over sigma functions... But I'm glad my prerequisite knowledge helps me understand the visualization concept of Time Series better. When I finish this it's going right to my portfolio website and LinkedIn post👍
Dear Alex, you nailed it!
Thanks a lot for this help and for trying your best on sharing you knowledge with us.
God bless you, man!
We waiting for the tableau series
Any learning series is welcomed too
Okay, I almost died at 15:25: "Hey, future Alex here..." Freaking priceless.
Hahaha glad someone enjoyed it :D
Hello Alex!
One more step is done, project is completed!
First of all, Alex, Thank you so much for your courses and your time spent on it. Personally for me, your educational materials appeal to me much more than other sources I use for my education. Thank you, Thank you, Thank you :)))
Just let you know, it is especially intriguing when I am working on data with approximately 2 years gap from your video and I see how much the picture is different from 2021 in the term of data. I also was curious to compare the forecast made in 2021 concerning further infection rate according to an analytical tool in Tableau, and my observation is that the projection was a little bit overestimated compared to what Globe has nowadays.
I am going further to your course! Thanks Much!
Best regards, Andrei
Truly an angel for doing this. Thank you so much.
Perfect video! Just a little suggestion. If you could just make a video as to how we can compile these projects together with our resume and a basics of tableau like the one for sql would be very very helpful. Thanks Alex!
I'll be doing that at the end :)
@@AlexTheAnalyst Thank you so much! Keep up the amazing spirit! Your lively spirit makes even 1hour tutorial short ❤️
Alex this was amazing and I am sure begginer will be able to use tableau much easier because of this project Portfolio 🙌
Suggestion how about you make a video on how to make website portfolio ?
Yep! Definitely agree with "future Alex" picture...hehe. Amazing video, thanks Alex.
It was 100% me :D Thanks for watching!
I'm loving this portfolio building series. Thank you so much
So glad to hear that!
I just finished the part 1 yesterday and was waiting for this!Thank you so much Alex!
So glad to hear that! Thanks for watching!
From where will you get the excel file
Alex, you're literally the best!!! Ken, stop disliking his videos! :P
It him and his numerous fake accounts...
Awesome video, looking forward Tableau tutorials.
Have been waiting for this. Thank you! I will be using Power BI to make Visualization with the same idea presented here.
I was able to writte "continent" every time no problem... Now I have to double check xD
Thank you so much!! I followed this 2 episodes and hopefully some recruiter will find them interesting.
Onward to the 3º
I have a student version of Tableau, so I was able to import the databases from SSMS. At 15:13, instead of modifying the worldwide numbers in Tableau, I edited the custom SQL query in Tableau to CAST() as a decimal as seen below:
SELECT SUM(new_cases) AS TotalCases,
SUM(CAST(new_deaths AS BIGINT)) AS TotalDeaths,
CAST(SUM(CAST(new_deaths AS BIGINT)) / SUM(new_cases) AS DECIMAL (10, 3)) * 100 AS DeathPercentage
FROM PortfolioProject..CovidDeaths
WHERE continent IS NOT NULL
Alex your the best thanks for this! You deserve whatever good that’s comes to you!!
I was waiting for this project. God bless man.
Big thanks for this video Alex! can't wait for the rest of the episodes!
Next one coming out on Tuesday :D
Amazing tutorials!!! Love the way you teach and guide us. Thanks a lot for putting so much effort into it. Hugs.
Great Alex, thanks. After this one i'm going to the Tableu Tutorial
Thanks very much for this Alex! It's hugely helpful and will be going in my portfolio for sure. You must have been knackered doing this at midnight.. ;) Greetings from Australia
Haha I have 3 kids so midnight is early for me :)
Hi Alex
You are such a blessing and a great teacher
Thanks so much for all you do…
I have learned a lot
Most awaited 🔥🙏
I love the hate for pie charts!! LOL "You want to mess up your visualization with a piechart? Go for it."
Thank you for this video turtorial Alex. The explanation is very clear and accurate.
weekend was done and dusted by doing this visualization Sir . Tableau made easy by Alex the Analyst :D
Thank you ALEX for the sharing your knowledge and skills. I aspire to be a proficient data analyst in the coming days.
hi. how were you able to save to Tableau public. I'm using the latest version of Tableau. couldn't find that option
I learned so much and was able to follow along perfectly. Thank you so much for helping me create my first portfolio!