I'm doing this in Oct 2021 and apparently one of the code chunks where you need to convert new_vaccinations column to integer, the sum value now has exceeded 2,147,483,647. So instead of converting it to "int", you will need to convert to "bigint". Hope this helps everyone.
I'm transitioning from teaching to data analytics. I recently finished the Google Data Analytics Certification, and I've been struggling to figure out how to get my portfolio started. I found this video, and I got really excited to use this as a guided project. Then, I saw Alex was using Covid data, and I had to pause to consider if I could handle it. I lost my dad to Covid 4 months ago. This is personal. However, I think I need this now as another way to process through the continuing grief. The fact is, data is personal. Each of these data points describes people. Someone's father, mother, sister, brother, grandparent, friend, and so on. This data is reality, and it's so important to analyze it in order to truly show the impact that this pandemic has made. Especially, as things may be getting back to "normal" in some places around the world, this data proves that "normal" is not the same without the lives of so many. And maybe, just maybe, analysis and visualization of this dataset can encourage others to get the vaccine, and we can be more informed moving forward.
Thank you for sharing Amy and I’m sorry for your loss. It definitely does give you some interesting insights into the real data rather than just seeing what is on news websites.
I lost my grandma, the closest person to my heart in this whole world. I know what the loss is, the dead may be just numbers for someone but only the people who lost someone close, knows the pain.
I’ve just started the video and I’m about 9 minutes in. I wanted to stop at this point to tell you I’m glad you showed your mistake live. It’s important for beginners to see that experts also make mistakes. It is encouraging. As a bonus, I will better remember to save as xlsx because you pointed it out. So thank you for leaving that in.
I make a ton of mistakes! haha the cuts that I took out were 5+ minutes of me having to research something or figure something out and then coming back. Didn't want to keep that boring stuff in lol
Years ago I said no to programming because I always find myself making mistakes (I'm a GIS Engineer). Then came my friend, a software developer also make tons of mistakes. I questioned him because he has a degree in software engineering with years of experience, then he replied "I'm a human, not a computer. Even human to human also sometimes struggle to communicate" haha
This was a lifesaver when I needed a portfolio quickly for a job interview while still being a beginner. It was easy to follow and I could base my own projects on it. This definitely was part of me getting the job!
I'm doing this in May 2024 and had trouble with inserting data. Here is the solution that worked for me: Select DB in SSMS > Tasks > Import Data > Next > Data source: Flat file source > Select CSV file (make sure you have saved the excel file as a CSV) > > Next > Destination: Microsoft OLE DB Driver for SQL Server > Click on Properties and enter server name, change to Windows Authentication, Select your Database name and test connection > Next > Next > Finish
@@transplantman2287 I hear you! I looked into the 2016 redistribution download and everything but nothing worked other than this. Hoping I can figure it out soon but this way for sure worked and got all the data inserted
@@pranavbhawane7591 When you first open the SQL Server studio, you will get the pop-up to connect. In this pop-up, you'll see the server type, server name, authentication... The server name is listed here. I would suggest copy and paste this before connecting to your server that way you already have it when you type in the name for the database
For me, this way worked: Select DB in SSMS > Tasks > Import Data > Next > Data source = Flat file source > Select CSV (!) file (you have to change expected file extension during file selection) > Locale = English (United States) (i don't know if it matters though) > Next > Destination > Microsoft OLE DB Provider for SQL Server > Next > Next > Finish
Hey I need help. After uploading my data, doesn't show up under the database. I have refreshed repeatedly but no luck with it. Any idea how I can solve this issue? thanks
For those who are currently working on their portfolio project and can't import Excel file using any of the methods Alex showed. I tried this and it worked. Save your file as CSV and apply the first method Alex showed right click the portfolio project, select task, in the dialogue box, select flat file source, browse your folder to select the CSV file (ensure the extension on the browse dialogue box is .CSV, so you can see your CSV files and select it, destination option select SQL server and click next till finish" Hope it helps. Alex thanks again for the video . I can now go ahead with my project
Hi Alex! Doing this in July 2023 and I think the SMSS features have changed a bit. Instead of using SQL Server Native Client 11.0 it is now Microsoft OLE DB Provider for SQL Server. This took me a while to figure out and import. Hope this helps!
To the ones stuck on 19:10 , use the following code to convert into float datatype when ''Null" Select location, date, total_cases,total_deaths, (CONVERT(float, total_deaths) / NULLIF(CONVERT(float, total_cases), 0)) * 100 AS Deathpercentage from PortfolioProject..covidDeaths order by 1,2
Just when I thought this guy has done a great deal of work for beginners like me, he goes on to do greater things like this. Really thank you Alex -from an aspiring analyst
For those doing it from March 2024, you should cast all the columns to floats. Took me days to figure it out. The data in the tables are more and int or even bigint doesn't cut it
Thank you so much! At 1:06 I got stuck because of the constant errors I was getting. When I read your comment and casted as float on the line code reading ", SUM(CAST(vac.new_vaccinations as float)) OVER (Partition by dea.location order by dea.location,dea.date) as RollingPeopleVaccinated" I finally got the query to work as it was suppoded to.
Man... you're amazing. Don't congratulate us to have stayed until the end! It's TONS of work you've done and it's only to be applauded and appreciated! I bet many agree with me - against your sore throat you guided us through soooo many ideas and possibilities! Thank you so much and wish you MILLIONS views!
Thanks alot for this great walkthrough Alex. 👏 👏 Just a quick question for the audience, I am looking for a good budget laptop. My primary purpose is to be able to run all the DB applications online or offline including SQL, PowerBI. Please suggest under $600-800
This is SO helpful, thanks Alex! For anyone looking for the intermediate-level SQL queries, they're near the end - here are the timestamps: 51:20 Joins 62:00 CTEs 66:30 Temp tables 70:20 Views
I just completely watched this priceless video. Many thanks Alex for teaching us free of cost and guiding us all along. I am an Economist and have been learning data analysis since 2022 and it is amazing that I have found your channel and you.
I can’t express how much I appreciate you creating these tutorials. As a beginner prospective analyst looking to add projects to a portfolio, I was lost and overwhelmed. Your videos are a godsend. Thanks a lot
@@AlexTheAnalyst Godsend is an understatement. As a beginner, getting something together from what you have studied is probably the hardest and having someone show you how to get that done with all the errors along the way, makes it seem possible. Glad to have found this channel.
I totally agree. I graduated from the data analytic course recently and was also struggling with the portfolio project. Alex's video is definitely a godsend and very helpful.
What I really want to thank you for is making this real. I mean, keeping all your own mistakes in the video is a booster for Aspiring Analysts like myself. "Yes, it can get messy. We just need to keep calm and figure it out". Thanks once again, Alex
As someone who had to track this type of data since the early days of the pandemic, the project hits a little different. I wish I had found data analysis tools sooner, spent days of work finding, loading and analyzing this information when we didn't have that kind of time. This isn't just a tutorial project just to learn, its the real deal!
38:23 The reason we are not getting correct total deaths when we break down by continents is that in our query we are using MAX(cast(total_deaths as int)), so what it does is it returns the maximum total_death from that particular continent(ex in Oceania continent it returned 910, which is the total death count for Australia and highest in its continent). We need to replace the query by- select continent, sum(new_deaths) from coviddeaths where continent!='' group by continent; Hope this helps!
I'm using MySQL and had a problem when importing the .csv files to the MySQL server. The entire records didn't go into the server, so I changed all the empty values to NULL with Pandas and I finally got the entire records. For people who are facing the same issue. AND I really appreciate your videos!
@@joshuajosh5181 Use pandas to replace all empty cells with a space and save as a new modified CSV. Select Table Data Import Wizard under Table in MySQL....Hope this will help
For those using Mac and found MySql as their preferred option; before you import data, be sure to reformat the date to yyyy-mm-dd so that MySql recognizes the date as an actual date. To do this, highlight the column and press control+1, go to date and select the format I mentioned above. Hope this helps someone!
Hey Jack. I formatted it to yyyy-mm-dd and then imported the files. But are you able to see the results sorted by date when we order by date? I tried cast(date as date) as date1 but still the result is not ordered by date.
@@rrromal I'm having trouble importing as well. I'm using Azure Data Studio on Mac. Is that what you were using and were you able to figure out the issue?
It is currently 2023 and I am doing this since yesterday May 29, 2023. Challenges encountered so far: 1. Using Macbook Air M1, and SQL Server Management Studio (SSMS) is not natively compatible, I have to use Azure SQL Edge virtual container in Docker(which makes my Mac a bit warm). I have to use Azure Data Studio for SQL IDE. Both Docker and Azure Data Studio can run natively in M1. 2. I am not able to import Excel files to the database, I need to convert them to CSV. Azure Data Studio can only import flat files like CSV and JSON. 3. Before importing, most of the numeric attributes needed to be declared into a float data type based on the error-caching of Azure Data Studio. All in all, it was a great dive, thank you, Alex!
Ok so something I want to point out to the newbies, like me, who may be frustrated, don't give up and don't be afraid to ask. Also, I spent an hour trying to figure out how the results pane was kept so clean.... Highlight the text, then click "execute". If you just do the text or code and then click execute, your results pane will stack and eventually you won't be able to see any of your results. Highlight, then execute. This is something nobody explains. Even the Google certificate course doesn't tell you this little detail that is important.
This has been beyond helpful! I've been taking lots of SQL classes at Datacamp, and as you mentioned in your video on Datacamp, one of the drawbacks is not necessarily knowing how to apply the concepts within the software. This helped me feel a lot more confident navigating and applying concepts with SQL Server :)
I appreciate that you talk about where you have issues, as a developer I'm so used to having people breeze through projects in their video without talking about the hiccups they had on their first run before recording. Although it doesn't provide much help in the way of solving problems while trying to follow along, it does help make it clear that solving the weird problems is a part of the journey (and in some cases a part of the fun)! Edit: For those curious, we're now at 92m cases as of August 2022 with a Death Percentage of 1.12%
Just finished the video after weeks of starting it and I'm so happy I finished it! I really want to thank you Alex for taking out time and teaching this cost free, it's my first SQL portfolio and I must say it worth the time spent.
Running this on windows is sooooo much easier than mac ! just fyi...On a mac you have to go to your terminal and program it in there to be compatible ... a lot of work to even come up with the right code! And Alex you ROCK! Thank you so much, wish there were more people like you out in the world giving back the same way you do!!
Hey! I'm struggling trying to import the files from cvs to my sql on my Mac, did you figure it out, would you mind explain me how do it, thank you so much
This is great to start with thanks Alex :) . If anyone like me had an issue with the NULL value for the Date column after importing the excel files to SQL Server, you might need to change the "Excel version" in SQL Server Import and Export Wizard to Microsoft Excel 2016. Also check your system date format to make sure it is the same format as in the video. These changes resolved my issue.
I have started and stopped this video many, many times, but today I got to the end and I'm glad I did. If you're struggling, that's okay. Take a break and come back when you're ready. Happy learnings y'all. And, big thanks Alex🎉
You're a life saver! i just finished the google data analytics course and since im new to all of this i had no idea what to do or where to start to make my portfolio to apply for jobs. Really appreciate you ❤
How you explain these steps is so kind and encouraging and makes nervous beginners such as myself feel fully capable!! THANK YOU. Honestly, without your videos, I probably would have felt too intimidated by data analytics and kept searching for another profession to change into (like you, I'm transitioning from healthcare!)
I just started with it and realized the data is no longer available with so many comments about it. Thank you for sharing the data in the links, you are so considerate.
I’m only 20 mins in and already learned more than my 4 years of bachelors schooling lolololllol. Plus I LOVE how you make tiny mistakes ( we are human, it happens, but they are common something we as beginners might make) and show us directly how to avoid or problem solve and fix them!!! You’re my hero !
HI Courtney, do you mind figuring out what is wrong with this code? select location, date, total_cases, total_deaths, (total_deaths/total_cases)*100 as deathpercentage from [covid death] order by 1,2 Operand data type nvarchar is invalid for divide operator.(this is the output i keep getting)
@@amosadeleke4548 "Operand data type nvarchar is invalid for divide operator" suggests that one or more of the columns used in the calculation for the death percentage field may be of data type nvarchar, which cannot be used in mathematical operations. To fix this issue, you need to ensure that the data type of both the total_cases and total_deaths columns is numeric, such as integer or float, before performing the division operation. One way to achieve this is by converting the data types of these columns using the CAST or CONVERT functions. You can use the below code: SELECT location, date, total_cases, total_deaths, (CAST(total_deaths AS float) / CAST(total_cases AS float)) * 100 AS deathpercentage FROM [covid death] ORDER BY 1, 2
@@amosadeleke4548 what i did here to solve this is i go to his github to download the coviddeaths and covidvaccination the author said that the dataset have been change by the source that is why you get that error so try to do it again as for me i get stuck at 1:09:30 temp table
For the query at 58:56, I was getting an error: "Arithmetic overflow error converting expression to data type int. Warning: Null value is eliminated by an aggregate or other SET operation." For those of you getting the same thing, change the "int" into "bigint", apparently its due to the sum function.
Great catch! I recently noticed this earlier in the video too - int allows max number of 2,147,483,647, bigint allows up to 9 quintillion (9,233,372,036,854). So when vaccinations surpassed ~2bn the video became just slightly obsolete 😀
Thank you soooo much, Alex. For those using Mac and having trouble importing xlsx into MySQL……Here’s my solution: 1.reformat date to yyyy-mm-dd and save as CSV 2.use python to replace all empty values in this CSV with a space (import pandas……fillna()…….) 3. create a new database in MySQL, and select Table Data Import Wizard under Table 4. Select your new modified CSV file and import…Hope this will help!!
For anyone using Azure Data Studio and having trouble importing the CSV files with the SQL Import extension. You will need to change around with the Data Types that Azure identifies. e.g. change Small Int to Int or nvarchar(1) to nvarchar(50). In addition, I made all columns to allow null values. Making these corrections then worked and both CSV files imported into my database.
I'm using the same software the author is and having same issues. I will probably have to go back into excel and change a LOT of the data types because almost all of the numerical columns are showing up as nvarchars. Makes any math functions impossible to use.
@@curiousss4960 Did you ever figure this out? I feel like I'm running into the same issues. No matter what I do to the data in excel (making sure all numbers are actually in a number format), every time i try to perform a calculation in SQL i still gets "0"s. I even tried creating a table from scratch in SQL, specifying what each column's data type should be, and kept running into the same issue.
For people who r geeting "arithmetic overflow error converting expression to data type int", this is because the value in the data exceeds the integer limit, Try converting new_vaccinations to BIGINT in place of INT. Like.... SUM(CONVERT(BIGINT, cv. new_vaccinations)) --cv is the covidVaccinations table This will remove the error. Hope this helps...
I did data analysis and error management in a HUGE database for sprint. The work I did was extremely similar to this. The database was way messier and more confusing than this, but if you can work out the problems as you go like he is, this is basically what I did everyday.
Hi, you seem to have prior experience of related datasets so pardon my asking. I'm at the part where I divide total deaths by total cases to get the deathpercentage. However upon running the query , I'm getting an error message that says 'operand data type nvarchar is invalid for divide operator'. Can you kindly suggest how solve it? Thanks
Dear Alex, as of July 2023 it was a real pain to install SSMS 19 and SQL server 2022. Many errors whilst trying to Connect to the server, and then to import the data through the Wizard...but I managed to find solutions to everything. Right now I just finished the whole Project Tutorial and feel grateful to you for dedicating time and effort to teach us. I'm looking forward to finish the whole Bootcamp and become a greater Data Analyst day by day. Cheers!
@@favourchukwumam3179 Hello mate. I used Alex's original data file in the description box. Nowadays the data set has changed drastically in order (i.e. columns). I just went to the website "ourworldindata" and downloaded the file in .CSV, then a quick search with ctrl+F found the "population column" in the AW spot in the data sheet. Hope this helps! Cheers.
You are doing an excellent job filling the gaps between knowledge and experience! Just finished Google’ s data analytics and building my portfolio, all thanks to your videos. Many thanks!
Thank u so much for the video! Something that I think it is important to clarify that the variable new_vaccinations refers to the number of doses available and not to the number of people vaccinated. If this exercise is done with the updated data, the cumulative percentage exceeds 100% in many countries. I think it should be reinterpreted as 'ratio of doses administered per 100 inhabitants'.
For whoever is having trouble in inserting their data in temp table, make sure to have the same data type of the columns in the covidDeaths table and temp table. And I found it better to specify the columns that you're inserting data in as: INSERT INTO #PercentageOfVaccinatedPopulation(location,date,population,new_vaccinations,TotalInLocation)
I actually did mine a bit differently because I noticed that people_vaccinated is a running total and more accurate than the new_vaccinations (since that column was only getting updated once in a while instead of each day new vaccinations were being performed 💡). I don't know about the earlier data sets, but the one I pulled on 11 November 2023 actually shows an interesting twist too that I didn't think about. If a person was quarantined outside of their resident country and received the first "vaccination" in the country they got it, then the spreadsheet shows more vaccinated people than residents in some cases. That also means though, that if they returned to their country of origin after they were initially "vaccinated" and received a booster there, then they will show again in the people_vaccinated for that country. Food for thought.
Doing this in July 2024, If still you have problems trying to import the data for me this worked: task>import flat file(choose the first one)> next>browse the location>new table name (will be autocompleted)>next >next>next>finish. Hope this helps.
Absolutely amazing video, I have finally realised that as a beginner in the financial investment market, you can achieve close to nothing yourself because you still have a lot to learn. Trading with a professional broker is more profitable and my advice for beginners is to always take advantage of that.
Instead of timing the market, you should try to diversify your portfolio in order to get a dollar-cost average when it’s time to retire. Keep in mind that you don't need a ton of money to invest. Investing in small amounts can build long-term wealth too!
For those who are doing it on MySql, kindly select a smaller dataset per say in a group of 50 from countries in each continent datewise, for both the total no. Of deaths and total vaccinations table.
Extremely useful video! Thanks so much. I play around a lot with data in SQL but was having a challenging time figuring out how to display my knowledge in a portfolio project. This really gave me a solid idea of how and which skills to include. As a healthcare professional looking to switch careers, this was a great topic as well.
Please do no congratulate us at the end. It is my privilege that you put in so much hard work to show how things work. I came here to learn how to 'play around' with the downloaded single file (any form ) and make it multiple files and do analysis. I must say I learn so much new things in SQL as for self learner in this almost 4 months journey, I feel comfortable working with Excel, Power Query, power pivot ,DAX ,Power BI etc. and when ever I encounter with SQL tables ,my main focus is always make simple query in SQL and then copies/import them into Excel for analysis. From today onwards, I would like try the reverse just to come out from my comfort zone. Thanks for your video. It is al so helping me to create portfolio of my work as this this the time to do that.
I really appreciate the inclusion of mistakes and research time, etc. I've been working with software long enough that I can google my way through all kinds of things. But I'm trying to start a data analyst career. And I get depressed when I read the "requirements" in job listings. So it's great to see what reality is for someone who got a job... and has their own RUclips channel.
Thank you Alex for making this learning process an easy and interesting journey. I'm certain that I'm getting a Data Analyst job very soon. I can't believe that I can finally analyze data using SQL, I've tried learning for months from other sources until I found yours. Thank you Alex.
Hi Alex! You are one of the real heroes. During the course of my graduate school studies and doing work on the side, I have had the great fortune of attending seminars, classes, workshops, etc. in great educational institutions from Europe, North America, and Asia. On that note, I have the chance to sit down maybe in the presence of great minds in my field. What I find common among them is the level of emotion, engagement, conviction, and insightfulness when they deliver they disseminate their knowledge and wisdom. Yeah, maybe I'm also a sucker for an excellent education. But man! Sorry to put you in the spot, but you're one of those few people I put in the category of those great educators. You are brilliant! I would compare the great Sal Khan (of Khan Academy) at least in the field you teaching. Much Thanks and appreciation. I'm a constant consumer of your content and enjoy extensively learning from them. Hoping you continue your great work. So happy to hear the last part of this video.
Thanks Alex, you're great!!! Today I finished my first project in SQL and I plan to complete all your videos. It's one of the best courses I've ever done, congratulations! I wish success to all students who, like me, seek to grow professionally.
How were you able to load the data.? I'm using the 19.1 version and for some reason it does not give me the option of import 64 bit and load the data as he mentions. Please help.
I really appreciate your efforts to train other beginner level students to Data Analytics (I'm one of them). Pls keep making such fruitful vedios for us. You're the best man!!!
7:25 I believe the reason is because you saved the excel file as .xlsx (64 bit), so you won't be able to use the 32 bit "SQL Server Import and Export Wizard" to import the data. Try saving the excel file as .xls instead (32 bit). At least that works for me :) Awesome content btw!
xls have only 64k rows. xlsx have +1m rows. xls is Excel 1997 format and have nothing to do with 32/64k. Its simple NOT compressed format. Wide used to exchange data between many systems and have status 'spreadsheet standard' in the old days. change ext of ANY xlsx file to .zip and you can open it by any archive program.
Hi Alex, I just want to give a huge thanks for making these videos. I have tried a couple of other courses but none have made as much sense as you do. I love the fact that you focus on the practical aspects instead of endlessly explaining the theory behind it. Since I´m not looking to reinvent the field but more learn how use the necessary tools, this is exactly what I´m looking for. Keep doing what you are doing, precisely like you are doing it!
For those getting an error message "ORDER BY list of RANGE window frame has total size of 1020 bytes. Largest size supported is 900 bytes." at time 1:00:09 in video, the solution I found is the following: SUM(cast(vac.new_vaccinations as bigint)) OVER (Partition by dea.Location Order by dea.Date)
I see from your task bar you're burning the midnight oil, Alex! Such a great showcase of building your portfolio for a data analyst, love this content!
Doing this in December 2023. I am a SQL beginner and a on my journey to breaking through the data analyst field and am so thankful to you ALEX. I have completed my first project.
Hey I am doing this project right now, For the second query I did this sql code -- Analyzing the likelihood of death if contracting Covid-19 in a specific country Select Location,date,total_cases,total_deaths, CONVERT(DECIMAL(18, 2), (CONVERT(DECIMAL(18, 2), total_deaths) / CONVERT(DECIMAL(18, 2), total_cases)))*100 as DeathPercentage From Covid_Data_Exploration_Project..CovidDeaths order by 1,2; But I am getting every value in the total_deaths column as NULL. Can you help?
Hey Alex, thank you so much. I'm certain that I'm getting a Data Analyst job very soon. I can't believe that I can finally analyze data using SQL, I've tried learning for months from other sources until I found yours. I recently finished the Linkedin Data Analytics Certification, and I've been struggling to figure out how to get my portfolio started. I want to tell you I’m glad you showed your mistake live. I really want to thank you for making this real. It’s important for beginners to see that experts also make mistakes and how can they solve. It is encouraging. As a bonus, I will better remember to save as .xlsx because you pointed it out :) keep going :D
@@AlexTheAnalyst Please help me out, am getting same errors when I try importing from the Portfolio project database But the alternative way you used isn't bringing up Microsoft Excel in the data Source in my system I don't know why
@@triumphotamiri7904 I'm not sure if you figured this yet, but if you didn't.. I was having the same exact problem so what I did was save the files in csv format and then import them as flat data sources since the Microsoft Excel data source was missing
Thank you so much Alex, I really feel this going to get me an actual shot for interviews and a new career, my online courses don’t seem to impress many employers lol
Thank you for doing this. I finished SQL on Khan, and I know you never stop learning, but doing the Covid project, I was able to put it on my github and portfolio, but for me I had a hard time understanding how you came up with the more complex queries at the end, that I thought maybe I’m not ready to apply for jobs? Is it just me, or did anyone else feel lost still even after teaching yourself sql? I was proud of being about to submit it on my github but felt less confident in my abilities because I don’t think I could have figured out those queries on my own.
Thanks to your comment I discovered the Khan Academy's SQL course, it's just amazing how it teaches SQL in such an efficient way, definitively worth it. Thanks to you man.
I just want to let you know, that I am at this point where I am learning SQL and I am feeling less than confident in myself because I am unsure how to figure out on my own what syntax to use to get certain results and how to apply them correctly. So you're not alone. I see that this comment it 5 months old how are you doing and feeling now?
yea I have 2 SQL certificates and have watched most of the popular SQL videos on YT but still am not that confident. It's weird because w/ anything else I learn and spend so much time w/ I would be more confident in.
I'm doing it in April 2024. The new_cases and new_deaths columns are reported every week, not daily anymore. You can just add new_cases 0 in the where statement and it will show you the weekly cases.
I just want to make sure that you know the value of the work that you have been doing. This is so far my favorite portfolio project vídeo on RUclips. I enjoyed every moment of it. Especially the errors/mistakes! I’m learning analytics and I face those errors I feel so frustrated and wondering if one day I will be really good at it. But watching your video I could see that the mistakes and experiments are part of the process!!! Thank you very much!!!
Can't thank you enough for this content!! Small note at 48:38 - I believe SUM(new_cases) and SUM(new_deaths) will be the same as new_cases/new_deaths (won't reflect the true totals) because you are grouping by date. I think it may be more accurate to use MAX(total_cases) and MAX(total_deaths) given that the values are compounded each day and will never decrease. Would love to hear your thoughts/feedback. Really loving this channel - keep up the great work.
Thank you Alex. I was really lost for the past 6 months, not knowing where to start! you really helped me a lot as a beginner, looking forward to more portfolio projects!:)
Alex, THANK YOU!!! I can't express my gratitude enough for everything you've done for us. I just made it through your SQL series (Beginner, Intermediate, & Advanced). Hooray! You make the process so simple and straightforward, which makes it SO easy to follow along. The project component is the BEST part. You're breaking down what we've learned and showing how we can actually use it. This is a HUGE missing link in today's education system. My Biomedical Engineering PhD program funding feel through (absolutely heartbreaking). I made it 2/3 of the way through and wrote 90 pages of a thesis that I was unable to use. While I was able to get a Master's degree, it was not in the subject/career I had wanted. My world was thrown upside down. I had no idea what I was going to do. Then, data analysis and YOU showed up in my life. You (and your "Become a Data Analyst" bootcamp) have served as a beacon of light and hope for my future. Bless you! And THANK YOU again!
Alex, your videos are amazing and you have really helped me get to a place in sql where i feel like i can jump off and just continue to increase my skills and value. I will continue to return to your content regularly and support how i can.
Hi Alex! Thank you very much for this video, I have been watching these videos thanks to the bootcamp playlist and I have learned a lot. For those who have problems uploading the files to SQL Server, what I did was transform the files to CSV and import them as Flat File, in the same way that Alex mentions it as the first option, at some point it will ask for the destination and I selected the one for “Microsoft OLE DB Provider for SQL Server”, or something like that. I know very little about this software, so I don't know exactly what I did, but it worked. I hope it works for you too. Greetings from Mexico!
@@VitorAbreu1001 i also having error like this "Operand data type nvarchar is invalid for divide operator." i tried to change the data type to float..but not working
@@amtzgaming3688 The code will look a bit different from Alex because I went for the updated dataset instead but the error you are saying I managed to fix with the code I have on the GitHub!
@@amtzgaming3688 Select location, date, total_cases,total_deaths, (CONVERT(float, total_deaths) / NULLIF(CONVERT(float, total_cases), 0)) * 100 AS Deathpercentage from PortfolioProject..covidDeaths order by 1,2
Thank you for doing this tutorial I've learn SQl from Udemy and Datacamp. But I really have no idea how to practice SQL until I found your channel! Such a gem.
Great Project - Thanks Alex! Had some trouble importing in the data, but figured out a fix. I did it as a Flat File (CSV) and for some reason, the data types which were recommended were completely wrong (e.g. Varchar was given for some, instead of Float). So I had to manually change a few of the data types myself. Tedious, but was the only solution here :)
@ezhankhan1035 - How did you change the data types? It is blocking me from changing them when I am uploading the CSV file in SQL Server Import & Export Wizard
@@conorkelly9642 I think I used a separate import wizard, just for flat files (CSV files). I right-clicked the database (which I wanted to create the table in) - went to tasks - import flat file. This way then allowed me to change any data types and all that good stuff. Hope it helps!
It took forever, but i finally figured out how to import the covid files. Save files in excel as CSV, right click your portfolio database, click task, import data. The the import wizard pops up, on the top where is says data source choose at Flat File Source, then browse for you file (make sure you select all files on the bottom right, so your CSV files can be seen), then click next, click next again, under destination choose Microsoft OLE DB Provider for SQL Server, confirm the server name is correct, click next, click your file name if it's not already, then next, run immediately should already be checked, click next then finish. When the execution is successul, hit close.
Hey, thanks for this. Followed your steps one-by-one, however some error messages popped up when I was performing the running and finishing up step. Stopped: prepare for execute Stopped: Pre-execute Error: Executing Stopped: Copying to [dbo].[Covid-Deaths] Stopped: Post-executed
You need to converts a values to a float datatype Select location, date, total_cases, total_deaths, (cast(total_deaths as float)/cast(total_cases as float))*100 as DeathPercentage From PortfolioProject..covidDeaths Order by 1,2
Took me over a week to translate MSSMS's syntax into bigquery in order to do this project but I'm smarter now because of it and also feel like an SQL god 😤 thanks sm for this tutorial Alex appreciate it a million
Those who are having trouble while trying to cast the matrices as integer value(apparently the numbers have grown lately ), Arithmetic overflow error is likely to occur. Try BIGINT instead of INT
-- Operand data type nvarchar is invalid for divide operator. I'm getting this error on this SELECT Location, date, total_cases, total_deaths, (total_deaths/total_cases) *100 as DeathPercentage FROM CovidDeaths_updated I checked chatgpt and I was directed to change the columns to INT by doing this: ALTER TABLE CovidDeaths ALTER COLUMN total_deaths INT; After doing so, my data seems inaccurate. Did I miss anything? By the way, I also ch went back and updated the data types in Excel and tried importing it again. But I am still getting the same error. TIA.
Doing this in 2023, the data columns of total_cases and total_deaths are assigned as nvchar which leads to issues in doing the death proportion operation, you need to cast the columns as decimal for the operation to work: I used (CAST(total_deaths AS decimal(12,2)) / CAST(total_cases AS decimal(12,2)))*100 also choose the decimal function first entry based on the numbers you get as if it is given too low it will result in nvchar to decimal overflow error.
I just completed this project and I would say this is really fantastic. I appreciate the effort you put in putting this video together. Thanks for your help Alex🙌
Hi I also want to complete this project. But I am enable to export this large dataset from Excel to Microsoft SQL. As the data has grown since the video was released. Were you able to get all rows in SQL ,which were lakhs in number approximately
I know you said you felt like you were rambling as the video progress, but please don't think so! It really helps understand the thought process behind each query. Thank you so much Alex for these videos! :)
I am doing this in 2024, if you notice this error(divide by zero error encontered at 48:42, insect function __________Nullif(sum(new_deaths), 0)/nullif(sum(new_cases), 0)*100 as deathpersntage________ Hope this helps
I have the same issue. I had to CAST both sums due to data format. In my case it looks: Nullif(sum(cast(new_deaths as int), 0)/nullif(sum(cast(new_cases as int), 0)*100 I get an error -- The sum function requires 1 argument(s).
What a coincidence!! I’m currently doing the Google Data Analytics Certificate Program. Already completed 6/8 courses in 3 weeks. Now in Course 7 learning about R. Found this dataset last week and plan to use it for my personal project. Very excited to see you work on this exact same dataset ;-)
to whoever is still having issues with importing Option 1: ruclips.net/video/JVP9frj2VSQ/видео.html Options 2: ruclips.net/video/brGq2by7DvA/видео.html Options 2 worked for me. Feel free to add more options as they arrive
Hello Alex, I'm doing this in Nov 2023. I've identified the root cause for our inaccurate total deaths breakdown by continent at 37:00 The issue lies in the cumulative total deaths column, which isn't accurate. Instead of relying on the 'Max' aggregate function, I now use the 'SUM' function for the new deaths column instead of the total deaths column that you used in the video, providing a more accurate total. This has been beyond helpful! Thank you so much for putting the time and effort into this! You're too kind
Can't thank you much for taking this initiative and helping beginners like me to apply the SQL skills to real-world data. Waiting for the second one. You are awesome buddy.
11-Aug-2023 Having problems with importing the data or csv files. Then, You should save your Excel file to a lower version is can be a 2003 version of excel. Once save the file you can now do the Data Transfer of SQL. THEN Hit NEXT. Instead of using SQL Server Native Client 11.0, It is now Microsoft OLE DB Provider for SQL Server. This took me a while to figure out and import. Hope this helps!
Great video and channel Alex. When creating the view around the 70 minute mark, I had to add "USE PortfolioProject GO" before the "CREATE VIEW" to get the view to show in the object explorer. Hope it helps someone. So thankful for the channel!!!
Had a problem calculating TotalDeathPercent and took me 2 hours to figure out the solution. I looked through the comments and performed below steps , 1) uninstalled my Microsoft SQL server 2023 and installed Microsoft SQL server 2019. 2) Imported Excel file rather than Flat text through Import Export Wizard as shown by Alex. 3) Converted the ncharvar Total deaths and total cases to Float using Command ALTER TABLE CovidDeaths ALTER COLUMN total_Cases FLOAT. Worked like a Charm. Hope it helps :)
Alex, you're awesome. Thank you very much for taking out time to make these videos. These are priceless. I was struggling to create a project. Thanks a lot again.
HI ALEX, I am from Philippines ,I appreciate you and your heart to helping us, you are my stepping stone in this career, Thank you again and God bless you!
I'm doing this in Oct 2021 and apparently one of the code chunks where you need to convert new_vaccinations column to integer, the sum value now has exceeded 2,147,483,647. So instead of converting it to "int", you will need to convert to "bigint". Hope this helps everyone.
Totally helped! Thank youu!
Thank you , that was a real big help for me.
You totally saved my life! I was almost doing crazy!
Thanks, I can stop banging my head.
Totally helped! Thank you!
I'm transitioning from teaching to data analytics. I recently finished the Google Data Analytics Certification, and I've been struggling to figure out how to get my portfolio started. I found this video, and I got really excited to use this as a guided project. Then, I saw Alex was using Covid data, and I had to pause to consider if I could handle it. I lost my dad to Covid 4 months ago. This is personal.
However, I think I need this now as another way to process through the continuing grief. The fact is, data is personal. Each of these data points describes people. Someone's father, mother, sister, brother, grandparent, friend, and so on. This data is reality, and it's so important to analyze it in order to truly show the impact that this pandemic has made. Especially, as things may be getting back to "normal" in some places around the world, this data proves that "normal" is not the same without the lives of so many. And maybe, just maybe, analysis and visualization of this dataset can encourage others to get the vaccine, and we can be more informed moving forward.
Thank you for sharing Amy and I’m sorry for your loss. It definitely does give you some interesting insights into the real data rather than just seeing what is on news websites.
So sorry for your loss. In Ghana we tell people to adhere to the protocols if they don't want to be used as data.
so did I , google data anlaytics certificate was too basic and so many theory!
@@garry6882 Yeah true
I lost my grandma, the closest person to my heart in this whole world. I know what the loss is, the dead may be just numbers for someone but only the people who lost someone close, knows the pain.
I’ve just started the video and I’m about 9 minutes in. I wanted to stop at this point to tell you I’m glad you showed your mistake live. It’s important for beginners to see that experts also make mistakes. It is encouraging. As a bonus, I will better remember to save as xlsx because you pointed it out. So thank you for leaving that in.
I make a ton of mistakes! haha the cuts that I took out were 5+ minutes of me having to research something or figure something out and then coming back. Didn't want to keep that boring stuff in lol
Agreed. The realness is encouraging for us mere mortals (and the mistakes help give me time to catch up to Alex...)
@@Major_Data well let’s not get carried away here. This is THE Alex the Analyst we are talking about! 🤣
@@veronicab2096 oh, I didn't mean catch up to him on skills. I just meant keep up with him on the video. 🤣
Years ago I said no to programming because I always find myself making mistakes (I'm a GIS Engineer). Then came my friend, a software developer also make tons of mistakes. I questioned him because he has a degree in software engineering with years of experience, then he replied "I'm a human, not a computer. Even human to human also sometimes struggle to communicate" haha
This was a lifesaver when I needed a portfolio quickly for a job interview while still being a beginner.
It was easy to follow and I could base my own projects on it. This definitely was part of me getting the job!
How did the J interview go
I wish I could give a "bravo" reaction to this comment! Congrats! Hope to hop on your boat soon enough and happy to have found this video!
how did you mention this project in your portfolio? like summary of this project. please help me with this.
Please where did you host your portfolio?
i mean how do you paste projects on your github if that's where we'll be hosting all our projects
I'm doing this in May 2024 and had trouble with inserting data. Here is the solution that worked for me:
Select DB in SSMS > Tasks > Import Data > Next > Data source: Flat file source > Select CSV file (make sure you have saved the excel file as a CSV) > > Next > Destination: Microsoft OLE DB Driver for SQL Server > Click on Properties and enter server name, change to Windows Authentication, Select your Database name and test connection > Next > Next > Finish
Thank you soo much😭😭😭❤️
I've been googling my way through errors for TWO MONTHS, thank you so much for this.
@@transplantman2287 I hear you! I looked into the 2016 redistribution download and everything but nothing worked other than this. Hoping I can figure it out soon but this way for sure worked and got all the data inserted
How to find a server name
@@pranavbhawane7591 When you first open the SQL Server studio, you will get the pop-up to connect. In this pop-up, you'll see the server type, server name, authentication... The server name is listed here. I would suggest copy and paste this before connecting to your server that way you already have it when you type in the name for the database
For me, this way worked:
Select DB in SSMS > Tasks > Import Data > Next > Data source = Flat file source > Select CSV (!) file (you have to change expected file extension during file selection) > Locale = English (United States) (i don't know if it matters though) > Next > Destination > Microsoft OLE DB Provider for SQL Server > Next > Next > Finish
Hey I need help. After uploading my data, doesn't show up under the database. I have refreshed repeatedly but no luck with it. Any idea how I can solve this issue? thanks
Same,I’ve encountered the same problem
when choosing destination, select "microsoft ole db provider for sql server"@@brendachiri2890
@@godswillekanem have you checked "Tables" under database?
Thanks man. You really saved my day with this method. I've wasted 2 entire days trying to import data already!!
Great content, as per. You helped me to get my dream job as a modelling analyst in the last couple of weeks, I am forever grateful to you!
That's so awesome! Congratulations!!
Great to here. What did the interviewers look for? Excel,SQL, and Tableau/PowerBi? I'm asking because I want to make sure I am on the right track.
@@CE-vd2px Please check previous videos of Alex, he has made some good videos on DA skills
@@binodrai3653 I did but I like to verify.
@@CE-vd2px in addition to what you have mentioned learn Python or R.
For those who are currently working on their portfolio project and can't import Excel file using any of the methods Alex showed.
I tried this and it worked.
Save your file as CSV and apply the first method Alex showed right click the portfolio project, select task, in the dialogue box, select flat file source, browse your folder to select the CSV file (ensure the extension on the browse dialogue box is .CSV, so you can see your CSV files and select it, destination option select SQL server and click next till finish"
Hope it helps. Alex thanks again for the video . I can now go ahead with my project
Thank you so much, that really helped.
Thanks a lot, it worked for me
Yes! That is true also because it works!
top comment
My guy! Thank you!
Hi Alex! Doing this in July 2023 and I think the SMSS features have changed a bit. Instead of using SQL Server Native Client 11.0 it is now Microsoft OLE DB Provider for SQL Server. This took me a while to figure out and import. Hope this helps!
Thank you, been at it for hours
God bless you brother..... almost felt left out
Helped me a lot !!!1 Thanks
Thank you so much for this.
thank you so much i was breaking my head
To the ones stuck on 19:10 , use the following code to convert into float datatype when ''Null"
Select location, date, total_cases,total_deaths,
(CONVERT(float, total_deaths) / NULLIF(CONVERT(float, total_cases), 0)) * 100 AS Deathpercentage
from PortfolioProject..covidDeaths
order by 1,2
So stuck in this part! thank youuuuuuuuuuu!
Ah yes. Thank you. I would love to understand more about how to query this
@@solomonadeniyi4197 brother its all about data type. Some of the data in "Numeric" data type is actually float, thats why we need to convert it
Yay! You saved my life
@alijokhio2995 thank you so much, brother
Just when I thought this guy has done a great deal of work for beginners like me, he goes on to do greater things like this. Really thank you Alex -from an aspiring analyst
You're most welcome! So glad it's helpful!
@@AlexTheAnalyst can you tell What is the Primary key in this Table?
@@k-EE-VIPESHDUNKWAL In short you can say it's the unique identifire of every rows in a table.
For those doing it from March 2024, you should cast all the columns to floats. Took me days to figure it out. The data in the tables are more and int or even bigint doesn't cut it
Thank you so much! At 1:06 I got stuck because of the constant errors I was getting. When I read your comment and casted as float on the line code reading ", SUM(CAST(vac.new_vaccinations as float)) OVER (Partition by dea.location order by dea.location,dea.date) as RollingPeopleVaccinated" I finally got the query to work as it was suppoded to.
@@maddie8564 I'm glad I could help
thank you so much i was getting errors and this helped
Thank you!
did you also find out that not all the data gets loaded onto sql for some reason? I only got about 2600 rows in smss. Not sure what to do to fix that
Man... you're amazing. Don't congratulate us to have stayed until the end! It's TONS of work you've done and it's only to be applauded and appreciated! I bet many agree with me - against your sore throat you guided us through soooo many ideas and possibilities! Thank you so much and wish you MILLIONS views!
Working on your education isn't easy, I'm proud you made it to the end - shows commitment :)
Thanks alot for this great walkthrough Alex. 👏 👏
Just a quick question for the audience, I am looking for a good budget laptop. My primary purpose is to be able to run all the DB applications online or offline including SQL, PowerBI. Please suggest under $600-800
Hey did u get the data from jan 2020 bcz now i am doing it and same website is consisting of data from feb 2020 to september 2022
I did everything up till the end and keep refreshing the View tab but it won’t appear.
❤ATA❤
This is SO helpful, thanks Alex! For anyone looking for the intermediate-level SQL queries, they're near the end - here are the timestamps:
51:20 Joins
62:00 CTEs
66:30 Temp tables
70:20 Views
great comment craig!
Hi, please can you help with the particular dataset that was used in this video?
@@eniolababafemi8549 Please see the link to it in the video description.
I did everything up till the end and keep refreshing the View tab but it won’t appear.
@@s.i.8852 Make sure you are filtered to Portfolio Project and not Master when you create it. Then refresh and it should show up
I just completely watched this priceless video. Many thanks Alex for teaching us free of cost and guiding us all along. I am an Economist and have been learning data analysis since 2022 and it is amazing that I have found your channel and you.
I can’t express how much I appreciate you creating these tutorials. As a beginner prospective analyst looking to add projects to a portfolio, I was lost and overwhelmed. Your videos are a godsend. Thanks a lot
So awesome to hear it!
@@AlexTheAnalyst Godsend is an understatement. As a beginner, getting something together from what you have studied is probably the hardest and having someone show you how to get that done with all the errors along the way, makes it seem possible. Glad to have found this channel.
I totally agree. I graduated from the data analytic course recently and was also struggling with the portfolio project. Alex's video is definitely a godsend and very helpful.
Sir where can I get this data set
I did everything up till the end and keep refreshing the View tab but it won’t appear.
What I really want to thank you for is making this real. I mean, keeping all your own mistakes in the video is a booster for Aspiring Analysts like myself.
"Yes, it can get messy. We just need to keep calm and figure it out". Thanks once again, Alex
As someone who had to track this type of data since the early days of the pandemic, the project hits a little different. I wish I had found data analysis tools sooner, spent days of work finding, loading and analyzing this information when we didn't have that kind of time. This isn't just a tutorial project just to learn, its the real deal!
Every time I watch this part, it makes me smile. "I don't understand, don't ask me". Thank you Alex.
38:23 The reason we are not getting correct total deaths when we break down by continents is that in our query we are using MAX(cast(total_deaths as int)), so what it does is it returns the maximum total_death from that particular continent(ex in Oceania continent it returned 910, which is the total death count for Australia and highest in its continent). We need to replace the query by- select continent, sum(new_deaths)
from coviddeaths
where continent!=''
group by continent;
Hope this helps!
Exactly! Because we're requesting the total of all deaths of the countries in each continent and not the HIGHEST death count 🙂
Thanks for pointing it out. I was also confused by the code Alex was suggesting because it didn't make sense so I also applied your suggestion.
Yes, I also noticed that, if you do it correctly you will notice that Europe had way more deaths than North America.
bro i made like that, the thing is that the numbers of north america are higher than US+CAD, idk why
nvm, NA has more countries not only US and CAD, thanks a lot!!
I'm using MySQL and had a problem when importing the .csv files to the MySQL server. The entire records didn't go into the server, so I changed all the empty values to NULL with Pandas and I finally got the entire records. For people who are facing the same issue. AND I really appreciate your videos!
Hey, do you mind explaining this a bit
I'm having issues importing the CSV files into Mysql as well. Unfortunately, I don't know much about Python. Is there any other way around this?
@@akinsanyaoluwatomisin513 Hi there, have you been able to figure out a way around it? Having the same issue :(
Thanks for your suggestion !! I am a Mac users, your comment is a life saver!
@@joshuajosh5181 Use pandas to replace all empty cells with a space and save as a new modified CSV. Select Table Data Import Wizard under Table in MySQL....Hope this will help
For those using Mac and found MySql as their preferred option; before you import data, be sure to reformat the date to yyyy-mm-dd so that MySql recognizes the date as an actual date. To do this, highlight the column and press control+1, go to date and select the format I mentioned above. Hope this helps someone!
Were you able to import the data? im still having trouble
Hey Jack. I formatted it to yyyy-mm-dd and then imported the files. But are you able to see the results sorted by date when we order by date? I tried cast(date as date) as date1 but still the result is not ordered by date.
@@rrromal I'm having trouble importing as well. I'm using Azure Data Studio on Mac. Is that what you were using and were you able to figure out the issue?
@@hi.imferg No I was using MySql, turns out I had to change data types
@@rrromal how you import files in mysql??? , please tell me
It is currently 2023 and I am doing this since yesterday May 29, 2023.
Challenges encountered so far:
1. Using Macbook Air M1, and SQL Server Management Studio (SSMS) is not natively compatible, I have to use Azure SQL Edge virtual container in Docker(which makes my Mac a bit warm). I have to use Azure Data Studio for SQL IDE. Both Docker and Azure Data Studio can run natively in M1.
2. I am not able to import Excel files to the database, I need to convert them to CSV. Azure Data Studio can only import flat files like CSV and JSON.
3. Before importing, most of the numeric attributes needed to be declared into a float data type based on the error-caching of Azure Data Studio.
All in all, it was a great dive, thank you, Alex!
Ok so something I want to point out to the newbies, like me, who may be frustrated, don't give up and don't be afraid to ask. Also, I spent an hour trying to figure out how the results pane was kept so clean.... Highlight the text, then click "execute". If you just do the text or code and then click execute, your results pane will stack and eventually you won't be able to see any of your results. Highlight, then execute. This is something nobody explains. Even the Google certificate course doesn't tell you this little detail that is important.
thanks this was helpful
Is there a free version of an app that allows you to edit XLSX files, or do you have to pay for some version of Microsoft 365? Thanks
Thank you. I really wish this was explained.
This has been beyond helpful! I've been taking lots of SQL classes at Datacamp, and as you mentioned in your video on Datacamp, one of the drawbacks is not necessarily knowing how to apply the concepts within the software. This helped me feel a lot more confident navigating and applying concepts with SQL Server :)
I appreciate that you talk about where you have issues, as a developer I'm so used to having people breeze through projects in their video without talking about the hiccups they had on their first run before recording. Although it doesn't provide much help in the way of solving problems while trying to follow along, it does help make it clear that solving the weird problems is a part of the journey (and in some cases a part of the fun)!
Edit: For those curious, we're now at 92m cases as of August 2022 with a Death Percentage of 1.12%
Just finished the video after weeks of starting it and I'm so happy I finished it!
I really want to thank you Alex for taking out time and teaching this cost free, it's my first SQL portfolio and I must say it worth the time spent.
Running this on windows is sooooo much easier than mac ! just fyi...On a mac you have to go to your terminal and program it in there to be compatible ... a lot of work to even come up with the right code! And Alex you ROCK! Thank you so much, wish there were more people like you out in the world giving back the same way you do!!
Hey! I'm struggling trying to import the files from cvs to my sql on my Mac, did you figure it out, would you mind explain me how do it, thank you so much
I just started learning sql 2 days ago, and now I'm doing my first project with your help!
So easy to understand!
Good work! :D
nice one nino, pls keep us updated. i too just started sql last 2 weeks
@@munachinwanedo494 I just started too.
hi, so to import the data, did you have to purchase Microsoft server 2022? I think it is not free anymore
This is great to start with thanks Alex :) . If anyone like me had an issue with the NULL value for the Date column after importing the excel files to SQL Server, you might need to change the "Excel version" in SQL Server Import and Export Wizard to Microsoft Excel 2016. Also check your system date format to make sure it is the same format as in the video. These changes resolved my issue.
I have started and stopped this video many, many times, but today I got to the end and I'm glad I did.
If you're struggling, that's okay.
Take a break and come back when you're ready.
Happy learnings y'all.
And, big thanks Alex🎉
This is my first project on SQL. I couldn't have done without you.
Thanks a lot
You're a life saver! i just finished the google data analytics course and since im new to all of this i had no idea what to do or where to start to make my portfolio to apply for jobs. Really appreciate you ❤
Glad I could help!
How you explain these steps is so kind and encouraging and makes nervous beginners such as myself feel fully capable!! THANK YOU. Honestly, without your videos, I probably would have felt too intimidated by data analytics and kept searching for another profession to change into (like you, I'm transitioning from healthcare!)
I'm so glad to hear that! That makes doing all of this worth it :D
I just started with it and realized the data is no longer available with so many comments about it. Thank you for sharing the data in the links, you are so considerate.
I’m only 20 mins in and already learned more than my 4 years of bachelors schooling lolololllol. Plus I LOVE how you make tiny mistakes ( we are human, it happens, but they are common something we as beginners might make) and show us directly how to avoid or problem solve and fix them!!! You’re my hero !
HI Courtney, do you mind figuring out what is wrong with this code?
select location, date, total_cases, total_deaths, (total_deaths/total_cases)*100 as deathpercentage
from [covid death]
order by 1,2
Operand data type nvarchar is invalid for divide operator.(this is the output i keep getting)
@@amosadeleke4548 "Operand data type nvarchar is invalid for divide operator" suggests that one or more of the columns used in the calculation for the death percentage field may be of data type nvarchar, which cannot be used in mathematical operations.
To fix this issue, you need to ensure that the data type of both the total_cases and total_deaths columns is numeric, such as integer or float, before performing the division operation. One way to achieve this is by converting the data types of these columns using the CAST or CONVERT functions.
You can use the below code:
SELECT location, date, total_cases, total_deaths,
(CAST(total_deaths AS float) / CAST(total_cases AS float)) * 100 AS deathpercentage
FROM [covid death]
ORDER BY 1, 2
@@harikrishna7634hi i tried this and it didn’t give me the result i wanted
@@amosadeleke4548 what i did here to solve this is i go to his github to download the coviddeaths and covidvaccination the author said that the dataset have been change by the source that is why you get that error so try to do it again as for me i get stuck at 1:09:30 temp table
For the query at 58:56, I was getting an error:
"Arithmetic overflow error converting expression to data type int. Warning: Null value is eliminated by an aggregate or other SET operation."
For those of you getting the same thing, change the "int" into "bigint", apparently its due to the sum function.
Thank u so much you’re a life saver!
thank you!!
Great catch! I recently noticed this earlier in the video too - int allows max number of 2,147,483,647, bigint allows up to 9 quintillion (9,233,372,036,854). So when vaccinations surpassed ~2bn the video became just slightly obsolete 😀
Glad all of you worked it out in the end!
you saved me thank you!!!!
My Only Regret is not finding your Channel sooner Alex. You have helped me so much and I am super grateful.
Thank you soooo much, Alex.
For those using Mac and having trouble importing xlsx into MySQL……Here’s my solution:
1.reformat date to yyyy-mm-dd and save as CSV
2.use python to replace all empty values in this CSV with a space
(import pandas……fillna()…….)
3. create a new database in MySQL, and select Table Data Import Wizard under Table
4. Select your new modified CSV file and import…Hope this will help!!
Hey, please can you help me. I am still having trouble using MySQL. Please help!
For anyone using Azure Data Studio and having trouble importing the CSV files with the SQL Import extension. You will need to change around with the Data Types that Azure identifies. e.g. change Small Int to Int or nvarchar(1) to nvarchar(50). In addition, I made all columns to allow null values. Making these corrections then worked and both CSV files imported into my database.
I'm using the same software the author is and having same issues. I will probably have to go back into excel and change a LOT of the data types because almost all of the numerical columns are showing up as nvarchars. Makes any math functions impossible to use.
@@curiousss4960 Did you ever figure this out? I feel like I'm running into the same issues. No matter what I do to the data in excel (making sure all numbers are actually in a number format), every time i try to perform a calculation in SQL i still gets "0"s. I even tried creating a table from scratch in SQL, specifying what each column's data type should be, and kept running into the same issue.
how did you do with covid vaccination table??
For people who r geeting "arithmetic overflow error converting expression to data type int", this is because the value in the data exceeds the integer limit,
Try converting new_vaccinations to BIGINT in place of INT.
Like....
SUM(CONVERT(BIGINT, cv. new_vaccinations))
--cv is the covidVaccinations table
This will remove the error.
Hope this helps...
Thanks, I had the error. i was stuck lol.
Thanks dude!
Appreciate you my dude!!!
I did data analysis and error management in a HUGE database for sprint. The work I did was extremely similar to this. The database was way messier and more confusing than this, but if you can work out the problems as you go like he is, this is basically what I did everyday.
Hi, you seem to have prior experience of related datasets so pardon my asking. I'm at the part where I divide total deaths by total cases to get the deathpercentage. However upon running the query , I'm getting an error message that says 'operand data type nvarchar is invalid for divide operator'.
Can you kindly suggest how solve it?
Thanks
Dear Alex, as of July 2023 it was a real pain to install SSMS 19 and SQL server 2022. Many errors whilst trying to Connect to the server, and then to import the data through the Wizard...but I managed to find solutions to everything.
Right now I just finished the whole Project Tutorial and feel grateful to you for dedicating time and effort to teach us. I'm looking forward to finish the whole Bootcamp and become a greater Data Analyst day by day.
Cheers!
Hi, i could not find population column in CovidDeaths Table, pls did you experience this?
@@favourchukwumam3179 Hello mate.
I used Alex's original data file in the description box. Nowadays the data set has changed drastically in order (i.e. columns).
I just went to the website "ourworldindata" and downloaded the file in .CSV, then a quick search with ctrl+F found the "population column" in the AW spot in the data sheet.
Hope this helps! Cheers.
Hi @julianoviedo, how did u download SSMS 19?
Hey there can you help me with the issues regarding uploading excel file into SQL
You are doing an excellent job filling the gaps between knowledge and experience! Just finished Google’ s data analytics and building my portfolio, all thanks to your videos. Many thanks!
How long did it take you to complete the course?
I did it in 2 months, but if you’re going to follow thorough every link,, sub course and indexes, then you’ll need more than 6 months!
This! I'm finishing mine right now as well and feel blessed to have found Alex's amazing videos.
is this course any good ???
Thank u so much for the video! Something that I think it is important to clarify that the variable new_vaccinations refers to the number of doses available and not to the number of people vaccinated. If this exercise is done with the updated data, the cumulative percentage exceeds 100% in many countries. I think it should be reinterpreted as 'ratio of doses administered per 100 inhabitants'.
For whoever is having trouble in inserting their data in temp table, make sure to have the same data type of the columns in the covidDeaths table and temp table. And I found it better to specify the columns that you're inserting data in as:
INSERT INTO #PercentageOfVaccinatedPopulation(location,date,population,new_vaccinations,TotalInLocation)
I actually did mine a bit differently because I noticed that people_vaccinated is a running total and more accurate than the new_vaccinations (since that column was only getting updated once in a while instead of each day new vaccinations were being performed 💡). I don't know about the earlier data sets, but the one I pulled on 11 November 2023 actually shows an interesting twist too that I didn't think about. If a person was quarantined outside of their resident country and received the first "vaccination" in the country they got it, then the spreadsheet shows more vaccinated people than residents in some cases. That also means though, that if they returned to their country of origin after they were initially "vaccinated" and received a booster there, then they will show again in the people_vaccinated for that country. Food for thought.
Doing this in July 2024, If still you have problems trying to import the data for me this worked:
task>import flat file(choose the first one)> next>browse the location>new table name (will be autocompleted)>next >next>next>finish. Hope this helps.
Thank you!
Absolutely amazing video, I have finally realised that as a beginner in the financial investment market, you can achieve close to nothing yourself because you still have a lot to learn. Trading with a professional broker is more profitable and my advice for beginners is to always take advantage of that.
Instead of timing the market, you should try to diversify your portfolio in order to get a dollar-cost average when it’s time to retire. Keep in mind that you don't need a ton of money to invest. Investing in small amounts can build long-term wealth too!
I'm an amateur making terrible picks and I really need assistance.
Trading is Profitable with the help of a seasoned broker managing your trading account.
@@helenoliver4838 'BRIDGET MARY TUROW"".
@@mariahhayes5089 How can i reach her?.
For those who are doing it on MySql, kindly select a smaller dataset per say in a group of 50 from countries in each continent datewise, for both the total no. Of deaths and total vaccinations table.
Extremely useful video! Thanks so much. I play around a lot with data in SQL but was having a challenging time figuring out how to display my knowledge in a portfolio project. This really gave me a solid idea of how and which skills to include. As a healthcare professional looking to switch careers, this was a great topic as well.
Please do no congratulate us at the end. It is my privilege that you put in so much hard work to show how things work. I came here to learn how to 'play around' with the downloaded single file (any form ) and make it multiple files and do analysis. I must say I learn so much new things in SQL as for self learner in this almost 4 months journey, I feel comfortable working with Excel, Power Query, power pivot ,DAX ,Power BI etc. and when ever I encounter with SQL tables ,my main focus is always make simple query in SQL and then copies/import them into Excel for analysis. From today onwards, I would like try the reverse just to come out from my comfort zone. Thanks for your video. It is al so helping me to create portfolio of my work as this this the time to do that.
I really appreciate the inclusion of mistakes and research time, etc. I've been working with software long enough that I can google my way through all kinds of things. But I'm trying to start a data analyst career. And I get depressed when I read the "requirements" in job listings. So it's great to see what reality is for someone who got a job... and has their own RUclips channel.
Thank you Alex for making this learning process an easy and interesting journey. I'm certain that I'm getting a Data Analyst job very soon. I can't believe that I can finally analyze data using SQL, I've tried learning for months from other sources until I found yours.
Thank you Alex.
I'm so glad it's helpful! So awesome to hear :)
Hi Alex! You are one of the real heroes.
During the course of my graduate school studies and doing work on the side, I have had the great fortune of attending seminars, classes, workshops, etc. in great educational institutions from Europe, North America, and Asia.
On that note, I have the chance to sit down maybe in the presence of great minds in my field.
What I find common among them is the level of emotion, engagement, conviction, and insightfulness when they deliver they disseminate their knowledge and wisdom.
Yeah, maybe I'm also a sucker for an excellent education.
But man! Sorry to put you in the spot, but you're one of those few people I put in the category of those great educators.
You are brilliant!
I would compare the great Sal Khan (of Khan Academy) at least in the field you teaching.
Much Thanks and appreciation.
I'm a constant consumer of your content and enjoy extensively learning from them.
Hoping you continue your great work.
So happy to hear the last part of this video.
Thanks Alex, you're great!!!
Today I finished my first project in SQL and I plan to complete all your videos. It's one of the best courses I've ever done, congratulations!
I wish success to all students who, like me, seek to grow professionally.
How were you able to load the data.? I'm using the 19.1 version and for some reason it does not give me the option of import 64 bit and load the data as he mentions. Please help.
I really appreciate your efforts to train other beginner level students to Data Analytics (I'm one of them). Pls keep making such fruitful vedios for us. You're the best man!!!
Thank you! Thanks for watching!
You're actually the best Alex, thank you so much, I'm so glad people like you are on this planet man, you make it better
So glad to hear it! Thanks for watching :D
7:25 I believe the reason is because you saved the excel file as .xlsx (64 bit), so you won't be able to use the 32 bit "SQL Server Import and Export Wizard" to import the data. Try saving the excel file as .xls instead (32 bit). At least that works for me :) Awesome content btw!
Definitely could be? I should look into that
True. Changing from xlsx to xls works without the error coming up
How did you put this big data through workbench wizard ....it would take months......can you help me
I tried to save as .xls, but it shows that some data might be lost in the .xls file.
xls have only 64k rows.
xlsx have +1m rows.
xls is Excel 1997 format and have nothing to do with 32/64k. Its simple NOT compressed format. Wide used to exchange data between many systems and have status 'spreadsheet standard' in the old days.
change ext of ANY xlsx file to .zip and you can open it by any archive program.
Hi Alex, I just want to give a huge thanks for making these videos. I have tried a couple of other courses but none have made as much sense as you do. I love the fact that you focus on the practical aspects instead of endlessly explaining the theory behind it. Since I´m not looking to reinvent the field but more learn how use the necessary tools, this is exactly what I´m looking for. Keep doing what you are doing, precisely like you are doing it!
For those getting an error message "ORDER BY list of RANGE window frame has total size of 1020 bytes. Largest size supported is 900 bytes." at time 1:00:09 in video, the solution I found is the following:
SUM(cast(vac.new_vaccinations as bigint)) OVER (Partition by dea.Location Order by dea.Date)
I appreciate your comment, man. This mistake is occurring for me.
thanks man
I see from your task bar you're burning the midnight oil, Alex!
Such a great showcase of building your portfolio for a data analyst, love this content!
Haha thanks man! :D
Just stopped here to say: This is gold!!
Doing this in December 2023. I am a SQL beginner and a on my journey to breaking through the data analyst field and am so thankful to you ALEX. I have completed my first project.
Hey I am doing this project right now, For the second query I did this sql code
-- Analyzing the likelihood of death if contracting Covid-19 in a specific country
Select Location,date,total_cases,total_deaths,
CONVERT(DECIMAL(18, 2), (CONVERT(DECIMAL(18, 2), total_deaths) / CONVERT(DECIMAL(18, 2), total_cases)))*100
as DeathPercentage
From Covid_Data_Exploration_Project..CovidDeaths
order by 1,2;
But I am getting every value in the total_deaths column as NULL. Can you help?
Hey Alex, thank you so much. I'm certain that I'm getting a Data Analyst job very soon. I can't believe that I can finally analyze data using SQL, I've tried learning for months from other sources until I found yours. I recently finished the Linkedin Data Analytics Certification, and I've been struggling to figure out how to get my portfolio started. I want to tell you I’m glad you showed your mistake live. I really want to thank you for making this real. It’s important for beginners to see that experts also make mistakes and how can they solve. It is encouraging. As a bonus, I will better remember to save as .xlsx because you pointed it out :) keep going :D
So glad to hear it :)
@@AlexTheAnalyst Please help me out, am getting same errors when I try importing from the Portfolio project database
But the alternative way you used isn't bringing up Microsoft Excel in the data Source in my system I don't know why
Update? Got a job?
@@triumphotamiri7904 I'm not sure if you figured this yet, but if you didn't.. I was having the same exact problem so what I did was save the files in csv format and then import them as flat data sources since the Microsoft Excel data source was missing
Thank you so much Alex, I really feel this going to get me an actual shot for interviews and a new career, my online courses don’t seem to impress many employers lol
Thank you for doing this. I finished SQL on Khan, and I know you never stop learning, but doing the Covid project, I was able to put it on my github and portfolio, but for me I had a hard time understanding how you came up with the more complex queries at the end, that I thought maybe I’m not ready to apply for jobs? Is it just me, or did anyone else feel lost still even after teaching yourself sql? I was proud of being about to submit it on my github but felt less confident in my abilities because I don’t think I could have figured out those queries on my own.
Thanks to your comment I discovered the Khan Academy's SQL course, it's just amazing how it teaches SQL in such an efficient way, definitively worth it. Thanks to you man.
I just want to let you know, that I am at this point where I am learning SQL and I am feeling less than confident in myself because I am unsure how to figure out on my own what syntax to use to get certain results and how to apply them correctly. So you're not alone. I see that this comment it 5 months old how are you doing and feeling now?
yea I have 2 SQL certificates and have watched most of the popular SQL videos on YT but still am not that confident. It's weird because w/ anything else I learn and spend so much time w/ I would be more confident in.
@@brittanyyoung3928 hey girl , presently at this phase now . just want to know how you feel now and if you were able to gain confidence .
I'm doing it in April 2024. The new_cases and new_deaths columns are reported every week, not daily anymore. You can just add new_cases 0 in the where statement and it will show you the weekly cases.
I just want to make sure that you know the value of the work that you have been doing.
This is so far my favorite portfolio project vídeo on RUclips. I enjoyed every moment of it. Especially the errors/mistakes!
I’m learning analytics and I face those errors I feel so frustrated and wondering if one day I will be really good at it. But watching your video I could see that the mistakes and experiments are part of the process!!!
Thank you very much!!!
So glad to hear it Tayuan!
Can't thank you enough for this content!!
Small note at 48:38 - I believe SUM(new_cases) and SUM(new_deaths) will be the same as new_cases/new_deaths (won't reflect the true totals) because you are grouping by date. I think it may be more accurate to use MAX(total_cases) and MAX(total_deaths) given that the values are compounded each day and will never decrease. Would love to hear your thoughts/feedback. Really loving this channel - keep up the great work.
Thank you for this! I had the same syntax as the video but new cases and new deaths were not being summed up and I was so confused.
You're right. I was having issues with this.
Thank you Alex. I was really lost for the past 6 months, not knowing where to start! you really helped me a lot as a beginner, looking forward to more portfolio projects!:)
So glad to hear that Sarah!
Alex, THANK YOU!!! I can't express my gratitude enough for everything you've done for us. I just made it through your SQL series (Beginner, Intermediate, & Advanced). Hooray! You make the process so simple and straightforward, which makes it SO easy to follow along. The project component is the BEST part. You're breaking down what we've learned and showing how we can actually use it. This is a HUGE missing link in today's education system. My Biomedical Engineering PhD program funding feel through (absolutely heartbreaking). I made it 2/3 of the way through and wrote 90 pages of a thesis that I was unable to use. While I was able to get a Master's degree, it was not in the subject/career I had wanted. My world was thrown upside down. I had no idea what I was going to do. Then, data analysis and YOU showed up in my life. You (and your "Become a Data Analyst" bootcamp) have served as a beacon of light and hope for my future. Bless you! And THANK YOU again!
Alex, your videos are amazing and you have really helped me get to a place in sql where i feel like i can jump off and just continue to increase my skills and value. I will continue to return to your content regularly and support how i can.
Happy to hear that!
Hi Alex! Thank you very much for this video, I have been watching these videos thanks to the bootcamp playlist and I have learned a lot.
For those who have problems uploading the files to SQL Server, what I did was transform the files to CSV and import them as Flat File, in the same way that Alex mentions it as the first option, at some point it will ask for the destination and I selected the one for “Microsoft OLE DB Provider for SQL Server”, or something like that.
I know very little about this software, so I don't know exactly what I did, but it worked. I hope it works for you too.
Greetings from Mexico!
Thanks man, you are a lifesaver
thank you so much! life saver!
While importing as excel(all formats) most of my data went NULL. but CSV plus Flatfile import worked. Can't thank you enough.
Thank you so much, your answer definetely helped me!!
YOU ARE A LIFESAVER
finally finished and submitted to my github account. So proud of myself! Thank you Alex!!
Congratulations on finnishing the project! Did you had any troubles with data types? Im having a lot of problems 🥲
@@VitorAbreu1001 i also having error like this "Operand data type nvarchar is invalid for divide operator." i tried to change the data type to float..but not working
@@amtzgaming3688 The code will look a bit different from Alex because I went for the updated dataset instead but the error you are saying I managed to fix with the code I have on the GitHub!
@@amtzgaming3688
Select location, date, total_cases,total_deaths,
(CONVERT(float, total_deaths) / NULLIF(CONVERT(float, total_cases), 0)) * 100 AS Deathpercentage
from PortfolioProject..covidDeaths
order by 1,2
Thank you for doing this tutorial I've learn SQl from Udemy and Datacamp. But I really have no idea how to practice SQL until I found your channel! Such a gem.
Great Project - Thanks Alex!
Had some trouble importing in the data, but figured out a fix. I did it as a Flat File (CSV) and for some reason, the data types which were recommended were completely wrong (e.g. Varchar was given for some, instead of Float). So I had to manually change a few of the data types myself. Tedious, but was the only solution here :)
@ezhankhan1035 - How did you change the data types? It is blocking me from changing them when I am uploading the CSV file in SQL Server Import & Export Wizard
@@conorkelly9642 I think I used a separate import wizard, just for flat files (CSV files).
I right-clicked the database (which I wanted to create the table in) - went to tasks - import flat file. This way then allowed me to change any data types and
all that good stuff. Hope it helps!
Thank you for this comment! It helped me get my data uploaded.
It took forever, but i finally figured out how to import the covid files. Save files in excel as CSV, right click your portfolio database, click task, import data. The the import wizard pops up, on the top where is says data source choose at Flat File Source, then browse for you file (make sure you select all files on the bottom right, so your CSV files can be seen), then click next, click next again, under destination choose Microsoft OLE DB Provider for SQL Server, confirm the server name is correct, click next, click your file name if it's not already, then next, run immediately should already be checked, click next then finish. When the execution is successul, hit close.
Hey, thanks for this. Followed your steps one-by-one, however some error messages popped up when I was performing the running and finishing up step.
Stopped: prepare for execute
Stopped: Pre-execute
Error: Executing
Stopped: Copying to [dbo].[Covid-Deaths]
Stopped: Post-executed
@@favourbarididum2623 sorry, i wish i did!
worked for me :)
@Emma thanks for this
You need to converts a values to a float datatype
Select location, date, total_cases, total_deaths, (cast(total_deaths as float)/cast(total_cases as float))*100 as DeathPercentage
From PortfolioProject..covidDeaths
Order by 1,2
Its been so long since i program that i forgot that float is to carry anything after a 0.000. thank you
did you notice that the excel data loaded doesnt contain the full rows but shows only 2600 rows?
Took me over a week to translate MSSMS's syntax into bigquery in order to do this project but I'm smarter now because of it and also feel like an SQL god 😤 thanks sm for this tutorial Alex appreciate it a million
Im trying to do that now. Do you have any tips?
i just downloaded the data today but i am finding it confusing cos the some columns are empty
@@NaturalNae can you send the dataset you downloaded to my email
Those who are having trouble while trying to cast the matrices as integer value(apparently the numbers have grown lately ), Arithmetic overflow error is likely to occur. Try BIGINT instead of INT
This comment should be pinned.
Thank you!
Really Thank you...
I converted to bigint but now it's showing multiple instances of the same dates and that's giving me the wrong sums
When I see that smiling face in the thumbnail I know it’s gonna be a great video!
😂😁
On my way through the boot camp. WHohoo! Portfolio Project!
-- Operand data type nvarchar is invalid for divide operator.
I'm getting this error on this
SELECT Location, date, total_cases, total_deaths, (total_deaths/total_cases) *100 as DeathPercentage
FROM CovidDeaths_updated
I checked chatgpt and I was directed to change the columns to INT by doing this:
ALTER TABLE CovidDeaths
ALTER COLUMN total_deaths INT;
After doing so, my data seems inaccurate. Did I miss anything?
By the way, I also ch went back and updated the data types in Excel and tried importing it again. But I am still getting the same error.
TIA.
Doing this in 2023, the data columns of total_cases and total_deaths are assigned as nvchar which leads to issues in doing the death proportion operation, you need to cast the columns as decimal for the operation to work: I used (CAST(total_deaths AS decimal(12,2)) / CAST(total_cases AS decimal(12,2)))*100 also choose the decimal function first entry based on the numbers you get as if it is given too low it will result in nvchar to decimal overflow error.
I just completed this project and I would say this is really fantastic. I appreciate the effort you put in putting this video together. Thanks for your help Alex🙌
Hi
I also want to complete this project.
But I am enable to export this large dataset from Excel to Microsoft SQL.
As the data has grown since the video was released.
Were you able to get all rows in SQL ,which were lakhs in number approximately
Hey please help me making this project I am getting problem in importing data.... which version u used developer or express please tell...
@@shilpashah-qf8qbI'm also having problem importing the data from Excel to SQL server, I keep getting Microsoft.Ace.Oledb.12
please can you help me with the data set?
I'd be very grateful
Spent a whole weekend on this but man did I learn a lot. Ready to get into part two visualizations next weekend. Thanks your guidance.
Glad to hear it! Hope it helps :)
Thank you so much for these videos, Alex. You're really helping me prepare for my transition to a data analytics position.
I know you said you felt like you were rambling as the video progress, but please don't think so! It really helps understand the thought process behind each query. Thank you so much Alex for these videos! :)
I am doing this in 2024, if you notice this error(divide by zero error encontered at 48:42, insect function
__________Nullif(sum(new_deaths), 0)/nullif(sum(new_cases), 0)*100 as deathpersntage________
Hope this helps
I have the same issue. I had to CAST both sums due to data format. In my case it looks:
Nullif(sum(cast(new_deaths as int), 0)/nullif(sum(cast(new_cases as int), 0)*100
I get an error -- The sum function requires 1 argument(s).
What a coincidence!! I’m currently doing the Google Data Analytics Certificate Program. Already completed 6/8 courses in 3 weeks. Now in Course 7 learning about R. Found this dataset last week and plan to use it for my personal project. Very excited to see you work on this exact same dataset ;-)
You finished 6/8 courses in 3 weeks, wow, how is great ^^
@@gianglearning3509 cos of lockdown 😁
Wow! You are fast! I’m still at 2/8
@@anoukc6928 And I am still at 1/8 in one week 😀😀
@@RiteshRaj-nn7ig how do you like the course so far?
to whoever is still having issues with importing
Option 1: ruclips.net/video/JVP9frj2VSQ/видео.html
Options 2: ruclips.net/video/brGq2by7DvA/видео.html
Options 2 worked for me. Feel free to add more options as they arrive
Thank you! That was really helpful.
The second solution was the fastest and most straightforward, learned a new trick with the /quiet at the same time!
I tried both but not working, in the second solution cmd prompt showing error while executing the installation.
Hello Alex, I'm doing this in Nov 2023. I've identified the root cause for our inaccurate total deaths breakdown by continent at 37:00 The issue lies in the cumulative total deaths column, which isn't accurate. Instead of relying on the 'Max' aggregate function, I now use the 'SUM' function for the new deaths column instead of the total deaths column that you used in the video, providing a more accurate total. This has been beyond helpful! Thank you so much for putting the time and effort into this! You're too kind
yeah sure. What problem do you have there?@ChristabelAdesua
Hello, if you can please also help me. I have typed in exactly what he typed on 39:28 and I’m getting invalid project name error
Can't thank you much for taking this initiative and helping beginners like me to apply the SQL skills to real-world data. Waiting for the second one.
You are awesome buddy.
So glad to hear that! Thanks for watching! :D
11-Aug-2023
Having problems with importing the data or csv files. Then, You should save your Excel file to a lower version is can be a 2003 version of excel. Once save the file you can now do the Data Transfer of SQL.
THEN Hit NEXT.
Instead of using SQL Server Native Client 11.0, It is now Microsoft OLE DB Provider for SQL Server. This took me a while to figure out and import.
Hope this helps!
@user-lj7vk4wj8n
Thanks dude
@@oussamaassou1529 حبيبي يفندم
Great video and channel Alex. When creating the view around the 70 minute mark, I had to add "USE PortfolioProject GO" before the "CREATE VIEW" to get the view to show in the object explorer. Hope it helps someone. So thankful for the channel!!!
Thank you!
thanks! couldn't understand what am I doing wrong, adding USE .. GO saved me
Had a problem calculating TotalDeathPercent and took me 2 hours to figure out the solution. I looked through the comments and performed below steps ,
1) uninstalled my Microsoft SQL server 2023 and installed Microsoft SQL server 2019.
2) Imported Excel file rather than Flat text through Import Export Wizard as shown by Alex.
3) Converted the ncharvar Total deaths and total cases to Float using Command ALTER TABLE CovidDeaths ALTER COLUMN total_Cases FLOAT.
Worked like a Charm. Hope it helps :)
wow great, thank you very much
Seems like you don't even have to re-install different versions of server. I just changed the data type of total_deaths and total_cases to FLOAT
I was just about to find some courses to continue SQL and Python study. Now I can follow this project! Thank you so much!!!
Forget the courses, projects gives you real useful knowledge!
Alex, you're awesome. Thank you very much for taking out time to make these videos. These are priceless. I was struggling to create a project. Thanks a lot again.
Invaluable content for aspiring data analysts! This is such a great channel. Thanks Alex!
HI ALEX, I am from Philippines ,I appreciate you and your heart to helping us, you are my stepping stone in this career, Thank you again and God bless you!
any update bro? im also from the philippines
"This guy's smart, I should hire him..."
:D
@@AlexTheAnalyst Hey Alex, I didn't realize how expensive Excel is: Should I buy excel or make due with Google Sheets?
@@CE-vd2px if you’re a student, you can get office 365 free on Mac with your student email ID
@@CE-vd2px download wps office.Which is free and has most features of excel and cross platform compactible.