Тёмный

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

Awesome Data
Подписаться 2,7 тыс.
Просмотров 7 тыс.
50% 1

Опубликовано:

 

29 сен 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.
@kunleenitan
@kunleenitan 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 месяца назад
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.
@jonathanmporampora2877
@jonathanmporampora2877 18 дней назад
Where do you get the data?
@laxmanreddy2051
@laxmanreddy2051 5 месяцев назад
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.
@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.
@lolcought4961
@lolcought4961 5 месяцев назад
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.
@khan3638
@khan3638 9 месяцев назад
So much practical learning and very professionally made videos. Keep up the good work brother.
@AwesomeData01
@AwesomeData01 9 месяцев назад
Your appreciation means everything, thanks.
@beewithmee
@beewithmee 6 месяцев назад
The database is not loading into postgresql. It failed. Same happened in Mysql as well.
@AwesomeData01
@AwesomeData01 6 месяцев назад
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 месяца назад
Hello, even I am waiting for the new SQL file. Please update
@mukhtaralkozay2989
@mukhtaralkozay2989 8 месяцев назад
The best tutorial I have ever watched.
@AwesomeData01
@AwesomeData01 8 месяцев назад
I am glad you liked it.
@СергейКондулуков-з9ч
@СергейКондулуков-з9ч 5 месяцев назад
Начинаю изучать SQL хорошая вещь.
@AwesomeData01
@AwesomeData01 4 месяца назад
Thanks
@zaidaiman1546
@zaidaiman1546 8 месяцев назад
Where can I download the database from?
@AwesomeData01
@AwesomeData01 8 месяцев назад
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.
@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".
@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.
@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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-FlgXbqwYZEw.htmlsi=6bsHSsuQm-03RKPo
@asp4628
@asp4628 9 месяцев назад
Sir please make videos like this based on real time project
@AwesomeData01
@AwesomeData01 9 месяцев назад
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.
@gaurav6254
@gaurav6254 9 месяцев назад
Sir please upload power bi videos soon, ❤❤
@AwesomeData01
@AwesomeData01 9 месяцев назад
Some PowerBI videos are already on the channel
@beewithmee
@beewithmee 7 месяцев назад
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 7 месяцев назад
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 7 месяцев назад
@@AwesomeData01 I have downloaded the .sql database from the link provided in the video to practice this end to end project.
@AwesomeData01
@AwesomeData01 7 месяцев назад
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.
@faridqanet4709
@faridqanet4709 7 месяцев назад
Excellent work!
@AwesomeData01
@AwesomeData01 7 месяцев назад
Glad you like it!
Далее
Teeth gadget every dentist should have 😬
00:20
Просмотров 878 тыс.
What does a Data Analyst actually do? (in 2024) Q&A
14:27
10 PORTFOLIO PROJECTS TO ADD TO YOUR DATA PORTFOLIO
14:39