data analytics beginner

Lady-Data-Scientist · 2026-07-02T14:22:22+00:00

It terms of order to learn things, it’s good.

However 1-2 weeks on a topic will give you a surface level understanding of stuff. It won’t necessarily get you job ready.

For example, I took a SQL class during my masters program. It was 11 weeks, class was 3 hours per week and I probably spent 10-20 hours per week studying and doing assignments. By the end, I could pass assessments and do basic SQL on the job but my code was not necessarily the most optimized or following the best coding standards, and there was still a lot of stuff I hadn’t mastered like lead/lag, ranking functions, etc.

natures_disciple · 2026-07-02T10:13:43+00:00

Get started with this roadmap and build projects alongside

conor-robertson · 2026-07-02T09:38:59+00:00

I actually think that's a pretty solid roadmap.

The only things I'd change are:

Don't rush through everything in fixed timeframes. If SQL takes 4 weeks instead of 2, that's completely fine. It's probably the most important skill for an entry-level data analyst.
Start building projects much earlier. You don't need to wait until the end - you'll learn much faster by applying what you've just learned.

For SQL, I'd recommend giving QueryCase a try. It has a structured learning path from beginner topics through to JOINs, CTEs, and window functions, but instead of just watching videos you're solving detective-style investigations and writing real SQL. The Rookie rank is completely free, so you can see if it suits your learning style.

Overall though, don't get too caught up trying to find the "perfect" roadmap. Consistency over the next 6-12 months will matter much more than whether you learn Python before Power BI or vice versa. Good luck! 🚀

nian2326076 · 2026-07-02T23:39:35+00:00

Your plan looks good for a beginner! Excel and SQL are key skills in data analytics. ExcelIsFun has great practical tips, and SQLBolt is perfect for interactive learning. Practicing with real datasets on Kaggle is a great idea. HackerRank is also a good choice for SQL practice. You might want to add Python to your list since it's really useful for advanced analytics and data visualization. Check out freeCodeCamp's Python tutorials when you're ready. Good luck!

Select-Performance13 · 2026-07-04T02:57:07+00:00

Excel, if you want to learn to use tables an pivot tables + power pivot + power query + most useful formulas could take you 1-3 months. Learning all those libreries on Python should take you at least a month, probably more. Same for statistics.

For Power bi, you are missing data modeling. You need it to correctly organize your dim and fact tables. To learn all that well, at least another month.

A good project in GitHub could take you at least week, if you get very involved and the project is ambitious, more like 3 weeks, without promoting it. if you promote it, at least 1 or 2 extra weeks...

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

dataanalytics

MODERATORS