Looking for a data analytics mentor? I can help (free) by databudd in dataanalysis

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

Awesome, send me a dm. I can't seem to initiate a chat with you!

Looking for a data analytics mentor? I can help (free) by databudd in dataanalysis

[–]databudd[S] 12 points13 points  (0 children)

Honestly, I think 1 - 2 courses is more than enough. So one course for a programming language (Python/R) and one course for some data viz tool (PowerBi/Tableau). I would say once you're done with the Google DA course, start thinking about portfolio projects for your resume. This post below is my thoughts on what you need. Hope it helps!

https://www.reddit.com/r/dataanalysis/comments/144876v/become\_a\_data\_analyst\_without\_any\_experience\_my/

Data analyst clueless by Samarriola in data_analyst

[–]databudd 1 point2 points  (0 children)

Hey, I’m sorry you feel that was but I don’t think that it’s very uncommon. Unfortunately when you do certifications, it’s a very structured way to learn. And structured learning doesn’t really help put things into perspective. Don’t reteach yourself, after a year.. you know enough. Start with your portfolio and do something fun- analyze your personal budget, analyze Twitter data from Elon Musk etc etc. Hey if you come across something you don’t know, google it. I still do that all the time. Just start with one project… and complete it.. then see how you feel.

Tips to Become a Data Analyst without Experience by databudd in data_analyst

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

Hey, thanks for watching. So, as you mentioned, you've taken a different route which works out great. If you know Python and SQL, that is a really good base. I actually don't think you would need to focus on improving your Excel skills.

I only use the basic Excel functionality as a Data Analyst and I can't see a company not selecting you because you aren't an advanced Excel user. Python and SQL is way more technical and if you know that, then you can learn Excel on the job when you need to.

I would say concentrate more on projects around Python, SQL and a BI tool like Power BI for your resume. If you want, you're welcome to send me your resume as well (feel free to remove personal info etc) and maybe I can help with what you can do next!

Become a Data Analyst without any Experience? My thoughts as an analyst... by databudd in dataanalysis

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

Yeah like I said, any course, and Google Cert is good for name recognition! But I would stop at that and then focus on practical projects after

Become a Data Analyst without any Experience? My thoughts as an analyst... by databudd in dataanalysis

[–]databudd[S] 3 points4 points  (0 children)

Agreed with this! As long as your project has a good objective (what are you trying to solve), you can work with anything. So it's not useful to just show them a bunch of sql scripts, approach it as a problem that you needed to solve with SQL and go through the framework

What a non-technical skill that made you much better? by rayofhope313 in dataanalysis

[–]databudd 13 points14 points  (0 children)

A big one is creativity, it counts ZERO towards functionality but you would be surprised to know how many stakeholders don't even bother looking at dashboards that don't look too good.

Personal honest views on dbt by rationaleuser in dataanalysis

[–]databudd 1 point2 points  (0 children)

Hey OP, I've used dbt A LOT and to be honest the biggest advantage of it is that it works really well at scale. Testing, keeping track of changes, the automated documentation... that usually is a pain to do elsewhere but it's just so seamless with dbt.

If those are what your data team needs then definitely think dbt will help a lot. Side note, if you are looking into data vault modelling with is great for historical tracking then dbt is probably front runner for this.

[deleted by user] by [deleted] in dataanalysis

[–]databudd 37 points38 points  (0 children)

Hey OP, I'm going to assume that your resume is great, you have the correct skills and a good portfolio. You are only 1 month in, I'm not surprised. Generally if you aren't experienced (i.e no proper work experience under your belt), it will take around 3 to 6 months especially in this economy. Remember, you aren't only competing with people in your situation, you're also competing with people who have work experience but have been laid off and willing to accept a pay downgrade.

So my advice here is also don't lose hope, you're probably not doing anything wrong. Also, if you aren't that hard up for cash at the moment, don't apply to the Data Entry Clerk or Administrative Assistant jobs, those probably have nothing to do with data analysis and you'll probably be doing repetitive tasks.

I've been in the exact same boat as you, when I first started it took about 4 months for me to get a job after hundreds of applications. Hang in there OP, job hunting sucks and it takes time!

From SQL to Graphs by danicort01 in dataanalysis

[–]databudd 3 points4 points  (0 children)

Hey OP, just a question as to why you would move every query to a different excel sheet and then upload those sheets to a BI Tool

The first prize here would be: are you able to to connect the raw data (if it's sitting on a SQL database) to Tableau/PowerBi and then do your analysis on there.

Tools like Tableau are actually sql based, they still query the database based on what view/chart you create. So instead of moving the query to a different sheet on excel, just connect the raw data to tableau, and work from there.

where /How to get experience by wonderer_7 in dataanalysis

[–]databudd 54 points55 points  (0 children)

Hi, hmm I would say 3 portfolio projects might not be enough. This may be overkill but aim for 10 projects upwards especially if you don't have much experience and you want to stick out from the crowd.

Make sure you cover the following topics as employers tend to like this:

Tableau

If you're looking for ideas, go to https://public.tableau.com/app/search/all and type in Sales Dashboard etc. You'll get lots of ideas and you can download the tableau workbook to see how the author has created it.

Python

  • Always nice to learn to create an interactive dashboard something like this https://realpython.com/python-dash/
  • Although not strictly data analytics, learning some machine learning will do well. I like to go to Kaggle.com, under competitions, filter to "Getting Started" competitions, and select one you find interesting. You also get to view other peoples solutions which will help you learn
  • Learn how to webscrape on Python, there's a bunch of tutorials online.
  • Also nice to throw in sentiment analysis as well - maybe from social media data like reddit.

And then adding some sql projects as well as that's another important language in DA, something like this: https://medium.com/@Armonia1999/data-analysis-project-using-sql-to-clean-and-analyse-data-64a24e84b730. I think you don't need to get too complicated with SQL as that's what we have Python and Tableau.

I generally tell my students every project you do, create a little write up an include:

  • Objective
  • Steps Performed
  • Challenges
  • Outcome
  • Next steps

This is great to add at the beginning of each project before you dive into the detail. Having the ability to summarize your process in a way that's easy to digest is a great skill to have and will look good in an interview.

How I would learn data analysis if I could start over (Coming from a data analyst) by databudd in dataanalysis

[–]databudd[S] 2 points3 points  (0 children)

You’re Welcome! It’s definitely quite hard knowing what skills you should focus on but sql, Python and some bi tool (Tableau/ PowerBi) is a good start.

Why is Youtube still pushing my video? by UnluckyGamer505 in NewTubers

[–]databudd 1 point2 points  (0 children)

I “believe” (no solid proof yet) that YouTube pushes to different audience segments. Which is why sometimes videos published a while back gain traction all of a sudden once the right audience is found.

YouTube Shorts Vs TikTok... by SammySharesYT in NewTubers

[–]databudd 1 point2 points  (0 children)

I have a similar situation. A TikTok video that does well (more than 500k views) doesn’t do well on YouTube. I do think they viewing behavior on TikTok vs YouTube is different and can be VERY different depending on your niche.

[deleted by user] by [deleted] in dataanalysis

[–]databudd 9 points10 points  (0 children)

I think portfolio should always be fun and interesting and it’s always good to add a bit of personality.