SQL & PowerBI Portfolio Project for Data Analysts

แชร์
ฝัง
  • เผยแพร่เมื่อ 14 ธ.ค. 2024

ความคิดเห็น • 382

  • @casafurix
    @casafurix ปีที่แล้ว +63

    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
      @vinodkumarhugar6418 ปีที่แล้ว +4

      It worked , Thanks 🤝

    • @herdataproject
      @herdataproject  ปีที่แล้ว +3

      Nice, thanks!

    • @somranjan5810
      @somranjan5810 ปีที่แล้ว +4

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

    • @vigneshnaruto9777
      @vigneshnaruto9777 ปีที่แล้ว +2

      thanks man

    • @Zovic_Kiddies
      @Zovic_Kiddies ปีที่แล้ว +1

      Can this work in Microsoft SQL server management studio pls?

  • @mayanktiwari5069
    @mayanktiwari5069 10 หลายเดือนก่อน +10

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

  • @sanketkalugade1076
    @sanketkalugade1076 ปีที่แล้ว +5

    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
      @yennhingo4936 11 หลายเดือนก่อน

      Thank you!

    • @jayakrishnanvn
      @jayakrishnanvn 6 หลายเดือนก่อน

      thanks mate ... very helpful...

  • @simonoganga5956
    @simonoganga5956 ปีที่แล้ว +8

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

    • @herdataproject
      @herdataproject  ปีที่แล้ว +3

      Thanks Simon. More projects coming soon

    • @simonoganga9535
      @simonoganga9535 ปีที่แล้ว +2

      @@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
    @HaydenTheAnalyst ปีที่แล้ว +12

    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
      @herdataproject  ปีที่แล้ว +1

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

  • @mm1234bb
    @mm1234bb ปีที่แล้ว +2

    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
      @herdataproject  ปีที่แล้ว

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

  • @rumonseoexparts9697
    @rumonseoexparts9697 ปีที่แล้ว +1

    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
    @Lost_John 7 หลายเดือนก่อน

    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
      @herdataproject  7 หลายเดือนก่อน

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

    • @ijeomajoseph1615
      @ijeomajoseph1615 2 หลายเดือนก่อน

      ​@@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
      @herdataproject  2 หลายเดือนก่อน

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

    • @ijeomajoseph1615
      @ijeomajoseph1615 2 หลายเดือนก่อน

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

  • @sowjanyakake5720
    @sowjanyakake5720 ปีที่แล้ว +1

    Thanks for covering various scenarios using sql.. quite helpful

    • @herdataproject
      @herdataproject  ปีที่แล้ว

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

  • @haohoangkim3247
    @haohoangkim3247 ปีที่แล้ว

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

  • @alowismusodza
    @alowismusodza ปีที่แล้ว

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

    • @herdataproject
      @herdataproject  ปีที่แล้ว

      You're welcome!! Thanks for watching

  • @charugera7654
    @charugera7654 ปีที่แล้ว +6

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

    • @herdataproject
      @herdataproject  ปีที่แล้ว +3

      You're welcome. I will definitely do that

  • @itnasss
    @itnasss ปีที่แล้ว

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

    • @itnasss
      @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
      @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

  • @jkschola1
    @jkschola1 ปีที่แล้ว +2

    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
      @herdataproject  ปีที่แล้ว +2

      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
      @anymjohnson1729 ปีที่แล้ว +1

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

    • @herdataproject
      @herdataproject  ปีที่แล้ว +1

      @anymjohnson1729 it's MySQL Workbench

  • @gozieprince9530
    @gozieprince9530 7 วันที่ผ่านมา

    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

  • @SahilSahil-vo1yw
    @SahilSahil-vo1yw 5 หลายเดือนก่อน

    It's awesome!! I've watched n number of TH-cam 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 ❤👍🤝.

  • @EdemKlogo-e7t
    @EdemKlogo-e7t หลายเดือนก่อน

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

    • @herdataproject
      @herdataproject  หลายเดือนก่อน

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

  • @onosemuodeikuesiri7620
    @onosemuodeikuesiri7620 2 หลายเดือนก่อน +1

    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
      @herdataproject  2 หลายเดือนก่อน

      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!!

  • @AyoRO88
    @AyoRO88 8 หลายเดือนก่อน

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

  • @khairunnisanada9124
    @khairunnisanada9124 ปีที่แล้ว

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

  • @francisonyango3868
    @francisonyango3868 8 หลายเดือนก่อน

    Clear explanations....thank you so much

    • @herdataproject
      @herdataproject  8 หลายเดือนก่อน

      You're most welcome!!

  • @ruchamasurkar9255
    @ruchamasurkar9255 ปีที่แล้ว +1

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

    • @herdataproject
      @herdataproject  ปีที่แล้ว

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

  • @arindamsinha5857
    @arindamsinha5857 ปีที่แล้ว +13

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

    • @herdataproject
      @herdataproject  ปีที่แล้ว +8

      Coming soon!!

    • @ntran04299
      @ntran04299 ปีที่แล้ว

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

  • @sasitpiasai8152
    @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
      @herdataproject  ปีที่แล้ว

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

  • @yogeshmeshram1120
    @yogeshmeshram1120 ปีที่แล้ว +2

    Amazing work. Plz make Python data Analysis Project Video.

  • @tpfw_daniel
    @tpfw_daniel ปีที่แล้ว

    You did a very good job. Keep it up.

    • @herdataproject
      @herdataproject  ปีที่แล้ว

      Thanks Daniel. I'm glad you found it helpful

  • @meraki2090
    @meraki2090 ปีที่แล้ว +1

    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
      @herdataproject  ปีที่แล้ว

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

  • @Ganeshay-09
    @Ganeshay-09 7 หลายเดือนก่อน

    Superb understanding easy way

  • @MaabHussein-f7e
    @MaabHussein-f7e 4 หลายเดือนก่อน

    I cannot thank you enough for this informative video

  • @ashok_rawat_
    @ashok_rawat_ ปีที่แล้ว

    You are doing it great, keep going,,

  • @AmalKrishnan-u2q
    @AmalKrishnan-u2q หลายเดือนก่อน

    Great Video. i'm confused why termdate

    • @herdataproject
      @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!

  • @VM-hw3qh
    @VM-hw3qh 3 หลายเดือนก่อน

    Great Work🙌

  • @mohineshsharma335
    @mohineshsharma335 ปีที่แล้ว

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

  • @carolinaninobeltran6716
    @carolinaninobeltran6716 ปีที่แล้ว

    Thank you very much, i found this tutorial very usefull

  • @Hasindu_Randika
    @Hasindu_Randika 4 หลายเดือนก่อน

    Thank you for your great tutorial. Keep it up!

  • @μελέτη1
    @μελέτη1 7 หลายเดือนก่อน +1

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

  • @terenceochuo701
    @terenceochuo701 11 หลายเดือนก่อน

    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

  • @jamesthomas3959
    @jamesthomas3959 ปีที่แล้ว

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

  • @giftcardseverywhere
    @giftcardseverywhere 7 หลายเดือนก่อน +1

    wow great stuff so much value

  • @jean-etiennengo4201
    @jean-etiennengo4201 ปีที่แล้ว +1

    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
      @herdataproject  ปีที่แล้ว +3

      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

  • @whiteana9713
    @whiteana9713 ปีที่แล้ว +1

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

    • @herdataproject
      @herdataproject  ปีที่แล้ว

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

  • @kapilak9530
    @kapilak9530 11 หลายเดือนก่อน

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

  • @Rabbani_World_Flock
    @Rabbani_World_Flock 10 หลายเดือนก่อน

    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

  • @augustineemmanuel6897
    @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
      @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
      @maskman6372 ปีที่แล้ว

      ​@@herdataproject birthdate becomes null

    • @esthernwaogu592
      @esthernwaogu592 ปีที่แล้ว

      Yes null

    • @chyonu
      @chyonu ปีที่แล้ว

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

  • @saisrikanth9313
    @saisrikanth9313 ปีที่แล้ว +1

    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
      @saisrikanth9313 ปีที่แล้ว

      I meant for Question 3 in analysis part

  • @AdityaSingh-mj2kh
    @AdityaSingh-mj2kh 4 หลายเดือนก่อน

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

  • @lukev730
    @lukev730 ปีที่แล้ว

    Amazing work
    Thank you

    • @herdataproject
      @herdataproject  ปีที่แล้ว

      Thank you and you're most welcome!!

  • @chalanatyjostna2229
    @chalanatyjostna2229 11 หลายเดือนก่อน

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

  • @thirdyako
    @thirdyako ปีที่แล้ว

    Thanks! It's been helpful. :)

    • @herdataproject
      @herdataproject  ปีที่แล้ว

      You're welcome!
      Thanks for watching: )

  • @aishwaryapattnaik3082
    @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
      @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"

  • @BeSweet-c4p
    @BeSweet-c4p ปีที่แล้ว +1

    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
      @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
      @BeSweet-c4p ปีที่แล้ว

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

  • @TeliahTalksData
    @TeliahTalksData ปีที่แล้ว +1

    Can I use Ms SQL?

  • @AustinIC
    @AustinIC 9 หลายเดือนก่อน

    Big thanks to you!!!

  • @ChipoMoyo-v8d
    @ChipoMoyo-v8d 11 หลายเดือนก่อน

    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.

  • @madcity2073
    @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
      @herdataproject  ปีที่แล้ว

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

    • @ELLIOT8209
      @ELLIOT8209 ปีที่แล้ว

      Search for duplicates

  • @tigerbojiteol
    @tigerbojiteol ปีที่แล้ว

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

    • @herdataproject
      @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

  • @AbigailNjambi
    @AbigailNjambi 7 หลายเดือนก่อน

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

  • @abhishekkumar-qi3is
    @abhishekkumar-qi3is ปีที่แล้ว

    please make vedio on orderback prediction and inventary management.

    • @herdataproject
      @herdataproject  ปีที่แล้ว

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

  • @Lordarknesss
    @Lordarknesss ปีที่แล้ว

    Keep going. Nice!

  • @sia_ibk
    @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
      @herdataproject  ปีที่แล้ว

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

  • @सुयशपाटील-ठ2ठ
    @सुयशपाटील-ठ2ठ ปีที่แล้ว +1

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

    • @herdataproject
      @herdataproject  ปีที่แล้ว

      Kindly share the whole error as is

  • @Mahesh717
    @Mahesh717 ปีที่แล้ว +1

    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
      @herdataproject  ปีที่แล้ว +1

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

  • @michellerosecruz4709
    @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
      @herdataproject  ปีที่แล้ว

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

  • @kausarali9852
    @kausarali9852 ปีที่แล้ว

    very informative
    thanks

  • @yasminibrahim9708
    @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
      @herdataproject  ปีที่แล้ว

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

  • @peace_321
    @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
      @herdataproject  ปีที่แล้ว +1

      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
      @peace_321 ปีที่แล้ว +1

      @@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
      @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
      @herdataproject  ปีที่แล้ว +1

      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
      @peace_321 ปีที่แล้ว +1

      @@herdataproject thank you mam 🙏🏻🙏🏻

  • @ezhil7942
    @ezhil7942 3 หลายเดือนก่อน +1

    Thanks it working

  • @902mayanksingh2
    @902mayanksingh2 ปีที่แล้ว

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

    • @herdataproject
      @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

  • @peace_321
    @peace_321 ปีที่แล้ว

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

    • @peace_321
      @peace_321 ปีที่แล้ว +1

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

    • @herdataproject
      @herdataproject  ปีที่แล้ว

      You're welcome!

  • @lakitajoseph3478
    @lakitajoseph3478 8 หลายเดือนก่อน

    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
      @herdataproject  8 หลายเดือนก่อน

      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
      @lakitajoseph3478 8 หลายเดือนก่อน

      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

  • @myvideos-uu6mj
    @myvideos-uu6mj ปีที่แล้ว

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

    • @herdataproject
      @herdataproject  ปีที่แล้ว

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

  • @adhytiamps622
    @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
      @herdataproject  ปีที่แล้ว

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

  • @RameshD-m5j
    @RameshD-m5j ปีที่แล้ว

    thank you so much for ur work.

  • @Rabbani_World_Flock
    @Rabbani_World_Flock 10 หลายเดือนก่อน

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

  • @FarhadKhan-xe4ft
    @FarhadKhan-xe4ft 3 หลายเดือนก่อน

    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
      @herdataproject  3 หลายเดือนก่อน

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

  • @chiragvaljee4306
    @chiragvaljee4306 9 หลายเดือนก่อน

    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
      @sembhaiamman9237 8 หลายเดือนก่อน

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

  • @Rahuljadhav-nm2sc
    @Rahuljadhav-nm2sc ปีที่แล้ว

    thank you so much 👌👌

  • @AustinIC
    @AustinIC 9 หลายเดือนก่อน

    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
      @herdataproject  9 หลายเดือนก่อน

      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
      @AustinIC 9 หลายเดือนก่อน

      🙏 Am grateful, thanks
      I will explore the options

  • @fransiscusnauli5469
    @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
      @herdataproject  ปีที่แล้ว +1

      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
      @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
      @herdataproject  ปีที่แล้ว +1

      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
      @PinessCodes ปีที่แล้ว +1

      Thank you Ma@@herdataproject

    • @fransiscusnauli5469
      @fransiscusnauli5469 ปีที่แล้ว

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

  • @samratkundu2799
    @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
      @herdataproject  ปีที่แล้ว +1

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

  • @CodingwithQ23
    @CodingwithQ23 8 หลายเดือนก่อน

    if everyone has trouble in the termdate column error when you update , let take the code " SET SQL_SAFE_UPDATES = 0" before the code update this colums. like this:
    SET SQL_SAFE_UPDATES = 0;
    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 ;

  • @souptikdas9461
    @souptikdas9461 ปีที่แล้ว

    Hello, how to solve the below problem in Microsoft sql
    UPDATE HR
    SET termdate = CONVERT(date, termdate, 120)
    WHERE termdate IS NOT NULL AND termdate != ' ';
    Error - Conversion failed when converting date and/or time from character string.

    • @herdataproject
      @herdataproject  ปีที่แล้ว

      you can modify the UPDATE statement to exclude the problematic rows that cannot be converted to a date.
      UPDATE HR
      SET termdate = CONVERT(date, termdate, 120)
      WHERE termdate IS NOT NULL AND termdate != ' ' AND ISDATE(termdate) = 1;
      The additional condition ISDATE(termdate) = 1 is added to ensure that only valid date values are considered for conversion. The ISDATE function checks if the value can be converted to a valid date, and only rows where the 'termdate' value is a valid date will be updated.
      Hope this helps

  • @PrinceJeniFX
    @PrinceJeniFX ปีที่แล้ว

    Please which software do you use for the screen recording?

  • @gokilaharish6305
    @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
      @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
      @herdataproject  ปีที่แล้ว

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

  • @TOO-FAM
    @TOO-FAM ปีที่แล้ว

    Irene, First I tried to download CSV, it became a text file, when I changed the file to CSV and imported to SQL, the data is not clear and has errors, please tell me step by step how to download the file from your GITHUB, and how to open in MySQL

    • @herdataproject
      @herdataproject  ปีที่แล้ว

      You can also download it from the telegram if you're able to install the app. I think it should download as a CSV file. Once you join the group it'll be pinned at the top

  • @Rabbani_World_Flock
    @Rabbani_World_Flock 10 หลายเดือนก่อน

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

    • @herdataproject
      @herdataproject  10 หลายเดือนก่อน +1

      Hi, which exact command isn't working?

    • @Rabbani_World_Flock
      @Rabbani_World_Flock 10 หลายเดือนก่อน

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

  • @afolayandamola6378
    @afolayandamola6378 ปีที่แล้ว

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

    • @ChinweAirdrop
      @ChinweAirdrop ปีที่แล้ว

      Change y to capital Y

    • @chyonu
      @chyonu ปีที่แล้ว

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

    • @pruthviraj8474
      @pruthviraj8474 8 หลายเดือนก่อน

      @@ChinweAirdrop Thank you so much

  • @chalanatyjostna2229
    @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
      @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
      @chalanatyjostna2229 ปีที่แล้ว

      @@herdataproject thank you so much for the ans.

  • @mahekgarg6205
    @mahekgarg6205 ปีที่แล้ว

    Hi, for min and max ages did anyone not get negative values? My result doesn't show -42. It shows minimum value as 20. I tried copy pasting the query from github too. Same result. Would really appreciate any help:) Thank you for the video .

    • @hakeemfujah2426
      @hakeemfujah2426 10 หลายเดือนก่อน

      You are correct mine shows as 21 maybe because I am doing this some months after you had done yours

  • @milank465
    @milank465 4 หลายเดือนก่อน

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

    • @herdataproject
      @herdataproject  4 หลายเดือนก่อน +1

      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

  • @eltoski01
    @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
      @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
      @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

  • @herdataproject
    @herdataproject  ปีที่แล้ว +2

    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

  • @LawalOluwakemi-bd9dh
    @LawalOluwakemi-bd9dh ปีที่แล้ว

    Using Microsoft sql and there is no str_to_date function, tried changing termdate data type but was not able to, tried convert, cast but it's not working, please help

    • @herdataproject
      @herdataproject  ปีที่แล้ว

      In Microsoft SQL Server, you can use the CONVERT() function to convert a string to a date. The format string to use with CONVERT() is different from the one used with STR_TO_DATE() in MySQL.
      UPDATE hr
      SET termdate = CONVERT(DATETIME, termdate, 120)
      WHERE termdate IS NOT NULL AND termdate != ' '
      In this example, the CONVERT() function is used to convert the termdate string to a datetime data type using the format code 120, which corresponds to the ISO 8601 format (yyyy-mm-dd hh:mi:ss(24h)).
      Something to keep in mind is that the CONVERT() function can be affected by the default language setting of the SQL Server instance. If you're experiencing issues with the conversion, you can try using the SET LANGUAGE statement to set the language explicitly before running the UPDATE statement:
      SET LANGUAGE us_english
      UPDATE hr
      SET termdate = CONVERT(DATETIME, termdate, 120)
      WHERE termdate IS NOT NULL AND termdate != ' '
      I hope this helps : )

    • @LawalOluwakemi-bd9dh
      @LawalOluwakemi-bd9dh ปีที่แล้ว

      @@herdataproject thank you so much

    • @herdataproject
      @herdataproject  ปีที่แล้ว

      You're welcome. I hope it worked

    • @azimahemad7067
      @azimahemad7067 ปีที่แล้ว

      Still not working in Microsoft SQL server

  • @LadyLuck93-gr4wq
    @LadyLuck93-gr4wq ปีที่แล้ว

    when I try to change the termdate I get an error stating incorrect datetime value. mine is copied EXACTLY like yours so I'm so confused

    • @LadyLuck93-gr4wq
      @LadyLuck93-gr4wq ปีที่แล้ว

      Error Code: 1411. Incorrect datetime value: '2029-10-29 06:09:38 UTC' for function str_to_date

    • @herdataproject
      @herdataproject  ปีที่แล้ว +1

      run this query first
      SET SQL_MODE = ' ';
      then run the update query

  • @vj3337
    @vj3337 ปีที่แล้ว +1

    967 records showing age minus value due to date conversion, some dates in text value like 6/26/67 changed to 2067-6-26 instead of 1967.
    I'm interested in, how to change these data to correct 1900 dates in the same command? anybody?
    ---
    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;
    ---
    And great tutorial btw, really helpful, two thumbs up.

    • @herdataproject
      @herdataproject  ปีที่แล้ว

      Thank you so much. More to come😊
      So I don't think I would be accurate to convert those dates to 1967 and so on because we don't know for sure that is the value that is supposed to be there. But if you decide to do that then you would have to mention it in your final documentation.

    • @samuel_muly
      @samuel_muly 9 หลายเดือนก่อน

      I also noticed that, however, I believe Excel can be used in date conversion in this case.

    • @ijeomajoseph1615
      @ijeomajoseph1615 2 หลายเดือนก่อน

      Thank you for this project
      Mine imported 17425 records instead of 22214
      Any reason why this is so Ma'am?​@@herdataproject

  • @PrajwalSSJA
    @PrajwalSSJA ปีที่แล้ว

    While operating on termdate
    And executing the query the date format was changed but blank cells were not updated with ''0000-00-00"

    • @herdataproject
      @herdataproject  ปีที่แล้ว +2

      They don't have to update to 0000-00-00. It all depends with the settings of your MySQL. If yours have remained as NULL it's okay. When writing the queries use
      WHERE termdate IS NULL instead of WHERE termdate = '0000-00-00'

    • @PrajwalSSJA
      @PrajwalSSJA ปีที่แล้ว

      @@herdataproject sure and thank you

    • @herdataproject
      @herdataproject  ปีที่แล้ว

      You're welcome

    • @PrajwalSSJA
      @PrajwalSSJA ปีที่แล้ว

      @@herdataproject sir will send that error in telegram group please help

    • @lahiruparakrama5708
      @lahiruparakrama5708 หลายเดือนก่อน

      @@herdataproject Is it a problem when working with Power BI, Because of a NULL value

  • @likithak2268
    @likithak2268 ปีที่แล้ว

    Hey, i keep getting this error, can u tell me how will i be able to resolve this issues for following code:
    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: '06-04-1991' for function str_to_date 0.000 sec

    • @herdataproject
      @herdataproject  ปีที่แล้ว

      Use Y instead of y.
      Try to write the code exactly as it is in the video

    • @obengdapaah0
      @obengdapaah0 ปีที่แล้ว

      @@herdataproject thank you but can you explain why the change of the Y. It would be very helpful

    • @peace_321
      @peace_321 ปีที่แล้ว +1

      @@herdataproject it worked... thank you infinite...

  • @oluwasegunraimi3453
    @oluwasegunraimi3453 11 หลายเดือนก่อน

    Some functions like describe, str_to_date isnt working on my system

  • @saidhikshi1105
    @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
      @herdataproject  ปีที่แล้ว

      Hello use UPDATE IGNORE hr

    • @nileshraut9
      @nileshraut9 2 หลายเดือนก่อน

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

  • @IvaRazmadze-tr1xw
    @IvaRazmadze-tr1xw 6 หลายเดือนก่อน

    I am having ERROR 1292 issue, can some1 help me?