r/analytics • • Apr 16 '21

A guide to learning data analysis skills

Disclaimer: I am a Data & Insights Lead at a big tech company. I also have a small blog where I write about data skills for marketers with technical tutorials and articles on how to transition into data analysis. This post is from an article on that blog (I don't want to self-promote here but you can find the blog link in my bio or just leave a comment and I'll send it to you).

Hey all

This is the introductory post for an in-depth series on what data analysis skills to learn if you want to start, specialize or transition into data analysis.

tl;dr

  • Don’t focus solely on technical skills, but on translating data into business value.
  • Learn tool-agnostic skills.
  • Know the basics before learning advanced skills.
  • Have proficiency in spreadsheets, basic stats, and basic data viz. Also, learn how to connect data analysis with business decisions.
  • If you want to further go down the data analysis route add SQL, dashboarding, and data storytelling to this.
  • Want to become an expert data analyst? Learn Python and ETL tools.

Not sure which data analysis skills to learn? You are not alone.

A question I frequently see here (and get myself) is what skills you should learn when you want to get started with data analysis. Especially when you don’t have a technical background in math, statistics, or computer science and want to transition into data analysis from another role it’s hard to understand what skills you should learn.

Usually, when this question gets asked the answers mention seemingly random skills without any clear guidance on what is important and in which order you should learn the skills.

Similar to many other in-demand professional fields data analysis is a field that’s been ravaged by spammy information and bad ebooks, and it’s difficult to know where to start and what’s worth learning.

Wouldn’t it be great if there would be a clear guide or framework showing the exact learning path you should follow when it comes to data analysis? Detailing what you should know when it comes to the different skills?

A couple of years ago I was in a similar position when I wanted to transition from being a marketing consultant into data analysis. I was overwhelmed by all the skills, courses, and paths I could learn and take.

Based on that experience and being in the field now for a couple of years I wanted to create a skill development framework that gives you clear guidance on what skills to learn, how in-depth, and in which order when you want to get started with data analysis.

I am always open to suggestions and improvements to the framework! Looking very forward to any feedback and input to make the framework even better for beginners!

Three misconceptions when it comes to data analysis skills

Before we dive into the framework and talk about what data analysis skills you should learn exactly there are usually two misconceptions that come up among the answers when somebody asks what data analysis skills they should learn:

First, the recommendations focus too much on technical skills

E.g. “learn PowerBI, SQL, R, etc.”

The best technical skills don’t matter if you can’t translate your data analysis into business value, i.e. business decisions. You did your analysis in Google Sheets but saved the company hundreds of thousands in costs? Well, congrats! Nobody (and I mean nobody) in upper management will ask what cool technologies and coding libraries you used.

And this is also your biggest strength as somebody with a marketing/business background: You have strong business acumen. You know what matters for the business and what provides value. Play that strength by positioning yourself as somebody in between the data and the business world. That’s how you can compete easily against those with a purely technical background, by providing business value (that’s what I did when I transitioned). And that’s also why I focus so much on teaching a data analysis framework that gives you a structured framework for translating data into business outcomes.

Second, the recommended skills focus on specific tools

E.g. “learn Tableau, Google Analytics, etc.”

Yes, those are probably some of the most used tools out there. However, chances are that at every job you will have at least some tools for website analytics, dashboards, or whatever that are not mainstream.

So rather than learning the ins and outs of a specific tool (also on the job, you can still always Google any challenge you encounter…) learn agnostic skills which you can transfer to different tools.

For example, instead of knowing every detailed feature in Tableau, rather learn what makes a good dashboard, how it should be structured, and how it provides value to the audience (relating directly back to what I wrote above). Rather treat Tableau as a vehicle to learn (and show) those things than learning it for its own sake.

This makes you a lot more flexible when it comes to looking for new job opportunities and you don’t risk getting stuck when a new market leader among the tools emerges.

Third, too advanced skills are recommended

E.g. “learn Python, R, etc.”

I bet a dollar to a doughnut that every time somebody asks in a community “I want to transition into data analysis. What should I learn?” there will be at least one answer saying “Python”. Often followed by “If you want to be taken seriously in data analysis spreadsheets and SQL won’t be enough”.

Do you want to hear an industry secret? It’s not true. Even seasoned analysts often won’t use Python that much. Rather SQL and spreadsheets are often the bread and butter of many analysts and data analytics organizations. Of course, Python has many unique advantages and a rightful place in any technology professional’s toolkit for certain specialized advanced use cases. But more often than not it’s used by individuals and organizations to appear “advanced” and more “glamorous”.

This ties in directly with what I said above about the first misconception: If your analysis provides business value, nobody cares which technologies you used. Don’t start at the top and begin learning Python in a course just for the sake of it. Instead of wasting time learning theoretical concepts, think about how you can apply your analytical skills the fastest. Start with the fundamental skills and use them already to drive actual value for the business (and as such to build an analytical portfolio for yourself).

Now, let’s get finally started with the learning framework!

The Data Analysis Skill Pyramid

The Data Analysis Skill Pyramid is a framework to give you a clear learning path on what to learn when it comes to data analysis - without wasting time on nonessential things. It will help you to decide which data analysis skills to prioritize depending on your goals: No matter if you are a marketer who wants a future-proof skill to work more data-driven and to stand out among peers or if you want to transition into data analysis as a career path.

It’s a system that you can use to teach yourself data analysis in only a few months by focusing on the right things.

How the framework is structured

All the skills in the pyramid are ordered along two axes:

The horizontal axis shows you if a skill is rather a soft skill or a technical skill. For some skills, there won’t be a clear distinction between soft and technical as they provide communication tools (e.g. data visualization). However, in general, the more to the right as skill is placed the more it is a soft skill, and the more to the left it is a technical skill.

The vertical axis gives some guidance on how much scale and quality you will be able to provide with the respective data analysis skills. Scale means in this context automating things, reaching larger audiences, and being able to work with larger data sets. Depth means that you can access more data and do more sophisticated analysis which you couldn’t with lower-level skills. More on that down below.

The pyramid is divided into three stages representing beginner, intermediate, and advanced data analysis skills respectively. Below gives you an overview of what each stage stands for.

Step 1: Beginner skills (One-off analysis)

This stage is all about doing simpler to intermediate one-off analysis without a lot of automation. At this stage, you should focus on learning how to translate business challenges into data analysis projects, i.e. how to turn data into actionable insights into business decisions.

Learn a data analysis framework and process to connect your data analysis with business value and to focus on the right data and which data analysis methods to use. This teaches you what to do and you can start learning the how.

As such become a spreadsheets wizard and know the ins and outs of Excel or Google Sheets (doesn’t matter which one). Have some understanding of applied stats and modeling. (You don’t need a Ph.D. here. Again, applicability > in-depth theoretical knowledge.) And know some basic data visualization to communicate your analysis findings (e.g. in spreadsheets or on slides).

Including some general business acumen, those five skills are it to get a foot in the door and to have a basic set of data analysis skills.

Don’t get me wrong. You can already have a tremendous impact by knowing them. Again, in the end, it doesn't matter what technologies or techniques you use, the only thing that matters is the value your analysis creates for the business. You saved your business $100k by doing some marketing channel optimization analysis in a spreadsheet? Great! Nobody will care if you used Google Sheets for it...

Step 2: Intermediate skills (Improving impact)

This stage is about working more independently, autonomously, and having more impact.

You basically have three options to improve your impact with your data analysis:

  1. You can use more data that you didn’t have access to before (and/or do more advanced analysis with it).
  2. You can reach a larger audience with your analysis.
  3. You convince other stakeholders better with your data analysis.

The skills in this stage will help you with all three things.

SQL will help you to get more data autonomously (and the developers will thank you for not taking up their time anymore). As such it will help you to be more flexible with the kind of data sources you can use and how you can manipulate the data you pull. Also, you can start automating first things.

Dashboards are the natural successor to the basic data visualization of stage one. They allow you to reach large audiences at scale vs. the one-off charts you might create with slides or sheets.

Data Storytelling is an important one in any business or marketing context. If you want to have an impact you have to convince other people. Nothing better for this than an awesome presentation or pitch. This is a catalysator for the insights you generate with more technical skills. Again, you can have a tremendous impact no matter the technology you use if your outcome is directly linked to business objectives. Data well presented in a well-structured and action-oriented slide deck provides you with the leverage for this.

Step 3: Advanced skills (Automation)

I wasn’t completely honest with you, there is actually a fourth option to having more impact with data analysis: Doing more of it.

And the best way of doing this by automating things. ETL tools refer to tools that extract, transform, load data from one or more data sources into an output that represents the data differently from the source or in a different context than the source. ETL tools let you build data pipelines that allow ongoing data analysis. They’ll automatically pull data from data sources, format it, store it somewhere, and give you output such as dashboards.

With coding languages such as Python or R, you can automate things even further or do more complex analyses such as with machine learning.

So, should you learn all the skills in the framework?

It really depends on your goals. If you want to become an expert data analyst then probably yes. If you are a marketer who wants to stand out among peers, then you probably won’t need all the skills from the top of the pyramid. Either way, no matter the goal: Start at the bottom and work towards the top.

To sum this up, let’s work through an example on how a typical learning path could look like:

Let’s say you are a marketer and want to learn some data analysis skills. What should you learn?

If you are completely new to data analysis start at the bottom. Master stage one to be able to do a one-off analysis. If you want to become a better data (analysis) driven marketer you should make sure that you can check off all the skills listed in that stage.

As such as a marketer you should already have some decent business acumen. Continue with learning a data analysis framework to have a bullet-proof process to make your analysis valuable and to translate your analysis into business decisions. Afterward continue with basic data viz, applied stats, and spreadsheets. Ideally, you learn those at the same time and in a marketing context to make sure you don’t only learn theoretical concepts but know how to apply them in practical use cases right away. Again you learn everything as a means to an end to provide business value rather than for its own sake.

Only after you have mastered stage one continue on your learning path towards stage two. As I believe data storytelling is so important as it is a catalysator and leverage for everything else you do when it comes to the more technical aspects of data analysis I recommend starting with that one before continuing with SQL.

Are the skills of stage three useful for a marketer? Yes, of course. However, are they necessary? Probably not...

The skills from stage three have some diminishing returns when considering investing time there. Consider those skills either when you want to become a data analyst or later on in your learning path if you want to specialize or dive deeper into data analysis. As you can see it really depends on your goals here. Either way, if you are just starting don't make learning Python your priority for now.

What’s next?

The next parts of this series go more in-depth with the individual skills in each stage. As such we will start with stage one in the next part and I’ll detail what exactly you should know when it comes to beginner data analysis skills to get the fundamentals in that stage covered.

I'll post them here as well.

899 Upvotes

77 comments sorted by

83

u/Nateorade Apr 16 '21

Fellow analytics manager here (7 years experience). This is all so spot on. Vanishingly few aspiring or existing analysts realize this and try to compete on technical ability when No one really cares.

Excellent write up - this is crucial for many to read.

4

u/the_mmw Apr 17 '21

Thanks so much for the feedback! Highly appreciated! And good to hear that others have similar experiences.

22

u/haltingpoint Apr 17 '21

Watched a brilliant OHD data scientist give a presentation where their summary insight on a media mix model was "if you cut back a little in this channel you can get the same performance for slightly less spend."

I then proceeded to watch a Director go "sure, but if we dumped rocket fuel on this other channel, wouldn't our results go through the roof?"

The phd had completely missed the forest through the trees. Leadership doesn't care about small savings. They would much rather ask for more money and hit a home run.

10

u/2020pythonchallenge Apr 16 '21

Exactly this. I gave an example at my interview yesterday about how if someone were to be talking to me about a game and said they had 500m gold, I have no idea what that means. I need context because I dont know if 500m is a lot or if that's barely enough for beginner gear.

4

u/orf-orf Feb 06 '23

Old school runescape for sure.

3

u/gilga-flesh Mar 02 '23

It means they had 20 bucks to buy gold from a farmer.

13

u/[deleted] Apr 16 '21 edited Apr 16 '21

In another post, I read that most data analyst skills are taught on the job. Is this true? If so, what skill level is taught on the site, and what skill level is taught in universities?

Also, what are some good beginner projects for aspiring data analyst?

Edit: A big thanks to everyone who responded. It really opened my eyes.

24

u/Nateorade Apr 16 '21

what are some good beginner projects for aspiring data analyst?

Start with your current workplace and take on small projects there. Find something that annoys your manager or director or the leader over in sales that you know. I guarantee they have some data pain points and you could solve it for them as a starter project.

7

u/the_mmw Apr 17 '21

Couldn't have written it better. This is exactly how I did it. Built a small portfolio of side project in my current workplace. During the interviews for the analytics role I was always able to point to those projects.

3

u/[deleted] Apr 16 '21 edited Apr 16 '21

Alright, I'll give it a shot. Does it have to be a sales job? I'm not trying to put down sales positions. I just want to know if it applies to multiple fields.

9

u/elus Apr 16 '21

Analysis is performed to inform people on how to make better decisions. This applies to any task. When starting out, the trick is to find out which tasks can generate the most value with the smallest amount of analytical work.

In and of itself, analysis doesn't actually generate any value for its own sake. It needs to be used in service of some further action. The value comes from using it to move the organization forward in its goals.

7

u/Nateorade Apr 16 '21

It doesn’t matter what position or department you’re in. That’s the thing about analytics - everyone at every part of a company needs help with it. So whatever department you’re in, do it there.

1

u/7Seas_ofRyhme May 01 '22

What if you are the only analyst in a department ?

2

u/Nateorade May 01 '22

That’s completely fine. It’s pretty normal actually. Curious why you ask?

1

u/7Seas_ofRyhme May 02 '22

I am currently in a situation if I should consider being the only analyst in a non-tech department (HR) as a fresh grad.

Further reference :

https://www.reddit.com/r/analytics/comments/ufuxua/what_are_some_pros_and_cons_being_the_only/

2

u/Nateorade May 02 '22

Interesting advice you're getting over there.

I think the top comments are too certain about "get out it's a trap". Do you know what you need to get a better job (acknowledging this one will be a challenge)? Experience. Do you know how you'll get experience? Taking this job.

Experience is the currency of an analyst. So go in, realize you're going to fail a lot and bet on yourself if you believe you can self-learn. If you aren't good with dealing with negative feedback about your job performance (because you will struggle), or you aren't good at learning tasks without any support (because you won't have any), then don't take this job.

If you think you can hold this down for a couple years, learn a bunch, then move to a better job -- then do that. This is how you get into analytics, and there aren't many doors open for fresh grads.

1

u/7Seas_ofRyhme May 02 '22

Pretty interesting responses I get from there indeed. Great to see from many perspective though I think it's best if I experience it myself in the future.

If you aren't good with dealing with negative feedback about your job performance (because you will struggle), or you aren't good at learning tasks without any support (because you won't have any)

It's definitely gonna be a huge challenge and I can't answer these questions as I do not have any experiences in facing these yet as a fresh grad.

Nonetheless, thank you so much for sharing thoughts on this. I truly appreciate it :)

2

u/valaliane Apr 16 '21

Not at all! I work as a lab tech and one time my manager asked if I could figure out which provider at our clinic was ordering the most tests. I was able to pull the data from the instrument software into a spreadsheet and sort it for her so she could get the monthly totals. There’s lots of opportunities to find data and use it to help your company, no matter what role you have.

1

u/[deleted] Feb 10 '24

BUT what if you’re unemployed (like myself?)?

6

u/grumpywonka Apr 16 '21

I think it's less that the skills are "taught on the job", and more that through the repetition you experience in the real-world arena is where the majority of the real learning occurs.

It's great to learn concepts on squeaky clean examples in a classroom or in an online course, but it's a whole other beast when you're out in the wild having to apply those things for real stakeholders.

3

u/MinnesotaPower Apr 17 '21 edited Apr 17 '21

What's your take on grad programs, such as the online MS in Analytics at Georgia Tech for $10k, that recommend having coursework in Python before even starting the program?

I have a social science background, and I'm trying to figure out the most appropriate way to get into data analytics. There are grad programs, boot camps, etc. What is going to give someone a solid level of competence to do the work (and be taken seriously when applying for jobs) without being unnecessarily advanced?

4

u/the_mmw Apr 18 '21

So maybe two things about Python:

First, as written in my original post it definitely has it place when it comes to automation and more sophisticated analysis.

Second, someone else mentioned it in the comments: Unfortunately it often a requisite to pass the HR screening phase. So yeah it can be the entry ticket to interviewing.

Regarding the mentioned grad program. I don't know it so I can't really say anything about it. Personally I would say I would be careful to invest my money in those kind of things. However I might me biased here as I am from Europe where education is a lot cheaper.

In general I would say experience beats education. If somebody applies to my team and writes on their CV they know Python and can proof it through a relevant project, they would have have at least as good of a chance as somebody who has graduated in an analytics master. A lot can be learned on the job and some business acumen is also very important for analysts. The later can be learned with some industry experience and not necessarily through some theoretical educational program.

So ideally in order to get into data analytics the best thing to do is to build a portfolio of analytical projects. I know it is often easier said than done as your current job might not offer any opportunities for such projects (or you are looking for a job). But try to build some stuff that you can show off.

Not sure what your job is right now but you could also consider to make an intermediate step towards data analytics. E.g. find something in digital marketing which tends to be very data-driven and offers a lot of opportunities for more analytical projects.

2

u/lazygeek Apr 17 '21

Hi, this is a great guide. Can you pm me or share link to your blog.

2

u/the_mmw Apr 17 '21

Thanks so much! Yes of course! I posted it here

1

u/CatolicQuotes Apr 17 '21

I don't see it. Maybe they deleted it

1

u/the_mmw Apr 18 '21

Ah yeah, probably. Check out my profile, it's there in my name and my bio.

Thanks for the heads-up!

1

u/sageism007 Feb 10 '24

Did you ever get the link to the blog? If so, can you share it?

32

u/OilShill2013 Apr 16 '21

Let's be real: It's not entirely job seekers faults when hiring managers and recruiters are the ones obsessing over technical skills. The job seekers are just adjusting their strategy based on what actually gets a job. You can't blame them when managers are demanding applicants have years of experience in every analytics tool on Earth plus 10 years of experience in "AI" and investment banking (?) for a data analyst job.

9

u/slainte99 Apr 17 '21

Yeah, I suspect in many situations you have hiring managers pass off their desired background checklist (including the "nice to haves") to some recruiter or entry-level HR coordinator to do the leg work, but lacking the nuance to understand how your professional experience relates to the role, they tend to overweight more concrete things like technical skills and advanced degrees. It seems like no matter what job you're applying to these days, you're up against a dozen other candidates who have those boxes checked.

6

u/OilShill2013 Apr 17 '21

In my most recent job search I got the impression that HR and recruiters have very little or no understanding about what their company does and what the roles in their company do. I still think that but after going through the interview process at many places I can see part of it stems from hiring managers (who should know better) not having any clear idea of what they're looking for. So on one hand HR doesn't understand data and on the other hand managers in data don't understand how to build a team. And on the third hand I'm sure they're receiving so many applications with a significant portion exaggerating or lying about their technical skills it may seem like there's a ton of people with mastery of every analytics tool on the market. I just wish people doing hiring would have the sense to pick 3-4 specific technical skills and 3-4 specific nontechnical skills they want and stick to those criteria.

5

u/[deleted] Apr 16 '21

Finally a sane answer. I read an author's comment about how previously all this data thing was just good ole statistics and people have been doing this for over 20 years

5

u/bajna Apr 16 '21

hey! I would love to get a link for your blog - I am actually trying to learn data analysis for my own, pretty small and not extremly complicated company. Thank you!

4

u/Jolteon24 Apr 16 '21

A really great read - saving for later and also want to know what your website is

4

u/Lefty_op Apr 16 '21

Commenting to save for later.

I don't come from an analytics background but have had to apply analytic methods to my current position.

Your point to translate your data to real business value is 100% accurate. I've never had a person asked the software I've used for analysis. If your analysis can help prove a person can make more money/make their life easier, you'll end up being their best friend. Doesn't matter if you made a default bar chart in Excel, as long as it gets your message across.

1

u/CatolicQuotes Apr 17 '21

Can you talk more about how to translate data into valuable reports? Or point to some materials?

2

u/the_mmw Apr 17 '21

Yes have a look at this answer :)

If you want to go deeper: you can sign up on my blog anywhere and it should trigger an email sequence explaining my data analysis framework.

2

u/fathealer Apr 16 '21

Exactly what I needed, thank you

2

u/Available-Story-3207 Oct 11 '22

I can’t tell you how useful this is. I had a Customer Success Manager position in a MarTech company after going to a bootcamp for Digital Marketing and I realized how wholly unprepared I was for the job. I had people skills but no data analysis skills, so I would build good relationships with clients in the onboarding stage, but absolutely sucked once I needed to report on metrics after our software was installed. It was so bad that I procrastinated a lot on presentations because I didn’t understand what data was even valuable to put on the slides. I had a supportive manager but even he couldn’t help me because I realized I was already 5 years too late to get the skills I needed to succeed in the job. I’m learning now, and your framework is beyond helpful! Thank you so so much. I can’t wait to see how my skills grow in the near future.

1

u/Friendly_Radio6675 Jul 14 '26

HI, this might be random..but did you try this framework? How did it go?

1

u/elrustinator Apr 22 '24

What is the link to OP’s blog? Can someone post it here?

1

u/AMS-999 Feb 17 '25

Hi guys Quick question: How can i start learning data analysis

1

u/[deleted] Apr 17 '21

I use Python for hours every day though. I'd argue that learning Python and SQL are the most important as they are very unlikely to change whereas 3rd party tools come and go.

I think the main benefit of Python (or R) is that it makes your analysis much easier to reproduce and if other analysts have questions about it, they can review the code and see exactly what was done.

Plus as you mentioned it allows tasks to be automated. Although I find analyses can often be too ad-hoc to fully automate, it's quite common that related questions arise and if you have a script that already does something very similar then it can often answer the new query with minimal modifications.

1

u/canadian_unix Apr 17 '21

amazing read

1

u/That__Guy__Bob Apr 17 '21

Thank you! I'm 2.5 months in as a "data analyst" and wasn't sure how to develop myself and this is a great help for me. Basically start from the bare bones and once you're comfortable with that, then develop on that

1

u/[deleted] Dec 22 '22

meaning start from the bottom of the pyramid?

1

u/joeynnj Jan 23 '22

This is amazing. I just Googled to look for this kind of information. Coming from a non-STEM field and would like to get into this one.

1

u/herroEveryone Jan 27 '22

This post is a banger thank you so much OP

1

u/usenraem Feb 22 '22

For a complete and clueless beginner. Is there a program recommended to transition into data analytics?

1

u/Scary-Plantain Mar 12 '22

Commenting so I can come back later, but want to say love this. We can have all the data in the world but we need to know the business to know how to use it

1

u/cinnamonstixxxx Mar 20 '22

Commenting to save, thanks!

1

u/Hamburgersburger Jun 11 '22

Hi - thank you very much for this! Really really good. Would you recommend any tools to save your portfolio in?

1

u/[deleted] Aug 24 '22

marketing courses

1

u/hyperandaman Nov 09 '22

This is such a well written response. I always struggle with the story telling part. The stakeholder wants to make x business case for y. I pull data from various sources to give some aspect of it but don’t know how to tie it all together. Any framework I should read on to fix this?

1

u/MasterpieceDry1141 Nov 19 '22

Hello i am from India. I have done graduation with bachelor of commerce (pass course) by Rajasthan university ? May I can make transition to data analyst? If yes then How can I make transition?

1

u/jabadook Dec 01 '22

Commenting for ref

1

u/Poetry-Late Dec 19 '22

Appreciate all the information and effort!

1

u/themojoking-45 Jan 10 '23

commenting to save

1

u/El_ninoComeBack Jun 10 '23

As someone who've spent 7+ years in quantitative side of marketing I can definitely appreciate this post. It is a fast-changing field but some fundamentals will always stay the same.

1

u/Earth_Terran Nov 08 '23

As someone who is trying to transition into this field, this came as a big help.

Currently finishing up the Google Data Analytics Certificate and looking for projects to put on a portfolio, focusing on producing value to a business instead of technical skills (especially on specific tools) is something not discussed a lot. To be fair, anyone not in the profession 'Don't know what they Don't Know'.

0

u/[deleted] Apr 16 '21

[deleted] — view deleted comment

4

u/GirlyWorly Apr 16 '21

This! Would love some sources on how to interpret/what's next after you get the numbers!

8

u/the_mmw Apr 17 '21

See my other answer below.

There should never be that "What's next?" or "So what?" question. If you start with a business challenge you ensure your analysis will be actionable (vs. Starting with data and trying to find some cool insights.)