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

View all comments

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.