(updated on 3 Apr 2024)
Hello, I'm Katie and I'm sharing with you my personal experience and approach to self-studying for data analytics.
π My Study Approach
- As a visual learner, I prefer watching video tutorials over reading textbooks to better understand how the code works on my screen.
π§ What You Should Know
- Self-studying can be challenging because you are on your own without any syllabus, instructors, or classmates to guide you.
- It requires resourcefulness in finding solutions and troubleshooting errors.
- If time is a constraint, self-study may not be the best option. However, with consistency, hard work, and determination, it is achievable.
Disclaimer: I'm not an expert, just someone who is passionate about data analysis and wants to help others who are transitioning into this field.
Another important note: I'm not sponsored to recommend any of the courses mentioned below.
- How and Where to Start?
- What are the Technical Skills to Learn?
- How to Create a Portfolio on GitHub?
If you're reading this, you're probably interested in starting a career in data analytics, but don't know where to begin or whether it's the right path for you. I totally get it - I was once in your shoes! π§
To start, I recommend taking a general data analytics course, like the Google Data Analytics or the IBM Data Analyst course. I started with Google's course as it was released more recently. I'm not sponsored for both courses.
Both courses provides:
- An overview of data analytics
- An introduction of the skills/tools you need to learn
- Flexible, study-at-your-own-pace courses
- Relatively inexpensive. You can apply for financial aid and study for free.
You can enroll in both courses on Coursera for around USD 20-40/month. I paid USD 39/month for Google's course last year, but a friend recently only paid USD 20+/month.
On average, people complete the course in 2 to 4 months, and the faster you complete it, the less you pay. π
π‘ My Experience
I found Google's course to be very helpful, especially since I'm a visual learner. However, please note that the courses only teach basic Spreadsheet, R, BigQuery (SQL), and Tableau, so you'll need to take additional courses to gain more in-depth knowledge.
- The course claims that you'll learn everything you need to know to be job-ready. That is not true. π₯²
- What you learn from this course is NOT ENOUGH to get an entry-level job or pass a technical interview.
- At most, the course contributed to 5% or less in my learning.
Thus, I'm sharing the following resources to help you continue your studies after completing the course.
In my opinion, you should focus on these three skills in the following order:
- SQL
- Tableau (or Power BI)
- Python & Statistics
I found SQL to be the easiest and most essential skill for any data analyst role. It's a crucial language for extracting, manipulating, and analyzing data. Once you understand SQL, you'll have an easier time learning other tools like Tableau, which relies on SQL for creating calculated fields.
Python is also an essential skill, particularly if you're pursuing a data scientist or data engineer role. However, it's not always a requirement for data analysts. In some companies, it's only a good-to-have skill, while in others, it's a must-have. I recommend becoming proficient in Python if you're planning to pursue a career in these fields.
I highly recommend checking out Alex the Analyst's free data analyst bootcamp on YouTube. Alex is a well-known expert in the data analysis community, and his resources are top-notch.
This bootcamp covers a range of tools, including SQL, Excel, Tableau, Power BI, and Python. It's an excellent resource if you're new to data analytics or want to improve your skills in any of these tools.
In my experience, Alex's instruction has helped me develop my own data analysis skills, and I believe you'll find his bootcamp to be a valuable resource.
π is my tried-and-tested favourite.
- Alex Freberg π
- Basic - A 4-part video series that covers the basics of SQL, including creating tables, inserting data, and querying data - https://www.youtube.com/playlist?list=PLUaB-1hjhk8GT6N5ne2qpf603sF26m2PW
- Intermediate - A 5-part video series that covers more advanced topics, including joins, subqueries, and functions - https://www.youtube.com/playlist?list=PLUaB-1hjhk8HTgPnBukmMq7QTe83ANirL
- Advanced - A 4-part video series that covers advanced SQL topics such as window functions, recursive queries, and common table expressions - https://www.youtube.com/playlist?list=PLUaB-1hjhk8EBZNL4nx4Otoa5Wb--rEpU
- Programming with Mosh π [Beginner] - A 3-hour course that covers the basics of SQL - https://www.youtube.com/watch?v=7S_tz1z_5bA&t=44s
- freeCodeCamp [Beginner] - 4-hour course - https://www.youtube.com/watch?v=HXV3zeQKqGY&t=12282s
- DataLemur SQL Tutorial π [Beginner] - https://datalemur.com/sql-tutorial
- Udacity SQL for Data Analysis π [Free][Beginner] - https://www.udacity.com/course/sql-for-data-analysis--ud198
- Danny Ma SQL Masterclass Course π [Free] - https://github.com/DataWithDanny/sql-masterclass
- Mode SQL Tutorial [Free][Beginner] - https://mode.com/sql-tutorial/
- freeCodeCamp Relational Database Course [Free][Intermediate-Advanced] - https://www.freecodecamp.org/learn/relational-database/
- Maven Analytics SQL for Data Analysis π [Paid][Beginner] - https://www.udemy.com/course/mysql-for-data-analysis/
- Maven Analytics Advanced SQL [Paid][Intermediate-Advanced] - https://www.udemy.com/course/advanced-sql-mysql-for-analytics-business-intelligence/
- SQL Bolt π [Free][Beginner-Intermediate] - https://sqlbolt.com/
- Select Star SQL π [Free][Beginner-Intermediate] - https://selectstarsql.com/
- SQL Zoo [Free][Beginner-Intermediate] - https://sqlzoo.net
- SQL Climber [Free] - https://www.sqlclimber.com/home
- SQL Murder Mystery [Free][Beginner] - Interactive game that teaches you SQL basics by solving a murder case. - https://mystery.knightlab.com/walkthrough.html
- The Schemaverse [Free][Beginner-Intermediate] - The Schemaverse is a space-based strategy game that allows players to write SQL code to control their spaceships and battle other players. - https://schemaverse.com
- SQL Police Department [Free][Beginner] - Online game that allows you to practice your SQL skills by solving a series of crimes. - https://sqlpd.com
- Covid-19 Project (SQL & Tableau) [Free] - In this project, you learn how to use SQL and Tableau to analyze Covid-19 data. - https://www.youtube.com/watch?v=qfyynHBFOsM
- Data Cleaning [Free] - https://www.youtube.com/watch?v=8rO7ztF4NtU&list=PLUaB-1hjhk8H48Pj32z4GZgGWyylqv85f&index=4&t=497s
- 8-Week SQL Challenge π [Free][Intermediate-Advanced] - 8 different SQL projects designed to improve your SQL skills. - https://8weeksqlchallenge.com. (You can check out my Github repo for solutions: https://github.com/katiehuangx/8-Week-SQL-Challenge)
- DataLemur π (I work here!) π [Semi-free][Intermediate-Advanced] - DataLemur offers a database of real-world SQL interview questions, complete with detailed solutions and explanations. - https://datalemur.com
- StrataScratch π [Semi-free][Intermediate-Advanced] - StrataScratch provides a variety of SQL interview questions with explanations and solutions. - https://platform.stratascratch.com/coding?code_type=1
- Ankit Bansal Top 10 SQL Interview Questions - https://www.youtube.com/watch?v=Iv9qBz-cyVA, https://www.youtube.com/playlist?list=PLBTZqjSKn0IeKBQDjLmzisazhqQy4iGkb
These are the most commonly free-to-use SQL softwares. In tech-speak, we call them SQL flavours.
- MySQL (Windows and Mac) - https://www.mysql.com/products/workbench/
- PostgreSQL (Windows and Mac) - https://www.postgresql.org/download/
- Microsoft SQL Server (only on Windows)
Tableau is a business intelligence and data visualization software that allows users to create interactive dashboards and reports. Here are some resources to help you get started:
- Andy Kriebel π - https://www.youtube.com/c/AndyKriebel/featured - A YouTube channel with many helpful Tableau tutorials.
- Alex Freberg's Tableau Tutorials π [Beginner] - https://www.youtube.com/playlist?list=PLUaB-1hjhk8GwbqoVmo_5zuhOa0Tcl3xC
- Codecademy Learn Tableau for Data Visualization [Free][Beginner] - [https://www.codecademy.com/learn/bi-dashboards-with-tableau
- Alex Freberg's Covid-19 Project π - https://www.youtube.com/watch?v=qfyynHBFOsM
- Alex Freberg's Visualisation Project - https://www.youtube.com/watch?v=QILNlRvJlfQ&list=PLUaB-1hjhk8H48Pj32z4GZgGWyylqv85f&index=3&t=14s
- Maven Analytics Monthly Challenges π [Free] - A series of monthly Tableau challenges posted on LinkedIn by Maven Analytics.
A YouTube video on installing Jupyter Notebooks, which is a notebook to code in Python - https://www.youtube.com/watch?v=WUeBzT43JyY
- Programming with Mosh π [Beginner] - https://www.youtube.com/watch?v=_uQrJ0TkZlc&t=8118s
- freeCodeCamp Learn Python [Beginner] - https://www.youtube.com/watch?v=rfscVS0vtbw&t=2565s
- freeCodeCamp Data Analysis with Python [Beginner] - https://www.youtube.com/watch?v=r-uOLxNrNk8
Free
- HarvardX CS50's Introduction to Programming with Python π [Free][Beginner] - https://www.edx.org/course/cs50s-introduction-to-programming-with-python
- Udacity Intro to Data Analysis π [Free][Beginner] - https://www.udacity.com/course/intro-to-data-analysis--ud170
- freeCodeCamp Data Analysis with Python [Free][Beginner-Intermediate] - https://www.freecodecamp.org/learn/data-analysis-with-python/
- WorldQuant University Applied Data Science Lab [Free][Intermediate-Advanced] - https://www.wqu.edu/programs/applied-ds-lab/
Paid
- Maven Analytics Python Foundations for Data Analysis π [Paid][Beginner] - https://www.udemy.com/course/python-foundations-for-data-analysis/
- Maven Analytics Data Analysis with Python: NumPy & Pandas π [Paid] - https://www.udemy.com/course/python-pandas/
- Maven Analytics Data Visualization with Matplotlib & Seaborn π [Paid] - https://www.udemy.com/course/python-data-visualization-matplotlib-seaborn/
- Khuyen Tran's Efficient Python Tricks and Tools for Data Scientists [Intermediate][Free] - https://khuyentran1401.github.io/Efficient_Python_tricks_and_tools_for_data_scientists/README.html
- Python for Data Analysis - https://www.oreilly.com/library/view/python-for-data/9781449323592/
- Amazon Web Scrapping [Guided][Intermediate] - https://www.youtube.com/watch?v=HiOtQMcI5wg&list=PLUaB-1hjhk8H48Pj32z4GZgGWyylqv85f&index=7&t=510s
- Automation Crypto Website using API [Guided][Intermediate] - https://www.youtube.com/watch?v=KB2CtEDrglY&list=PLUaB-1hjhk8H48Pj32z4GZgGWyylqv85f&index=10
- freeCodeCamp Projects [Unguided][Intermediate] - https://www.freecodecamp.org/learn/data-analysis-with-python/
- WorldQuant University Applied Data Science Lab [Free][Guided][Intermediate-Advanced] - https://www.wqu.edu/programs/applied-ds-lab/
- StatQuest with Josh Starmer Statistics Fundamentals π - https://www.youtube.com/playlist?list=PLblh5JKOoLUK0FLuzwntyYI10UQFUhsY9
- Khan Academy Statistics & Probability [Free][Beginner] - https://www.khanacademy.org/math/statistics-probability 2 Codecademy Probability [Free][Beginner] - https://www.codecademy.com/learn/probability-mssp
Looking to showcase your coding projects and skills to potential employers or clients? Creating a portfolio on GitHub is a great way to do so.
Check out this guide on how to create a portfolio on GitHub: https://github.com/katiehuangx/How-to-Create-a-GitHub-Portfolio/blob/main/README.md
You can also refer to my portfolio for inspiration on structure and content.
If you find this guide helpful, give me a π! (simply click on the Star button on the top right of this page)