How to Become a Data Analyst in Malaysia (2026): A Six-Month Plan

If you already work in Malaysia, the most practical route into data analysis runs through your current employer. Learn Excel analysis, then SQL, then Power BI, and finish with the PL-300 Power BI Data Analyst exam, building projects from real problems in your job. Six months at five to eight hours a week is a workable pace, and HRD Corp claimable training can put the cost on your employer.

At a glance

Why start from the job you already have

Career switchers often begin with generic courses and sample datasets about films or the Titanic. You have something better: real business questions, real data and people who need answers. A sales coordinator who knows why returns spike, or a finance executive who knows which cost centres get misposted, already has the domain knowledge that analysts spend months learning.

In many Malaysian companies, reporting still starts with Excel exports from an accounting, ERP or point-of-sale system. Every one of those manual reports is a project waiting to be automated. Internal job titles to watch for include MIS executive, reporting analyst, BI analyst and data analyst, and moving across from inside the company is usually easier than applying cold.

Ask your employer to fund it

If your employer has 10 or more Malaysian employees, it must be registered with HRD Corp and pays a monthly levy of 1% of wages, which can fund approved training. The employer, not you, applies through e-TRiS before the course starts. When you ask your manager, link the training to one report you will automate, not to your career plans. Our HRD Corp claimable training guide explains the process your HR team will follow.

Set a weekly rhythm

Five to eight hours a week only works if it is protected time. A pattern that suits most working adults is two weekday sessions of about 90 minutes for new material, plus one longer weekend block for the project. Apply each new skill to your own data within the same week. If a topic does not stick after two weeks, slow down rather than skipping ahead, because each month builds on the one before.

Month 1: Excel for analysis

Most new analysts already "know Excel" but have never used it as an analysis tool. Focus on:

• Formatted tables instead of loose ranges
• PivotTables and PivotCharts for quick summaries
• XLOOKUP for joining data from two sheets
• Power Query (Get and Transform) to clean exports the same way every month

Power Query is the step that matters most, because Power BI uses the same engine. Your task for the month: pick one report you rebuild by hand every week or month and make it refresh with one click.

Month 2: SQL

SQL lets you ask questions of the database directly, instead of waiting for someone to export a file. Install SQL Server 2025 Express, Microsoft's free entry-level edition, or a free Developer edition, which is licensed for development and testing but not production. Then learn SELECT, WHERE, GROUP BY, JOIN, common table expressions and simple window functions.

Ask IT for read-only access to a reporting copy of a database. Never run your practice queries against a live production system without permission. A typical first business query looks like this:

-- Monthly sales by state since January 2025
SELECT
    YEAR(o.OrderDate)  AS SalesYear,
    MONTH(o.OrderDate) AS SalesMonth,
    c.State,
    SUM(o.Amount)      AS TotalSales,
    COUNT(*)           AS OrderCount
FROM dbo.Orders AS o
JOIN dbo.Customers AS c
    ON c.CustomerID = o.CustomerID
WHERE o.OrderDate >= '2025-01-01'
GROUP BY YEAR(o.OrderDate), MONTH(o.OrderDate), c.State
ORDER BY SalesYear DESC, SalesMonth DESC, TotalSales DESC;

Your task: write queries that answer five questions your manager actually asks, and save them with a comment explaining each one.

Month 3: Power BI basics

Power BI Desktop is a free Windows application. Connect it to your Excel files and SQL queries, clean the data in Power Query, and build a one-page report with slicers and a few well-chosen visuals. Sharing through the Power BI service depends on your organisation's licences, so ask IT before you publish anything.

Keep the first report small. One page that a manager opens every Monday beats ten pages nobody reads.

Month 4: data modelling and DAX

This is where Excel users become analysts. Learn to split data into fact tables (transactions) and dimension tables (customers, products, dates), connect them in a star schema, and write measures in DAX.

Total Sales = SUM ( Sales[Amount] )

Sales YoY % =
VAR CurrentSales = [Total Sales]
VAR PriorSales =
    CALCULATE ( [Total Sales], SAMEPERIODLASTYEAR ( 'Date'[Date] ) )
RETURN
    DIVIDE ( CurrentSales - PriorSales, PriorSales )

Build a proper date table and mark it as the date table. For Malaysian data, add columns for public holidays and working days. Weekends and holidays differ between states, and some states, such as Kelantan and Terengganu, have a Friday and Saturday weekend, so a single national calendar can miscount working days for branches or plants.

Month 5: prepare for and sit PL-300

PL-300 earns the Microsoft Certified: Power BI Data Analyst Associate certification. As of October 2026, the PL-300 study guide lists skills measured as of 20 April 2026:

The exam gives you 100 minutes, and a score of 700 or greater is required to pass. The certification renews every 12 months through a free online assessment on Microsoft Learn. The current skills list includes Copilot tasks, such as creating a report page with Copilot and using it to summarise a semantic model, plus row-level security, sensitivity labels and choosing between Import, DirectQuery and Direct Lake. Take the free practice assessment early to find your weak domain, and leave the last two weeks for practice rather than new topics.

Month 6: build a portfolio from your own work

Aim for three projects that show different skills:

1. A work report, rebuilt and anonymised. With your manager's permission, recreate a report you automated, using fake or aggregated values.
2. A public Malaysian dataset. Use OpenDOSM, the Department of Statistics Malaysia's open data platform, or the government's open data portal, data.gov.my. Topics such as consumer prices, population or the labour market make good practice in modelling time series.
3. A before and after case. Describe a manual process, what you automated and the time you measured it saving. Use only numbers you recorded yourself.

Keep personal data out of your portfolio

Real work data almost always contains personal data: names, MyKad numbers, phone numbers and addresses. Under the Personal Data Protection Act, your employer is responsible for that data, and you should never upload it to a public portfolio, a personal cloud drive or a public AI tool. Aggregate, replace identifiers or generate realistic fake data instead. Our guide to the PDPA and AI tools at work covers the rules.

Finish the month with a 10-minute demo to your manager: the problem, the report and what it saves. That conversation does more for an internal move than any certificate.

After six months: where to go next

• Deeper SQL for performance and more complex queries, if your company runs on SQL Server.
• Python for automation and statistics. The PCEP entry-level certification is a sensible first step before PCAP.
• Microsoft Fabric if your team is moving reports and data pipelines into one platform.

Common mistakes

• Collecting certificates without building anything from real work
• Starting with Python before SQL, when most Microsoft-based reporting roles use SQL and Power BI daily
• Building dashboards nobody asked for, instead of fixing a report people already use
• Showing real customer or employee data in a portfolio

How CertTulen Academy can help

CertTulen Academy runs PL-300 and Microsoft SQL Server Fundamentals (CT-MSSQL-B) as live, MCT-led classes with hands-on labs, and offers PCEP for the Python step. Professional certification courses include an exam voucher, mock practice tests and lab access; see each course page for details. CertTulen is an HRD Corp accredited training provider, and many professional courses can be claimed by HRD Corp registered employers, so ask us which courses are claimable. Contact us or WhatsApp +60 16-241 8686.