How To Become A GREAT Data Analyst - 5 Skills And Best Practices For Data Analysts

Рет қаралды 14,261

Күн бұрын

Data analysis is abstract. It is not math (although math is involved) and it is not English or accounting. It requires a hands-on approach to truly understand the pitfalls good analysts will run into.
Yet, most students have not dealt with vague parameters and large data sets by the time they get their first job, which is a shame! Many students haven’t even heard of a data warehouse and this is where most of the data, which helps managers make critical decisions, resides.
In the modern business world, data analysis is not limited to data scientists. It is also key for analysts, system engineers, financial teams, PR, HR, marketing, and so on.
If you enjoyed this video, check out some of my other top videos.
Top Courses For Data Engineers
• Top Courses To Become ...
Data Engineering Project Ideas
• 5 Data Sources for You...
If you want to learn more about machine learning, check out DataCamps Machine Learning Course
bit.ly/3BeLEml
If you'd like to read up on my updates about the data field, then you can sign up for our newsletter here.
seattledataguy.substack.com/
Or check out my blog
www.theseattledataguy.com/
0:00 Intro
2:15 Set Up A Clear Data Analytics Process
4:56 Don't Bury The Lede
6:39 Data Analytics Peer Review
8:51 Triple Check Your Data
11:46 Know When To Stop Your Analysis
13:05 Recap
Tags: Data engineering projects, Data engineer project ideas, data project sources, data analytics project sources, data project portfolio
_____________________________________________________________
Subscribe: / @seattledataguy
_____________________________________________________________
About me:
I have spent my career focused on all forms of data. I have focused on developing algorithms to detect fraud, reduce patient readmission and redesign insurance provider policy to help reduce the overall cost of healthcare. I have also helped develop analytics for marketing and IT operations in order to optimize limited resources such as employees and budget. I privately consult on data science and engineering problems both solo as well as with a company called Acheron Analytics. I have experience both working hands-on with technical problems as well as helping leadership teams develop strategies to maximize their data.
*I do participate in affiliate programs, if a link has an "*" by it, then I may receive a small portion of the proceeds at no extra cost to you.

Пікірлер: 40

@naheliegend5222 2 жыл бұрын

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.

@SeattleDataGuy 2 жыл бұрын

This is very true. Not to mention as soon as you touch anything technical people assume you just know it all.

@Steve211Ucdhihifvshi Жыл бұрын

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.

@gilbi 2 жыл бұрын

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

@SeattleDataGuy 2 жыл бұрын

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.

@DataProfessor 2 жыл бұрын

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.

@SeattleDataGuy 2 жыл бұрын

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.

@subtleteez5619 2 жыл бұрын

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.

@SeattleDataGuy 2 жыл бұрын

Totally agree! As a consultant, its the same. You need to get stakeholders bought in more than anything else

@arghidontknow Жыл бұрын

Great points. Thank you for the helpful tips.

@shikharsaxena8984 2 жыл бұрын

Very useful video for Data analysts, agree with you completely on having a clear scope and objectives for analysis of data 👍🙂

@LukeBarousse 2 жыл бұрын

But what if I just want to be an AVERAGE analyst?!? 🤷🏼‍♂jk Great vid as always Ben; Love the support for data analysts!

@SeattleDataGuy 2 жыл бұрын

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"

@charlesludwig8672 2 жыл бұрын

There will still be a function for you AVG()

@LukeBarousse 2 жыл бұрын

@@charlesludwig8672 🥰

@lukeivanov2327 2 жыл бұрын

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.

@SeattleDataGuy 2 жыл бұрын

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.

@Thahid 2 жыл бұрын

Thanks I wished more people made videos of how to improve the day-to-day work processes. It really makes a difference over time.

@SeattleDataGuy 2 жыл бұрын

Thanks for the comment! Yeah small changes add up!

@ryanhatch4012 Жыл бұрын

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

@aaaa1324 Жыл бұрын

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

@rachelzhang5709 2 жыл бұрын

5:54 you can't lose if you land on 'can we buy pie for the team'

@SeattleDataGuy 2 жыл бұрын

Not at all 🥧🥧🥧🥧🥧🥧

@SeattleDataGuy 2 жыл бұрын

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&

@Arvin_great23 Жыл бұрын

do you need a degree to become a data analyst ?

@SeattleDataGuy Жыл бұрын

Depends on the company, but in most US companies, yes.

@Arvin_great23 Жыл бұрын

I have 6 professional certificates as a data analyst. Do you think I should apply?

@SeattleDataGuy Жыл бұрын

@@Arvin_great23 Always apply! Just make sure your ready for the interview by asking the HR person what you should expect.

@Arvin_great23 Жыл бұрын

Ok. I got 2 certificates from Google

@SeattleDataGuy Жыл бұрын

@@Arvin_great23 Nice what jobs are you applying too!

@MDARUN-ph1dw 2 жыл бұрын

did you trolled him 170000 lol

@SeattleDataGuy 2 жыл бұрын

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.

@northpaul3276 2 жыл бұрын

@@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

@SeattleDataGuy 2 жыл бұрын

@@northpaul3276 That's what I assumed. That's why I wasn't really trolling. I was being pretty honest.

@MDARUN-ph1dw 2 жыл бұрын

@@northpaul3276 👍

@MDARUN-ph1dw 2 жыл бұрын

@@SeattleDataGuy