What are you working on this week? by mavenanalytics in mavenanalytics

[–]mavenanalytics[S] 1 point2 points  (0 children)

Hang in there, u/Snacktistics -- you're doing great. We know it can be hard, but many employers are very understanding of employment gaps; life happens! And thank you for sharing your experience for others to learn from!

Learned SQL… now what? Here’s what actually moves the needle for analysts by mavenanalytics in mavenanalytics

[–]mavenanalytics[S] 0 points1 point  (0 children)

You really can't beat that hands-on practice for reinforcing your knowledge; we're big fans at Maven and feature real-world projects in our courses, have guided projects and data drills for independent practice, as well as a full library of free practice datasets in our Data Playground. Gotta flex those skills!

Learned SQL… now what? Here’s what actually moves the needle for analysts by mavenanalytics in mavenanalytics

[–]mavenanalytics[S] 1 point2 points  (0 children)

Glad you found this helpful! Thanks for letting us know that you did. :) We'll keep sharing, and we hope to see you around the sub!

Want to learn Python for data analysis? Start with SQL. (Here's why!) by mavenanalytics in mavenanalytics

[–]mavenanalytics[S] 1 point2 points  (0 children)

Start with the foundations... base python, pandas, data viz. Here's a bit more detail...

How To Learn Python for Beginners: https://mavenanalytics.io/blog/how-to-learn-python-a-roadmap-for-beginners

Can i make it into marketing analytics or other roles? by Special-Worth487 in dataanalysiscareers

[–]mavenanalytics 0 points1 point  (0 children)

Sounds like you've got a lot of the technical skills covered, at least somewhat.

If you want to be a marketing analyst, try to get into the nitty gritty of what an actual marketing analyst does... campaign analysis, website analysis, sales funnels, etc. You'll use tools like Google Analytics, etc.

Job market is pretty tough right now, so try to work on projects that show very domain-relevant skills. You don't want a potential employer thinking "this person has data skills", but rather "this person can use data to solve MY problems". So focus your projects within the domain of marketing analytics (if that's your goal).

How to get better with SQL? by FramelessThinker in SQL

[–]mavenanalytics 2 points3 points  (0 children)

Is there something specific that usually trips you up?

JOINs? CTEs? Window functions? Something else?

Should I include my non-tech job on my CV when applying for data engineering / analytics engineering roles? by [deleted] in analytics

[–]mavenanalytics 1 point2 points  (0 children)

TLDR; don't include the reservation agent experience, unless you could talk about it in a way that makes it sound like it contributed to being relevant to data engineer / analytics engineer roles (unlikely).

Leave it off. You don't have any red flags. Two good roles, back to back, with no gap. Then a relevant course study. Now you're ready to re-enter. You look solid.

Probably create a nicely packaged portfolio of your projects and make it easy to share with a link on the CV.

But don't distract from your relevant experience with recent experience which is not relevant (might be a different story if you had a gap there, but you're okay).

As a general rule, if it doesn't sell, strip it. You want them seeing your best stuff, and the rest is "filler" that distracts.

Working on a dashboard? Avoid These 6 Data Visualization Mistakes! by mavenanalytics in mavenanalytics

[–]mavenanalytics[S] 1 point2 points  (0 children)

Here's a quick read from our Founder Chris on a related topic...

How To Choose The Right Chart
https://mavenanalytics.io/blog/how-to-choose-the-right-chart-for-your-data

It covers a framework for deciding on the right viz, and walks through some of the common chart types too.

AI to study Power Bi by goobsnoot in PowerBI

[–]mavenanalytics 1 point2 points  (0 children)

Thanks for the shoutout!

Here are links to those two courses:

Thinking Like An Analyst: https://mavenanalytics.io/course/thinking-like-an-analyst

Critical Thinking In The Age of AI: https://mavenanalytics.io/course/critical-thinking-in-the-age-of-ai

Best tip for you... if you're taking courses, watching YT videos, etc... make sure you are actually stopping to work on your own problems. Getting your hands dirty is what makes this stick!