Resources for Learning Data Analytics in 2024
Hey there 😃
Welcome back!
In this article, I’d be sharing valuable resources you can use to kickstart your data Analytics journey this year. If you are yet to see the data analytics roadmap I curated for beginners alongside the guide I put together to help beginners understand data analytics, click here and here to read them before perusing this list of resources.
This list will cover resources for learning how to work with Microsoft Excel, SQL, Power BI, Tableau, Python, and R as beginners in the field of Data Analytics. Feel free to share with anyone who is in need of this.
PS: this list covers both FREE & PAID resources.
Microsoft Excel
- Data analytics using Microsoft Excel (covers: Basic Introduction to Excel, data cleaning, pivot tables and data visualization). Link: here
- Microsoft Excel formulas and functions. Link: here
- Excel video training from Microsoft. Link: here
SQL
- Learn the basics of SQL and practice alongside. Link: here
- Beginner and Advanced SQL course in one place. Link: here
- Full SQL video tutorial. Link: here
- SQL practice:
- Hackerrank — https://www.hackerrank.com/domains/sql
- Datalemur — https://datalemur.com/sql-tutorial
- SQL Bolt —https://sqlbolt.com/
Power BI
- Power BI Beginner to Intermediate course. Link: here
- Power BI full video course. Link: here
- Complete training (documentation) from Microsoft. Link: here
Tableau
- Complete Tableau bootcamp. Link: here
- Complete video course. Link: here
- Tableau desktop crash course. Link: here
- Tableau BI Analyst Certificate course. Link: here
Python/R
- Highly recommended ✅: Dataquest. Link: here
- R video course. Link: here
- Python video course. Link: here
Data Analysis Bootcamps
- Alex The Analyst (includes prerecorded videos on Excel, SQL, Power BI and Python): here
- Datanex Learning (includes live classes covering Data Analytics with Excel, SQL, Power BI and Python): here
I hope the courses I’ve put together help you achieve your goals faster. For completely FREE courses, click here.
Feel free to share, leave a comment and connect with me on LinkedIn or X.
In my next article, I’d be sharing valuable tips to help you advance progressively in your career as a Data Analyst. See you next week!☺👋
