Made with ♥️ by Lore So What & Datapizza Team

Ciao guys, I’m Lore and with this guide my aim is to remove the fluff and give you the fundamental skills and resources required to start your Data Analytics journey 🚀

The guide is divided into 3 categories of resources, based on the difficulty level:

• Beginner
• Medium
• Expert

This video from my YouTube channel can give you an overview on how to start your Data Analytics Journey from ZERO, especially if you don’t have a technical background (which was my case).

I Became a Data Analyst with ZERO Experience 👉🏻 https://www.youtube.com/watch?v=1WN3-4YIINI

The best beginner course if you are starting out, the most popular and recognized one, which will give you a solid foundation about Data Analytics, without going into much details on the different topics:

🔗 Google Data Analytics Certification 👉🏻 http://imp.i384100.net/1

Before you go into the more advanced resources online, make sure you understand the basics of a data analytics portfolio.

The reason is simple: while you have to start putting concepts into practice so that you can showcase your skills. A certificate is good but a project in your portfolio is what will make you stand out from the crowd…

ALL YOU NEED to build your data analytics portfolio 👉🏻 https://youtu.be/0jIPrbsLCqw

This is the perfect project to start your data analytics journey - no skills required to start, you will just need Excel to give it a go. Also, companies still heavily rely on Excel so, even if it has its limitations, do not overestimate it and get familiar with it before moving to other fancy tools.

Full Project in Excel | Excel Tutorials for Beginners 👉🏻 https://youtu.be/opJgMj1IUrc

Another holistic course that will cover the basics in more details, is the one offered by IBM

🔗 IBM Data Analyst Certification 👉🏻 http://imp.i384100.net/2

🔗 Master Excel 👉🏻 http://imp.i384100.net/4

🔗 Learn SQL Basics 👉🏻 http://imp.i384100.net/5

🔗 Python for Everybody 👉🏻 http://imp.i384100.net/6

🔗 Data Visualization with Tableau 👉🏻 http://imp.i384100.net/7

🔗 Data Visualization with PowerBI 👉🏻 http://imp.i384100.net/8

How I find projects as a Data Analyst 👉🏻 https://www.youtube.com/watch?v=NQSe-SuykJU&t=311s

Give it a go replicating this Tableau project - follow each steps and in less than 20 minutes you will have a new project to add to your portfolio!

The ONLY Data Analytics Portfolio Project You Need - Walkthrough 👉🏻 https://youtu.be/g6cjhUhrhY8

This Excel Tutorial full course will help you to write functions, sort, and filter data, how to import data and split data into multiple columns, learn about sumif and countif functions, and many more functions and formulas available in Microsoft Excel.

Advanced Excel Full Course 2022 | Advanced Excel Functions | MS Excel 19 Training | Simplilearn 👉🏻 https://www.youtube.com/watch?v=RkQl2wVpQAo

As SQL remains the most in-demand skill for data analysts, it is worth it to bring it to the next level. Check out the whole YouTube playlist to bring your SQL to the next level…

Advanced SQL Tutorials 👉🏻 https://www.youtube.com/playlist?list=PLUaB-1hjhk8EBZNL4nx4Otoa5Wb--rEpU

Transform your Data into Stunning Visual 👉🏻 https://youtu.be/SyWDBr_4sgg

A Python project in your portfolio is not essential, but definitely good if you want to show your versatility to more technical data analytics skills that might be required in the work place.

You can easily replicate the following project if you want to challenge yourself…

👉🏻 https://www.youtube.com/watch?v=mOfH1TqaYWM&feature=youtu.be