How to Learn Data Analyst Skills in 2024 within 3 months

Data Analysis

May 09, 2024 | By Codebasics Team

How to Learn Data Analyst Skills in 2024 within 3 months

If you are fond of numbers and handling datasets, then you would have surely considered becoming a Data Analyst. The good news is you don’t have to be an engineer, scientist, or programmer to learn data analyst skill sets. You can belong to any profession, be anywhere in the world, and still be that cool data analyst who guides all the important decisions of the business.

But are you struggling to find the right learning process that helps you master the data analyst skills needed? Codebasics has a researched and refined approach to your problem!

The internet is full of overwhelming information, which can distract you from the right learning process. We at Codebasics, have prepared a step-by-step guide to master data analyst skills in 3 months in this YouTube video.

This article contains all the useful chunks of information and valuable data analyst skills to learn, which will help you lay a strong foundation.

What are the top skills required for Data Analyst in 2024?

  1. Proficiency with Microsoft Excel and Statistics

  2. Business Intelligence tools (BI tools)

  3. Python

  4. Structured Query Language (SQL)

  5. Soft Skills

skill set for data analyst

Often, we end up learning that the most complicated skills are required to study and analyze data. But, focussing on the fundamentals is key for a better outcome.

What are the required Data Analyst skills needed? Let's take a look at the data analyst skill set required for being a Data Analyst so that you can churn datasets properly.

1. Proficiency with Microsoft Excel and statistics

Being a Data Analyst, you are married to Microsoft Excel and its sheets. Proficiency with Excel and its features can help you churn out datasets with ease. Charting, inserting pivot tables, filtering and computing are some of the essential features that will help you analyze data quickly and efficiently.

Getting familiar with the tool will be easier once you start preparing sheets on it. Focusing on developing Excel skills is key to gaining the data analyst skills needed.

Preparing a spreadsheet in Excel will not be a bad idea. Working on real-time projects and bettering the approach toward data with Excel sheets will help you excel as a data analyst. 

However, the quantitative approach toward data will only get better once you get a knack for the statistics involved. Learning the basics of statistics will make the process of analyzing data hassle-free.

It is advised that you spend the first two weeks of your learning journey with Excel and statistics. 

But what if you come across large chunks of data that need cleaning and structuring? Also, is there any way to get better insights?

2. Business Intelligence tools (BI tools)

Business Intelligence tools like Power BI tools are important for building dashboards and better data visualization. As a Data Analyst, data cleansing, analyzing, and reporting can be a nightmare. To avoid those nightmares, BI tools like Power BI and Tableau are useful. 

A flair for BI tools will ensure a seamless learning process for you as a data analyst. Moreover, what’s better than learning from projects, that have been prepared to solve a problem in the real world.

Spending three weeks with BI tools and working with real data will help you lay a strong foundation for your data analyst skills.

Now, if you are analyzing data, you will need libraries for computing tools and handling data well. How can that be done? Python can help you. Yes, the programming language.

3. Python

Python is considered to be one of the most efficient and easy-to-learn programming languages. Being an aspiring Data Analyst, you must immediately accept the language as your friend and not foe. It is one of the top data analyst qualifications and technical skills needed to analyse data

Analysts find Python a flexible language, and you can explore data at a completely different level with the help of its libraries such as NumPy and Pandas. NumPy and Pandas are rich libraries that will allow you to carry out all the mathematical operations easily.

Spending the next two weeks on Python will secure your spot on the elite panel of skilled data analysts. But, you will still be missing something.

4. Structured Query Language (SQL)

Now that you have decided to play with data and become a Data Analyst, it would be important that you know their language right?

Structured Query Language is an integral part of the data analyst skill set which will allow you to work on specific information within the datasets. Accessibility of datasets will be improved by SQL. 

Three weeks of learning SQL will bring you very close to your goal. But, you would not want to miss out on soft skills too.

5. Soft Skills

There are some essential soft skills to learn to become a Data Analyst. Soft skills such as time management, adaptability, and communication will enable you to learn effectively.

While you would be starting this new journey of learning data analytics, you would prefer to be self-motivated and driven during the whole phase. 

Soft skills will take you to the next level as they improve your performance. You will be able to see a noticeable difference in the final output after learning soft skills.


The roadmap presented in this article provides a clear and structured path for becoming a skilled Data Analyst within 3 months.

By focusing on developing the fundamental data analyst skills needed - proficiency in Excel, Statistics, BI Tools, Python, SQL, and Soft Skills - an aspiring student can gain the required abilities.

The step-by-step guide is here, and dedicated practice is what will lead to success. Aim to spend 4-5 hours every day actively working through tasks and evolving with the latest trends. The more you practice, the better your results will be.

The river has been crossed, and the doors to the data world are opening. Now is the time to begin! With hard work and consistency in following this roadmap, nothing can stop you from mastering essential data analyst skills and calling yourself a skilled professional in just 3 short months.



Share With Friends

8 Must-Have Skills to Get a Data Analyst Job in 2024 Learn Coding From Scratch: a 3-months Roadmap