Data Analyst for Beginners in the Philippines: Where to Start

The simplest data analyst for beginners path in the Philippines goes like this: start with spreadsheets, then basic SQL, then one dashboard tool, and build two or three small projects using free public data. That's the core of most entry level data analyst jobs: pulling data, cleaning it, summarizing it, and explaining what it means to someone who doesn't want to read a spreadsheet. You don't need a math degree or Python on day one.

A lot of people get scared off by "data science" content full of machine learning. Ignore that for now. Junior analyst roles here, in banks, BPOs, retail chains, e-commerce and logistics companies, mostly need someone who can answer business questions accurately and on time. Here's the order I'd learn things in.

What does a junior data analyst actually do?

Real examples of requests you'd get in your first job:

• "How many tickets did each team close last week, and which ones missed the SLA?"
• "Which branches had the biggest drop in sales compared to last quarter?"
• "Can you build a dashboard so the operations manager can check this daily?"
• "These two reports don't match. Find out why."

That last one is more common than people expect. A big part of the job is cleaning messy data: duplicate rows, inconsistent spellings ("Quezon City," "QC," "Q.C."), dates stored as text, blanks where there should be zeros. If you enjoy making order out of chaos, you'll probably like this work.

If you came from a BPO, you've likely already seen this side of operations: workforce management, reporting analysts, the person who sends the daily AHT and CSAT report. That's a common doorway into analyst work, so don't overlook internal postings at your current company.

Stage 1: Get really good at Excel or Google Sheets

Spreadsheets are still where most business data ends up, and almost every analyst job post lists Excel. Google Sheets is free and covers nearly everything you need to learn.

Learn these until you can do them without searching:

• Sorting, filtering, and freezing header rows
• SUMIFS, COUNTIFS, AVERAGEIFS
• XLOOKUP (or VLOOKUP and INDEX/MATCH, since older files use them)
• IF, IFERROR, and combining conditions with AND/OR
• Text cleanup: TRIM, PROPER, SPLIT or Text to Columns
• Pivot tables (this one is huge)
• Basic charts: column, line, and bar, with clear titles

Stage 2: Learn SQL basics

SQL is how analysts pull data out of databases. The good news is that the beginner level is very learnable. SQLBolt and Khan Academy's intro to SQL are both free and interactive, and they're a good place to start.

Focus on SELECT, WHERE, ORDER BY, GROUP BY, aggregate functions like COUNT and SUM, JOIN, and HAVING. Here's what a typical beginner query looks like, answering "which branches had the most sales in September?":

SELECT branch_name,
       COUNT(*) AS orders,
       SUM(total_amount) AS total_sales
FROM sales
WHERE order_date >= '2026-09-01'
  AND order_date < '2026-10-01'
GROUP BY branch_name
ORDER BY total_sales DESC
LIMIT 10;

Read it like a sentence: from the sales table, keep only September orders, group them by branch, count and total each group, sort from highest to lowest, and show the top 10. If you can write and explain queries like this, plus a simple JOIN between two tables, you're at the level many junior interviews check.

If you get stuck on a query, write down what you expected and what you got, then ask someone. In our cohorts, that exact question is what people bring to the weekly live call (it's recorded, so night shift doesn't make you miss it), and a five-minute walkthrough usually saves an evening of guessing.

Stage 3: Build simple dashboards

A dashboard is just a page that answers a few questions at a glance. Two free options to learn:

• Looker Studio (from Google): free, browser-based, connects easily to Google Sheets.
• Power BI Desktop: free to download on Windows and very common in corporate job posts here.

Tableau Public is another free option if you like its style. Pick one tool based on what your target job posts mention most and stick with it for now.

Rules for a beginner dashboard that actually looks professional:

1. Start with three to five questions the dashboard must answer.
2. Put the most important number at the top left.
3. Use one chart per question, with a title that states the finding ("Sales dropped in Visayas branches in Q3"), not just "Sales by Region."
4. Add one or two filters (date range, region) and no more.
5. Keep the colors simple. Gray for most things, one accent color for what matters.

Data analyst for beginners: portfolio projects using public data

You need proof, and public data is the easiest way to get it. Government and open data portals publish a lot of free datasets. The Philippine Statistics Authority's OpenSTAT and the government's open data portals are good places to look for things like population, prices, labor, agriculture and regional statistics. Availability and formats change over time, so browse what's currently published rather than assuming a specific dataset exists. Kaggle also has many public datasets if you want more variety.

Project ideas that tell a local story:

• Prices over time: track changes in the prices of common goods across regions and show which areas rose fastest.
• Regional comparison: compare a labor or population indicator across regions and explain the differences in plain English.
• Your own data: export your GCash or bank transactions (remove personal info first) and build a monthly spending dashboard. Simple, but it shows the full process.

For each project, write a short summary: the question, where the data came from, how you cleaned it, what you found, and one limitation. Put it on GitHub or a simple page, with a link to the dashboard. Three of these beat a dozen certificates. Here's the shape of a good summary (swap in what your own data actually shows):

• Question: Which regions saw the biggest rise in rice prices over the last two years?
• Data: Retail price tables downloaded from OpenSTAT, saved as CSV.
• Cleaning: Standardized region labels, converted text dates to real dates, flagged months with missing values.
• Finding: Name the two or three regions that rose fastest and by how much, compared to the national average.
• Limitation: Monthly averages hide week-to-week spikes, and a few months had gaps.

Notice the limitation line. Interviewers like it, because it shows you know what your data can't tell you.

Mistakes beginners make

• Learning Python, R, statistics and machine learning all at once. Spreadsheets and SQL first. Python can come after your first job or once the basics feel easy.
• Making dashboards nobody can read. Fifteen charts on one page is noise.
• Skipping the "so what." A chart without a sentence explaining it is half the work.
• Collecting certificates instead of projects. Certificates can help you get past filters, but projects get you through interviews. If you want options, our list of free IT courses with certificates covers the good ones.
• Only applying to "Data Analyst" titles. Also search "reporting analyst," "MIS analyst," "business analyst (junior)," "workforce analyst" and "data associate" on JobStreet, LinkedIn and Kalibrr.

Data analyst is also one of the IT jobs that don't require coding in the heavy software-engineering sense, though SQL is close to it.

You can learn all of this alone, and plenty of people do. What the Career Shifter Track saves you is guesswork. Week 1 helps you confirm data is really your lane (and not QA or support), and your dashboard project gets read by a coach who tells you which chart titles still don't state a finding. You can try a few lessons in the free preview without an account, and free materials to start with are in the IT Job Starter Kit.

Frequently asked questions

Can I become a data analyst without an IT degree?

Yes. Many analysts come from business, accounting, engineering, psychology or operations backgrounds. Employers mostly check whether you can use spreadsheets, write basic SQL, and explain findings clearly, so a portfolio matters more than your course.

Do I need Python to get a data analyst job?

Not usually for entry level roles in the Philippines. Many job posts ask for Excel and SQL first, with Python or R listed as a plus. Learn it once spreadsheets and SQL feel comfortable.

Excel or Google Sheets: which should I learn?

The core skills are almost identical, so start with whichever you have. Google Sheets is free. Many companies use Excel, so get comfortable with it too before interviews if you can.

How much do data analysts earn in the Philippines?

It varies a lot by industry, city and company, so I won't quote a number. Check current data analyst postings on JobStreet and LinkedIn in your area for realistic ranges.