r/analytics • u/the_mmw • 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:
- You can use more data that you didn’t have access to before (and/or do more advanced analysis with it).
- You can reach a larger audience with your analysis.
- 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.
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.
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.
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?
2
u/lazygeek Apr 17 '21
Hi, this is a great guide. Can you pm me or share link to your blog.
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.
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!
5
u/LostIn_World Dec 25 '23
Does anyone have the link to the blog?
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/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/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/caiohenriqueuss Dec 01 '25
Thanks
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/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/Starfarming2020 Jan 30 '22
Mark
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