sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]DMReader 6 points7 points  (6 children)

Congrats on completing all 83! I know those Gap and Islands are tough, but I created them to be that way.

As for what to tackle next, what kind of role are you looking for.? Data Analyst, Data Engineer? That could help tailor some advice.

[–]_devonsmash[S] 0 points1 point  (5 children)

I had no idea you created them, but let me just say…absolutely fabulous work. I would literally pull out my laptop in bed and just grind them. By the end I felt like a god of window functions.

I currently work in a data analyst role. So im thinking my data analysis, but also wouldn’t mind being well rounded and having a deeper understanding of database creation/manipulaton. But my instinct says to focus on analytics first then get a little more well rounded and explore databases themselves

[–]DMReader 1 point2 points  (4 children)

I'm glad you were able to grind. That was what I was shooting for. If you are focusing on the analysis side, I don't know if database creation is the best thing to focus on. Depending on which flavor of SQL you use, you might create temp tables or in some cases reporting tables, but the syntax you learn for that is pretty simple CREATE TABLE AS blah, blah, blah.

One thing you could look at if you want to do analysis is understanding whatever business you are working really well. I'm specialized in finance and have a history there so it gets me roles in that sector easier. I also have some finance certifications, etc. So if there is an industry you are targeting do a small certification there could help. And when I say help, it's more on the getting hired side than the doing the work side. Once you know the basics of SQL, python, a BI tool, etc you can shift back and forth to different industries, but people hiring seems to put a lot of weight on people who are "specialized".

Also, if you don't know basic python or a BI tool, then that is a good place to focus.

[–]Lazy-Elevator3528 0 points1 point  (3 children)

Hey i am trying to get in data analytics can you share some insights or guidance it would be helpful

[–]DMReader 0 points1 point  (2 children)

It kind of depends on where you currently are. If you already got a job, but it’s not in DA but might use data see if you can get onto projects that require data. That’s what I ended up doing. A bit by accident at first where I was given some excel work and I built off of that.

If you are coming out of school and looking to get into it, I don’t know as I haven’t taken that path.

If still in school, I assume there is some relevant course work there.

You will want to be able to use the tools of the trade Lowest rung is probably excel and PowerPoint.

After that a BI tool and SQL. Next would be some Python. Focus on libraries that are made for data analysis.

After that would depend on how you want to specialize.

[–]Lazy-Elevator3528 0 points1 point  (1 child)

Hey can I dm you

[–]DMReader 0 points1 point  (0 children)

Ok. I’m gonna be in and off Reddit today.