Theoretically I am a Data Analyst in my company, practically I have to write a lot of code, build models, ETL pipelines and so on. Be aware of , especially in smaller companies, that you have to be a Data Analyst, Data Scientist and Data Engineer at once. They just call it Data Analyst, because so they can pay you less.
Exactly, mine combined all that as well as Oracle netsuite product expert, data entry bitch and fortune teller. As well as being blamed for all the business problems because they have under skilled people in technical roles.
Great insights for becoming a data analyst. Certainly agreed with you about having a clear scope and objectives of an analysis so as to mitigate against a prolong or run-on report that may arise when the scope/objectives are unclear.
Thanks for the comment! Yeah, its really easy for analytical projects and requests to grow and honestly have 0 impact on their original goal because of new questions that have nothing to do with the original goal.
I always tell my analysts to: 1. Check that they don’t fall down the rabbit hole by reviewing the business question and the hypothesis several times mid-analysis. 2. When finalizing the analysis, start with one simple concise sentence of the bottom line of your analysis (a tl;dr) then build your (data) case. 3. Use charts that support your analysis and, for the love of God, highlight the important data point in them to maintain focus. 4. Know your audience, use the terms they are familiar with and don’t use any made-up abbreviations. 5. Honestly, outside of your team, no one really cares what model you use or how accomplished your technical skills are as long as you are confident with your analysis results
I love that last point 5. It's so true, as technical people we like to show off now and again. But like you said, in general, management doesn't care how you save them 1 million dollars...they just care that you can save them 1 million dollars.
You mentioned it once, but personally I feel it is the single most important aspect of all the data roles in a company: The Stakeholder. The great analyst will recognize immediately that the stakeholder is not the IT manager, but the business champion that has sponsored the effort and will align their insights to speak directly to the stakeholder. As for data quality, IMHO, if they ever actually figure out how to clean it up without manual effort, we will all be out of a job ;) Been that way all of my career (30+yrs) and for every step closer to clean, the messier it gets.
If you enjoyed this video, then sign up for my newsletter! seattledataguy.substack.com/ Also if you're looking for a conference on machine learning, the apply() conference is on the 10th! www.applyconf.com/?Seattle_Data_Guy&Referral&
Just because job postings are requiring more technical skills does not mean that new hires will have those skills. A lot of hiring managers don’t know how to write a proper job description and overestimate what a role should have so don’t take job postings seriously.
Totally agree. I poke fun at facebooks job postings because they say you should be well versed in distributed systems..but I was using it more for an example to say that some analysts are becoming more versed in these skills.
As an analyst being given a lot of responsibility early, I found this video at the right time. A process and goal to an analysis/project is definitely necessary. Only realize you should be more concise once you have to explain your findings in a meeting with people unfamiliar with the project lol
I don't know if I meant to troll. I do know some analysts at google that make that much but they are actually closer to DEs. So its a very possible salary.
@@SeattleDataGuy he earned that as a freelancer, and in amsterdam, for context. He could really be doing anything data related (de ds) and marketed himself well probably for this salary
Theoretically I am a Data Analyst in my company, practically I have to write a lot of code, build models, ETL pipelines and so on. Be aware of , especially in smaller companies, that you have to be a Data Analyst, Data Scientist and Data Engineer at once. They just call it Data Analyst, because so they can pay you less.
This is very true. Not to mention as soon as you touch anything technical people assume you just know it all.
Exactly, mine combined all that as well as Oracle netsuite product expert, data entry bitch and fortune teller. As well as being blamed for all the business problems because they have under skilled people in technical roles.
Great insights for becoming a data analyst. Certainly agreed with you about having a clear scope and objectives of an analysis so as to mitigate against a prolong or run-on report that may arise when the scope/objectives are unclear.
Thanks for the comment! Yeah, its really easy for analytical projects and requests to grow and honestly have 0 impact on their original goal because of new questions that have nothing to do with the original goal.
I always tell my analysts to:
1. Check that they don’t fall down the rabbit hole by reviewing the business question and the hypothesis several times mid-analysis.
2. When finalizing the analysis, start with one simple concise sentence of the bottom line of your analysis (a tl;dr) then build your (data) case.
3. Use charts that support your analysis and, for the love of God, highlight the important data point in them to maintain focus.
4. Know your audience, use the terms they are familiar with and don’t use any made-up abbreviations.
5. Honestly, outside of your team, no one really cares what model you use or how accomplished your technical skills are as long as you are confident with your analysis results
I love that last point 5. It's so true, as technical people we like to show off now and again. But like you said, in general, management doesn't care how you save them 1 million dollars...they just care that you can save them 1 million dollars.
You mentioned it once, but personally I feel it is the single most important aspect of all the data roles in a company: The Stakeholder. The great analyst will recognize immediately that the stakeholder is not the IT manager, but the business champion that has sponsored the effort and will align their insights to speak directly to the stakeholder. As for data quality, IMHO, if they ever actually figure out how to clean it up without manual effort, we will all be out of a job ;) Been that way all of my career (30+yrs) and for every step closer to clean, the messier it gets.
Totally agree! As a consultant, its the same. You need to get stakeholders bought in more than anything else
If you enjoyed this video, then sign up for my newsletter! seattledataguy.substack.com/ Also if you're looking for a conference on machine learning, the apply() conference is on the 10th! www.applyconf.com/?Seattle_Data_Guy&Referral&
Thanks I wished more people made videos of how to improve the day-to-day work processes. It really makes a difference over time.
Thanks for the comment! Yeah small changes add up!
Great points. Thank you for the helpful tips.
Very useful video for Data analysts, agree with you completely on having a clear scope and objectives for analysis of data 👍🙂
Just because job postings are requiring more technical skills does not mean that new hires will have those skills. A lot of hiring managers don’t know how to write a proper job description and overestimate what a role should have so don’t take job postings seriously.
Totally agree. I poke fun at facebooks job postings because they say you should be well versed in distributed systems..but I was using it more for an example to say that some analysts are becoming more versed in these skills.
But what if I just want to be an AVERAGE analyst?!? 🤷🏼♂jk
Great vid as always Ben; Love the support for data analysts!
In the words of an old sous chef I worked for - "I mean if you're ok with mediocrity I guess that dish is fine"
There will still be a function for you AVG()
@@charlesludwig8672 🥰
As an analyst being given a lot of responsibility early, I found this video at the right time. A process and goal to an analysis/project is definitely necessary. Only realize you should be more concise once you have to explain your findings in a meeting with people unfamiliar with the project lol
Hi dear, can you use your analysis skills for starting a business? Is it beneficial? Because im willing to complete my master on business analytics
5:54 you can't lose if you land on 'can we buy pie for the team'
Not at all 🥧🥧🥧🥧🥧🥧
do you need a degree to become a data analyst ?
Depends on the company, but in most US companies, yes.
I have 6 professional certificates as a data analyst. Do you think I should apply?
@@Arvin_great23 Always apply! Just make sure your ready for the interview by asking the HR person what you should expect.
Ok. I got 2 certificates from Google
@@Arvin_great23 Nice what jobs are you applying too!
did you trolled him 170000 lol
I don't know if I meant to troll. I do know some analysts at google that make that much but they are actually closer to DEs. So its a very possible salary.
@@SeattleDataGuy he earned that as a freelancer, and in amsterdam, for context. He could really be doing anything data related (de ds) and marketed himself well probably for this salary
@@northpaul3276 That's what I assumed. That's why I wasn't really trolling. I was being pretty honest.
@@northpaul3276 👍
@@SeattleDataGuy