mtahiraslan/data-analyst-roadmap mtahiraslan/data-analyst-roadmap

  • Stars
    star
    264
  • Rank 155,103 (Top 4 %)
  • Language
  • License
    MIT License
  • Created over 1 year ago
  • Updated 12 months ago
Twitter logo Share LinkedIn logo Share Facebook logo Share
mtahiraslan/data-analyst-roadmap
github

mtahiraslan

Reviews

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

Repository Details

Based on my own experience, I think this roadmap will answer all the questions of how to become a data analyst from zero, which technologies and programming languages are better to know, what kind of soft skills do we need, how do I start my professional career in this field.

Data Analyst Full Roadmap

"Companies are collecting large amounts of data and analyzing it to make strategic decisions in various processes within their businesses, which is why there is an increasing demand for data analysts. Additionally, data analysis technology and tools are constantly evolving, which makes data analysts' work more efficient."

Role of a Data Analyst

"A data analyst collects, cleans, and interprets data sets in order to answer a question or solve a problem."

Six steps of data analysis:

  • Business Question: Define what problem you want to solve.
  • Get Data: Collect the data required for analysis.
  • Explore Data: Explore data with visual exploration to understand what is in a dataset.
  • Prepare Data: Data cleaning, calculated fields and data validation.
  • Analyze Data: Use data analysis techniques to understand, interpret, and derive conclusions based on the requirements.
  • Present Findings: Share insights with stakeholders.

Roadmap

Uygulama Ekran Görüntüsü

1. Statistics

"Statistical foundations are crucial for a data analyst because they form the basis of the data analysis process. Through statistical methods, a data analyst can use a scientific approach to understand, interpret, and report on data results."

Youtube Channels & Videos

Cheat Sheets & Books

2. Microsoft Excel

"Excel is a commonly used tool for data analysis and is important for data analysts because it helps to organize, analyze, visualize, and manipulate data. Additionally, it is user-friendly and accessible to most data analysts."

Youtube Channels & Videos

Cheat Sheets & Books

3. SQL

"SQL is a programming language used by database management systems for storing, querying, organizing, and managing data. Knowing SQL is important for a data analyst because it is a tool used for querying, filtering, joining, and analyzing data. SQL is used by data analysts for managing and analyzing data, and it helps make analysis processes more efficient and effective."

Uygulama Ekran Görüntüsü_2

Uygulama Ekran Görüntüsü_3

Books

Blogs

Youtube Channels & Videos

Courses

Tutorials

Practice & Online Databases

Cheat Sheets

4. BI (Business Intelligence) Tools - Power BI & Tableau

"BI (Business Intelligence) tools are important for data analysts because they are used to analyze, visualize and make sense of data. These tools help data analysts to speed up their workflow and better understand data. BI tools offer different visualization techniques and graphs to analyze data and visualize it for management decisions. This enables data analysts to better understand data, interpret results more effectively and create a better foundation for business decisions."

Uygulama Ekran Görüntüsü_4

Microsoft Power BI

Tableau

5. Programming - Python

"Python is important for data analysts because it is considered a programming language that can be used for many data analysis processes. Python can be used for many data analysis processes, such as analyzing large datasets, data manipulation, data visualization, machine learning modeling, data mining processes, and data cleaning processes. Additionally, Python's open-source nature, free availability, and ease of learning are advantages for a data analyst. Therefore, knowing Python as a data analyst creates a versatile tool for data analysis processes and can help make data analysis processes faster, more efficient, and more accurate."

Web Sites

Courses

Youtube Channels & Videos

6. Soft Skills for Data Analyst

Uygulama Ekran Görüntüsü_5

"What are the soft skills that a Data Analyst should have?"

  • Analytical Thinking: Analytical thinking skills are required to understand, manage and interpret data. A data analyst must use logical and critical thinking skills to analyze data and make decisions based on the results.

  • Communication Skills: Data analysts must have effective communication skills to explain complex data by translating technical terms into easily understandable language and to interact with other team members. Sharing the results of data analysis and discussing action plans with other team members is important for a successful data analyst.

  • Problem Solving: A data analyst must identify problems by analyzing data and develop effective strategies to solve them. Therefore, problem-solving skills require a flexible approach that can adapt to the complexity and variability of data.

  • Teamwork: Data analysts must be effective in teamwork and be able to collaborate with team members to exchange ideas during the data analysis process. A data analyst may also interact with other teams (such as marketing, engineering, etc.), so teamwork skills are of great importance.

  • Business Understanding: A data analyst must have an understanding of business. Understanding business needs and goals can help in asking the right questions and obtaining the right results in data analysis.

  • Storytelling: A data analyst must have effective storytelling skills to communicate data. By presenting data in an understandable way, a data analyst can help in the effective use of data.

7. Resume & Interview Preparation

Resume

  • There is nothing called PERFECT resume, so keep learning and updating!
  • Prepare one page resume and use professional template.
  • Based on above learnings and projects update your resume.
  • Also, if you have done any courses/certificates do add them as well.
  • Tailor your resume based on the role/company you’re applying.

Free resume template websites:

Interview Preparation:

  • Once you have completed all the above steps, just start applying for related jobs. Giving interview is also a part of your learning.
  • Be thorough with your resume, even with minute details.
  • Again, watch podcasts and interview experience shared on YouTube.
  • Read interview questions available on sites like: LinkedIn, Indeed, Glassdoor.

Congratulations!

Ta ta ta ta congratulations!, you are now a Data Analyst and you can apply for your dream job and company. 🥳🎉

If you've come this far and reviewed or completed all the steps, you can help me by giving this repository a star ⭐.

Contact Me

Twitter Badge

Linkedin Badge

Github Badge

Contribution Guideline

You can open an issue and give your suggestions as to how I can improve this roadmap, or what I can do to improve the learning experience.

You can also fork this repo and send a pull request to fix any mistakes that you have found.

More Repositories

1

rule_based_classification

It is an application that estimates how much a new customer can earn on average and in which segment by applying EDA (Exploratory Data Analysis), segmentation and forecasting methods on persona.csv (customer dataset) using the Streamlit library.
Python
9
star
2

flo_cltv_prediction

FLO wants to determine roadmap for sales and marketing activities. In order for the company to make a medium long -term plan, it is necessary to estimate the potential value that existing customers will provide to the company in the future.
Python
8
star
3

8_week_sql_challenge

SQL solutions for #8WeekSQLChallenge questions by Danny Ma
8
star
4

ab_testing_project

Comparison of A/B Test and Conversion of Bidding Methods
Python
4
star
5

flo_rfm_analysis

FLO, which is an online shoe store, wants to divide its customers into segments and determine marketing strategies according to these segments. For this, the behavior of customers will be defined and groups will be formed according to the clutches in these behaviors.
Python
4
star
6

DataAnalysisPowerBI_SQL

TSQL
3
star
7

rating_products_sorting_reviews_amazon

Rating Product & Sorting Reviews in Amazon
Python
3
star
8

mtahiraslan

3
star
9

armut_arl_recommender_system

An association rule learning-based product recommendation system is desired to be created using the dataset containing users who received services and the categories of services they received.
Python
3
star
10

Data_Analysis_and_Visualization_Netflix

Jupyter Notebook
3
star
11

Huawei_Cloud_Practicum_Final_Case

It is the repository that contains the service, framework, technology and other information I will use for the project I have created for the Huawei Cloud Practicum final case.
2
star
12

ArtificialNeuralNetwork

Python
2
star
13

Titanic-Hayatta-Kalma-Tahmini

Jupyter Notebook
2
star
14

WebScrapingCarInfo

Jupyter Notebook
1
star
15

mtahiraslan.github.io

CSS
1
star
16

Korona-Virus-Veri-Analizi

Jupyter Notebook
1
star
17

MVC_Ozgecmis_Web_Sitesi

JavaScript
1
star
18

DeepNeuralNetworks

Python
1
star