{"id":11795,"date":"2026-09-11T17:02:30","date_gmt":"2026-09-11T10:02:30","guid":{"rendered":"https:\/\/vtiacademy.site\/?p=11795"},"modified":"2026-09-11T17:04:50","modified_gmt":"2026-09-11T10:04:50","slug":"tu-hoc-data-analyst","status":"publish","type":"post","link":"https:\/\/vtiacademy.site\/index.php\/tu-hoc-data-analyst\/","title":{"rendered":"L\u1ed9 tr\u00ecnh t\u1ef1 h\u1ecdc Data Analyst cho ng\u01b0\u1eddi m\u1edbi (full t\u00e0i li\u1ec7u)"},"content":{"rendered":"

T\u1ef1 h\u1ecdc Data Analyst l\u00e0 l\u1ef1a ch\u1ecdn ng\u00e0y c\u00e0ng ph\u1ed5 bi\u1ebfn \u0111\u1ed1i v\u1edbi nhi\u1ec1u b\u1ea1n tr\u1ebb v\u00e0 ng\u01b0\u1eddi \u0111i l\u00e0m m\u00e0 v\u1eabn ch\u1ee7 \u0111\u1ed9ng v\u1ec1 th\u1eddi gian v\u00e0 chi ph\u00ed. B\u00e0i vi\u1ebft n\u00e0y, VTI Academy s\u1ebd tr\u00ecnh b\u00e0y chi ti\u1ebft l\u1ed9 tr\u00ecnh t\u1ef1 h\u1ecdc Data Analyst cho ng\u01b0\u1eddi m\u1edbi, danh s\u00e1ch t\u00e0i li\u1ec7u th\u1ef1c s\u1ef1 h\u1eefu \u00edch v\u00e0 nh\u1eefng sai l\u1ea7m th\u01b0\u1eddng g\u1eb7p c\u1ea7n tr\u00e1nh, gi\u00fap b\u1ea1n x\u00e2y d\u1ef1ng n\u1ec1n t\u1ea3ng v\u1eefng ch\u1eafc ngay t\u1eeb \u0111\u1ea7u.<\/p>\n

L\u1ed9 tr\u00ecnh t\u1ef1 h\u1ecdc Data Analyst cho ng\u01b0\u1eddi m\u1edbi<\/h2>\n

D\u01b0\u1edbi \u0111\u00e2y l\u00e0 l\u1ed9 tr\u00ecnh t\u1ef1 h\u1ecdc Data Analysis chi ti\u1ebft, ph\u00f9 h\u1ee3p v\u1edbi h\u1ecdc data analyst cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u, h\u1ecdc data analyst b\u1eaft \u0111\u1ea7u t\u1eeb \u0111\u1ea7u v\u00e0 b\u1eaft \u0111\u1ea7u h\u1ecdc data analyst cho ng\u01b0\u1eddi m\u1edbi. N\u1ebfu b\u1ea1n ki\u00ean tr\u00ec theo \u0111\u00fang th\u1ee9 t\u1ef1 v\u00e0 d\u00e0nh kho\u1ea3ng 10\u201315 gi\u1edd m\u1ed7i tu\u1ea7n, b\u1ea1n c\u00f3 th\u1ec3 ho\u00e0n th\u00e0nh trong 4\u20137 th\u00e1ng.<\/p>\n

Giai \u0111o\u1ea1n 1: X\u00e2y d\u1ef1ng t\u01b0 duy d\u1eef li\u1ec7u v\u00e0 th\u00e0nh th\u1ea1o Excel (3\u20135 tu\u1ea7n)<\/h3>\n

\u0110\u00e2y l\u00e0 b\u01b0\u1edbc quan tr\u1ecdng nh\u1ea5t trong l\u1ed9 tr\u00ecnh Data Analyst cho ng\u01b0\u1eddi m\u1edbi. Thay v\u00ec lao ngay v\u00e0o l\u1eadp tr\u00ecnh, h\u00e3y d\u00e0nh th\u1eddi gian l\u00e0m quen v\u1edbi Excel n\u00e2ng cao. H\u1ecdc c\u00e1c h\u00e0m t\u00ecm ki\u1ebfm (VLOOKUP, XLOOKUP, INDEX-MATCH), Pivot Table, Power Query \u0111\u1ec3 l\u00e0m s\u1ea1ch v\u00e0 bi\u1ebfn \u0111\u1ed5i d\u1eef li\u1ec7u, c\u00f9ng c\u00e1c k\u1ef9 thu\u1eadt t\u1ea1o b\u00e1o c\u00e1o \u0111\u1ed9ng. Song song \u0111\u00f3, r\u00e8n luy\u1ec7n t\u01b0 duy \u0111\u1eb7t c\u00e2u h\u1ecfi: d\u1eef li\u1ec7u n\u00e0y cho bi\u1ebft \u0111i\u1ec1u g\u00ec, t\u1ea1i sao l\u1ea1i nh\u01b0 v\u1eady, v\u00e0 c\u00f3 th\u1ec3 \u0111\u01b0a ra quy\u1ebft \u0111\u1ecbnh g\u00ec.<\/p>\n

B\u1ea1n n\u00ean th\u1ef1c h\u00e0nh ngay tr\u00ean c\u00e1c b\u1ed9 d\u1eef li\u1ec7u \u0111\u01a1n gi\u1ea3n nh\u01b0 doanh s\u1ed1 b\u00e1n h\u00e0ng ho\u1eb7c kh\u1ea3o s\u00e1t kh\u00e1ch h\u00e0ng. M\u1ee5c ti\u00eau c\u1ee7a giai \u0111o\u1ea1n n\u00e0y l\u00e0 bi\u1ebfn Excel th\u00e0nh c\u00f4ng c\u1ee5 ph\u00e2n t\u00edch m\u1ea1nh m\u1ebd, \u0111\u1ed3ng th\u1eddi h\u00ecnh th\u00e0nh th\u00f3i quen quan s\u00e1t v\u00e0 di\u1ec5n gi\u1ea3i s\u1ed1 li\u1ec7u m\u1ed9t c\u00e1ch logic. Nhi\u1ec1u ng\u01b0\u1eddi b\u1ecf qua b\u01b0\u1edbc n\u00e0y n\u00ean khi h\u1ecdc c\u00e1c c\u00f4ng c\u1ee5 n\u00e2ng cao h\u01a1n th\u01b0\u1eddng b\u1ecb l\u00fang t\u00fang.<\/p>\n

\"\"<\/p>\n

Giai \u0111o\u1ea1n 2: L\u00e0m ch\u1ee7 SQL – ng\u00f4n ng\u1eef truy v\u1ea5n d\u1eef li\u1ec7u (4\u20136 tu\u1ea7n)<\/h3>\n

SQL l\u00e0 k\u1ef9 n\u0103ng c\u1ed1t l\u00f5i m\u00e0 h\u1ea7u h\u1ebft nh\u00e0 tuy\u1ec3n d\u1ee5ng \u0111\u1ec1u y\u00eau c\u1ea7u. B\u1eaft \u0111\u1ea7u v\u1edbi c\u00e1c c\u00e2u l\u1ec7nh c\u01a1 b\u1ea3n: SELECT, FROM, WHERE, GROUP BY, ORDER BY, sau \u0111\u00f3 h\u1ecdc JOIN (INNER, LEFT, RIGHT), subquery, CTE v\u00e0 window function.<\/p>\n

H\u00e3y th\u1ef1c h\u00e0nh tr\u00ean c\u00e1c n\u1ec1n t\u1ea3ng mi\u1ec5n ph\u00ed c\u00f3 s\u1eb5n d\u1eef li\u1ec7u m\u1eabu. M\u1ee5c ti\u00eau kh\u00f4ng ch\u1ec9 l\u00e0 vi\u1ebft \u0111\u01b0\u1ee3c c\u00e2u truy v\u1ea5n \u0111\u00fang c\u00fa ph\u00e1p m\u00e0 c\u00f2n ph\u1ea3i hi\u1ec3u c\u00e1ch t\u1ed1i \u01b0u \u0111\u1ec3 l\u1ea5y \u0111\u00fang th\u00f4ng tin c\u1ea7n thi\u1ebft trong th\u1eddi gian ng\u1eafn. Giai \u0111o\u1ea1n n\u00e0y gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 v\u1edbi c\u01a1 s\u1edf d\u1eef li\u1ec7u th\u1ef1c t\u1ebf \u2013 th\u1ee9 m\u00e0 Excel kh\u00f3 x\u1eed l\u00fd khi d\u1eef li\u1ec7u l\u1edbn. \u0110\u00e2y c\u0169ng l\u00e0 b\u01b0\u1edbc quan tr\u1ecdng trong l\u1ed9 tr\u00ecnh h\u1ecdc Data Analysis v\u00ec ph\u1ea7n l\u1edbn c\u00f4ng vi\u1ec7c c\u1ee7a Data Analyst b\u1eaft \u0111\u1ea7u t\u1eeb vi\u1ec7c l\u1ea5y v\u00e0 l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u.<\/p>\n

Giai \u0111o\u1ea1n 3: Python cho ph\u00e2n t\u00edch d\u1eef li\u1ec7u (5\u20137 tu\u1ea7n)<\/h3>\n

Khi \u0111\u00e3 c\u00f3 n\u1ec1n t\u1ea3ng Excel v\u00e0 SQL, b\u1ea1n chuy\u1ec3n sang Python. T\u1eadp trung v\u00e0o c\u00e1c th\u01b0 vi\u1ec7n ch\u00ednh: Pandas \u0111\u1ec3 x\u1eed l\u00fd v\u00e0 l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u, NumPy cho t\u00ednh to\u00e1n, Matplotlib v\u00e0 Seaborn \u0111\u1ec3 v\u1ebd bi\u1ec3u \u0111\u1ed3. H\u1ecdc c\u00e1ch \u0111\u1ecdc nhi\u1ec1u \u0111\u1ecbnh d\u1ea1ng file, x\u1eed l\u00fd gi\u00e1 tr\u1ecb thi\u1ebfu, lo\u1ea1i b\u1ecf ngo\u1ea1i lai, t\u1ea1o bi\u1ebfn m\u1edbi v\u00e0 th\u1ef1c hi\u1ec7n ph\u00e2n t\u00edch kh\u00e1m ph\u00e1 d\u1eef li\u1ec7u (EDA).<\/p>\n

S\u1eed d\u1ee5ng Jupyter Notebook ho\u1eb7c Google Colab \u0111\u1ec3 vi\u1ebft code v\u00e0 ghi ch\u00fa song song. H\u00e3y l\u00e0m nhi\u1ec1u b\u00e0i t\u1eadp nh\u1ecf h\u00e0ng ng\u00e0y, sau \u0111\u00f3 t\u1ed5ng h\u1ee3p th\u00e0nh m\u1ed9t quy tr\u00ecnh ho\u00e0n ch\u1ec9nh t\u1eeb d\u1eef li\u1ec7u th\u00f4 \u0111\u1ebfn insight. Giai \u0111o\u1ea1n n\u00e0y gi\u00fap b\u1ea1n x\u1eed l\u00fd \u0111\u01b0\u1ee3c kh\u1ed1i l\u01b0\u1ee3ng d\u1eef li\u1ec7u l\u1edbn h\u01a1n nhi\u1ec1u so v\u1edbi Excel v\u00e0 chu\u1ea9n b\u1ecb t\u1ed1t cho c\u00e1c b\u00e0i to\u00e1n ph\u1ee9c t\u1ea1p h\u01a1n.<\/p>\n

Giai \u0111o\u1ea1n 4: Tr\u1ef1c quan h\u00f3a d\u1eef li\u1ec7u v\u00e0 storytelling (3\u20135 tu\u1ea7n)<\/h3>\n

H\u1ecdc Power BI ho\u1eb7c Tableau \u0111\u1ec3 bi\u1ebfn s\u1ed1 li\u1ec7u th\u00e0nh dashboard d\u1ec5 hi\u1ec3u. T\u1eadp trung v\u00e0o c\u00e1ch k\u1ebft n\u1ed1i d\u1eef li\u1ec7u, x\u00e2y d\u1ef1ng m\u00f4 h\u00ecnh quan h\u1ec7, t\u1ea1o measure b\u1eb1ng DAX (n\u1ebfu d\u00f9ng Power BI) v\u00e0 thi\u1ebft k\u1ebf giao di\u1ec7n tr\u1ef1c quan. Quan tr\u1ecdng h\u01a1n c\u1ea3 l\u00e0 k\u1ef9 n\u0103ng k\u1ec3 chuy\u1ec7n b\u1eb1ng d\u1eef li\u1ec7u: l\u00e0m sao \u0111\u1ec3 ng\u01b0\u1eddi xem nhanh ch\u00f3ng n\u1eafm \u0111\u01b0\u1ee3c th\u00f4ng \u0111i\u1ec7p ch\u00ednh m\u00e0 kh\u00f4ng b\u1ecb r\u1ed1i.<\/p>\n

H\u00e3y th\u1ef1c h\u00e0nh x\u00e2y d\u1ef1ng dashboard ho\u00e0n ch\u1ec9nh t\u1eeb c\u00e1c d\u1ef1 \u00e1n tr\u01b0\u1edbc \u0111\u00f3. K\u1ef9 n\u0103ng n\u00e0y th\u01b0\u1eddng l\u00e0 \u0111i\u1ec3m c\u1ed9ng l\u1edbn khi b\u1ea1n \u1ee9ng tuy\u1ec3n v\u00ec nh\u00e0 tuy\u1ec3n d\u1ee5ng mu\u1ed1n th\u1ea5y kh\u1ea3 n\u0103ng truy\u1ec1n \u0111\u1ea1t insight r\u00f5 r\u00e0ng.<\/p>\n

Giai \u0111o\u1ea1n 5: Th\u1ed1ng k\u00ea c\u01a1 b\u1ea3n v\u00e0 l\u00e0m quen Machine Learning (3\u20134 tu\u1ea7n)<\/h3>\n

Hi\u1ec3u c\u00e1c kh\u00e1i ni\u1ec7m th\u1ed1ng k\u00ea m\u00f4 t\u1ea3 (mean, median, mode, \u0111\u1ed9 l\u1ec7ch chu\u1ea9n), t\u01b0\u01a1ng quan, v\u00e0 h\u1ed3i quy \u0111\u01a1n gi\u1ea3n. Sau \u0111\u00f3 l\u00e0m quen v\u1edbi quy tr\u00ecnh Machine Learning c\u01a1 b\u1ea3n b\u1eb1ng scikit-learn: chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u, chia t\u1eadp train\/test, hu\u1ea5n luy\u1ec7n m\u00f4 h\u00ecnh \u0111\u01a1n gi\u1ea3n (h\u1ed3i quy tuy\u1ebfn t\u00ednh, c\u00e2y quy\u1ebft \u0111\u1ecbnh) v\u00e0 \u0111\u00e1nh gi\u00e1 k\u1ebft qu\u1ea3.<\/p>\n

Kh\u00f4ng c\u1ea7n \u0111i qu\u00e1 s\u00e2u v\u00e0o thu\u1eadt to\u00e1n ph\u1ee9c t\u1ea1p. M\u1ee5c ti\u00eau ch\u1ec9 l\u00e0 n\u1eafm \u0111\u01b0\u1ee3c c\u00e1ch th\u1ee9c ho\u1ea1t \u0111\u1ed9ng v\u00e0 bi\u1ebft khi n\u00e0o n\u00ean \u00e1p d\u1ee5ng. Giai \u0111o\u1ea1n n\u00e0y gi\u00fap b\u1ea1n t\u1ef1 tin h\u01a1n khi \u0111\u1ecdc b\u00e1o c\u00e1o ph\u00e2n t\u00edch ho\u1eb7c tham gia c\u00e1c d\u1ef1 \u00e1n c\u00f3 y\u1ebfu t\u1ed1 d\u1ef1 b\u00e1o.<\/p>\n

\"\"<\/p>\n

Giai \u0111o\u1ea1n 6: Th\u1ef1c hi\u1ec7n d\u1ef1 \u00e1n th\u1ef1c t\u1ebf v\u00e0 x\u00e2y d\u1ef1ng portfolio (li\u00ean t\u1ee5c t\u1eeb th\u00e1ng th\u1ee9 3)<\/h3>\n

\u0110\u00e2y l\u00e0 ph\u1ea7n quan tr\u1ecdng nh\u1ea5t c\u1ee7a l\u1ed9 tr\u00ecnh tr\u1edf th\u00e0nh Data Analyst. H\u00e3y ch\u1ecdn 4\u20136 d\u1ef1 \u00e1n \u0111a d\u1ea1ng: ph\u00e2n t\u00edch doanh s\u1ed1 theo th\u1eddi gian, ph\u00e2n kh\u00fac kh\u00e1ch h\u00e0ng, d\u1ef1 b\u00e1o nhu c\u1ea7u \u0111\u01a1n gi\u1ea3n, ho\u1eb7c ph\u00e2n t\u00edch d\u1eef li\u1ec7u c\u00f4ng khai tr\u00ean Kaggle. M\u1ed7i d\u1ef1 \u00e1n c\u1ea7n c\u00f3 b\u00e1o c\u00e1o r\u00f5 r\u00e0ng: m\u1ee5c ti\u00eau, quy tr\u00ecnh x\u1eed l\u00fd, insight ch\u00ednh v\u00e0 \u0111\u1ec1 xu\u1ea5t h\u00e0nh \u0111\u1ed9ng.<\/p>\n

Vi\u1ebft code s\u1ea1ch, th\u00eam gi\u1ea3i th\u00edch, v\u00e0 l\u01b0u tr\u1eef tr\u00ean GitHub. Portfolio ch\u1ea5t l\u01b0\u1ee3ng s\u1ebd l\u00e0 minh ch\u1ee9ng m\u1ea1nh m\u1ebd cho n\u0103ng l\u1ef1c c\u1ee7a b\u1ea1n, quan tr\u1ecdng h\u01a1n nhi\u1ec1u so v\u1edbi vi\u1ec7c ch\u1ec9 li\u1ec7t k\u00ea c\u00e1c kh\u00f3a h\u1ecdc \u0111\u00e3 ho\u00e0n th\u00e0nh. \u0110\u00e2y c\u0169ng l\u00e0 l\u00fac b\u1ea1n luy\u1ec7n b\u00e0i t\u1eadp Data Analyst \u1edf m\u1ee9c \u0111\u1ed9 th\u1ef1c chi\u1ebfn nh\u1ea5t.<\/p>\n

Giai \u0111o\u1ea1n 7: Chu\u1ea9n b\u1ecb ph\u1ecfng v\u1ea5n v\u00e0 c\u1eadp nh\u1eadt ki\u1ebfn th\u1ee9c<\/h3>\n

Luy\u1ec7n c\u00e1c c\u00e2u h\u1ecfi k\u1ef9 thu\u1eadt ph\u1ed5 bi\u1ebfn v\u1ec1 SQL, Python, case study ph\u00e2n t\u00edch. T\u1eadp gi\u1ea3i th\u00edch insight m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n, d\u1ec5 hi\u1ec3u. \u0110\u1ed3ng th\u1eddi theo d\u00f5i xu h\u01b0\u1edbng c\u00f4ng c\u1ee5 m\u1edbi v\u00e0 c\u00e1c v\u1ecb tr\u00ed tuy\u1ec3n d\u1ee5ng \u0111\u1ec3 \u0111i\u1ec1u ch\u1ec9nh k\u1ef9 n\u0103ng cho ph\u00f9 h\u1ee3p.<\/p>\n

L\u1ed9 tr\u00ecnh h\u1ecdc Data Analyst tr\u00ean \u0111\u00e2y \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf d\u00e0nh ri\u00eang cho ng\u01b0\u1eddi m\u1edbi, kh\u00f4ng y\u00eau c\u1ea7u n\u1ec1n t\u1ea3ng l\u1eadp tr\u00ecnh s\u1eb5n c\u00f3. Nhi\u1ec1u b\u1ea1n th\u1eafc m\u1eafc h\u1ecdc Data Analyst c\u00f3 kh\u00f3 kh\u00f4ng\u00a0th\u1ef1c t\u1ebf kh\u00f4ng qu\u00e1 kh\u00f3 n\u1ebfu b\u1ea1n \u0111i \u0111\u00fang th\u1ee9 t\u1ef1, th\u1ef1c h\u00e0nh \u0111\u1ec1u \u0111\u1eb7n v\u00e0 kh\u00f4ng n\u00f3ng v\u1ed9i. T\u1ef1 h\u1ecdc Data Analysis \u0111\u00f2i h\u1ecfi t\u00ednh k\u1ef7 lu\u1eadt, nh\u01b0ng \u0111\u1ed5i l\u1ea1i b\u1ea1n ch\u1ee7 \u0111\u1ed9ng ho\u00e0n to\u00e0n v\u1ec1 t\u1ed1c \u0111\u1ed9 v\u00e0 n\u1ed9i dung.<\/p>\n

C\u00e1c t\u00e0i li\u1ec7u h\u1eefu \u00edch b\u1ea1n kh\u00f4ng n\u00ean b\u1ecf qua<\/h2>\n

\u0110\u1ec3 h\u1ed7 tr\u1ee3 qu\u00e1 tr\u00ecnh t\u1ef1 h\u1ecdc Data Analyst, b\u1ea1n n\u00ean k\u1ebft h\u1ee3p nhi\u1ec1u ngu\u1ed3n t\u00e0i li\u1ec7u Data Analysis\u00a0ch\u1ea5t l\u01b0\u1ee3ng. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 danh s\u00e1ch \u0111\u01b0\u1ee3c ch\u1ecdn l\u1ecdc, d\u1ec5 ti\u1ebfp c\u1eadn v\u00e0 th\u1ef1c s\u1ef1 h\u1eefu \u00edch:<\/p>\n