{"id":132,"date":"2023-07-23T11:52:18","date_gmt":"2023-07-23T10:52:18","guid":{"rendered":"https:\/\/thehaublog.com\/?p=132"},"modified":"2023-08-05T09:51:05","modified_gmt":"2023-08-05T08:51:05","slug":"3-tru-cot-kien-thuc-ky-nang-de-lam-tot-hon-cong-viec-phan-tich-du-lieu","status":"publish","type":"post","link":"https:\/\/thehaublog.com\/index.php\/2023\/07\/23\/3-tru-cot-kien-thuc-ky-nang-de-lam-tot-hon-cong-viec-phan-tich-du-lieu\/","title":{"rendered":"3 tr\u1ee5 c\u1ed9t ki\u1ebfn th\u1ee9c & k\u1ef9 n\u0103ng \u0111\u1ec3 l\u00e0m t\u1ed1t h\u01a1n c\u00f4ng vi\u1ec7c c\u1ee7a Data Analyst\/Business Intelligence Analyst"},"content":{"rendered":"\n

Ti\u1ebfp theo series t\u1ed5ng quan v\u1ec1 ng\u00e0nh data<\/strong><\/a> th\u00ec trong b\u00e0i vi\u1ebft n\u00e0y m\u00ecnh s\u1ebd chia s\u1ebb cho c\u00e1c b\u1ea1n c\u00e1c tr\u1ee5 c\u1ed9t ch\u00ednh v\u1ec1 ki\u1ebfn th\u1ee9c v\u00e0 k\u1ef9 n\u0103ng c\u1ea7n thi\u1ebft \u0111\u1ec3 l\u00e0m t\u1ed1t c\u00f4ng vi\u1ec7c ph\u00e2n t\u00edch d\u1eef li\u1ec7u c\u1ee7a Data Analyst\/Business Intelligence Analyst.<\/p>\n\n\n\n

Th\u00f4ng th\u01b0\u1eddng c\u00e1c b\u1ea1n m\u1edbi t\u00ecm hi\u1ec3u v\u1ec1 ngh\u1ec1 Data Analyst\/Business Intelligence Analyst th\u01b0\u1eddng nghe \u0111\u1ebfn c\u00e1c keywords trong c\u00e1c b\u00e0i qu\u1ea3ng c\u00e1o c\u1ee7a r\u1ea5t nhi\u1ec1u trung t\u00e2m d\u1ea1y v\u1ec1 ph\u00e2n t\u00edch d\u1eef li\u1ec7u nh\u01b0: h\u1ecdc SQL, h\u1ecdc l\u00e0m b\u00e1o c\u00e1o v\u1edbi Power BI, Tableau, Python sau 3 th\u00e1ng th\u00ec s\u1ebd c\u00f3 \u0111\u01b0\u1ee3c c\u00f4ng vi\u1ec7c data analyst ng\u00e0n \u0111\u00f4. C\u00e1c k\u1ef9 n\u0103ng n\u00e0y l\u00e0 c\u1ea7n thi\u1ebft nh\u01b0ng theo kinh nghi\u1ec7m \u0111i l\u00e0m th\u1ef1c t\u1ebf v\u00e0 quan s\u00e1t c\u00e1 nh\u00e2n m\u00ecnh th\u00ec n\u00f3 v\u1eabn ch\u01b0a \u0111\u1ee7. \u1ede b\u00e0i n\u00e0y m\u00ecnh s\u1ebd c\u1ed1 g\u1eafng chia s\u1ebb b\u1ee9c tranh t\u1ed5ng qu\u00e1t h\u01a1n v\u1ec1 c\u00e1c m\u1ea3ng ki\u1ebfn th\u1ee9c v\u00e0 k\u1ef9 n\u0103ng c\u1ea7n thi\u1ebft \u0111\u1ec3 l\u00e0m t\u1ed1t c\u00f4ng vi\u1ec7c n\u00e0y. <\/p>\n\n\n\n

Ph\u00e2n t\u00edch d\u1eef li\u1ec7u l\u00e0 m\u1ed9t h\u01b0\u1edbng ng\u00e0nh tri\u1ec3n v\u1ecdng tr\u00ean th\u1ebf gi\u1edbi v\u00e0 c\u1ea3 Vi\u1ec7t Nam nh\u01b0 \u1edf b\u00e0i vi\u1ebft tr\u01b0\u1edbc<\/a> m\u00ecnh \u0111\u00e3 chia s\u1ebb, \u0111\u1ed3ng th\u1eddi n\u00f3 c\u0169ng l\u00e0 m\u1ed9t ngh\u1ec1 kh\u00f3<\/strong>, \u0111\u00f2i h\u1ecfi nhi\u1ec1u chi\u1ec1u ki\u1ebfn th\u1ee9c kh\u00e1c nhau v\u00e0 ki\u1ebfn th\u1ee9c trong ng\u00e0nh c\u0169ng thay \u0111\u1ed5i nhanh \u0111\u00f2i h\u1ecfi ng\u01b0\u1eddi theo ngh\u1ec1 ph\u1ea3i li\u00ean t\u1ee5c trau d\u1ed3i, update ki\u1ebfn th\u1ee9c li\u00ean t\u1ee5c \u0111\u1ec3 kh\u00f4ng b\u1ecb t\u1ee5t l\u1ea1i ph\u00eda sau. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Nh\u01b0 h\u00ecnh b\u00ean tr\u00ean, theo m\u00ecnh \u0111\u1ec3 l\u00e0m t\u1ed1t c\u00f4ng vi\u1ec7c ph\u00e2n t\u00edch d\u1eef li\u1ec7u c\u1ea7n c\u00f3 3 tr\u1ee5 c\u1ed9t ch\u00ednh: <\/p>\n\n\n\n

    \n
  1. Business domain:<\/strong> ki\u1ebfn th\u1ee9c v\u1ec1 ng\u00e0nh\/l\u0129nh v\u1ef1c b\u1ea1n \u0111ang ph\u00e2n t\u00edch.<\/li>\n\n\n\n
  2. Tech stack:<\/strong> c\u00e1c c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 cho vi\u1ec7c ph\u00e2n t\u00edch d\u1eef li\u1ec7u, t\u01b0 duy ph\u00e2n t\u00edch, ki\u1ebfn th\u1ee9c v\u1ec1 th\u1ed1ng k\u00ea..,<\/li>\n\n\n\n
  3. K\u1ef9 n\u0103ng m\u1ec1m:<\/strong> storytelling with data (k\u1ef9 n\u0103ng k\u1ec3 chuy\u1ec7n b\u1eb1ng d\u1eef li\u1ec7u), teamwork, project management (k\u1ef9 n\u0103ng qu\u1ea3n l\u00fd d\u1ef1 \u00e1n), stakeholder management, communication.., <\/li>\n<\/ol>\n\n\n\n

    Nh\u01b0 c\u00e1c b\u1ea1n th\u1ea5y, ki\u1ebfn th\u1ee9c v\u1ec1 SQL hay c\u00e1c BI tools (Power BI, Tableau..,) ch\u1ec9 l\u00e0 m\u1ed9t ph\u1ea7n nh\u1ecf trong b\u1ee9c tranh l\u1edbn, c\u00e1c ki\u1ebfn th\u1ee9c n\u00e0y \u0111ang n\u1eb1m trong ph\u1ea7n “tech stack” c\u00f9ng v\u1edbi kha kh\u00e1 nhi\u1ec1u c\u00e1c ki\u1ebfn th\u1ee9c v\u00e0 k\u1ef9 n\u0103ng kh\u00e1c (chi ti\u1ebft \u1edf d\u01b0\u1edbi).<\/em><\/p>\n\n\n\n

    1. Business domain (ki\u1ebfn th\u1ee9c ng\u00e0nh)<\/h2>\n\n\n\n

    Theo c\u00e1 nh\u00e2n m\u00ecnh th\u00ec business domain ki\u1ebfn th\u1ee9c ng\u00e0nh l\u00e0 m\u1ed9t m\u1ea3ng quan tr\u1ecdng kh\u00f4ng th\u1ec3 thi\u1ebfu n\u1ebfu b\u1ea1n mu\u1ed1n l\u00e0m t\u1ed1t c\u00f4ng vi\u1ec7c ph\u00e2n t\u00edch d\u1eef li\u1ec7u. M\u1ed9t b\u00e1o c\u00e1o ho\u1eb7c m\u1ed9t b\u00e0i ph\u00e2n t\u00edch s\u1ebd kh\u00f4ng mang l\u1ea1i nhi\u1ec1u value cho business<\/strong> n\u1ebfu b\u1ea1n kh\u00f4ng hi\u1ec3u r\u00f5<\/strong> c\u00e1c ch\u1ec9 s\u1ed1 m\u00ecnh \u0111ang \u0111o l\u01b0\u1eddng \u0111ang ph\u1ee5c v\u1ee5 cho m\u1ee5c \u0111\u00edch g\u00ec? T\u1ea1i sao l\u1ea1i c\u00f3 b\u00e0i ph\u00e2n t\u00edch \u0111\u00f3?<\/strong> T\u1ea1i sao ch\u1ed7 n\u00e0y l\u00e0 ph\u00e2n t\u00edch theo h\u01b0\u1edbng A, ch\u1ed7 kia l\u1ea1i ph\u00e2n t\u00edch theo h\u01b0\u1edbng B? C\u0169ng d\u1ec5 hi\u1ec3u khi \u0111\u00e2y c\u0169ng l\u00e0 th\u1ee9 c\u00e1c newbie m\u1edbi v\u00e0o ngh\u1ec1 s\u1ebd b\u1ecb thi\u1ebfu, v\u00ec b\u1ea3n th\u00e2n m\u00ecnh l\u00fac m\u1edbi b\u1eaft \u0111\u1ea7u c\u0169ng g\u1eb7p t\u00ecnh tr\u1ea1ng t\u01b0\u01a1ng t\u1ef1. N\u1ebfu ch\u00fang ta ch\u01b0a l\u00e0m trong c\u00e1c l\u0129nh v\u1ef1c c\u1ee5 th\u1ec3 n\u00e0y bao gi\u1edd th\u00ec c\u00e1c nghi\u1ec7p v\u1ee5, ch\u1ec9 s\u1ed1 \u0111o l\u01b0\u1eddng, quy tr\u00ecnh \u0111\u1eb7c th\u00f9 c\u1ee7a l\u0129nh v\u1ef1c \u0111\u00f3 ch\u00fang ta s\u1ebd kh\u00f3 m\u00e0 hi\u1ec3u s\u00e2u \u0111\u01b0\u1ee3c. M\u1ed9t s\u1ed1 c\u00e1ch \u0111\u1ec3 t\u1ee5i m\u00ecnh c\u00f3 th\u1ec3 trau d\u1ed3i ph\u1ea7n ki\u1ebfn th\u1ee9c ng\u00e0nh n\u00e0y:<\/p>\n\n\n\n

      \n
    • \u0110\u1ecdc nhi\u1ec1u t\u00e0i li\u1ec7u v\u1ec1 c\u00e1c business model t\u01b0\u01a1ng t\u1ef1 tr\u00ean th\u1ecb tr\u01b0\u1eddng c\u1ea3 trong n\u01b0\u1edbc v\u00e0 th\u1ebf gi\u1edbi.<\/li>\n\n\n\n
    • Li\u00ean t\u1ee5c h\u1ecdc h\u1ecfi t\u1eeb c\u00e1c \u0111\u1ed3ng nghi\u1ec7p trong v\u00e0 ngo\u00e0i<\/strong> team data.<\/li>\n\n\n\n
    • \u0110\u1ecdc v\u00e0 research v\u1ec1 c\u00e1c b\u00e1o c\u00e1o, b\u00e0i ph\u00e2n t\u00edch hi\u1ec7n t\u1ea1i, t\u00e0i li\u1ec7u n\u1ed9i b\u1ed9 kh\u00f4ng ch\u1ec9 c\u1ee7a m\u1ea3ng m\u00ecnh \u0111ang l\u00e0m m\u00e0 c\u00f2n c\u1ee7a c\u00e1c m\u1ea3ng kh\u00e1c t\u1eeb \u0111\u00f3 c\u00f3 \u0111\u01b0\u1ee3c m\u1ed9t c\u00e1i nh\u00ecn t\u1ed5ng th\u1ec3 v\u1ec1 c\u1ea3 business c\u1ee7a c\u00f4ng ty.<\/li>\n\n\n\n
    • C\u1ed1 g\u1eafng n\u00f3i chuy\u1ec7n nhi\u1ec1u v\u1edbi c\u00e1c ph\u00f2ng ban m\u00e0 m\u00ecnh \u0111ang h\u1ed7 tr\u1ee3 \u0111\u1ec3 hi\u1ec3u r\u00f5 quy tr\u00ecnh nghi\u1ec7p v\u1ee5 c\u1ee7a h\u1ecd, pain point h\u1ecd \u0111ang g\u1eb7p ph\u1ea3i v\u00e0 data \u0111ang h\u1ed7 tr\u1ee3 h\u1ecd th\u1ebf n\u00e0o trong c\u00f4ng vi\u1ec7c h\u1eb1ng ng\u00e0y. G\u1ea1ch \u0111\u1ea7u d\u00f2ng n\u00e0y m\u00ecnh \u0111ang \u00e1p d\u1ee5ng nhi\u1ec1u nh\u1ea5t v\u00e0 n\u00f3 \u0111em l\u1ea1i cho m\u00ecnh nhi\u1ec1u g\u00f3c nh\u00ecn m\u1edbi t\u1eeb c\u00e1c team v\u1eadn h\u00e0nh kh\u00e1c, t\u1eeb \u0111\u00f3 m\u00ecnh c\u0169ng h\u1ed7 tr\u1ee3 h\u1ecd t\u1ed1t h\u01a1n v\u1ec1 m\u1eb7t s\u1eed d\u1ee5ng d\u1eef li\u1ec7u \u0111\u1ec3 ra quy\u1ebft \u0111\u1ecbnh.<\/li>\n<\/ul>\n\n\n\n

      C\u00f3 \u0111\u01b0\u1ee3c m\u1ed9t n\u1ec1n t\u1ea3ng v\u1ec1 ki\u1ebfn th\u1ee9c ng\u00e0nh v\u1ec1 l\u0129nh v\u1ef1c b\u1ea1n \u0111ang l\u00e0m th\u00ec m\u00ecnh tin l\u00e0 c\u00f4ng vi\u1ec7c c\u1ee7a m\u1ecdi ng\u01b0\u1eddi s\u1ebd tr\u1edf n\u00ean m\u01b0\u1ee3t m\u00e0 <\/strong>h\u01a1n r\u1ea5t nhi\u1ec1u. C\u00e1c b\u00e0i ph\u00e2n t\u00edch c\u1ee7a c\u00e1c b\u1ea1n s\u1ebd \u0111i v\u00e0o tr\u1ecdng t\u00e2m<\/strong> h\u01a1n, \u0111\u00e1nh \u0111\u00fang v\u00e0o \u0111i\u1ec3m m\u00e0 business c\u1ea7n<\/strong> thay v\u00ec b\u1ea1n ph\u1ea3i t\u1ed1n th\u1eddi gian \u0111i l\u1ee5c l\u1ecdi data ch\u1ec9 v\u00ec kh\u00f4ng bi\u1ebft m\u00ecnh s\u1ebd l\u00e0m g\u00ec. C\u00e1c b\u00e1o c\u00e1o, c\u00e1c b\u00e0i ph\u00e2n t\u00edch s\u1ebd mang l\u1ea1i nhi\u1ec1u impact v\u00e0 value h\u01a1n cho busines<\/strong>s, ngo\u00e0i ra c\u00f2n gi\u1ea3m <\/strong>\u0111\u01b0\u1ee3c vi\u1ec7c misunderstanding <\/strong>trong qu\u00e1 tr\u00ecnh trao \u0111\u1ed5i c\u00f4ng vi\u1ec7c, d\u1ea7n d\u1ea7n \u0111\u00f3ng g\u00f3p c\u1ee7a b\u1ea1n cho team, c\u00e1c ph\u00f2ng ban kh\u00e1c v\u00e0 business n\u00f3i chung c\u0169ng s\u1ebd \u0111\u01b0\u1ee3c ghi nh\u1eadn nhi\u1ec1u h\u01a1n.<\/p>\n\n\n\n

      V\u00ed d\u1ee5 c\u00f4ng vi\u1ec7c hi\u1ec7n t\u1ea1i c\u1ee7a m\u00ecnh l\u00e0 l\u00e0m trong l\u0129nh v\u1ef1c online food delivery t\u1ea1i th\u1ecb tr\u01b0\u1eddng Vi\u1ec7t Nam. Th\u00ec \u00edt nh\u1ea5t m\u00ecnh c\u0169ng ph\u1ea3i bi\u1ebft \u0111\u01b0\u1ee3c: <\/p>\n\n\n\n

      -Business model c\u1ee7a c\u00f4ng ty hi\u1ec7n t\u1ea1i? C\u00e1c \u0111\u1ed1i th\u1ee7 tr\u00ean th\u1ecb tr\u01b0\u1eddng l\u00e0 ai?<\/p>\n\n\n\n

      -C\u00e1c ngu\u1ed3n doanh thu, chi ph\u00ed<\/p>\n\n\n\n

      -C\u00e1c b\u00ean li\u00ean quan trong business model n\u00e0y (customers: kh\u00e1ch h\u00e0ng cu\u1ed1i, merchants: c\u00e1c c\u1eeda h\u00e0ng \u0111\u0103ng k\u00fd gian h\u00e0ng tr\u00ean \u1ee9ng d\u1ee5ng, drivers: \u0111\u1ed9i ng\u0169 giao h\u00e0ng v\u00e0 cu\u1ed1i c\u00f9ng l\u00e0 \u1ee8ng d\u1ee5ng )<\/p>\n\n\n\n

      -C\u00e1c ch\u1ec9 s\u1ed1 quan tr\u1ecdng nh\u1ea5t m\u00e0 c\u1ea3 business \u0111ang nh\u00ecn v\u00e0o v\u00e0o h\u1eb1ng ng\u00e0y, v\u00ed d\u1ee5<\/p>\n\n\n\n

        \n
      • S\u1ed1 l\u01b0\u1ee3ng \u0111\u01a1n h\u00e0ng trung b\u00ecnh h\u1eb1ng ng\u00e0y (Average daily order)<\/li>\n\n\n\n
      • Chi ph\u00ed khuy\u1ebfn m\u00e3i tr\u00ean m\u1ed9t \u0111\u01a1n h\u00e0ng (Promotion cost per order)<\/li>\n\n\n\n
      • Chi ph\u00ed giao h\u00e0ng tr\u00ean m\u1ed9t \u0111\u01a1n h\u00e0ng cho driver (driver cost per order)<\/li>\n\n\n\n
      • Gi\u00e1 tr\u1ecb trung b\u00ecnh \u0111\u01a1n h\u00e0ng (ABS: average bill size)<\/li>\n\n\n\n
      • Hoa h\u1ed3ng tr\u00ean m\u1ed7i \u0111\u01a1n h\u00e0ng th\u00e0nh c\u00f4ng t\u1eeb merchant (commission per order)<\/li>\n\n\n\n
      • ….,<\/li>\n<\/ul>\n\n\n\n

        Khi c\u00f3 hi\u1ec3u bi\u1ebft \u0111\u1ee7 s\u00e2u v\u1ec1 l\u0129nh v\u1ef1c hi\u1ec7n t\u1ea1i th\u00ec khi g\u1eb7p b\u00e0i to\u00e1n ph\u00e2n t\u00edch m\u00ecnh s\u1ebd bi\u1ebft n\u00ean s\u1eed d\u1ee5ng ch\u1ec9 s\u1ed1 n\u00e0o \u0111\u1ec3 ph\u00e2n t\u00edch v\u00e0 c\u00e1c chi\u1ec1u ph\u00e2n t\u00edch nh\u01b0 th\u1ebf n\u00e0o \u0111\u1ec3 h\u1ed7 tr\u1ee3 gi\u1ea3i quy\u1ebft \u0111\u01b0\u1ee3c v\u1ea5n \u0111\u1ec1 business \u0111ang g\u1eb7p ph\u1ea3i d\u01b0\u1edbi g\u00f3c nh\u00ecn d\u1eef li\u1ec7u.<\/p>\n\n\n\n

        2. Tech stack<\/h2>\n\n\n\n

        Kh\u00e1i ni\u1ec7m v\u1ec1 tech stack hi\u1ec3u \u0111\u01a1n gi\u1ea3n l\u00e0 b\u1ed9 c\u00e1c c\u00f4ng c\u1ee5, k\u1ef9 n\u0103ng c\u1ea7n cho vi\u1ec7c ph\u00e2n t\u00edch d\u1eef li\u1ec7u. \u0110\u00e2y l\u00e0 ph\u1ea7n c\u00e1c b\u1ea1n s\u1ebd c\u00f3 th\u1ec3 t\u1ef1 h\u1ecdc ho\u1eb7c h\u1ecdc t\u1eeb trung t\u00e2m (ch\u1ecdn l\u1ecdc). <\/p>\n\n\n\n

        a. Ki\u1ebfn th\u1ee9c v\u1ec1 c\u01a1 s\u1edf d\u1eef li\u1ec7u & c\u00f4ng c\u1ee5 cho vi\u1ec7c ph\u00e2n t\u00edch d\u1eef li\u1ec7u<\/h3>\n\n\n\n
          \n
        • Database & data warehouse structure:<\/strong> Ph\u1ea7n ki\u1ebfn th\u1ee9c n\u00e0y m\u00ecnh th\u1ea5y n\u00f3 kh\u00e1 quan tr\u1ecdng v\u00ec \u0111\u00e2y l\u00e0 th\u1ee9 m\u00e0 h\u1eb1ng ng\u00e0y ng\u01b0\u1eddi l\u00e0m ph\u00e2n t\u00edch d\u1eef li\u1ec7u ph\u1ea3i nh\u00ecn v\u00e0o v\u00e0 hi\u1ec3u r\u00f5 n\u00f3 \u0111\u1ec3 ph\u1ee5c v\u1ee5 cho c\u00f4ng vi\u1ec7c. Ki\u1ebfn th\u1ee9c v\u1ec1 ph\u1ea7n n\u00e0y s\u1ebd g\u1ed3m m\u1ed9t s\u1ed1 terms ch\u00ednh nh\u01b0: ki\u1ebfn tr\u00fac c\u1ee7a m\u1ed9t h\u1ec7 th\u1ed1ng d\u1eef li\u1ec7u c\u1ee7a doanh nghi\u1ec7p g\u1ed3m nh\u1eefng ph\u1ea7n n\u00e0o? C\u00e1ch c\u00e1c lo\u1ea1i data \u0111ang \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef nh\u01b0 th\u1ebf n\u00e0o? C\u1ea5u tr\u00fac c\u1ee7a c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u m\u00e0 ng\u01b0\u1eddi ph\u00e2n t\u00edch s\u1ebd l\u1ea5y d\u1eef li\u1ec7u? <\/li>\n<\/ul>\n\n\n\n
            \n
          • SQL (Structured Query Language): <\/strong> 80-90% c\u00f4ng vi\u1ec7c h\u1eb1ng ng\u00e0y c\u1ee7a c\u00e1c b\u1ea1n l\u00e0m ph\u00e2n t\u00edch d\u1eef li\u1ec7u data analyst\/BI analyst s\u1ebd l\u00e0m vi\u1ec7c v\u1edbi data d\u1ea1ng b\u1ea3ng (tabular data), hi\u1ec3u \u0111\u01a1n gi\u1ea3n SQL l\u00e0 c\u00f4ng c\u1ee5 gi\u00fap m\u1ecdi ng\u01b0\u1eddi c\u00f3 th\u1ec3 giao ti\u1ebfp v\u00e0 l\u00e0m vi\u1ec7c v\u1edbi c\u01a1 s\u1edf d\u1eef li\u1ec7u d\u1ea1ng b\u1ea3ng. SQL gi\u00fap ng\u01b0\u1eddi ph\u00e2n t\u00edch truy v\u1ea5n v\u00e0 l\u1ea5y ra d\u1eef li\u1ec7u c\u1ea7n thi\u1ebft cho b\u00e1o c\u00e1o v\u00e0 ph\u00e2n t\u00edch c\u1ee7a m\u00ecnh. \u0110\u00e2y l\u00e0 c\u00f4ng c\u1ee5 b\u1eaft bu\u1ed9c ng\u01b0\u1eddi l\u00e0m vi\u1ec7c li\u00ean quan t\u1edbi d\u1eef li\u1ec7u ph\u1ea3i bi\u1ebft, SQL \u0111ang v\u00e0 s\u1ebd ph\u1ed5 bi\u1ebfn nh\u01b0 Excel trong m\u1ed9t v\u00e0i n\u0103m t\u1edbi. Kh\u00f4ng ch\u1ec9 ng\u01b0\u1eddi l\u00e0m ph\u00e2n t\u00edch d\u1eef li\u1ec7u c\u1ea7n “master” SQL m\u00e0 hi\u1ec7n gi\u1edd theo m\u00ecnh quan s\u00e1t th\u00ec r\u1ea5t nhi\u1ec1u ph\u00f2ng ban kh\u00e1c \u0111\u00e3 c\u00f3 th\u1ec3 d\u00f9ng SQL \u0111\u1ec3 ph\u1ee5c v\u1ee5 cho nhu c\u1ea7u s\u1ed1 li\u1ec7u c\u1ee7a m\u00ecnh thay v\u00ec ph\u1ea3i nh\u1edd team data l\u1ea5y s\u1ed1 theo y\u00eau c\u1ea7u. V\u00ec v\u1eady \u0111\u00e2y l\u00e0 c\u00f4ng c\u1ee5 v\u1ee1 l\u00f2ng n\u00ean \u0111\u01b0\u1ee3c \u01b0u ti\u00ean h\u1ecdc tr\u01b0\u1edbc khi b\u01b0\u1edbc ch\u00e2n v\u00e0o ng\u00e0nh data. Ngu\u1ed3n h\u1ecdc SQL th\u00ec r\u1ea5t nhi\u1ec1u, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 google, c\u00f3 d\u1ecbp m\u00ecnh s\u1ebd chia s\u1ebb s\u00e2u h\u01a1n \u1edf nh\u1eefng series sau.<\/li>\n\n\n\n
          • BI Tools:<\/strong> ph\u1ed5 bi\u1ebfn nh\u1ea5t l\u00e0 Power BI, Tableau, Google Looker studio..,. Hi\u1ec3u \u0111\u01a1n gi\u1ea3n th\u00ec c\u00e1c c\u00f4ng c\u1ee5 n\u00e0y s\u1ebd gi\u00fap ng\u01b0\u1eddi ph\u00e2n t\u00edch d\u1eef li\u1ec7u tr\u1ef1c quan h\u00f3a s\u1ed1 li\u1ec7u v\u00e0 k\u1ebft qu\u1ea3 ph\u00e2n t\u00edch c\u1ee7a m\u00ecnh d\u01b0\u1edbi d\u1ea1ng c\u00e1c bi\u1ec3u \u0111\u1ed3, nh\u1eb1m gi\u00fap cho ng\u01b0\u1eddi ng\u01b0\u1eddi \u0111\u1ecdc b\u00e1o c\u00e1o\/ph\u00e2n t\u00edch c\u00f3 th\u1ec3 consume th\u00f4ng tin m\u1ed9t c\u00e1ch t\u1ed1t h\u01a1n v\u00e0 tr\u1ef1c quan h\u01a1n. Ngo\u00e0i ra c\u00e1c c\u00f4ng c\u1ee5 n\u00e0y c\u0169ng cung c\u1ea5p m\u1ed9t s\u1ed1 ch\u1ee9c n\u0103ng h\u1ed7 tr\u1ee3 cho ng\u01b0\u1eddi ph\u00e2n t\u00edch t\u00ecm ra insights t\u1ed1t h\u01a1n, nh\u00ecn d\u1eef li\u1ec7u theo nhi\u1ec1u chi\u1ec1u kh\u00e1c nhau v\u00e0 ti\u1ebft ki\u1ec7n th\u1eddi gian th\u1ef1c hi\u1ec7n b\u00e1o c\u00e1o\/ph\u00e2n t\u00edch.<\/li>\n\n\n\n
          • R\/Python: <\/strong>\u0110\u00e2y l\u00e0 hai ng\u00f4n ng\u1eef l\u1eadp tr\u00ecnh gi\u00fap ng\u01b0\u1eddi ph\u00e2n t\u00edch d\u1eef li\u1ec7u c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc x\u1eed l\u00fd d\u1eef li\u1ec7u n\u00e2ng cao, d\u1eef li\u1ec7u v\u1edbi dung l\u01b0\u1ee3ng l\u1edbn v\u00e0 c\u1ea5u tr\u00fac ph\u1ee9c t\u1ea1p. Ngo\u00e0i ra hai ng\u00f4n ng\u1eef n\u00e0y c\u00f2n l\u00e0 c\u00f4ng c\u1ee5 gi\u00fap ng\u01b0\u1eddi ph\u00e2n t\u00edch th\u1ef1c hi\u1ec7n c\u00e1c b\u00e0i to\u00e1n Predictive analytics s\u1eed d\u1ee5ng c\u00e1c m\u00f4 h\u00ecnh th\u1ed1ng k\u00ea, machine learning, deep learning. \u1ede nh\u1eefng giai \u0111o\u1ea1n \u0111\u1ea7u th\u00ec m\u00ecnh khuy\u00ean c\u00e1c b\u1ea1n n\u00ean t\u1ea1m khoan h\u1ecdc<\/strong> ph\u1ea7n n\u00e0y, m\u00e0 h\u00e3y ch\u00fa tr\u1ecdng 2 ph\u1ea7n tr\u00ean tr\u01b0\u1edbc. Sau khi \u0111\u00e3 \u0111i l\u00e0m v\u00e0 ti\u1ebfp x\u00fac v\u1edbi c\u00e1c b\u00e0i to\u00e1n th\u1ef1c t\u1ebf, c\u00f3 usecase c\u1ea7n d\u00f9ng \u0111\u1ebfn th\u00ec h\u1eb5ng b\u1eaft \u0111\u1ea7u h\u1ecdc (theo d\u1ea1ng project based learning).<\/li>\n<\/ul>\n\n\n\n

            b. Mindset v\u00e0 c\u00e1c ki\u1ebfn th\u1ee9c li\u00ean quan:<\/h3>\n\n\n\n
              \n
            • Statistical mindset: t\u01b0 duy v\u00e0 ki\u1ebfn th\u1ee9c v\u1ec1 th\u1ed1ng k\u00ea \u0111\u1ec3 nh\u00ecn d\u1eef li\u1ec7u t\u1ed1t h\u01a1n, tr\u00e1nh b\u1ecb d\u1eef li\u1ec7u \u0111\u00e1nh l\u1eeba v\u00e0 c\u00e1c ch\u1ec9 s\u1ed1 trong b\u00e0i ph\u00e2n t\u00edch mang \u00fd ngh\u0129a v\u1ec1 m\u1eb7t th\u00f4ng k\u00ea.<\/li>\n\n\n\n
            • Analytical mindset: t\u01b0 duy ph\u00e2n t\u00edch, c\u00e1c b\u01b0\u1edbc \u0111\u1ec3 th\u1ef1c hi\u1ec7n m\u1ed9t b\u00e0i ph\u00e2n t\u00edch, c\u00e1c nguy\u00ean l\u00fd ph\u1ed5 bi\u1ebfn th\u01b0\u1eddng s\u1eed d\u1ee5ng (MECE, 80\/20)<\/li>\n\n\n\n
            • Visualization mindset: t\u01b0 duy v\u1ec1 tr\u1ef1c quan h\u00f3a d\u1eef li\u1ec7u, ch\u1ecdn bi\u1ec3u \u0111\u1ed3 ph\u00f9 h\u1ee3p, lo\u1ea1i b\u1ecf c\u00e1c y\u1ebfu t\u1ed1 th\u1eeba trong khi tr\u1ef1c quan h\u00f3a d\u1eef li\u1ec7u.<\/li>\n\n\n\n
            • Ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n v\u1ec1 c\u00e1c m\u00f4 h\u00ecnh machine learning, c\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a m\u00f4 h\u00ecnh, background to\u00e1n b\u00ean d\u01b0\u1edbi c\u1ee7a m\u00f4 h\u00ecnh. Ph\u1ea7n n\u00e0y l\u00e0 m\u1ed9t ph\u1ea7n kh\u00f3 n\u00ean c\u1ea7n nhi\u1ec1u th\u1eddi gian v\u00e0 va ch\u1ea1m \u0111\u1ec3 m\u1ecdi ng\u01b0\u1eddi c\u00f3 th\u1ec3 x\u00e2y d\u1ef1ng n\u1ec1n t\u1ea3ng ki\u1ebfn th\u1ee9c d\u1ea7n d\u1ea7n.<\/li>\n<\/ul>\n\n\n\n

              3. Soft skills (k\u1ef9 n\u0103ng m\u1ec1m):<\/h2>\n\n\n\n

              K\u1ef9 n\u0103ng m\u1ec1m th\u00ec m\u00ecnh s\u1ebd kh\u00f4ng n\u00f3i nhi\u1ec1u \u1edf \u0111\u00e2y v\u00ec m\u00ecnh ngh\u0129 ng\u00e0nh n\u00e0o c\u0169ng c\u1ea7n t\u1edbi c\u00e1c k\u1ef9 n\u0103ng n\u00e0y v\u00e0 \u0111\u00e2y l\u00e0 ph\u1ea7n h\u01a1i c\u00e1 nh\u00e2n, m\u1ed7i ng\u01b0\u1eddi s\u1ebd c\u00f3 m\u1ed9t c\u00e1ch r\u00e8n luy\u1ec7n v\u00e0 ph\u00e1t tri\u1ec3n c\u00e1c k\u1ef9 n\u0103ng m\u1ec1m c\u1ee7a m\u00ecnh kh\u00e1c nhau. M\u1ed9t s\u1ed1 k\u1ef9 n\u0103ng quan tr\u1ecdng d\u01b0\u1edbi \u0111\u00e2y theo m\u00ecnh th\u1ea5y c\u1ef1c k\u1ef3 c\u1ea7n thi\u1ebft cho c\u00f4ng vi\u1ec7c h\u1eb1ng ng\u00e0y c\u1ee7a m\u1ed9t ng\u01b0\u1eddi ph\u00e2n t\u00edch d\u1eef li\u1ec7u t\u1eeb ch\u00ednh tr\u1ea3i nghi\u1ec7m b\u1ea3n th\u00e2n m\u00ecnh, n\u1ebfu thi\u1ebfu c\u00e1c k\u1ef9 n\u0103ng \u0111\u00f3 th\u00ec c\u00f4ng vi\u1ec7c c\u1ee7a c\u00e1c b\u1ea1n s\u1ebd kh\u00f3 su\u00f4n s\u1ebb \u0111\u01b0\u1ee3c. Song song v\u1edbi chuy\u00ean m\u00f4n th\u00ec c\u00e1c b\u1ea1n c\u0169ng n\u00ean \u0111\u1ea7u t\u01b0 th\u1eddi gian, s\u1ee9c l\u1ef1c \u0111\u1ec3 trau d\u1ed3i c\u00e1c k\u1ef9 n\u0103ng n\u00e0y ng\u00e0y m\u1ed9t t\u1ed1t h\u01a1n.<\/p>\n\n\n\n

                \n
              • Storytelling with data<\/li>\n\n\n\n
              • Teamwork<\/li>\n\n\n\n
              • Project management<\/li>\n\n\n\n
              • Stakeholder management<\/li>\n\n\n\n
              • Communication<\/li>\n\n\n\n
              • Presentation<\/li>\n<\/ul>\n\n\n\n

                T\u00fam c\u00e1i v\u00e1y l\u1ea1i th\u00ec \u0111\u1ec3 l\u00e0m t\u1ed1t c\u00f4ng vi\u1ec7c ph\u00e2n t\u00edch d\u1eef li\u1ec7u th\u00ec m\u1ecdi ng\u01b0\u1eddi n\u00ean ph\u00e1t tri\u1ec3n c\u1ea3 3 tr\u1ee5 c\u1ed9t m\u00ecnh chia s\u1ebb trong b\u00e0i thay v\u00ec ch\u1ec9 ch\u0103m ch\u0103m v\u00e0o ph\u1ea7n c\u00f4ng c\u1ee5, ph\u00e2n t\u00edch d\u1eef li\u1ec7u l\u00e0 m\u1ed9t ng\u00e0nh \u0111\u00f2i h\u1ecfi r\u1ea5t nhi\u1ec1u k\u1ef9 n\u0103ng v\u00e0 ki\u1ebfn th\u1ee9c \u1edf nhi\u1ec1u l\u0129nh v\u1ef1c n\u00ean c\u1ed1 l\u00ean c\u00e1c b\u1ea1n nh\u00e9. ^^ C\u00f3 c\u00e2u h\u1ecfi g\u00ec c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft n\u1ed1i v\u1edbi m\u00ecnh theo contact b\u00ean ph\u1ea3i ho\u1eb7c comment nh\u00e9, happy to help! Thanks<\/p>\n\n\n\n

                *Disclaimers: <\/strong>C\u00e1c b\u00e0i vi\u1ebft m\u00ecnh chia s\u1ebb tr\u00ean blog ch\u1ee7 y\u1ebfu \u0111\u1ebfn t\u1eeb tr\u1ea3i nghi\u1ec7m c\u00e1 nh\u00e2n v\u00e0 kinh nghi\u1ec7m c\u1ee7a b\u1ea3n th\u00e2n m\u00ecnh<\/strong>, v\u1edbi mong mu\u1ed1n mang \u0111\u1ebfn th\u00eam nhi\u1ec1u g\u00f3c nh\u00ecn b\u1ed5 \u00edch cho c\u00f4ng vi\u1ec7c v\u00e0 cu\u1ed9c s\u1ed1ng c\u1ee7a c\u00e1c b\u1ea1n. Mong r\u1eb1ng c\u00e1c b\u1ea1n s\u1ebd \u0111\u00f3n nh\u1eadn v\u00e0 g\u00f3p \u00fd nh\u1eefng \u0111i\u1ec1u m\u00ecnh chia s\u1ebb v\u1edbi m\u1ed9t t\u01b0 duy m\u1edf v\u00e0 ph\u00e1t tri\u1ec3n. B\u00e0i vi\u1ebft \u0111\u00f4i khi s\u1ebd s\u1eed d\u1ee5ng m\u1ed9t s\u1ed1 thu\u1eadt ng\u1eef ti\u1ebfng Anh v\u00ec n\u1ebfu d\u1ecbch sang ti\u1ebfng Vi\u1ec7t s\u1ebd h\u01a1i kh\u00f3 hi\u1ec3u n\u00ean m\u00ecnh v\u1eabn s\u1ebd gi\u1eef nguy\u00ean b\u1ea3n. C\u00e1m \u01a1n c\u00e1c b\u1ea1n \u0111\u00e3 gh\u00e9 th\u0103m blog c\u1ee7a m\u00ecnh.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

                H\u1ecdc SQL, h\u1ecdc l\u00e0m b\u00e1o c\u00e1o v\u1edbi Power BI, Tableau, Python sau 3 th\u00e1ng th\u00ec s\u1ebd c\u00f3 \u0111\u01b0\u1ee3c c\u00f4ng vi\u1ec7c data analyst ng\u00e0n \u0111\u00f4. C\u00e1c k\u1ef9 n\u0103ng n\u00e0y l\u00e0 c\u1ea7n thi\u1ebft nh\u01b0ng theo kinh nghi\u1ec7m \u0111i l\u00e0m th\u1ef1c t\u1ebf v\u00e0 quan s\u00e1t c\u00e1 nh\u00e2n m\u00ecnh th\u00ec n\u00f3 v\u1eabn ch\u01b0a \u0111\u1ee7. \u1ede b\u00e0i n\u00e0y m\u00ecnh s\u1ebd c\u1ed1 g\u1eafng chia s\u1ebb b\u1ee9c tranh t\u1ed5ng qu\u00e1t h\u01a1n v\u1ec1 c\u00e1c m\u1ea3ng ki\u1ebfn th\u1ee9c v\u00e0 k\u1ef9 n\u0103ng c\u1ea7n thi\u1ebft \u0111\u1ec3 l\u00e0m t\u1ed1t c\u00f4ng vi\u1ec7c n\u00e0y.<\/p>\n","protected":false},"author":1,"featured_media":178,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[12,17,1],"tags":[32,27,31,30,28],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/thehaublog.com\/index.php\/wp-json\/wp\/v2\/posts\/132"}],"collection":[{"href":"https:\/\/thehaublog.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thehaublog.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thehaublog.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/thehaublog.com\/index.php\/wp-json\/wp\/v2\/comments?post=132"}],"version-history":[{"count":13,"href":"https:\/\/thehaublog.com\/index.php\/wp-json\/wp\/v2\/posts\/132\/revisions"}],"predecessor-version":[{"id":182,"href":"https:\/\/thehaublog.com\/index.php\/wp-json\/wp\/v2\/posts\/132\/revisions\/182"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/thehaublog.com\/index.php\/wp-json\/wp\/v2\/media\/178"}],"wp:attachment":[{"href":"https:\/\/thehaublog.com\/index.php\/wp-json\/wp\/v2\/media?parent=132"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thehaublog.com\/index.php\/wp-json\/wp\/v2\/categories?post=132"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thehaublog.com\/index.php\/wp-json\/wp\/v2\/tags?post=132"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}