Learning by Doing: 14 Free Data Analytics Projects with Detailed Video Solutions

From the author of the Telegram channel Analytics and Growth Mind-set. (Subscribe, there are lots of useful resources here for data analysts). Also visit my website growthmindset.dev.

Below are projects focusing on individual data analytics skills. In each video, the authors demonstrate their solutions from start to finish.

Such video guides:

• Help practice independently
• Are suitable if you are a beginner and need an example of what a data analyst does in practice

1. Microsoft Excel:

• Complete project in Excel https://www.youtube.com/watch?v=opJgMj1IUrc
• Interactive dashboard in Excel https://www.youtube.com/watch?v=m13o5aqeCbM

2. SQL:

• Creating a database, analyzing, and retrieving data using SQL, visualizing data in Power BI https://www.youtube.com/watch?v=S2zBHmkRbhY
• From SQL to dashboard https://www.youtube.com/watch?v=oQSX_y2wfhc
• From SQL database to interactive dashboard https://www.youtube.com/watch?v=0rB_memC-dA
• Analyzing AirBnB data using SQL https://www.youtube.com/watch?v=CHb-QvGcRjw
• Sales analysis using Power BI and SQL https://www.youtube.com/playlist?list=PLMfXakCUhXsEUtk8c0zWr4whamGxLhAu0

3. Python:

• Customer segmentation and clustering https://www.youtube.com/watch?v=iwUli5gIcU0
• Exploratory data analysis using Python https://www.youtube.com/watch?v=4sZFkPw87ng
• Economic data analysis project using Python https://www.youtube.com/watch?v=R67XuYc9NQ4

4. Power BI:

• Dashboard in Power BI from start to finish https://www.youtube.com/watch?v=pixlHHe_lNQ

5. Tableau:

• Visualization in Tableau https://www.youtube.com/watch?v=QILNlRvJlfQ

6. Web-scraping:

• Parsing Amazon web pages using Python https://www.youtube.com/watch?v=HiOtQMcI5wg

7. Project from a Google Analytics course:

• Complete analysis project for obtaining a Google certificate https://www.youtube.com/watch?v=JsI71WjM5bo

More projects will be available here.

From the author of the Telegram channel Analytics and Growth Mind-set. Subscribe, there are lots of useful resources here for data analysts. Also visit my website growthmindset.dev.