{"id":6333,"date":"2024-12-21T15:05:16","date_gmt":"2024-12-21T15:05:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/power-query-da-cuu-vot-thoi-gian-thuc-tap-cua-minh-nhu-nao-phan-3\/"},"modified":"2024-12-21T15:05:16","modified_gmt":"2024-12-21T15:05:16","slug":"power-query-da-cuu-vot-thoi-gian-thuc-tap-cua-minh-nhu-nao-phan-3","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/power-query-da-cuu-vot-thoi-gian-thuc-tap-cua-minh-nhu-nao-phan-3\/","title":{"rendered":"Power Query \u0111\u00e3 c\u1ee9u v\u1edbt th\u1eddi gian th\u1ef1c t\u1eadp c\u1ee7a m\u00ecnh nh\u01b0 n\u00e0o? \u2013 Ph\u1ea7n 3"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-h4k0Fa0I#1\">\n<p><em>Trong ph\u1ea7n tr\u01b0\u1edbc, m\u00ecnh \u0111\u00e3 \u201cth\u00e0nh c\u00f4ng\u201d \u0111\u01b0a \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u v\u00e0o <a href=\"http:\/\/blog.ezworkapp.com\/power-query-da-cuu-vot-thuc-tap-nhu-nao-2.html\"><strong>Power Query<\/strong><\/a>. \u1ede ph\u1ea7n 3, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd n\u00f3i \u0111\u1ebfn nh\u1eefng v\u1ea5n \u0111\u1ec1 g\u1eb7p ph\u1ea3i khi x\u1eed l\u00fd d\u1eef li\u1ec7u, c\u00e1ch m\u00ecnh \u0111\u00e3 x\u1eed l\u00ed v\u00e0 \u0111\u1ea9y d\u1eef li\u1ec7u v\u00e0o nh\u01b0 th\u1ebf n\u00e0o.<\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6766d92c17670\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/power-query-da-cuu-vot-thuc-tap-nhu-nao-3.html#Dua_du_lieu_vao_va_xu_ly_trong_Power_Query\" title=\"\u0110\u01b0a d\u1eef li\u1ec7u v\u00e0o v\u00e0 x\u1eed l\u00fd trong Power Query\">\u0110\u01b0a d\u1eef li\u1ec7u v\u00e0o v\u00e0 x\u1eed l\u00fd trong Power Query<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/power-query-da-cuu-vot-thuc-tap-nhu-nao-3.html#Load_du_lieu_vao_nhu_the_nao\" title=\"Load d\u1eef li\u1ec7u v\u00e0o nh\u01b0 th\u1ebf n\u00e0o?\">Load d\u1eef li\u1ec7u v\u00e0o nh\u01b0 th\u1ebf n\u00e0o?<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Dua_du_lieu_vao_va_xu_ly_trong_Power_Query\"><\/span>\u0110\u01b0a d\u1eef li\u1ec7u v\u00e0o v\u00e0 x\u1eed l\u00fd trong Power Query<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><em>Nh\u01b0 \u0111\u00e3 n\u00f3i t\u1eeb tr\u01b0\u1edbc, quy tr\u00ecnh d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh s\u1ebd nh\u01b0 sau:<\/em><\/p>\n<p>\u2013<em>\u201cL\u00e0m s\u1ea1ch\u201d d\u1eef li\u1ec7u<\/em><\/p>\n<p><em>-T\u1ea1o m\u1ed9t file Excel ch\u1ee9a c\u00e1c dashboard<\/em><\/p>\n<p>\u2013<em>T\u1ea1o m\u1ed9t folder ch\u1ee9a c\u00e1c file d\u1eef li\u1ec7u \u0111\u00e3 l\u00e0m s\u1ea1ch<\/em><\/p>\n<p><em>-S\u1eed d\u1ee5ng Power Query \u0111\u1ec3 t\u1ea1o k\u1ebft n\u1ed1i<\/em><\/p>\n<p>N\u00f3i ng\u1eafn g\u1ecdn, \u00fd t\u01b0\u1edfng \u0111\u01b0\u1ee3c thu g\u1ecdn trong <a href=\"https:\/\/www.youtube.com\/watch?v=9glqnywsL60\">video n\u00e0y<\/a>:<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-570.gif\" title=\"ex101_92019-nho-570\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>[iframe src=\u201d\/\/www.youtube.com\/embed\/9glqnywsL60\u2033 width=\u201d560\u2033 height=\u201d314\u2033 allowfullscreen=\u201dallowfullscreen\u201d]<\/p>\n<p>K\u1ebft qu\u1ea3 sau khi import \u1edf trong \u1ea3nh d\u01b0\u1edbi \u0111\u00e2y. V\u1ec1 c\u01a1 b\u1ea3n, b\u1edfi d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh kh\u00e1 \u201cs\u1ea1ch\u201d n\u00ean kh\u00f4ng ph\u1ea3i ch\u1ec9nh s\u1eeda nhi\u1ec1u, ngo\u00e0i m\u1ed9t s\u1ed1 l\u01b0u \u00fd nh\u01b0\u00a0<em>d\u1eef li\u1ec7u c\u1ea7n \u0111\u1ecbnh d\u1ea1ng cho ph\u00f9 h\u1ee3p (Text, Date hay Number?), nh\u1eefng c\u1ed9t c\u1ea7n gi\u1eef, nh\u1eefng c\u1ed9t th\u1eeba c\u00f3 th\u1ec3 b\u1ecf \u0111i, nh\u1eefng th\u1ee9 c\u1ea7n th\u00eam v\u00e0o\u2026<\/em><\/p>\n<figure id=\"attachment_32164\" aria-describedby=\"caption-attachment-32164\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32164 size-large\" title=\"\u0110\u01b0a d\u1eef li\u1ec7u v\u00e0o v\u00e0 x\u1eed l\u00fd trong Power Query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/power-query-3-1-1024x548-1.png\" alt=\"\u0110\u01b0a d\u1eef li\u1ec7u v\u00e0o v\u00e0 x\u1eed l\u00fd trong Power Query\" width=\"1024\" height=\"548\"><figcaption id=\"caption-attachment-32164\" class=\"wp-caption-text\">\u0110\u01b0a d\u1eef li\u1ec7u v\u00e0o v\u00e0 x\u1eed l\u00fd trong Power Query<\/figcaption><\/figure>\n<p>\u0110\u00e2y l\u00e0 m\u1ed9t b\u01b0\u1edbc kh\u00e1 su\u00f4n s\u1ebb, g\u1ea7n nh\u01b0 m\u00ecnh kh\u00f4ng g\u1eb7p kh\u00f3 kh\u0103n g\u00ec nhi\u1ec1u. Tuy v\u1eady, th\u1ee9 khi\u1ebfn cho m\u00ecnh b\u0103n kho\u0103n l\u1ea1i n\u1eb1m \u1edf b\u01b0\u1edbc ti\u1ebfp theo.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Load_du_lieu_vao_nhu_the_nao\"><\/span>Load d\u1eef li\u1ec7u v\u00e0o nh\u01b0 th\u1ebf n\u00e0o?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<figure id=\"attachment_32165\" aria-describedby=\"caption-attachment-32165\" style=\"width: 521px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32165 size-full\" title=\"Load d\u1eef li\u1ec7u v\u00e0o nh\u01b0 th\u1ebf n\u00e0o?\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/power-query-3-2.png\" alt=\"Load d\u1eef li\u1ec7u v\u00e0o nh\u01b0 th\u1ebf n\u00e0o?\" width=\"521\" height=\"392\"><figcaption id=\"caption-attachment-32165\" class=\"wp-caption-text\">Load d\u1eef li\u1ec7u v\u00e0o nh\u01b0 th\u1ebf n\u00e0o?<\/figcaption><\/figure>\n<p>Sau khi k\u1ebft th\u00fac qu\u00e1 tr\u00ecnh \u201cTransform\u201d m\u00ecnh b\u1eaft \u0111\u1ea7u qu\u00e1 tr\u00ecnh Load d\u1eef li\u1ec7u. V\u1ea5n \u0111\u1ec1 \u1edf \u0111\u00e2y l\u00e0: n\u00ean load th\u1ebf n\u00e0o?<br \/>\nNhu c\u1ea7u c\u1ee7a m\u00ecnh \u0111\u00f3 l\u00e0 c\u00f3 m\u1ed9t d\u1eef li\u1ec7u li\u00ean k\u1ebft \u0111\u1ec3 t\u1ea1o ra c\u00e1c bi\u1ec3u \u0111\u1ed3 (chart &amp; pivot chart) cho dashboard, sau \u0111\u00f3 s\u1ebd \u0111\u01b0a v\u00e0o PowerPoint v\u00e0\/ho\u1eb7c bi\u1ec3u di\u1ec5n tr\u1ef1c ti\u1ebfp tr\u00ean Excel. M\u00ecnh \u0111\u00e3 \u0111\u00e1nh gi\u00e1 nh\u01b0 sau:<\/p>\n<ol>\n<li>\u0110\u01b0a v\u00e0o d\u01b0\u1edbi d\u1ea1ng <strong>Table\u00a0<\/strong>l\u00e0 m\u1ed9t ph\u01b0\u01a1ng \u00e1n kh\u1ea3 quan.<\/li>\n<li>Pivot Table Report &amp; Pivot Chart s\u1ebd kh\u00f4ng ph\u00f9 h\u1ee3p b\u1edfi: a. M\u00ecnh c\u1ea7n nhi\u1ec1u report t\u1eeb 1 ngu\u1ed3n d\u1eef li\u1ec7u. b. Query s\u1ebd b\u1ecb duplicate khi th\u00eam v\u00e0o d\u01b0\u1edbi d\u1ea1ng Pivot Table. \u0110\u1ecdc th\u00eam t\u1ea1i \u0111\u00e2y: https:\/\/stackoverflow.com\/questions\/49512640\/excel-query-gets-duplicated-when-adding-pivot-table<\/li>\n<li>Only Create Connection c\u0169ng l\u00e0 m\u1ed9t ph\u01b0\u01a1ng \u00e1n, \u0111\u1ed3ng th\u1eddi s\u1ebd gi\u00fap file dashboard kh\u00f4ng b\u1ecb c\u1ea3m gi\u00e1c n\u1eb7ng n\u1ec1 so v\u1edbi \u0111\u01b0a v\u00e0o d\u01b0\u1edbi d\u1ea1ng Table trong 1 sheet ri\u00eang.<\/li>\n<\/ol>\n<p>B\u1edfi v\u1eady m\u00ecnh \u0111\u00e3 ch\u1ecdn\u00a0<strong>Only Create Connection<\/strong>\u00a0<strong>k\u1ebft h\u1ee3p v\u1edbi \u201cAdd this to Data Model\u201d <\/strong>\u0111\u1ec3 c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc ch\u1ec9nh s\u1eeda li\u00ean quan t\u1edbi\u00a0<strong>Power Pivot.<\/strong><\/p>\n<figure id=\"attachment_32167\" aria-describedby=\"caption-attachment-32167\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32167 size-large\" title=\"Power Pivot\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/power-query-3-3-1024x527-1.png\" alt=\"Power Pivot\" width=\"1024\" height=\"527\"><figcaption id=\"caption-attachment-32167\" class=\"wp-caption-text\">Power Pivot<\/figcaption><\/figure>\n<p>T\u1ea1i sao m\u00ecnh l\u1ea1i ph\u1ea3i t\u01b0 duy v\u00e0 th\u1ef1c hi\u1ec7n quy tr\u00ecnh \u201cl\u1eb1ng nh\u1eb1ng\u201d nh\u01b0 v\u1eady? Trong ph\u1ea7n ti\u1ebfp theo, m\u00ecnh s\u1ebd n\u00f3i v\u1edbi c\u00e1c b\u1ea1n c\u00e1ch m\u00ecnh s\u1eed d\u1ee5ng\u00a0<strong>h\u00e0m DAX c\u01a1 b\u1ea3n trong Power Query<\/strong> c\u00f9ng v\u1edbi c\u00e1ch m\u00ecnh t\u1ea1o ra c\u00e1c bi\u1ec3u \u0111\u1ed3 cho dashboard.<\/p>\n<figure id=\"attachment_32168\" aria-describedby=\"caption-attachment-32168\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32168 size-large\" title=\"\u00a0h\u00e0m DAX c\u01a1 b\u1ea3n trong Power Query\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/power-query-3-4-1024x520-1.png\" alt=\"\u00a0h\u00e0m DAX c\u01a1 b\u1ea3n trong Power Query\" width=\"1024\" height=\"520\"><figcaption id=\"caption-attachment-32168\" class=\"wp-caption-text\">Dashboard s\u1ebd tr\u00f4ng nh\u01b0 n\u00e0y<\/figcaption><\/figure>\n<hr>\n<p>Danh s\u00e1ch c\u00e1c ph\u1ea7n:<br \/>\n<a href=\"http:\/\/blog.ezworkapp.com\/power-query-da-cuu-vot-thuc-tap-nhu-nao-1.html\">Power Query Ph\u1ea7n 1<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/power-query-da-cuu-vot-thuc-tap-nhu-nao-2.html\">Power Query Ph\u1ea7n 2<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/power-query-da-cuu-vot-thuc-tap-nhu-nao-4.html\">Power Query Ph\u1ea7n 4<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-570.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6334,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-6333","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6333","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=6333"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6333\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6334"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6333"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6333"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6333"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}