How to Become a Data Analyst in Indonesia: Skills, Roadmap and Salary (2026)
The short answer
To become a data analyst, learn spreadsheets, SQL, one BI tool such as Looker Studio or Power BI, basic statistics, and how to explain a finding in plain words. Most people can learn the basics in about six months part-time, then need two or three portfolio projects to get interviews. In Indonesia the average data analyst salary on Indeed is about Rp6.3 million a month.
A data analyst answers business questions with data. Which product sold best last month? Why did sign-ups drop in Surabaya? Did the new promo pay for itself? The job is to pull the right numbers, check them, and explain what they mean to people who have to make a decision.
It is also the most common first job in data. You do not need a computer science degree, and the tools are ones you can learn on a laptop at home. Google’s own Data Analytics certificate, for example, asks for no degree or prior experience and takes under six months at under 10 hours a week (Coursera).
1. What a data analyst does all day
The work changes by company, but most weeks look something like this:
- Writing SQL to pull sales, user or operations data from the company database
- Cleaning that data: removing duplicates, fixing dates, and checking totals against a number people trust
- Building and updating dashboards that managers open every Monday
- Answering one-off questions from marketing, finance or operations, often by the end of the day
- Writing a short summary of what changed, why it probably changed, and what to do next
The last point is the one most beginners underrate. A chart nobody understands changes nothing. The analysts who get promoted are the ones whose findings turn into decisions.
Data analyst, data scientist or data engineer?
The three titles overlap, and small companies often mix them. The usual split looks like this:
| Role | Main question | Core tools |
|---|---|---|
| Data analyst | What happened, and why? | Spreadsheets, SQL, a BI tool, basic statistics |
| Data scientist | What will happen, and what should we test? | Python, statistics, machine learning, experiments |
| Data engineer | Is the data there, correct and on time? | SQL, Python, pipelines, orchestration, cloud warehouses |
If you are unsure which one suits you, start with analyst. The skills carry over to both of the others. Read how to become a data scientist or how to become a data engineer when you know which direction pulls you.
2. The five skills you need
Spreadsheets (Excel or Google Sheets)
Almost every company in Indonesia still runs on spreadsheets, so this is where you start. Learn sorting and filtering, SUMIFS and COUNTIFS, XLOOKUP or VLOOKUP, pivot tables, and simple charts. If you can turn a raw export into a clean pivot table in ten minutes, you are already useful.
SQL
SQL is how you get data out of a database without asking an engineer. Learn SELECT, WHERE, GROUP BY, JOIN and, later, window functions. It is the core of the job, and it is also the first skill a data engineer needs, so the time is never wasted.
One BI tool
A BI (business intelligence) tool turns tables into dashboards other people can use. Pick one: Looker Studio is free and popular with startups, while Power BI and Tableau are often used at larger companies. Once you know one, the others take days, not months.
Statistics basics
You do not need advanced math. You need averages and medians (and when each one lies), percentages and growth rates, distributions, correlation versus cause, and enough sampling to know when a difference is too small to trust.
Storytelling with data
This means choosing the right chart, putting the conclusion in the title, and writing three sentences a busy manager will read. Practice by explaining every chart you make out loud, as if to someone outside your team.
AI tools help with all five, from writing a first draft of a SQL query to suggesting a chart. They also make confident mistakes, so check their work. Our guide to writing a good prompt shows how to ask for something you can verify.
3. A roadmap, in order
Learn the skills in this order. Each step uses the one before it. The times assume about 8 to 10 hours a week, which matches the pace of the Google Data Analytics certificate. roadmap.sh’s data analyst roadmap is a good checklist if you want more detail.
- 1Spreadsheets3 to 4 weeksFormulas, lookups, pivot tables, simple charts
- 2SQL4 to 6 weeksSELECT, WHERE, GROUP BY, JOIN, then window functions
- 3Statistics basics2 to 3 weeksAverages, distributions, growth rates, correlation versus cause
- 4One BI tool3 to 4 weeksLooker Studio, Power BI or Tableau: one dashboard end to end
- 5Storytelling2 weeks, then ongoingChart choice, titles that state the finding, short written summaries
- 6Portfolio projects4 to 6 weeksTwo or three projects on real, public data
- Spreadsheets (3 to 4 weeks): formulas, lookups, pivot tables and simple charts.
- SQL (4 to 6 weeks): SELECT, WHERE, GROUP BY, JOIN, then window functions.
- Statistics basics (2 to 3 weeks): averages, distributions, growth rates, correlation versus cause.
- One BI tool (3 to 4 weeks): build one dashboard from raw data to something a manager can use.
- Storytelling (2 weeks, then ongoing): pick the right chart, title it with the finding, write a short summary.
- Portfolio projects (4 to 6 weeks): two or three projects on real, public data.
Portfolio ideas that work in Indonesia
- Regional prices. Take public price or inflation data by province and show where prices rose fastest, with one clear chart and a paragraph on why.
- An online shop’s sales. Use a public e-commerce dataset, write the SQL, and build a dashboard of sales by category, month and city.
- A question from your own job. Anonymise the data first. A real business question beats a famous dataset every time.
For each one, write a short README: the question, the data, what you found, and what you would check next. Hiring managers read that before they open your dashboard.
4. What data analysts earn in Indonesia
On Indeed Indonesia, the average data analyst salary is Rp6,324,092 a month, from 89 reported salaries (updated 27 October 2026). Typical pay runs from about Rp3.3 million to Rp12 million a month. Jakarta averages about Rp7.6 million.
Jobstreet’s figures, based on salary ranges employers put in their ads, show a similar picture for Jakarta: an average of Rp7.5 million in West Jakarta and Rp10 million in East Jakarta (Jobstreet, November 2026).
- Data analyst · average Rp6.3m, 89 salariesRp3.3 to 12 million
- Data engineer · average Rp8.5m, 41 salariesRp2.3 to 31.6 million
- Data scientist · average Rp14.5m, 8 salariesRp8.3 to 25.4 million
Two things to keep in mind. First, these are averages across all levels; a first job usually pays near the bottom of the range. Second, the title hides a lot. A “data analyst” at a tech company who writes SQL all day is paid differently from an admin role that updates one spreadsheet, and both appear in the same average. Read the job description, not just the title.
Demand is not going away either. The World Economic Forum’s Future of Jobs Report 2025 puts big data specialists at the top of its fastest-growing jobs to 2030 (WEF), and Indonesia’s Ministry of Communication and Digital Affairs now estimates the country needs 12 million digital workers by 2030, up from an earlier 9 million (Investortrust).
5. Getting your first data analyst job
Your starting point decides the shortest route. Three common ones:
- You already work with spreadsheets (finance, sales ops, admin, marketing). Start doing analysis in your current job: build the report nobody has time for, then ask to own it. An internal move is often the fastest way in.
- You are a student or fresh graduate. Aim for an internship or a junior role, and put your projects at the top of your CV, above your GPA.
- You are switching from an unrelated field. Pick an industry you know, such as retail, healthcare or logistics, and build your projects on its data. Domain knowledge is a real advantage.
Common mistakes
- Learning Python before SQL. Python is useful, but SQL is what an analyst uses every day, so it comes first.
- Collecting certificates instead of finishing projects. Two finished projects with a clear write-up beat five certificates.
- Dashboards with no point. Every dashboard should answer one question. Put that question in the title.
- Not checking the numbers. Compare your totals with a figure people already trust before you share anything.
When you are ready to start, Datamew’s Data Analyst track covers these skills in three-minute lessons, and the first unit is free. After a year or two as an analyst, many people move on to data science, data engineering or AI. See the AI engineer career path if building with AI models interests you.
Frequently asked questions
Can I become a data analyst without a degree?
Yes. Many Indonesian job ads still list a bachelor’s degree, but a strong portfolio and a good SQL test can outweigh it, especially at startups. Google’s Data Analytics certificate asks for no degree or experience.
Do I need to learn Python to be a data analyst?
Not at first. Spreadsheets, SQL and one BI tool are enough for most junior roles. Python helps later, and you will need it if you move into data science.
How long does it take to become a data analyst?
About five to six months of part-time study for the basics, at 8 to 10 hours a week, then one or two months on portfolio projects. Faster if you already use spreadsheets at work.
How much does a data analyst earn in Indonesia?
Indeed Indonesia puts the average at about Rp6.3 million a month, with typical pay from about Rp3.3 to 12 million (October 2026). Jakarta averages about Rp7.6 million. Pay varies a lot by company and level.
Is Excel enough to get a data analyst job?
Sometimes, for entry roles at smaller companies. But SQL is the everyday tool of the job, so learn it early. It also makes you far faster with large data.
Start the Data Analyst track today
Datamew’s Data Analyst track teaches these skills in three-minute lessons, in order. The first unit is free. Curious ($3 a month) opens every lesson; Mastery ($15 a month) adds exercises, from quizzes to AI-graded chart explanations. Start learning in the web app now; phone apps are coming soon.
Start learningSources
- Indeed Indonesia: Data analyst salaries (updated 27 October 2026)
- Indeed Indonesia: Data scientist salaries (updated 6 October 2026)
- Indeed Indonesia: Data engineer salaries (updated 20 October 2026)
- Jobstreet: Gaji analis data di Indonesia (November 2026)
- Coursera: Google Data Analytics Professional Certificate
- roadmap.sh: Data Analyst roadmap
- World Economic Forum: Future of Jobs Report 2025, fastest-growing and declining jobs
- Investortrust: Kebutuhan talenta digital Indonesia melonjak jadi 12 juta hingga 2030 (20 June 2025)
Keep reading
How to Become a Data Scientist in Indonesia: Skills, Roadmap and Salary (2026)
A data scientist uses Python, statistics and machine learning to predict what will happen and to test what works. Most people get there through data analysis first: learn SQL and statistics, then Python, experiments and machine learning, which takes roughly a year part-time. In Indonesia, data scientist salaries on Indeed average about Rp14.5 million a month.
8 min readHow to Become a Data Engineer in Indonesia: Skills, Roadmap and Salary (2026)
A data engineer builds the pipelines that move data from apps and systems into a warehouse, clean and on time, so analysts and data scientists can use it. Learn SQL, Python, data modelling, ETL and ELT pipelines, an orchestrator such as Airflow, and one cloud warehouse; most people need around 8 to 10 months part-time. On Indeed Indonesia, data engineers average about Rp8.5 million a month, and the range runs much higher.
8 min read
AI Engineer Career Path: Roles, Skills, Salary and a Realistic Roadmap (2026)
An AI engineer builds products on top of existing AI models, such as ChatGPT-style chatbots, document search and AI agents. Most do not train models from scratch. Instead, they connect models to data, tools and users, then test that the results are reliable.
9 min read
How to Write a Good Prompt: A 5-Part Framework for Work
A good prompt gives the AI five things: context, task, input, format and limits. It says who the work is for, what to do, which material to use, how the answer should look and what to avoid. Then you check the answer and ask a follow-up.
7 min read
How to Learn AI From Zero, Without Coding
Yes, you can learn AI without writing any code. To use AI well at work you need four things: a basic idea of how it works, a sense of where it fails, practice with one or two free tools, and the habit of checking every answer before you use it.
8 min read