Data Analyst Portfolio Project in SQL | End-to-End Employee Data Analysis

Поділитися
Вставка
  • Опубліковано 6 жов 2024

КОМЕНТАРІ • 53

  • @AwesomeData01
    @AwesomeData01  9 місяців тому

    Dear Friends,
    Please provide your honest feedback in the comments below so we can consider your feedback for the coming videos related to Python.
    Thanks.

  • @mukhtaralkozay2989
    @mukhtaralkozay2989 8 місяців тому +2

    The best tutorial I have ever watched.

  • @khan3638
    @khan3638 9 місяців тому +1

    So much practical learning and very professionally made videos. Keep up the good work brother.

    • @AwesomeData01
      @AwesomeData01  9 місяців тому

      Your appreciation means everything, thanks.

  • @gaming-zones
    @gaming-zones 9 місяців тому

    These Kind of videos and projects really increase our information, please keep working on real time projects, Thank you.

    • @AwesomeData01
      @AwesomeData01  9 місяців тому

      Sure, we will work on real-life scenarios and projects in the coming time. This is the roadmap for building the basics and after this, we will work on big and real projects.

  • @kunleenitan
    @kunleenitan 2 місяці тому +2

    I so much wish I could follow the training as I find the teaching approach very simple but couldn't access the dataset. It would have been easy if it was in CSV.

    • @AwesomeData01
      @AwesomeData01  2 місяці тому +1

      The dataset is in sql file which you can download from link in the description and restore it to a DBMS where you can follow along.

  • @СергейКондулуков-з9ч
    @СергейКондулуков-з9ч 5 місяців тому +1

    Начинаю изучать SQL хорошая вещь.

  • @faridqanet4709
    @faridqanet4709 7 місяців тому +1

    Excellent work!

  • @buchimaximus3188
    @buchimaximus3188 4 місяці тому

    I really enjoyed watching this video. unfortunately i cannot work along with the project because the backup file has refused to retore on MySQL 😢

    • @AwesomeData01
      @AwesomeData01  4 місяці тому

      ​ @buchimaximus3188
      Please check the new file now, we have updated the backup file which works fine. Sorry for the inconvenience.

  • @jonathanmporampora2877
    @jonathanmporampora2877 24 дні тому

    Where do you get the data?

  • @beewithmee
    @beewithmee 6 місяців тому +2

    The database is not loading into postgresql. It failed. Same happened in Mysql as well.

    • @AwesomeData01
      @AwesomeData01  6 місяців тому +1

      The .sql file has been corrupted, we will upload a new backup file and then you will be able to use it.
      We are sorry for any inconvenience.

    • @beewithmee
      @beewithmee 6 місяців тому

      Please notify once updated Thanks @@AwesomeData01

    • @mkt20998
      @mkt20998 5 місяців тому

      @@AwesomeData01 please upload a new backup file

    • @buchimaximus3188
      @buchimaximus3188 4 місяці тому

      Hello, thanks for the tutorial. please, is there a new sql file? I am unable to follow up with the project because I cannot get the data set. Thank You @AwesomeData01

    • @beewithmee
      @beewithmee 4 місяці тому +1

      Hello, even I am waiting for the new SQL file. Please update

  • @laxmanreddy2051
    @laxmanreddy2051 5 місяців тому +1

    Have to create schemas according to coulmns Please reply

    • @AwesomeData01
      @AwesomeData01  5 місяців тому

      You need to restore the database from the link below and use it:
      ​ Please check the new file now, we have updated the backup file which works fine. Sorry for the inconvenience.

  • @asp4628
    @asp4628 9 місяців тому

    Sir please make videos like this based on real time project

    • @AwesomeData01
      @AwesomeData01  9 місяців тому +1

      Sure! Once this roadmap is completed, we will surely work on some very big and real projects in the future. This roadmap is designed to build the basics of the community members and then move on to the advanced projects.
      Thanks for your feedback.

  • @lolcought4961
    @lolcought4961 5 місяців тому +1

    sir where is dataset ?

    • @AwesomeData01
      @AwesomeData01  5 місяців тому

      The dataset is in the link below:
      ​ Please check the new file now, we have updated the backup file which works fine. Sorry for the inconvenience.

    • @AwesomeData01
      @AwesomeData01  5 місяців тому

      Here is the dataset:
      ​ Please check the new file now, we have updated the backup file which works fine. Sorry for the inconvenience.

  • @YawNtow
    @YawNtow 6 місяців тому

    I use Microsoft SQL Server Management Studio. How do I get this data my SQL server?

    • @AwesomeData01
      @AwesomeData01  6 місяців тому

      The .sql backup can be restored into any database management system.

  • @shwetamishra1497
    @shwetamishra1497 9 місяців тому

    provide the excel data file for this project without file how can we do analysis ?

    • @AwesomeData01
      @AwesomeData01  9 місяців тому

      All the files are provided in another video called "Backup and restore database".

  • @gaurav6254
    @gaurav6254 9 місяців тому

    Sir please upload power bi videos soon, ❤❤

    • @AwesomeData01
      @AwesomeData01  9 місяців тому

      Some PowerBI videos are already on the channel

  • @beewithmee
    @beewithmee 8 місяців тому

    after successfull import of the database into mysql still the data is not showing in schemas. I have restarted and refreshed the schemas as well. Please suggest!

    • @AwesomeData01
      @AwesomeData01  8 місяців тому

      If your backup is with .sql extension, you can easily restore it in MySQL DBMS.
      Are you using the MySQL command-line or any GUI application for MySQL?

    • @beewithmee
      @beewithmee 8 місяців тому +1

      @@AwesomeData01
      I have downloaded the .sql database from the link provided in the video to practice this end to end project.

    • @AwesomeData01
      @AwesomeData01  8 місяців тому

      How can I see your problem? I would appreciate it if you could record your process of restoring database in mysql and send it to me via WhatsApp.
      You will be able to find my WhatsApp number from our WhatsApp community of Data Analysts that you can join from the link in the video description.

    • @AwesomeData01
      @AwesomeData01  4 місяці тому

      @@beewithmee Get the updated file and restore it, it should work now.

  • @cricketloversonly9675
    @cricketloversonly9675 8 місяців тому

    How to add this dataset in to our sql pgadmin please answer.

    • @AwesomeData01
      @AwesomeData01  8 місяців тому

      We have a dedicated video on that. I am adding the link here:
      ua-cam.com/video/FlgXbqwYZEw/v-deo.htmlsi=6bsHSsuQm-03RKPo

  • @zaidaiman1546
    @zaidaiman1546 9 місяців тому +1

    Where can I download the database from?

    • @AwesomeData01
      @AwesomeData01  9 місяців тому

      You can find it in the video description.

  • @YawNtow
    @YawNtow 6 місяців тому

    I use Microsoft SQL Server Management Studio. How do I get this data my SQL server?

    • @AwesomeData01
      @AwesomeData01  6 місяців тому

      The .sql backup can be restored into any database management system.