Article • 16 November 2026

Data Analyst Learning Roadmap: Start from Scratch

By : Wahyu Yudistira

Data Analyst Learning Roadmap: Start from Scratch

A roadmap for learning data analysis from scratch starts with Excel, SQL, basic statistics, data visualization with Power BI or Tableau, and Python. Once you understand these skills, the next step is to work on practical projects and build a portfolio. With consistent study, beginners can aim to develop foundational skills in around 3–6 months.

You do not need an IT background or advanced coding skills to get started. You can follow a gradual learning path, from working with simple datasets to producing analysis that supports business decisions.

What should you learn, and in what order? Explore the complete roadmap below.

What Is a Data Analyst, and What Do They Do?

A data analyst is a professional who collects, cleans, processes, analyzes, and presents data to support decision-making.

Imagine an e-commerce company experiencing a decline in sales. To understand why, the company needs to examine its transactions, identify its best-selling products, and explore changes in customer purchasing patterns.

This is where data analysts come in. They process this information to identify patterns, explain their findings, and make recommendations based on data.

The role involves more than numbers and charts. Critical thinking, problem-solving, and communication are also essential parts of the job.

6 Stages in Your Data Analyst Learning Roadmap

For beginners, learning data analysis is easier when you follow a clear sequence. You do not need to learn every tool at once. Start with the fundamentals, then develop your skills through practice and projects.

Here are six stages you can follow.

1. Learn Microsoft Excel and Spreadsheets

Estimated learning time: 2–3 weeks

Excel is a useful starting point for your data analysis journey. It helps you understand how to manage data before you begin learning a programming language.

Start by learning how tables are structured, how to enter data, and how to use simple formulas.

Key Excel topics include:

  • Basic formulas: SUM, AVERAGE, COUNT, IF, and SUMIFS for calculations.
  • Data cleaning: Sort, Filter, Remove Duplicates, and handling missing values.
  • Lookups: VLOOKUP or XLOOKUP to find and combine information.
  • PivotTables: Summarize data by category.
  • Charts: Present processed data visually.

To make these concepts easier to understand, practice with a store's sales data.

Use it to calculate total revenue, identify best-selling products, and track changes in monthly sales.

Learning goal: Process transaction data and create a simple report using PivotTables and charts.

2. Master SQL to Retrieve and Process Data

Estimated learning time: 3–4 weeks

Once you understand Excel, the next step is SQL, or Structured Query Language.

SQL is used to retrieve and process data stored in relational databases. This skill allows data analysts to work with information beyond spreadsheet files.

Begin with these basic commands:

  • SELECT: Choose the data you want to display.
  • WHERE: Filter data based on specific conditions.
  • ORDER BY: Sort query results.
  • GROUP BY: Group data by category.
  • SUM, COUNT, and AVG: Perform aggregate calculations.
  • JOIN: Combine data from multiple tables.

For example, you may want to find out which product category generates the most sales. SQL lets you group transactions by category and calculate total sales for each one.

These fundamentals are also covered in the official PostgreSQL documentation, which you can use as a reference when learning SQL.

You do not need to memorize every command immediately. Focus on understanding what each query does, then use it to answer simple questions about a dataset.

Learning goal: Write SQL queries to retrieve, filter, join, and summarize data.

3. Understand Basic Statistics for Data Analysis

Estimated learning time: 1–2 weeks

Knowing how to use tools is only part of the job. A data analyst also needs to understand what the numbers mean.

That is why basic statistics is an important part of your learning roadmap.

Topics to understand include:

  • Mean, median, and mode.
  • Percentages and growth.
  • Variance and standard deviation.
  • Data distributions and outliers.
  • Correlation and the difference between correlation and causation.
  • Basic sampling concepts.

Suppose a store's average transaction value increases. Does that mean every customer has started spending more?

Not necessarily.

A few unusually large transactions may have raised the average. Understanding statistics helps you assess the situation more carefully before drawing conclusions.

Learning goal: Read, calculate, and interpret data using basic statistical concepts.

4. Learn Data Visualization with Power BI or Tableau

Estimated learning time: 2–3 weeks

After processing and analyzing data, you need to present the results in a way that others can understand.

At this stage, you can start learning Power BI or Tableau.

Both tools can create visualizations and dashboards that help people understand data. If you are already familiar with Excel, Power BI can be a practical starting point.

Topics to learn include:

  • Importing data from Excel or databases.
  • Cleaning data with Power Query when using Power BI.
  • Understanding relationships between tables.
  • Creating charts and KPI indicators.
  • Using filters and slicers.
  • Building interactive dashboards.

For practice, create a sales dashboard showing total revenue, monthly sales trends, best-selling product categories, and product performance.

You can later develop this dashboard into a portfolio project.

To explore the subject further, Microsoft Learn provides learning resources on data preparation, modeling, and visualization with Power BI.

Learning goal: Build an interactive dashboard that communicates business information clearly.

5. Learn Python for More Complex Data Analysis

Estimated learning time: 3–4 weeks

Python is a programming language used to process and analyze data.

In analytical work, Python helps with repetitive data processing tasks and more complex analysis.

If you are just starting out, take time to understand Excel and SQL before moving on to Python.

Begin with programming fundamentals such as variables, data types, conditional statements, loops, and functions.

Then explore libraries commonly used in data analysis:

  • Pandas: Process, clean, and analyze tabular data.
  • NumPy: Perform numerical operations.
  • Matplotlib: Create charts and data visualizations.
  • Seaborn: Create statistical visualizations.

As a practice exercise, use Python to read a CSV file, check for missing values, calculate total transactions, and present the results in a chart.

The official Pandas documentation can also help you understand how to use DataFrames for data processing and analysis.

Learning goal: Use Python and Pandas to clean, process, and visualize a dataset.

6. Build a Portfolio with Practical Data Projects

Estimated learning time: 2–4 weeks

Once you have learned the fundamentals, it is time to apply them to practical projects.

A portfolio demonstrates how you use tools to solve problems through data analysis.

Start with simple projects. Your first analysis does not have to be highly complex.

Here are a few project ideas for aspiring data analysts.

E-Commerce Sales Analysis Project

Use transaction data to identify revenue trends, best-selling product categories, and each category's contribution to total sales.

You can use Excel, SQL, and Power BI for this project.

Customer Behavior Analysis Project

Analyze customer data to group customers by purchase frequency and transaction value.

You can complete this project using SQL, Python, and Power BI.

Employee Data Analysis Project

Use an employee dataset to explore turnover patterns by department, length of service, or other available information.

Excel, Python, and Power BI can help you complete this project.

For practice material, explore the datasets available through Kaggle Datasets.

After completing a project, document the business question, data source, cleaning process, analytical methods, visualizations, key findings, limitations, and recommendations.

You can share the results on GitHub or organize them into a portfolio report.

Learning goal: Complete a project that demonstrates your ability to process data, find insights, and communicate recommendations.

Tips to Keep Your Data Analyst Learning Journey on Track

When you are starting out, the number of tools and topics available can feel overwhelming.

A few learning habits can help you stay focused.

First, focus on one skill before moving on to the next. For example, complete your Excel data processing exercises before starting SQL.

Second, practice every new concept. When learning PivotTables, apply them to a simple dataset right away. Do the same when learning SQL or Python.

Third, use case studies with a clear objective. Instead of creating charts without a purpose, answer questions such as which products generate the most revenue or how transaction trends change each month.

Fourth, practice explaining your findings in simple language. Charts and numbers are more useful when you can clearly explain what they show.

Finally, start building your portfolio before you have mastered every tool. You can complete your first projects with Excel, SQL, and Power BI while continuing to learn Python.

Frequently Asked Questions (FAQ)

1. Do I Need Coding Skills to Learn Data Analysis?

Not at the beginning. You can start with Excel, SQL, and Power BI to understand the basics of data processing and visualization. Learn Python later to expand your analytical skills.

2. How Long Does It Take to Learn Data Analysis from Scratch?

Around 3–6 months can be a target for developing foundational skills and an initial portfolio. The time required depends on your experience, study consistency, and the complexity of your projects.

3. Can Someone Without an IT Degree Become a Data Analyst?

Yes. A non-IT educational background does not automatically prevent you from learning data analysis. Focus on processing data, thinking analytically, understanding business problems, and demonstrating your skills through a portfolio.

Conclusion

Learning data analysis from scratch does not have to begin with a complicated programming language. Build a foundation with Excel, then move on to SQL, basic statistics, data visualization, and Python.

Apply these skills to practical projects so you develop experience turning data into useful information alongside your theoretical knowledge.

With a structured roadmap and consistent practice, you can start building the skills needed to pursue a career in data analysis.

Start Learning with Koding Akademi's Data Analyst Bootcamp

Now that you know the learning roadmap, are you still unsure where to begin? Follow a more structured learning path with Koding Akademi's Data Analyst Bootcamp.

Build your understanding of data processing, analysis, and visualization as you prepare to take your first steps in the field.

Start your learning journey with us. Visit Koding Akademi to learn more about Koding Akademi's Data Analyst Bootcamp.

Share this post

START TOGETHER

The Best Investment for Your Child's Future

Sign up now for a trial class or consult with our educational advisory team.

Logo Koding Akademi

Koding Akademi

Online

Today