Please go through this top 10 SQL projects with Datasets that you can practice and can add in your resume
๐1. Social Media Analytics:
(https://www.kaggle.com/amanajmera1/framingham-heart-study-dataset)
๐2. Web Analytics:
(https://www.kaggle.com/zynicide/wine-reviews)
๐3. HR Analytics:
(https://www.kaggle.com/pavansubhasht/ibm-hr-analytics-
attrition-dataset)
๐4. Healthcare Data Analysis:
(https://www.kaggle.com/cdc/mortality)
๐5. E-commerce Analysis:
(https://www.kaggle.com/olistbr/brazilian-ecommerce)
๐6. Inventory Management:
(https://www.kaggle.com/datasets?
search=inventory+management)
๐ 7.Customer Relationship Management:
(https://www.kaggle.com/pankajjsh06/ibm-watson-
marketing-customer-value-data)
๐8. Financial Data Analysis:
(https://www.kaggle.com/awaiskalia/banking-database)
๐9. Supply Chain Management:
(https://www.kaggle.com/shashwatwork/procurement-analytics)
๐10. Analysis of Sales Data:
(https://www.kaggle.com/kyanyoga/sample-sales-data)
Small suggestion from my side for non tech students: kindly pick those datasets which you like the subject in general, that way you will be more excited to practice it, instead of just doing it for the sake of resume, you will learn SQL more passionately, since itโs a programming language try to make it more exciting for yourself.
Join for more: https://t.me/DataPortfolio
Hope this piece of information helps you
๐1. Social Media Analytics:
(https://www.kaggle.com/amanajmera1/framingham-heart-study-dataset)
๐2. Web Analytics:
(https://www.kaggle.com/zynicide/wine-reviews)
๐3. HR Analytics:
(https://www.kaggle.com/pavansubhasht/ibm-hr-analytics-
attrition-dataset)
๐4. Healthcare Data Analysis:
(https://www.kaggle.com/cdc/mortality)
๐5. E-commerce Analysis:
(https://www.kaggle.com/olistbr/brazilian-ecommerce)
๐6. Inventory Management:
(https://www.kaggle.com/datasets?
search=inventory+management)
๐ 7.Customer Relationship Management:
(https://www.kaggle.com/pankajjsh06/ibm-watson-
marketing-customer-value-data)
๐8. Financial Data Analysis:
(https://www.kaggle.com/awaiskalia/banking-database)
๐9. Supply Chain Management:
(https://www.kaggle.com/shashwatwork/procurement-analytics)
๐10. Analysis of Sales Data:
(https://www.kaggle.com/kyanyoga/sample-sales-data)
Small suggestion from my side for non tech students: kindly pick those datasets which you like the subject in general, that way you will be more excited to practice it, instead of just doing it for the sake of resume, you will learn SQL more passionately, since itโs a programming language try to make it more exciting for yourself.
Join for more: https://t.me/DataPortfolio
Hope this piece of information helps you
๐56โค13๐2โก1
parkinsons.zip
297 KB
๐ฆ Datasets name: Parkinson Dataset
โ Format: CSV files
๐ From: UC IRVAN
โ Format: CSV files
๐ From: UC IRVAN
๐18
Python Topics for Data Analysts
๐๐
https://t.me/sqlspecialist/548
Data Analyst Jobs
๐๐
https://t.me/jobs_SQL/297
Excel Topics for Data Analysts
๐๐
https://t.me/sqlspecialist/547
Data Science Projects
๐๐
https://t.me/sqlproject
๐๐
https://t.me/sqlspecialist/548
Data Analyst Jobs
๐๐
https://t.me/jobs_SQL/297
Excel Topics for Data Analysts
๐๐
https://t.me/sqlspecialist/547
Data Science Projects
๐๐
https://t.me/sqlproject
๐11โค1
๐Here are 5 fresh Project ideas for Data Analysts ๐
๐ฏ ๐๐ถ๐ฟ๐ฏ๐ป๐ฏ ๐ข๐ฝ๐ฒ๐ป ๐๐ฎ๐๐ฎ ๐
https://www.kaggle.com/datasets/arianazmoudeh/airbnbopendata
๐กThis dataset describes the listing activity of homestays in New York City
๐ฏ ๐ง๐ผ๐ฝ ๐ฆ๐ฝ๐ผ๐๐ถ๐ณ๐ ๐๐ผ๐ป๐ด๐ ๐ณ๐ฟ๐ผ๐บ ๐ฎ๐ฌ๐ญ๐ฌ-๐ฎ๐ฌ๐ญ๐ต ๐ต
https://www.kaggle.com/datasets/leonardopena/top-spotify-songs-from-20102019-by-year
๐ฏ๐ช๐ฎ๐น๐บ๐ฎ๐ฟ๐ ๐ฆ๐๐ผ๐ฟ๐ฒ ๐ฆ๐ฎ๐น๐ฒ๐ ๐๐ผ๐ฟ๐ฒ๐ฐ๐ฎ๐๐๐ถ๐ป๐ด ๐
https://www.kaggle.com/c/walmart-recruiting-store-sales-forecasting/data
๐กUse historical markdown data to predict store sales
๐ฏ ๐ก๐ฒ๐๐ณ๐น๐ถ๐ ๐ ๐ผ๐๐ถ๐ฒ๐ ๐ฎ๐ป๐ฑ ๐ง๐ฉ ๐ฆ๐ต๐ผ๐๐ ๐บ
https://www.kaggle.com/datasets/shivamb/netflix-shows
๐กListings of movies and tv shows on Netflix - Regularly Updated
๐ฏ๐๐ถ๐ป๐ธ๐ฒ๐ฑ๐๐ป ๐๐ฎ๐๐ฎ ๐๐ป๐ฎ๐น๐๐๐ ๐ท๐ผ๐ฏ๐ ๐น๐ถ๐๐๐ถ๐ป๐ด๐ ๐ผ
https://www.kaggle.com/datasets/cedricaubin/linkedin-data-analyst-jobs-listings
๐กMore than 8400 rows of data analyst jobs from USA, Canada and Africa.
Join for more -> https://t.me/addlist/KBNT2WWRIEs0NzIx
ENJOY LEARNING ๐๐
๐ฏ ๐๐ถ๐ฟ๐ฏ๐ป๐ฏ ๐ข๐ฝ๐ฒ๐ป ๐๐ฎ๐๐ฎ ๐
https://www.kaggle.com/datasets/arianazmoudeh/airbnbopendata
๐กThis dataset describes the listing activity of homestays in New York City
๐ฏ ๐ง๐ผ๐ฝ ๐ฆ๐ฝ๐ผ๐๐ถ๐ณ๐ ๐๐ผ๐ป๐ด๐ ๐ณ๐ฟ๐ผ๐บ ๐ฎ๐ฌ๐ญ๐ฌ-๐ฎ๐ฌ๐ญ๐ต ๐ต
https://www.kaggle.com/datasets/leonardopena/top-spotify-songs-from-20102019-by-year
๐ฏ๐ช๐ฎ๐น๐บ๐ฎ๐ฟ๐ ๐ฆ๐๐ผ๐ฟ๐ฒ ๐ฆ๐ฎ๐น๐ฒ๐ ๐๐ผ๐ฟ๐ฒ๐ฐ๐ฎ๐๐๐ถ๐ป๐ด ๐
https://www.kaggle.com/c/walmart-recruiting-store-sales-forecasting/data
๐กUse historical markdown data to predict store sales
๐ฏ ๐ก๐ฒ๐๐ณ๐น๐ถ๐ ๐ ๐ผ๐๐ถ๐ฒ๐ ๐ฎ๐ป๐ฑ ๐ง๐ฉ ๐ฆ๐ต๐ผ๐๐ ๐บ
https://www.kaggle.com/datasets/shivamb/netflix-shows
๐กListings of movies and tv shows on Netflix - Regularly Updated
๐ฏ๐๐ถ๐ป๐ธ๐ฒ๐ฑ๐๐ป ๐๐ฎ๐๐ฎ ๐๐ป๐ฎ๐น๐๐๐ ๐ท๐ผ๐ฏ๐ ๐น๐ถ๐๐๐ถ๐ป๐ด๐ ๐ผ
https://www.kaggle.com/datasets/cedricaubin/linkedin-data-analyst-jobs-listings
๐กMore than 8400 rows of data analyst jobs from USA, Canada and Africa.
Join for more -> https://t.me/addlist/KBNT2WWRIEs0NzIx
ENJOY LEARNING ๐๐
๐14โค5๐ฅ2
Please go through this top 5 SQL projects with Datasets that you can practice and can add in your resume
๐1. Web Analytics:
(https://www.kaggle.com/zynicide/wine-reviews)
๐2. Healthcare Data Analysis:
(https://www.kaggle.com/cdc/mortality)
๐3. E-commerce Analysis:
(https://www.kaggle.com/olistbr/brazilian-ecommerce)
๐4. Inventory Management:
(https://www.kaggle.com/code/govindji/inventory-management)
๐ 5. Analysis of Sales Data:
(https://www.kaggle.com/kyanyoga/sample-sales-data)
Small suggestion from my side for non tech students: kindly pick those datasets which you like the subject in general, that way you will be more excited to practice it, instead of just doing it for the sake of resume, you will learn SQL more passionately, since itโs a programming language try to make it more exciting for yourself.
Hope this piece of information helps you
Join for more -> https://t.me/addlist/KBNT2WWRIEs0NzIx
ENJOY LEARNING ๐๐
๐1. Web Analytics:
(https://www.kaggle.com/zynicide/wine-reviews)
๐2. Healthcare Data Analysis:
(https://www.kaggle.com/cdc/mortality)
๐3. E-commerce Analysis:
(https://www.kaggle.com/olistbr/brazilian-ecommerce)
๐4. Inventory Management:
(https://www.kaggle.com/code/govindji/inventory-management)
๐ 5. Analysis of Sales Data:
(https://www.kaggle.com/kyanyoga/sample-sales-data)
Small suggestion from my side for non tech students: kindly pick those datasets which you like the subject in general, that way you will be more excited to practice it, instead of just doing it for the sake of resume, you will learn SQL more passionately, since itโs a programming language try to make it more exciting for yourself.
Hope this piece of information helps you
Join for more -> https://t.me/addlist/KBNT2WWRIEs0NzIx
ENJOY LEARNING ๐๐
๐15โค6
Useful Telegram Channels for Free Learning ๐๐
Free Courses with Certificate
Web Development
Data Science & Machine Learning
Programming books
Python Free Courses
Data Analytics
Ethical Hacking & Cyber Security
English Speaking & Communication
Stock Marketing & Investment Banking
Excel
ChatGPT Hacks
SQL
Tableau & Power BI
Coding Projects
Data Science Projects
Jobs & Internship Opportunities
Coding Interviews
Udemy Free Courses with Certificate
Cryptocurrency & Bitcoin
Python Projects
Data Analyst Interview
Data Analyst Jobs
Python Interview
ChatGPT Hacks
ENJOY LEARNING ๐๐
Free Courses with Certificate
Web Development
Data Science & Machine Learning
Programming books
Python Free Courses
Data Analytics
Ethical Hacking & Cyber Security
English Speaking & Communication
Stock Marketing & Investment Banking
Excel
ChatGPT Hacks
SQL
Tableau & Power BI
Coding Projects
Data Science Projects
Jobs & Internship Opportunities
Coding Interviews
Udemy Free Courses with Certificate
Cryptocurrency & Bitcoin
Python Projects
Data Analyst Interview
Data Analyst Jobs
Python Interview
ChatGPT Hacks
ENJOY LEARNING ๐๐
๐21โค1๐ฅ1
Creating a data science portfolio is a great way to showcase your skills and experience to potential employers. Here are some steps to help you create a strong data science portfolio:
1. Choose relevant projects: Select a few data science projects that demonstrate your skills and interests. These projects can be from your previous work experience, personal projects, or online competitions.
2. Clean and organize your code: Make sure your code is well-documented, organized, and easy to understand. Use comments to explain your thought process and the steps you took in your analysis.
3. Include a variety of projects: Try to include a mix of projects that showcase different aspects of data science, such as data cleaning, exploratory data analysis, machine learning, and data visualization.
4. Create visualizations: Data visualizations can help make your portfolio more engaging and easier to understand. Use tools like Matplotlib, Seaborn, or Tableau to create visually appealing charts and graphs.
5. Write project summaries: For each project, provide a brief summary of the problem you were trying to solve, the dataset you used, the methods you applied, and the results you obtained. Include any insights or recommendations that came out of your analysis.
6. Showcase your technical skills: Highlight the programming languages, libraries, and tools you used in each project. Mention any specific techniques or algorithms you implemented.
7. Link to your code and data: Provide links to your code repositories (e.g., GitHub) and any datasets you used in your projects. This allows potential employers to review your work in more detail.
8. Keep it updated: Regularly update your portfolio with new projects and skills as you gain more experience in data science. This will show that you are actively engaged in the field and continuously improving your skills.
By following these steps, you can create a comprehensive and visually appealing data science portfolio that will impress potential employers and help you stand out in the competitive job market.
1. Choose relevant projects: Select a few data science projects that demonstrate your skills and interests. These projects can be from your previous work experience, personal projects, or online competitions.
2. Clean and organize your code: Make sure your code is well-documented, organized, and easy to understand. Use comments to explain your thought process and the steps you took in your analysis.
3. Include a variety of projects: Try to include a mix of projects that showcase different aspects of data science, such as data cleaning, exploratory data analysis, machine learning, and data visualization.
4. Create visualizations: Data visualizations can help make your portfolio more engaging and easier to understand. Use tools like Matplotlib, Seaborn, or Tableau to create visually appealing charts and graphs.
5. Write project summaries: For each project, provide a brief summary of the problem you were trying to solve, the dataset you used, the methods you applied, and the results you obtained. Include any insights or recommendations that came out of your analysis.
6. Showcase your technical skills: Highlight the programming languages, libraries, and tools you used in each project. Mention any specific techniques or algorithms you implemented.
7. Link to your code and data: Provide links to your code repositories (e.g., GitHub) and any datasets you used in your projects. This allows potential employers to review your work in more detail.
8. Keep it updated: Regularly update your portfolio with new projects and skills as you gain more experience in data science. This will show that you are actively engaged in the field and continuously improving your skills.
By following these steps, you can create a comprehensive and visually appealing data science portfolio that will impress potential employers and help you stand out in the competitive job market.
๐22โค2
Learning Python for data science can be a rewarding experience. Here are some steps you can follow to get started:
1. Learn the Basics of Python: Start by learning the basics of Python programming language such as syntax, data types, functions, loops, and conditional statements. There are many online resources available for free to learn Python.
2. Understand Data Structures and Libraries: Familiarize yourself with data structures like lists, dictionaries, tuples, and sets. Also, learn about popular Python libraries used in data science such as NumPy, Pandas, Matplotlib, and Scikit-learn.
3. Practice with Projects: Start working on small data science projects to apply your knowledge. You can find datasets online to practice your skills and build your portfolio.
4. Take Online Courses: Enroll in online courses specifically tailored for learning Python for data science. Websites like Coursera, Udemy, and DataCamp offer courses on Python programming for data science.
5. Join Data Science Communities: Join online communities and forums like Stack Overflow, Reddit, or Kaggle to connect with other data science enthusiasts and get help with any questions you may have.
6. Read Books: There are many great books available on Python for data science that can help you deepen your understanding of the subject. Some popular books include "Python for Data Analysis" by Wes McKinney and "Data Science from Scratch" by Joel Grus.
7. Practice Regularly: Practice is key to mastering any skill. Make sure to practice regularly and work on real-world data science problems to improve your skills.
Remember that learning Python for data science is a continuous process, so be patient and persistent in your efforts. Good luck!
1. Learn the Basics of Python: Start by learning the basics of Python programming language such as syntax, data types, functions, loops, and conditional statements. There are many online resources available for free to learn Python.
2. Understand Data Structures and Libraries: Familiarize yourself with data structures like lists, dictionaries, tuples, and sets. Also, learn about popular Python libraries used in data science such as NumPy, Pandas, Matplotlib, and Scikit-learn.
3. Practice with Projects: Start working on small data science projects to apply your knowledge. You can find datasets online to practice your skills and build your portfolio.
4. Take Online Courses: Enroll in online courses specifically tailored for learning Python for data science. Websites like Coursera, Udemy, and DataCamp offer courses on Python programming for data science.
5. Join Data Science Communities: Join online communities and forums like Stack Overflow, Reddit, or Kaggle to connect with other data science enthusiasts and get help with any questions you may have.
6. Read Books: There are many great books available on Python for data science that can help you deepen your understanding of the subject. Some popular books include "Python for Data Analysis" by Wes McKinney and "Data Science from Scratch" by Joel Grus.
7. Practice Regularly: Practice is key to mastering any skill. Make sure to practice regularly and work on real-world data science problems to improve your skills.
Remember that learning Python for data science is a continuous process, so be patient and persistent in your efforts. Good luck!
๐15โค5
Here are two amazing SQL Projects for data analytics ๐๐
Calculating Free-to-Paid Conversion Rate with SQL Project
Career Track Analysis with SQL and Tableau Project
Like this post if you need more data analytics projects in the channel ๐
Hope it helps :)
Calculating Free-to-Paid Conversion Rate with SQL Project
Career Track Analysis with SQL and Tableau Project
Like this post if you need more data analytics projects in the channel ๐
Hope it helps :)
๐21โค4
โ
Free Courses with Certificate:
https://t.me/free4unow_backup
โ Best Telegram channels to get free coding & data science resources
https://t.me/addlist/ID95piZJZa0wYzk5
https://t.me/free4unow_backup
โ Best Telegram channels to get free coding & data science resources
https://t.me/addlist/ID95piZJZa0wYzk5
7 Free Kaggle Micro-Courses for Data Science Beginners with Certification
Python
https://www.kaggle.com/learn/python
Pandas
https://www.kaggle.com/learn/pandas
Data visualization
https://www.kaggle.com/learn/data-visualization
Intro to sql
https://www.kaggle.com/learn/intro-to-sql
Advanced Sql
https://www.kaggle.com/learn/advanced-sql
Intro to ML
https://www.kaggle.com/learn/intro-to-machine-learning
Advanced ML
https://www.kaggle.com/learn/intermediate-machine-learning
More data analytics resources
https://t.me/sqlspecialist
Hope it helps :)
Python
https://www.kaggle.com/learn/python
Pandas
https://www.kaggle.com/learn/pandas
Data visualization
https://www.kaggle.com/learn/data-visualization
Intro to sql
https://www.kaggle.com/learn/intro-to-sql
Advanced Sql
https://www.kaggle.com/learn/advanced-sql
Intro to ML
https://www.kaggle.com/learn/intro-to-machine-learning
Advanced ML
https://www.kaggle.com/learn/intermediate-machine-learning
More data analytics resources
https://t.me/sqlspecialist
Hope it helps :)
๐12โค4๐ฅ1
Twitter Sentiment Analysis.zip
2 MB
๐ฆ Datasets name: Twitter Sentiment Analysis
๐นThis is an entity-level sentiment analysis dataset of twitter. Given a message and an entity, the task is to judge the sentiment of the message about the entity. There are three classes in this dataset: Positive, Negative and Neutral. We regard messages that are not relevant to the entity (i.e. Irrelevant) as Neutral
๐นThis is an entity-level sentiment analysis dataset of twitter. Given a message and an entity, the task is to judge the sentiment of the message about the entity. There are three classes in this dataset: Positive, Negative and Neutral. We regard messages that are not relevant to the entity (i.e. Irrelevant) as Neutral
Movie Rating DataSet.zip
1.6 MB
๐ฆ Datasets name: Movie Rating DataSet
๐นThis Data About Movie Voting and their best rating.
This Data have 20 Columns and 4804 Rows. And In this dataset how was the popularity of a movie and their characters and how was the release date of the movie revenue , status , title , movie language , average vote ,id and more..
๐นThis Data About Movie Voting and their best rating.
This Data have 20 Columns and 4804 Rows. And In this dataset how was the popularity of a movie and their characters and how was the release date of the movie revenue , status , title , movie language , average vote ,id and more..
๐12