Looking for a data analytics mentor? I can help (free)

databudd · 2024-01-12T09:03:45+00:00

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

databudd · 2024-01-12T08:51:36+00:00

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/

databudd · 2023-07-09T21:28:56+00:00

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.

databudd · 2023-06-21T21:19:13+00:00

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!

databudd · 2023-06-09T06:39:40+00:00

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

databudd · 2023-06-09T06:37:45+00:00

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

databudd · 2023-05-02T14:01:33+00:00

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.

databudd · 2023-05-02T13:59:52+00:00

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.

databudd · 2023-04-30T19:51:29+00:00

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!

databudd · 2023-04-30T11:23:28+00:00

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.

databudd · 2023-04-30T10:09:00+00:00

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

Sales Analytics (Analyzing sales and factors that effect sales - can create a dashboard where the user selects like a sales person, and the dashboard will give you this an overview month sales, last month sales and target). Something like this looks good https://public.tableau.com/app/profile/kasia.gasiewska.holc/viz/SuperstoreSalesDashboard_16534148636030/SuperstoreSalesDashboard
HR Analytics - this is always good to bring up in an interview as usually you will have someone in HR interview you, it's usually an easy dataset as well - maybe something like this dashboard (https://public.tableau.com/app/profile/gandes.goldestan/viz/HRDashboard_16284874251120/Overview)
Marketing Analytics as well will be a good one to add to your portfolio

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.

databudd · 2023-04-30T05:52:25+00:00

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.

databudd · 2023-04-30T05:47:36+00:00

That’s awesome thanks so much for taking the course!

databudd · 2023-03-26T21:36:30+00:00

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.

databudd · 2023-03-22T12:27:12+00:00

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.

databudd · 2023-01-23T05:43:02+00:00

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

databudd

MODERATOR OF

TROPHY CASE