Persediaan temu duga data analyst, dibina untuk Asia Tenggara
Round SQL adalah tempat kebanyakan permohonan data analyst di Malaysia terhenti.
Belajar. Buktikan. Rehearse.
Latih senario interview SQL dan Excel original yang diinspirasikan oleh kerja di Grab, Shopee dan Maybank — digred serta-merta, dalam browser anda, percuma untuk mula.
101 soalan SQL · 29 bab SQL · percuma, tak perlu sign up untuk mula
Macam mana rasa bila anda stuck
Stuck kat sini? Ini yang jadi seterusnya.
Shopee's finance team wants a cumulative view of sales during a campaign.
From the daily_sales table, return each sale_date, its amount, and the running total of amount ordered by date as running_total. Order the output by sale_date.
Setiap soalan di laman ini ada scaffold macam ini. Merentasi seluruh bank, itu kira-kira 81,000 perkataan penjelasan bertulis — bukan sekadar jawapan.
Start smaller than the question. Before worrying about "running", just get the campaign's grand total:
SELECT SUM(amount) AS grand_total FROM daily_sales;Run it. You get one row — 925.00 — and the four daily rows are gone. That is the thing to fix: you need the total and the rows.
Mula dari sini
Four workplace milestones from an entry screening to owning a decision-ready analysis, with a diagnostic route for skills you already have.
- 01
Pass the screen
Build the smallest useful SQL and spreadsheet toolkit, then prove you can turn a plain request into a correct result.
- 02
Deliver trustworthy numbers
Handle the dirty-data traps behind first-month analyst work: NULLs, duplicates, joins, dates, lookups, and mismatched labels.
- 03
Own the analysis
Move from answering a query to framing, checking, and communicating an analysis that another person can act on.
- 04
Influence the decision
Develop senior signals: reason about schemas and performance, challenge experiment readouts, and communicate what the evidence cannot prove.
Cara ia berfungsi
Satu laluan, dari query pertama anda sampai ke temu duga.
Belajar
Kurikulum percuma — SQL, Excel, dan asas di sebalik kedua-duanya — serta track data science berbayar, disusun dari mula hingga akhir, setiap contoh boleh dijalankan.
Practice
Digred serta-merta terhadap keseluruhan result set — Postgres sebenar yang di-compile ke WebAssembly, jalan dalam browser anda.
Berlatih
Format yang interview loop sebenar guna — bukan sekadar lebih banyak soalan.
AI coach
Ia baca query anda, bukan skrip.
Bila anda tersalah, coach tengok query sebenar yang anda tulis — nama table anda, logik anda, kesilapan spesifik anda — dan bagitahu apa yang tak kena tanpa terus bagi jawapan. Percuma, 3 sesi sehari.
Cuba pada satu soalanGrab · Completed rides by city
SELECT city, COUNT(*) AS completed_rides FROM rides GROUP BY city;
AI coach
Anda group by city dan kira semua rides tanpa kira status, sebab itu Ipoh (yang tiada completed rides) termasuk secara salah. Cuba filter rides dulu supaya hanya ambil yang status = 'completed' sebelum group by — itu akan betulkan kiraan dan keluarkan bandar yang tiada completed rides. Cara ini lebih jelas dan lebih efficient untuk objektif anda. Teruskan, anda dah hampir!
Selain SQL
Dua lagi disiplin, digred cara yang sama.
Excel
Setel · Klasifikasikan tier loyalty ahli ikut perbelanjaan bulanan
Keputusan yang digred: A1 is 180: not under 100, so the first branch fails, but under 300, so it lands on Silver.
Take-home
Setiap lab berakhir dengan write-up yang take-home sebenar dinilai — petikan model answer, bukan sekadar query.
### Question What's total revenue from this CSV export, and is the export itself trustworthy enough to report a number from? ### Data One `txns` table, 24 rows, dates 2026-07-01 to 2026-07-20 — a single export, no joins. ### Method - Counted rows and pulled …
Database
Sesetengah soalan bukan digred ikut baris output langsung — soalan ini digred dengan check catalog Postgres sendiri untuk primary key constraint yang betul.
ALTER TABLE orders ADD CONSTRAINT orders_pkey PRIMARY KEY (id);
Kurikulum
29 bab, tersusun
Single-table fundamentals: read, filter, sort, and reshape data.
- 01Start here: SQL & this tutorial
- 02SELECT: reading data
- 03WHERE: filtering rows
+ 10 lagi
Summarize data and combine it across tables.
- 14Aggregate functions: SUM, AVG, COUNT, MIN, MAX
- 15GROUP BY: one row per group
- 16HAVING: filtering groups, not rows
+ 4 lagi
Multi-step reasoning: the questions that separate candidates.
- 21Query execution order
- 22Subqueries & CTEs
- 23Window functions
+ 6 lagi
Basic — RM 25/bulan
Free bagi jawapan. Basic ajar sebab.
Setiap soalan datang dengan walkthrough langkah demi langkah dan soalan susulan interviewer — digate walaupun pada soalan free, sebab itulah saat interview sebenar teruskan. Basic juga buka keseluruhan bank, take-home round, Data Lab (beta), had AI coach harian yang lebih tinggi, dan dashboard dengan review queue yang makin berguna semakin lama anda guna.
Lihat hargaShopee
Running total of daily sales
Free
Scaffold 4-hint bawa anda dari query kosong ke jawapan, satu nudge pada satu masa — tak pernah terus bagi solution.
Basic — soalan susulan interviewer
Nice — the running total works. Now add a column showing each day's amount as a percentage of the whole campaign's total (pct_of_total), rounded to one decimal place.
Bank soalan
Sedikit rasa apa yang anda akan selesaikan
Add a primary key to an unkeyed orders table
schema-designAbsolute difference and relative lift
experimentationBusiest data center in each region
windowApplicants with no referral code on file
basicsAccounts above their own branch's average
subqueryCharge each payout its tier's fee
mathTemu duga data anda seterusnya bermula di sini.
Mula laluan Data Analyst, atau terus ke bank soalan. Kedua-duanya percuma, dan tiada satu pun minta anda sign up dulu.