SQL & PowerBI Portfolio Project for Data Analysts

[@casafurix]

For the termdate column error, run the following 4 queries and it'll work: UPDATE hr SET termdate = IF(termdate IS NOT NULL AND termdate != '', date(str_to_date(termdate, '%Y-%m-%d %H:%i:%s UTC')), '0000-00-00') WHERE true; SELECT termdate from hr; SET sql_mode = 'ALLOW_INVALID_DATES'; ALTER TABLE hr MODIFY COLUMN termdate DATE;

[@vinodkumarhugar6418]

It worked , Thanks 🤝

[@herdataproject]

Nice, thanks!

[@somranjan5810]

I stucked at this error and just found your precious comment, Thank you

[@vigneshnaruto9777]

thanks man

[@Zovic_Kiddies]

Can this work in Microsoft SQL server management studio pls?

[@mayanktiwari5069]

This one is my first power bi report and this report will remain special forever in my life.

[@simonoganga5956]

Irene, amazing work, quite impressive, thank you for supporting the community with your knowledge

[@herdataproject]

Thanks Simon. More projects coming soon

[@simonoganga9535]

@@herdataproject Wonderful news, I can't wait to follow them, I am currently doing an SQL course, as soon as I am done, I want to replicate this project to improve my skills.

[@HaydenTheAnalyst]

You made it already!! Thank you so much!!! Extremely helpful!!! Keep up the videos plz your projects are unbelievably helpful for me right now as I’m work my on building a strong portfolio, I am sure you are helping many others also!

[@herdataproject]

You're welcome. More videos coming soon. Thanks for watching!

[@rumonseoexparts9697]

Thanks, Irene I was able to go through the tutorial and actually practice on it and I can say it is absolutely helpful to me as a beginner in the data industry. Thumbs up and keep up inspiring!! love from Bangladesh

[@Lost_John]

I want to say thank you for this video! It made it using Microsoft SQL server much more understandable because I understand that it is more advanced but using my SQL workbench requires a more hands-on approach to learning the basics. You showed how to manually change things in the best way possible! Also, I will support any future videos !! Keep up the good work!

[@herdataproject]

You're most welcome! I really appreciate the feedback and support

[@ijeomajoseph1615]

​@@herdataproject Thank you for much for always ..However I got stuck trying to answer the first question ...It keeps returning an error message 'Incorrect DATE value:'0000-00-00'.. Here is my line of code ; Select gender, count(*) AS gender_count FROM hr WHERE age >= 18 AND termdate = '0000-00-00' GROUP BY gender; ..Please where am I getting it wrong ?

[@herdataproject]

You're welcome and thank you😊 What are the values of your term_date column?

[@ijeomajoseph1615]

@@herdataproject They are in this format Ma, 0000-00-00, 2014-02-24 etc....

[@dlucas527]

I love your explanations. Very clear and concise.

[@herdataproject]

The dataset can be downloaded from Telegram or GitHub. On Telegram check the pinned message Telegram - t.me/+7ms4DzzAYVlhYmZk GitHub - github.com/Irene-arch/HR-Dashboard-MySQL-PowerBI Please leave any questions or requests in the comments

[@akhileshkumarpatel3772]

Bhai data file nahi download ho raha hai

[@jkschola1]

Kudos, Great video! I thoroughly enjoyed it and found the SQL Data Analysis walkthrough to be quite accessible, especially on date formatting and conversion 👏🏽. However, for enhanced practicality, consider leveraging Power BI's DAX to calculate most measures after establishing a data model. This approach enhances interactivity and reusability in any project. Looking forward to more content like this! 👏🏽👋🏽💯

[@herdataproject]

Thanks for the insights. I'm glad you found the video helpful. I'll be sure to show how to use DAX in the next PowerBI project. Stay tuned and thanks for watching!!

[@anymjohnson1729]

@@herdataproject; When you begin the Video, what Application or program is that?? Is it Power BI, or SQL.

[@herdataproject]

@anymjohnson1729 it's MySQL Workbench

[@SahilSahil-vo1yw]

It's awesome!! I've watched n number of KZbin videos but i found this video is very useful especially at data cleaning and data analysis part as its crystal clear in terms of better understanding... Thanks so much ❤👍🤝.

[@ruchamasurkar9255]

Thank you so much for this project🙏It was very clear and easy to follow😊Plz keep making these type of videos👍

[@herdataproject]

You're most welcome. There's more to come! Thanks for watching

[@mm1234bb]

I’m so glad I found your channel! I really like learning through projects, will you be adding on more videos? Thanks so much!

[@herdataproject]

You're welcome. Yes there'll be more videos soon. Stay tuned!

[@gozieprince9530]

Thank you so much for this wonderful tutorial, you are so calm in teaching and it makes it very understanding. Please can you do more videos on SQL+Power Bi. I just started my learning journey as a Data Analyst. Please can you Mentor me

[@itnasss]

Thank you!!! This helped me soooo much with my own portfolio project. You're doing great!

[@itnasss]

PS - I was having issues with obtaining the data set, when I open the file that you've suggested excel doesn't read it as a table and there is an error report. I was able to find the same data set on kaggle (the data set did not include the negative age for one of the employees as shown in your video) and I was able to follow along thereafter.

[@herdataproject]

You're most welcome. I'm glad you found the video helpful. Sorry for the hustle in getting the dataset. It's on Github and Telegram. So once you join Telegram, check the pinned messages and you'll be able to get the dataset

[@EdemKlogo-e7t]

Thank you for this video, truly. I learned so much from this video.

[@herdataproject]

You’re most welcome! I’m so happy to hear that

[@sanketkalugade1076]

To update age = '2060-01-01' AND birthdate < '2070-01-01'; The reason age is showing in negative is instead of 1960 it is mentioned as 2060 , so you can use DATE_SUB to subtract 100 years. Hope this helps thanks !

[@yennhingo4936]

Thank you!

[@jayakrishnanvn]

thanks mate ... very helpful...

[@gnardi6928]

My youngest age is 22 , would this be because of insufficient data from import ?

[@herdataproject]

@gnardi6928 i think its due to the time youre doing the project unless you got an error during import. Since we’re using current date it is different from the one I used when recording the video

[@sowjanyakake5720]

Thanks for covering various scenarios using sql.. quite helpful

[@herdataproject]

You're welcome. I hope you find the most recent project helpful as well

[@alowismusodza]

I just bumped into this amazing and well explained tutorial. Thanks so so much...

[@herdataproject]

You're welcome!! Thanks for watching

[@haohoangkim3247]

Thanks from Viet Nam. More other videos please. Hope to see them soon.

[@herdataproject]

You're welcome. More to come!

[@AyoRO88]

Amazing video! Wow. Wish I wouldve found it sooner. Wouldve saved me so much trouble

[@herdataproject]

Thank you so much!!

[@charugera7654]

Excellent tutorial. Many thanks. Can you please make similar projects using intermediate and advanced SQL concepts?

[@herdataproject]

You're welcome. I will definitely do that

[@sasitpiasai8152]

thank you so much. I can adapt this project to make my project and learn to familiarize with data cleaning and analysis process.

[@herdataproject]

You're welcome. Yes you can and keep practicing to master all the concepts

[@meraki2090]

Thank you for this video. It was really easy to follow and understand for me. And when I got stuck with a sql queries related with termdate, I could find solution in the comment as well..

[@herdataproject]

You're most welcome. I'm glad you found it helpful

[@gabesegun7966]

This is what exactly I have been looking for. We'll made. Thanks ++. As I am just learning sql any suggestions on a good book to learn instead of only videos.

[@gebidehun]

Thank you for sharing

[@MaabHussein-f7e]

I cannot thank you enough for this informative video

[@khairunnisanada9124]

very helpful, thankyou!!! will wait for your next update👍

[@herdataproject]

Thank you, more coming soon!!

[@francisonyango3868]

Clear explanations....thank you so much

[@herdataproject]

You're most welcome!!

[@onosemuodeikuesiri7620]

Q6. How does the gender distribution vary across departments and JOB TITLES? 43:18 I think you ignored the "job title' part of this question. This was what I did. SELECT * FROM hr; SELECT department, jobtitle, gender, count(*) count FROM hr WHERE age >= 18 AND termdate = '0000-00-00' GROUP BY department, jobtitle, gender ORDER BY department;

[@herdataproject]

Heeeey, yes I did. I think it was coz of how varied they were so decided to just go with departments to have a general overview. Thanks for sharing your solution and keep up the amazing work!!

[@Ganeshay-09]

Superb understanding easy way

[@Hasindu_Randika]

Thank you for your great tutorial. Keep it up!

[@ashok_rawat_]

You are doing it great, keep going,,

[@herdataproject]

Thank you!!

[@skillrovertechnologies]

You did a very good job. Keep it up.

[@herdataproject]

Thanks Daniel. I'm glad you found it helpful

[@mohineshsharma335]

Thank you for such an amazing video full of information and knowledge 😊👍

[@herdataproject]

You're most welcome! More to come

[@mohineshsharma335]

@@herdataproject waiting for next

[@yogeshmeshram1120]

Amazing work. Plz make Python data Analysis Project Video.

[@herdataproject]

Thank you. Coming soon!

[@giftcardseverywhere]

wow great stuff so much value

[@herdataproject]

Thank you!

[@AmalKrishnan-u2q]

Great Video. i'm confused why termdate

[@herdataproject]

The assumption is that termdate is the date the employment ended. So it wouldn't make sense to have it as a future date. That's why I made sure to use the termdate as less than more equal to the current date. Hope this helps!

[@ZaremaDibirova]

Thank you🌻

[@MuftiHammadAhmedSpeeches]

I have seen half of this video while even I couldn't know you are Male or Female. But video is osm fantastic ❤❤🎉🎉

[@carolinaninobeltran6716]

Thank you very much, i found this tutorial very usefull

[@herdataproject]

You're welcome!!

[@jamesthomas3959]

Please can I see all the data types for your columns when trying to upload the data into table.

[@arindamsinha5857]

Need more industry level power bi projects end to end please.. I will pay also if required

[@herdataproject]

Coming soon!!

[@ntran04299]

good suggestion. I would love to see near world data projects with various messy data sources. Would support with donation too!

[@peace_321]

19:12 While using the query that you have used, the blank cells are not getting updated with '0000-00-00' .. What shall I do... Please reply..

[@herdataproject]

Hello, it's okay if they remain blank. Mine are updating to '0000-00-00' because strict mode in my version of SQL has been disabled. Yours is not that's why they're not updating. The only thing you'll change in your queries while answering the questions is just writing 'termdate IS NULL' instead of 'termdate = '0000-00-00' But if you'd also like to disable strict mode on your version of SQL you can run this query SET SQL_MODE = ' '; Then run your queries. Let me know if it works!

[@peace_321]

@@herdataproject thank you soooo much mam for relying I will try it .. Thank you for being sooo kind 🙏🏻🙏🏻🙏🏻🙏🏻🙏🏻.. thank you for giving your valuable time. 🙏🏻🙏🏻🙏🏻

[@peace_321]

@@herdataproject how you are soo expert in sql queries,, please please give some suggestions to me,, how can I be good SQL queries..

[@herdataproject]

You're welcome. I'm not yet an expert but to be good you need to learn and always practise what you've learnt so that you don't forget. That way you build knowledge on a lot of concepts.

[@peace_321]

@@herdataproject thank you mam 🙏🏻🙏🏻

[@BeSweet-c4p]

Heloo Mam, why we need to analyse these data in sql instead of excel? we didn't connect that sql analysis in power bi then why we need to find that analyse in sql just simply use one tool like power bi and easy find that analyse in power bi .what the use in that analyse in sql? I don't know why please leave the answer mam🙏

[@herdataproject]

It's just a preference. There are people who had requested to be shown how to clean and analyse data using SQL. You can use Excel or PowerBI from start to finish if that's what you prefer.

[@BeSweet-c4p]

@@herdataproject Thank You very much mam👍Thanks for your reply mam✨

[@terenceochuo701]

Hello first and foremost thank you Irene for showing this project,as i was going through it using sql server microsoft i am stuck on changing the termdate data type anyone using ssms how did you go about it,i will appreciate for any help

[@lukev730]

Amazing work Thank you

[@herdataproject]

Thank you and you're most welcome!!

[@saisrikanth9313]

Hi, thank you for helping me learn with this video, but I had a doubt, some of the answers I get are slightly different from yours for example I got slightly different values when I calculated the different age groups, could you please tell me why is that?

[@saisrikanth9313]

I meant for Question 3 in analysis part

[@μελέτη1]

27:19 , I am getting count as zero n all results as zero

[@peace_321]

13:31 It shows Error code : 1292. Truncated incorrect date vale : '06-04-1991' What shall I do

[@peace_321]

@@herdataproject thank you for responding.. Actually i was Using small y instead of Y I saw your coment then i understood..

[@herdataproject]

You're welcome!

[@whiteana9713]

Please, how did u get the Total count, Terminated count cause, hires, and termination cause it tells me the column doesn't exist

[@herdataproject]

Those are derived columns from the inner query which will be run first

[@VM-hw3qh]

Great Work🙌

[@Rahuljadhav-nm2sc]

thank you so much 👌👌

[@ChipoMoyo-v8d]

This is great, just a question, is the dataset you provided via GitHub the exact same as the one you used in the video? I noticed the values I'm getting in my analysis as I follow along are slightly different from yours, I'm worried i might be making mistakes in my queries.. I'm using SQL server by the way, the differences are minor but they do affect the results of the analysis for example for you, the lowest turnover rate was the marketing department and mine was the business development department.

[@pimjaaadirektrakarn7898]

I’ve got the same problem as you😅

[@avazbektolibjonov4035]

great course

[@MuftiHammadAhmedSpeeches]

Bro please tell me update command not working in my SQL workbench since last 24 hours😭😭😭 I tried again and again Pls tell me where is fault, chatGPT speaks I apologise too

[@AustinIC]

Big thanks to you!!!

[@tigerbojiteol]

Thank you for the video. So you prefer skipping the data modeling and DAX at all?

[@herdataproject]

Hello, I skipped the data modelling section because the data was already cleaned in SQL and didn't require advanced transformations like creating measures or calculated columns. But you could do the modelling if you're looking to make you report interactive

[@thirdyako]

Thanks! It's been helpful. :)

[@herdataproject]

You're welcome! Thanks for watching: )

[@ezhil7942]

Thanks it working

[@yasminibrahim9708]

hi, thanks so much for this great video , i downloaded the dataset but it's cleaned how i can get the uncleaned one please

[@herdataproject]

You're most welcome. You can download it from the Telegram group. I've pinned the original dataset

[@chalanatyjostna2229]

when we are considering the term date 00000 to select the employees, what about the employees whose term date is in future?that means they are still in the company and we are not considering them

[@herdataproject]

We can't verify that for sure so we assumed it was a data entry error and documented the same as limitation in our analysis.

[@chalanatyjostna2229]

@@herdataproject thank you so much for the ans.

[@kausarali9852]

very informative thanks

[@herdataproject]

You're welcome!!

[@FarhadKhan-xe4ft]

can anyone explain the aim of this project mean why we make dishbord and i cant understand dishbord mean wht is the problem behind this that we make this typle dishbord

[@herdataproject]

This is an informational dashboard. It helps management understand the status of their employees at any point in time

[@Mahesh717]

why did you past all the queries in diff excel files & then imported in power bi, instead of you can directly connect to power bi using import mode....

[@herdataproject]

I'm sure that works too, I think it's a matter of preference

[@AdityaSingh-mj2kh]

i am not able import file into postgre sql it showing hiredate is out of range

[@kapilak9530]

Hi 1292 truncated date error value…how to fix that sir ..while doing the query changing string to date format

[@michellerosecruz4709]

Hi, is this the correct way of utilizing databases for Power BI Visualizations? I mean we need to export the details as csv file then import it to Power BI? Or can we directly connect to database to get the data? Thanks

[@herdataproject]

Hi, it's not the only way. You can also connect directly to your SQL database. Check Microsoft Learn website for more details.

[@sia_ibk]

When I export to PDF, the page gets zoomed in and the export cuts out a part of the right and bottom of the viz. How do I aviod this please?

[@herdataproject]

Hi, you can try checking your zoom before exporting and also the orientation. It should be landscape instead of portrait

[@aishwaryapattnaik3082]

Hello 👋 ! I was trying this in Power Query Editor for the data cleaning part for hire_date col. How can the null values be dealt with in this way, can you please help😅

[@herdataproject]

Hello, try this. Hard to explain via text but hope it works Select the table or range that contains the column with null values. Go to the "Data" tab. Click on "From Table/Range" to open the Power Query Editor. In the Power Query Editor, find and select the column with null values in the "Query Settings" pane on the right. Go to the "Transform" tab in the Power Query Editor ribbon. Click on "Replace Values" from the "Any Column" group. In the "Replace Values" dialog box, enter "null" (without quotes) in the "Value to Find" box. Leave the "Replace With" box empty to remove null values from the column. Click "OK" to apply the changes. Once you've made all necessary transformations, click "Close & Apply"

[@सुयशपाटील-ठ2ठ]

Mamm the 10th question it shows me error To Termination invalid filed from HR

[@herdataproject]

Kindly share the whole error as is

[@RameshD-m5j]

thank you so much for ur work.

[@herdataproject]

You're most welcome!

[@abhishekkumar-qi3is]

please make vedio on orderback prediction and inventary management.

[@herdataproject]

Noted!! I have added it to my list of projects

[@milank465]

Why do I get different values with the exact same code?

[@herdataproject]

Depends on the column you're referring to. For dates etc, you're running the code on a different date than I did. If that's not the case then please share a screenshot in the Telegram group to allow me to assist you further

[@lakitajoseph3478]

Hi there im slightly stuck with question 10, it comes up with error code unknown column 'termination' in field list, does anyone know why?

[@herdataproject]

Hi Lakita, I think the issue is the name of the column. Make sure it's the exact name of the column as is in the database

[@lakitajoseph3478]

Thank you! May I ask, what did you save your data cleaning file as from MySql? Or did you save it from somewhere else?@@herdataproject

[@TeliahTalksData]

Can I use Ms SQL?

[@herdataproject]

Yes you can

[@MuftiHammadAhmedSpeeches]

While I'm writing same to same QUERY like you ❤❤😢😢

[@herdataproject]

Hi, which exact command isn't working?

[@MuftiHammadAhmedSpeeches]

@@herdataproject Update command on birthday column, he reflects error like truncated incorrect date value 😭😭 I tired since 3 days not proceeding further 🙏

[@adityabonde7310]

At @28.34 im getting this error select gender,count(*) as count from hr where age >= 18 and termdate = '0000-00-00' group by gender LIMIT 0, 5000 Error Code: 1525. Incorrect DATE value: '0000-00-00' 0.00037 sec

[@herdataproject]

Are your date values blank or in that format?

[@adityabonde7310]

@@herdataproject no its not blank . i did the same as you did.

[@herdataproject]

@adityabonde7310 please share a screenshot on telegram. Link is in the description

[@madcity2073]

thanks for the video, very well explained, just one question if the original CSV file that you initially imported to SQL suffers any change lets say gets more rows added whitin the already existing categories would that get reflected on the MySQL values as well?

[@herdataproject]

I'm not entirely sure what you mean. Are the rows added during the import?

[@ELLIOT8209]

Search for duplicates

[@saidhikshi1105]

17:19:17 UPDATE hr SET birthdate=CASE WHEN birthdate LIKE'%/%'THEN date_format(str_to_date(birthdate,'%m/%d/%Y'),'%Y-%m-%d') WHEN birthdate LIKE'%-%'THEN date_format(str_to_date(birthdate,'%m-%d-%Y'),'%Y-%m-%d') ELSE NULL END Error Code: 1411. Incorrect datetime value: '2012-01-01' for function str_to_date 0.012 sec Could you help me with this?

[@herdataproject]

Hello use UPDATE IGNORE hr

[@nileshraut9]

Remove or comment ELSE from query and then try hope this will work

[@myvideos-uu6mj]

Thank you but where do i get this sample data from in order to do the same on my own ?

[@herdataproject]

Hello check the description for the Telegram link and once you join, check the pinned messages

[@augustineemmanuel6897]

SELECT birthdate FROM hr; SET sql_safe_updates = 0; UPDATE hr SET birthdate = CASE WHEN birthdate LIKE '%/%' THEN date_format(Str_to_date(birthdate,'%m/%d/%y'),'%Y-%m-%d') WHEN birthdate LIKE '%-%' THEN date_format(Str_to_date(birthdate,'%m-%d-%y'),'%Y-%m-%d') ELSE NULL END; 03:00:08 UPDATE hr SET birthdate = CASE WHEN birthdate LIKE '%/%' THEN date_format(Str_to_date(birthdate,'%m/%d/%y'),'%Y-%m-%d') WHEN birthdate LIKE '%-%' THEN date_format(Str_to_date(birthdate,'%m-%d-%y'),'%Y-%m-%d') ELSE NULL END Error Code: 1292. Truncated incorrect date value: '06/04/1991' 0.000 sec please could you help me with this

[@herdataproject]

First import the dataset again because the values have already become NULL and then run SET SQL_MODE = ' '; then run the update query. Hopefully it works

[@maskman6372]

​@@herdataproject birthdate becomes null

[@esthernwaogu592]

Yes null

[@chyonu]

@@esthernwaogu592 pls have you been able to solve this issue?

[@NgoJayE]

HEllo, for the termdate column, I don't have the 0000-00-00 when the line is empty, I have nothing so I have an error when I want to convert the type text to a date.

[@herdataproject]

There's another alternative you can use to convert the values from text to date UPDATE hr SET termdate = IF(termdate = '', NULL, str_to_date(termdate, "%Y-%m-%d %H:%i:%s UTC")) WHERE termdate IS NOT NULL; And in place of termdate = '0000-00-00 ' use IS NULL. Let me know if it works for you

[@chalanatyjostna2229]

Hi, How can I apply filter on this csv files imported through sql query? i am unable to do.

[@jameskalenga7546]

thanks for sharing

[@herdataproject]

Thanks for watching!

[@AbigailNjambi]

I tried converting the birthdate format but it's not working for me can anyone help

[@fransiscusnauli5469]

thank you for the video you created, it's an awesome project and the way you explain it makes the code syntax easier to understand. anyway, may i add this project to my resume?

[@herdataproject]

Thank you, and thanks for watching. Yes you can for now but I'd advise finding your own dataset and working on it so that you can make sure you have mastered the concepts as well as the entire process. And also in case a recruiter came across this video they don't assume you just did copy and paste.

[@fransiscusnauli5469]

@@herdataproject thank you again madam. I'll write your name on the description and perhaps the link to the video. After completing this project, i will start to build my own one.

[@herdataproject]

I'm glad to hear that. Good luck and if you encounter any issues you can always reach out on the Telegram Community. Plenty of people willing to help

[@PinessCodes]

Thank you Ma@@herdataproject

[@fransiscusnauli5469]

@@herdataproject thank you again mam and good luck for your next project as well, im joining right now.

[@chiragvaljee4306]

Hi there, I am getting an error on question 5. This is my code: SELECT AVG(DATEDIFF(termdate, hire_date))/365 AS average_length_of_employment FROM hr WHERE termdate =18; This is the error I am receiving: Error Code: 1525. Incorrect DATE value: '0000-00-00'. Any assistance would be appreciated. Thanx

[@sembhaiamman9237]

You should run the set sql_mode query first to sort this error

[@902mayanksingh2]

why it is showing Error code : 1193. unknown system variable 'Age' , even after successful implementation of Age column ?

[@herdataproject]

I'm not sure what the issue could be. You could post the screenshot of the query and the error on Telegram and then we could try to figure it out

[@AustinIC]

Please I tried to download the dataset from the link on the description box, but link can't be reach. Can you help please?

[@herdataproject]

Hi the link works. You can try it again here t.me/+7ms4DzzAYVlhYmZk If it doesn't work, try downloading from Github github.com/Irene-arch/HR-Dashboard-MySQL-PowerBI

[@AustinIC]

🙏 Am grateful, thanks I will explore the options

[@ronipriyosejati5792]

ty a greate tutorial for me

[@Lordarknesss]

Keep going. Nice!

[@herdataproject]

Thank you!!

[@gokilaharish6305]

I couldnt update termdate using PLSQL developer. STR_TO_DATE is not working. I tried using TO_CHAR(TERMDATE,'DD/MM/YYYY') , trunc(TERMDATE).. nothing works out. Datatype is Varchar 26. Plz help.

[@gokilaharish6305]

I fixed it.. following syntax works out.. UPDATE tablename SET TERMDATE=cast(to_timestamp_tz(TERMDATE, 'yyyy-mm-dd hh24:mi:ss "UTC"') as date) WHERE TERMDATE IS NOT NULL;

[@herdataproject]

Thank you so much for this. It will be very helpful for many other people using Oracle.

[@afolayandamola6378]

for the birthdate update, i keep getting truncated incorrect date value '6/29/1984', how do i correct that error

[@ChinweAirdrop]

Change y to capital Y

[@chyonu]

@@ChinweAirdrop the birthdate column becomes null Pls what's the solution?

[@pruthviraj8474]

@@ChinweAirdrop Thank you so much

[@adhytiamps622]

i get trouble with this query, the output is error : SELECT GENDER, count(*) AS COUNT FROM HR WHERE AGE >= 18 AND TERMDATE = IS NOT NULL group by GENDER; because some part in termdate table is null? how can fix it?

[@herdataproject]

Remove the = from TERMDATE = IS NULL. It should work

[@samratkundu2799]

Hi, it was a great video. I'm working on a HR Analytics Portfolio Project. The way You imported data in Power BI, can you please tell me how make this Dashboard Interactive ?

[@herdataproject]

Hi,you can add slicers to the report to be able to filter by your fields of interest. That will make the dashboard interactive

[@oluwasegunraimi3453]

Some functions like describe, str_to_date isnt working on my system

[@herdataproject]

Which SQL dialect are you using?

[@oluwasegunraimi3453]

MySQL

[@inglestopia]

I think you made a mistake in minute 33:17, it should be THEN '45-54' and not 44-54 and you didn't correct it, but I think everything else is fine, thanks for the video.

[@herdataproject]

Thanks for the feedback. I'm glad you found the video helpful

[@eltoski01]

Please i have a question... When i query for "what is the gender breakdown of employee in the company" and SQL returns the result table.....is there a way to save the result so that when I connect powerBI to the SQL database I will have access to the result table from the query rather than exporting each result as a CSV because imagine you are working with a large company and the result table from your query is 3million rows I don't think I will be able to export that into excel easily? Do you get me?

[@herdataproject]

Yes I get you. I think what you're looking for is something like a database view. Create a database view with the SQL query logic. Power BI can then directly connect to this view and retrieve data without running the query every time. I have never tried to use it before with PowerBI or even Tableau but I think it would work. You can try it out and let me know.

[@eltoski01]

@@herdataproject I think you're right. Just did a quick Google search and I think database views might be the solution. Thanks for the reply

[@ChinweAirdrop]

Thank you so much for this project When I try Update hr Set termdate = date(str_to_date(termdate, '%Y-%m-%d %H:%i:%s UTC')) Where termdate is not null and termdate != ' '; It shows error incorrect datetime value

[@herdataproject]

Hello please refer to the pinned comment

[@ChinweAirdrop]

@@herdataproject thank you 🤗

[@poojaganguli4828]

Hello , UPDATE hr SET termdate = date(str_to_date(termdate, '%Y-%m-%d %H:%i:%s UTC')) WHERE termdate IS NOT NULL AND termdate != ' '; - This part is throwing error on mysql. Below is the response error- Response- Error Code: 1411. Incorrect datetime value: '' for function str_to_date

[@poojaganguli4828]

@@herdataproject Error Code: 1411. Incorrect datetime value: '' for function str_to_date

[@herdataproject]

So the error message suggests that you have an empty string ('') in your termdate column, which cannot be converted to a datetime value using the str_to_date() function. To fix this, you can add an additional condition in your WHERE clause to exclude empty strings: So add this condition as well to just take care of any kind of empty string in the column UPDATE hr SET termdate = date(str_to_date(termdate, '%Y-%m-%d %H:%i:%s UTC')) WHERE termdate IS NOT NULL AND termdate != ' ' AND termdate != '';

[@casafurix]

UPDATE hr SET termdate = IF(termdate IS NOT NULL AND termdate != '', date(str_to_date(termdate, '%Y-%m-%d %H:%i:%s UTC')), '0000-00-00') WHERE true; this will fix it

[@princessiloh5091]

@@casafurix Thanks

[@PinessCodes]

@@casafurix it's showing this error 1411 Incorrect datetime value: "for function str_to_date