{"id":95610,"date":"2026-04-18T22:16:24","date_gmt":"2026-04-18T15:16:24","guid":{"rendered":"https:\/\/itviec.com\/blog\/?p=95610"},"modified":"2026-04-18T22:16:25","modified_gmt":"2026-04-18T15:16:25","slug":"cach-su-dung-power-bi","status":"publish","type":"post","link":"https:\/\/itviec.com\/blog\/cach-su-dung-power-bi\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng Power BI hi\u1ec7u qu\u1ea3 v\u00e0 c\u00e1c best practices c\u1ea7n bi\u1ebft"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">N\u1ed9i dung b\u00e0i vi\u1ebft<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/itviec.com\/blog\/cach-su-dung-power-bi\/#Tong_quan_ve_Power_BI\" >T\u1ed5ng quan v\u1ec1 Power BI<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/itviec.com\/blog\/cach-su-dung-power-bi\/#Cach_su_dung_Power_BI_tong_quan_theo_tung_linh_vuc\" >C\u00e1ch s\u1eed d\u1ee5ng Power BI t\u1ed5ng quan theo t\u1eebng l\u0129nh v\u1ef1c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/itviec.com\/blog\/cach-su-dung-power-bi\/#Ket_noi_du_lieu_trong_Power_BI\" >K\u1ebft n\u1ed1i d\u1eef li\u1ec7u trong Power BI<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/itviec.com\/blog\/cach-su-dung-power-bi\/#Bien_doi_du_lieu_voi_Power_Query\" >Bi\u1ebfn \u0111\u1ed5i d\u1eef li\u1ec7u v\u1edbi Power Query<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/itviec.com\/blog\/cach-su-dung-power-bi\/#Xay_dung_mo_hinh_du_lieu_data_model\" >X\u00e2y d\u1ef1ng m\u00f4 h\u00ecnh d\u1eef li\u1ec7u (data model)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/itviec.com\/blog\/cach-su-dung-power-bi\/#Cach_lam_viec_voi_DAX\" >C\u00e1ch l\u00e0m vi\u1ec7c v\u1edbi DAX<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/itviec.com\/blog\/cach-su-dung-power-bi\/#Truc_quan_hoa_du_lieu_Visualization\" >Tr\u1ef1c quan h\u00f3a d\u1eef li\u1ec7u (Visualization)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/itviec.com\/blog\/cach-su-dung-power-bi\/#Publish_bao_cao_vao_Power_BI_Service\" >Publish b\u00e1o c\u00e1o v\u00e0o Power BI Service<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/itviec.com\/blog\/cach-su-dung-power-bi\/#Kinh_nghiem_cach_su_dung_Power_BI_hieu_qua\" >Kinh nghi\u1ec7m c\u00e1ch s\u1eed d\u1ee5ng Power BI hi\u1ec7u qu\u1ea3<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/itviec.com\/blog\/cach-su-dung-power-bi\/#Cau_hoi_thuong_gap_ve_cach_su_dung_Power_BI\" >C\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng Power BI<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/itviec.com\/blog\/cach-su-dung-power-bi\/#Tong_ket\" >T\u1ed5ng k\u1ebft<\/a><\/li><\/ul><\/nav><\/div>\n\n<p><strong><em>Power BI \u0111ang tr\u1edf th\u00e0nh m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 ph\u00e2n t\u00edch d\u1eef li\u1ec7u ph\u1ed5 bi\u1ebfn nh\u1ea5t hi\u1ec7n nay, gi\u00fap doanh nghi\u1ec7p v\u00e0 c\u00e1 nh\u00e2n d\u1ec5 d\u00e0ng bi\u1ebfn d\u1eef li\u1ec7u th\u00f4 th\u00e0nh nh\u1eefng b\u00e1o c\u00e1o tr\u1ef1c quan, d\u1ec5 hi\u1ec3u. V\u00ec v\u1eady, b\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u00fap b\u1ea1n n\u1eafm \u0111\u01b0\u1ee3c c\u00e1ch s\u1eed d\u1ee5ng Power BI t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao, t\u1eeb vi\u1ec7c k\u1ebft n\u1ed1i d\u1eef li\u1ec7u, x\u1eed l\u00fd, \u0111\u1ebfn x\u00e2y d\u1ef1ng dashboard v\u00e0 b\u00e1o c\u00e1o hi\u1ec7u qu\u1ea3 trong th\u1ef1c t\u1ebf.<\/em><\/strong><\/p>\n\n\n\n<p>\u0110\u1ecdc b\u00e0i vi\u1ebft n\u00e0y \u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng Power BI \u1edf c\u00e1c kh\u00eda c\u1ea1nh:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>K\u1ebft n\u1ed1i d\u1eef li\u1ec7u trong Power BI<\/li>\n\n\n\n<li>Bi\u1ebfn \u0111\u1ed5i d\u1eef li\u1ec7u v\u1edbi Power Query<\/li>\n\n\n\n<li>M\u00f4 h\u00ecnh d\u1eef li\u1ec7u trong Power BI<\/li>\n\n\n\n<li>Tr\u1ef1c quan h\u00f3a d\u1eef li\u1ec7u<\/li>\n\n\n\n<li>Publish b\u00e1o c\u00e1o v\u00e0o Power BI Service<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-t\u1ed5ng-quan-v\u1ec1-power-bi\"><span class=\"ez-toc-section\" id=\"Tong_quan_ve_Power_BI\"><\/span><strong>T\u1ed5ng quan v\u1ec1 Power BI<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Power BI l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 ph\u00e2n t\u00edch v\u00e0 tr\u1ef1c quan h\u00f3a d\u1eef li\u1ec7u do Microsoft ph\u00e1t tri\u1ec3n, gi\u00fap ng\u01b0\u1eddi d\u00f9ng bi\u1ebfn d\u1eef li\u1ec7u th\u00f4 th\u00e0nh c\u00e1c b\u00e1o c\u00e1o v\u00e0 dashboard tr\u1ef1c quan, d\u1ec5 theo d\u00f5i. V\u1edbi Power BI, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft n\u1ed1i nhi\u1ec1u ngu\u1ed3n d\u1eef li\u1ec7u kh\u00e1c nhau nh\u01b0 Excel, SQL Server, Google Analytics, hay c\u00e1c h\u1ec7 th\u1ed1ng qu\u1ea3n l\u00fd doanh nghi\u1ec7p, sau \u0111\u00f3 x\u1eed l\u00fd v\u00e0 tr\u00ecnh b\u00e0y d\u1eef li\u1ec7u d\u01b0\u1edbi d\u1ea1ng bi\u1ec3u \u0111\u1ed3, b\u1ea3ng, b\u1ea3n \u0111\u1ed3 m\u1ed9t c\u00e1ch sinh \u0111\u1ed9ng.<\/p>\n\n\n\n<p>\u0110i\u1ec3m m\u1ea1nh c\u1ee7a Power BI n\u1eb1m \u1edf giao di\u1ec7n th\u00e2n thi\u1ec7n, kh\u1ea3 n\u0103ng k\u00e9o-th\u1ea3 linh ho\u1ea1t v\u00e0 kh\u00f4ng y\u00eau c\u1ea7u qu\u00e1 nhi\u1ec1u ki\u1ebfn th\u1ee9c l\u1eadp tr\u00ecnh. Nh\u1edd \u0111\u00f3, c\u1ea3 ng\u01b0\u1eddi d\u00f9ng nghi\u1ec7p v\u1ee5 l\u1eabn chuy\u00ean vi\u00ean ph\u00e2n t\u00edch d\u1eef li\u1ec7u \u0111\u1ec1u c\u00f3 th\u1ec3 nhanh ch\u00f3ng khai th\u00e1c th\u00f4ng tin v\u00e0 h\u1ed7 tr\u1ee3 vi\u1ec7c ra quy\u1ebft \u0111\u1ecbnh d\u1ef1a tr\u00ean d\u1eef li\u1ec7u.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><em>\u0110\u1ecdc chi ti\u1ebft: <strong><a href=\"https:\/\/itviec.com\/blog\/power-bi-la-gi\/\" target=\"_blank\" rel=\"noreferrer noopener\">Power BI l\u00e0 g\u00ec? T\u1ed5ng quan, c\u00e1ch ho\u1ea1t \u0111\u1ed9ng v\u00e0 \u1ee9ng d\u1ee5ng th\u1ef1c t\u1ebf<\/a><\/strong><\/em><\/p>\n<\/blockquote>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-cach-s\u1eed-d\u1ee5ng-power-bi-t\u1ed5ng-quan-theo-t\u1eebng-linh-v\u1ef1c\"><span class=\"ez-toc-section\" id=\"Cach_su_dung_Power_BI_tong_quan_theo_tung_linh_vuc\"><\/span><strong>C\u00e1ch s\u1eed d\u1ee5ng Power BI t\u1ed5ng quan theo t\u1eebng l\u0129nh v\u1ef1c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Power BI \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i trong nhi\u1ec1u l\u0129nh v\u1ef1c kh\u00e1c nhau, h\u1ed7 tr\u1ee3 doanh nghi\u1ec7p v\u00e0 c\u00e1 nh\u00e2n ph\u00e2n t\u00edch d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3. M\u1ed9t s\u1ed1 \u1ee9ng d\u1ee5ng ph\u1ed5 bi\u1ebfn c\u1ee7a Power BI bao g\u1ed3m:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Ph\u00e2n t\u00edch kinh doanh<\/strong>: Theo d\u00f5i doanh thu, l\u1ee3i nhu\u1eadn, chi ph\u00ed v\u00e0 hi\u1ec7u su\u1ea5t b\u00e1n h\u00e0ng g\u1ea7n theo th\u1eddi gian th\u1ef1c, gi\u00fap nh\u00e0 qu\u1ea3n l\u00fd nhanh ch\u00f3ng n\u1eafm b\u1eaft t\u00ecnh h\u00ecnh ho\u1ea1t \u0111\u1ed9ng.<\/li>\n\n\n\n<li><strong>Marketing v\u00e0 b\u00e1n h\u00e0ng<\/strong>: Ph\u00e2n t\u00edch h\u00e0nh vi kh\u00e1ch h\u00e0ng, \u0111\u00e1nh gi\u00e1 hi\u1ec7u qu\u1ea3 c\u00e1c chi\u1ebfn d\u1ecbch marketing, theo d\u00f5i c\u00e1c ch\u1ec9 s\u1ed1 quan tr\u1ecdng nh\u01b0 l\u01b0\u1ee3t truy c\u1eadp, t\u1ef7 l\u1ec7 chuy\u1ec3n \u0111\u1ed5i, doanh s\u1ed1 theo k\u00eanh.<\/li>\n\n\n\n<li><strong>T\u00e0i ch\u00ednh &#8211; k\u1ebf to\u00e1n<\/strong>: T\u1ed5ng h\u1ee3p v\u00e0 ph\u00e2n t\u00edch b\u00e1o c\u00e1o t\u00e0i ch\u00ednh, theo d\u00f5i d\u00f2ng ti\u1ec1n, ng\u00e2n s\u00e1ch v\u00e0 c\u00e1c ch\u1ec9 s\u1ed1 t\u00e0i ch\u00ednh quan tr\u1ecdng m\u1ed9t c\u00e1ch tr\u1ef1c quan.<\/li>\n\n\n\n<li><strong>Qu\u1ea3n l\u00fd nh\u00e2n s\u1ef1<\/strong>: Theo d\u00f5i s\u1ed1 l\u01b0\u1ee3ng nh\u00e2n vi\u00ean, t\u1ef7 l\u1ec7 ngh\u1ec9 vi\u1ec7c, hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c v\u00e0 c\u00e1c ch\u1ec9 s\u1ed1 nh\u00e2n s\u1ef1 kh\u00e1c \u0111\u1ec3 h\u1ed7 tr\u1ee3 vi\u1ec7c ra quy\u1ebft \u0111\u1ecbnh.<\/li>\n\n\n\n<li><strong>B\u00e1o c\u00e1o v\u00e0 chia s\u1ebb d\u1eef li\u1ec7u n\u1ed9i b\u1ed9<\/strong>: T\u1ea1o c\u00e1c dashboard \u0111\u1ed9ng, t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt d\u1eef li\u1ec7u v\u00e0 d\u1ec5 d\u00e0ng chia s\u1ebb b\u00e1o c\u00e1o gi\u1eefa c\u00e1c ph\u00f2ng ban trong doanh nghi\u1ec7p.<\/li>\n<\/ul>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><em>\u0110\u1ecdc chi ti\u1ebft: <strong><a href=\"https:\/\/itviec.com\/blog\/huong-dan-tai-power-bi\/\" target=\"_blank\" rel=\"noreferrer noopener\">H\u01b0\u1edbng d\u1eabn t\u1ea3i Power BI \u0111\u1ea7y \u0111\u1ee7 v\u00e0 d\u1ec5 hi\u1ec3u cho ng\u01b0\u1eddi m\u1edbi<\/a><\/strong><\/em><\/p>\n<\/blockquote>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-k\u1ebft-n\u1ed1i-d\u1eef-li\u1ec7u-trong-power-bi\"><span class=\"ez-toc-section\" id=\"Ket_noi_du_lieu_trong_Power_BI\"><\/span><strong>K\u1ebft n\u1ed1i d\u1eef li\u1ec7u trong Power BI<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>K\u1ebft n\u1ed1i d\u1eef li\u1ec7u l\u00e0 b\u01b0\u1edbc kh\u1edfi \u0111\u1ea7u v\u00e0 c\u0169ng l\u00e0 n\u1ec1n t\u1ea3ng quan tr\u1ecdng nh\u1ea5t trong to\u00e0n b\u1ed9 quy tr\u00ecnh s\u1eed d\u1ee5ng Power BI. Ch\u1ea5t l\u01b0\u1ee3ng c\u1ee7a b\u00e1o c\u00e1o, \u0111\u1ed9 ch\u00ednh x\u00e1c c\u1ee7a ph\u00e2n t\u00edch v\u00e0 hi\u1ec7u n\u0103ng hi\u1ec3n th\u1ecb dashboard \u0111\u1ec1u ph\u1ee5 thu\u1ed9c tr\u1ef1c ti\u1ebfp v\u00e0o c\u00e1ch d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c k\u1ebft n\u1ed1i v\u00e0 t\u1ed5 ch\u1ee9c ngay t\u1eeb giai \u0111o\u1ea1n n\u00e0y.&nbsp;<\/p>\n\n\n\n<p>Power BI h\u1ed7 tr\u1ee3 kh\u1ea3 n\u0103ng k\u1ebft n\u1ed1i linh ho\u1ea1t v\u1edbi nhi\u1ec1u lo\u1ea1i ngu\u1ed3n d\u1eef li\u1ec7u kh\u00e1c nhau, t\u1eeb file \u0111\u01a1n gi\u1ea3n cho \u0111\u1ebfn h\u1ec7 th\u1ed1ng c\u01a1 s\u1edf d\u1eef li\u1ec7u doanh nghi\u1ec7p v\u00e0 d\u1ecbch v\u1ee5 \u0111\u00e1m m\u00e2y, t\u00f9y thu\u1ed9c v\u00e0o nhu c\u1ea7u v\u00e0 h\u1ec7 th\u1ed1ng b\u1ea1n \u0111ang s\u1eed d\u1ee5ng.&nbsp;<\/p>\n\n\n\n<p>M\u1ed9t s\u1ed1 ngu\u1ed3n d\u1eef li\u1ec7u ph\u1ed5 bi\u1ebfn:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>File d\u1eef li\u1ec7u (Excel, CSV, TXT, JSON, XML, Parquet): <\/strong>\u0110\u00e2y l\u00e0 nh\u00f3m ngu\u1ed3n ph\u1ed5 bi\u1ebfn nh\u1ea5t \u0111\u1ed1i v\u1edbi ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u. D\u1eef li\u1ec7u th\u01b0\u1eddng n\u1eb1m s\u1eb5n tr\u00ean m\u00e1y ho\u1eb7c \u0111\u01b0\u1ee3c xu\u1ea5t t\u1eeb h\u1ec7 th\u1ed1ng kh\u00e1c. \u01afu \u0111i\u1ec3m l\u00e0 d\u1ec5 s\u1eed d\u1ee5ng, kh\u00f4ng c\u1ea7n c\u1ea5u h\u00ecnh ph\u1ee9c t\u1ea1p, tuy nhi\u00ean kh\u00f3 m\u1edf r\u1ed9ng khi d\u1eef li\u1ec7u l\u1edbn ho\u1eb7c c\u1ea7n c\u1eadp nh\u1eadt th\u01b0\u1eddng xuy\u00ean.<\/li>\n\n\n\n<li><strong>Folder (th\u01b0 m\u1ee5c ch\u1ee9a nhi\u1ec1u file): <\/strong>Cho ph\u00e9p Power BI \u0111\u1ecdc to\u00e0n b\u1ed9 file trong m\u1ed9t th\u01b0 m\u1ee5c theo c\u00f9ng c\u1ea5u tr\u00fac. Ngu\u1ed3n n\u00e0y r\u1ea5t ph\u00f9 h\u1ee3p cho c\u00e1c b\u00e0i to\u00e1n m\u00e0 d\u1eef li\u1ec7u ph\u00e1t sinh h\u1eb1ng ng\u00e0y ho\u1eb7c h\u1eb1ng th\u00e1ng, v\u00ed d\u1ee5 nh\u01b0 b\u00e1o c\u00e1o b\u00e1n h\u00e0ng theo ng\u00e0y.<\/li>\n\n\n\n<li><strong>C\u01a1 s\u1edf d\u1eef li\u1ec7u (Database): <\/strong>Bao g\u1ed3m SQL Server, MySQL, PostgreSQL, Oracle, MariaDB\u2026 \u0110\u00e2y l\u00e0 ngu\u1ed3n d\u1eef li\u1ec7u ph\u1ed5 bi\u1ebfn trong doanh nghi\u1ec7p, gi\u00fap qu\u1ea3n l\u00fd d\u1eef li\u1ec7u t\u1eadp trung, h\u1ed7 tr\u1ee3 l\u01b0\u1ee3ng d\u1eef li\u1ec7u l\u1edbn v\u00e0 d\u1ec5 t\u00edch h\u1ee3p v\u1edbi Power BI Service. Khi l\u00e0m vi\u1ec7c v\u1edbi ngu\u1ed3n n\u00e0y, ta n\u00ean \u01b0u ti\u00ean ch\u1ec9 l\u1ea5y nh\u1eefng b\u1ea3ng ho\u1eb7c c\u1ed9t th\u1ef1c s\u1ef1 c\u1ea7n thi\u1ebft, s\u1eed d\u1ee5ng c\u00e1c view ho\u1eb7c c\u00e2u truy v\u1ea5n \u0111\u00e3 \u0111\u01b0\u1ee3c t\u1ed1i \u01b0u s\u1eb5n t\u1eeb ph\u00eda database, \u0111\u1ed3ng th\u1eddi thi\u1ebft k\u1ebf m\u00f4 h\u00ecnh d\u1eef li\u1ec7u theo c\u1ea5u tr\u00fac Fact &#8211; Dimension \u0111\u1ec3 gi\u00fap vi\u1ec7c ph\u00e2n t\u00edch v\u00e0 x\u00e2y d\u1ef1ng b\u00e1o c\u00e1o trong Power BI tr\u1edf n\u00ean d\u1ec5 d\u00e0ng v\u00e0 hi\u1ec7u qu\u1ea3 h\u01a1n.<\/li>\n\n\n\n<li><strong>Data Warehouse &amp; Cloud Database: <\/strong>C\u00e1c n\u1ec1n t\u1ea3ng nh\u01b0 Azure SQL Database, Azure Synapse, BigQuery, Snowflake, Amazon Redshift th\u01b0\u1eddng \u0111\u01b0\u1ee3c d\u00f9ng cho h\u1ec7 th\u1ed1ng BI hi\u1ec7n \u0111\u1ea1i. Nh\u00f3m n\u00e0y ph\u00f9 h\u1ee3p v\u1edbi d\u1eef li\u1ec7u l\u1edbn, nhi\u1ec1u ng\u01b0\u1eddi truy c\u1eadp v\u00e0 y\u00eau c\u1ea7u hi\u1ec7u n\u0103ng cao. V\u00e0 n\u00ean \u01b0u ti\u00ean x\u1eed l\u00fd v\u00e0 l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u ch\u1ee7 y\u1ebfu \u1edf t\u1ea7ng warehouse thay v\u00ec \u0111\u1ea9y h\u1ebft v\u1ec1 Power BI. Ngo\u00e0i ra, c\u1ea7n c\u00e2n nh\u1eafc gi\u1eefa Import v\u00e0 DirectQuery \u0111\u1ec3 c\u00e2n b\u1eb1ng gi\u1eefa hi\u1ec7u n\u0103ng v\u00e0 chi ph\u00ed truy v\u1ea5n.<\/li>\n\n\n\n<li><strong>D\u1ecbch v\u1ee5 SaaS &amp; n\u1ec1n t\u1ea3ng online: <\/strong>Power BI h\u1ed7 tr\u1ee3 s\u1eb5n c\u00e1c connector cho Google Analytics, Dynamics 365, Salesforce, SharePoint, OneDrive\u2026 Th\u01b0\u1eddng \u0111\u01b0\u1ee3c d\u00f9ng trong b\u00e1o c\u00e1o marketing, v\u1eadn h\u00e0nh v\u00e0 theo d\u00f5i ho\u1ea1t \u0111\u1ed9ng kinh doanh.<\/li>\n\n\n\n<li><strong>Web &amp; API: <\/strong>Cho ph\u00e9p k\u1ebft n\u1ed1i d\u1eef li\u1ec7u t\u1eeb REST API ho\u1eb7c \u0111\u01b0\u1eddng d\u1eabn web. Ph\u00f9 h\u1ee3p khi d\u1eef li\u1ec7u kh\u00f4ng n\u1eb1m trong database m\u00e0 \u0111\u01b0\u1ee3c cung c\u1ea5p th\u00f4ng qua h\u1ec7 th\u1ed1ng b\u00ean th\u1ee9 ba y\u00eau c\u1ea7u. N\u00ean \u01b0u ti\u00ean c\u00e1c API c\u00f3 h\u1ed7 tr\u1ee3 ph\u00e2n trang (pagination) v\u00e0 b\u1ed9 l\u1ecdc theo th\u1eddi gian, \u0111\u1ed3ng th\u1eddi ch\u00fa \u00fd \u0111\u1ebfn gi\u1edbi h\u1ea1n truy c\u1eadp (rate limit) \u0111\u1ec3 tr\u00e1nh l\u1ed7i khi l\u00e0m m\u1edbi d\u1eef li\u1ec7u. V\u1edbi c\u00e1c API ph\u1ee9c t\u1ea1p, n\u00ean t\u1ed5 ch\u1ee9c c\u00e1c b\u01b0\u1edbc x\u1eed l\u00fd trong Power Query m\u1ed9t c\u00e1ch r\u00f5 r\u00e0ng v\u00e0 c\u00f3 c\u1ea5u tr\u00fac.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-import-mode-vs-directquery\"><strong>Import mode vs DirectQuery<\/strong><\/h3>\n\n\n\n<p>Trong Power BI, sau khi ch\u1ecdn v\u00e0 k\u1ebft n\u1ed1i ngu\u1ed3n d\u1eef li\u1ec7u, ng\u01b0\u1eddi d\u00f9ng c\u1ea7n quy\u1ebft \u0111\u1ecbnh ch\u1ebf \u0111\u1ed9 truy c\u1eadp d\u1eef li\u1ec7u (data connectivity mode), v\u00ec l\u1ef1a ch\u1ecdn n\u00e0y s\u1ebd \u1ea3nh h\u01b0\u1edfng tr\u1ef1c ti\u1ebfp \u0111\u1ebfn hi\u1ec7u n\u0103ng b\u00e1o c\u00e1o, c\u00e1ch d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef, kh\u1ea3 n\u0103ng l\u00e0m m\u1edbi (refresh) v\u00e0 m\u1ee9c \u0111\u1ed9 linh ho\u1ea1t trong vi\u1ec7c x\u00e2y d\u1ef1ng m\u00f4 h\u00ecnh d\u1eef li\u1ec7u.&nbsp;<\/p>\n\n\n\n<p>Hi\u1ec7n nay, Power BI cung c\u1ea5p hai ch\u1ebf \u0111\u1ed9 ch\u00ednh \u0111\u1ec3 l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u ngu\u1ed3n l\u00e0 <strong>Import mode<\/strong> v\u00e0 <strong>DirectQuery<\/strong>. M\u1ed7i ch\u1ebf \u0111\u1ed9 c\u00f3 c\u00e1ch ho\u1ea1t \u0111\u1ed9ng kh\u00e1c nhau, \u01b0u \u0111i\u1ec3m v\u00e0 h\u1ea1n ch\u1ebf ri\u00eang, ph\u00f9 h\u1ee3p v\u1edbi nh\u1eefng b\u00e0i to\u00e1n v\u00e0 h\u1ea1 t\u1ea7ng d\u1eef li\u1ec7u kh\u00e1c nhau.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Ti\u00eau ch\u00ed<\/strong><\/td><td><strong>Import mode<\/strong><\/td><td><strong>DirectQuery<\/strong><\/td><\/tr><tr><td>Kh\u00e1i ni\u1ec7m<\/td><td>L\u00e0 ch\u1ebf \u0111\u1ed9 m\u00e0 Power BI t\u1ea3i (import) d\u1eef li\u1ec7u t\u1eeb ngu\u1ed3n v\u1ec1 v\u00e0 l\u01b0u tr\u1eef trong m\u00f4 h\u00ecnh VertiPaq c\u1ee7a Power BI \u0111\u1ec3 ph\u1ee5c v\u1ee5 ph\u00e2n t\u00edch v\u00e0 tr\u1ef1c quan h\u00f3a.<\/td><td>L\u00e0 ch\u1ebf \u0111\u1ed9 m\u00e0 Power BI kh\u00f4ng l\u01b0u d\u1eef li\u1ec7u trong file b\u00e1o c\u00e1o, m\u00e0 truy v\u1ea5n tr\u1ef1c ti\u1ebfp v\u00e0o ngu\u1ed3n d\u1eef li\u1ec7u m\u1ed7i khi ng\u01b0\u1eddi d\u00f9ng t\u01b0\u01a1ng t\u00e1c v\u1edbi b\u00e1o c\u00e1o.<\/td><\/tr><tr><td>C\u00e1ch Power BI x\u1eed l\u00fd d\u1eef li\u1ec7u<\/td><td>Power BI t\u1ea3i d\u1eef li\u1ec7u t\u1eeb ngu\u1ed3n v\u1ec1 v\u00e0 l\u01b0u v\u00e0o m\u00f4 h\u00ecnh (VertiPaq). C\u00e1c visual truy v\u1ea5n tr\u1ef1c ti\u1ebfp tr\u00ean d\u1eef li\u1ec7u \u0111\u00e3 n\u1ea1p.<\/td><td>Power BI kh\u00f4ng l\u01b0u d\u1eef li\u1ec7u trong file; m\u1ed7i t\u01b0\u01a1ng t\u00e1c c\u1ee7a ng\u01b0\u1eddi d\u00f9ng (l\u1ecdc, ch\u1ecdn slicer, drill\u2026) s\u1ebd t\u1ea1o truy v\u1ea5n g\u1eedi v\u1ec1 ngu\u1ed3n d\u1eef li\u1ec7u \u0111\u1ec3 l\u1ea5y k\u1ebft qu\u1ea3.<\/td><\/tr><tr><td>Tr\u1ea3i nghi\u1ec7m t\u1ed1c \u0111\u1ed9 khi thao t\u00e1c b\u00e1o c\u00e1o<\/td><td>Th\u01b0\u1eddng r\u1ea5t m\u01b0\u1ee3t do d\u1eef li\u1ec7u n\u1eb1m s\u1eb5n trong m\u00f4 h\u00ecnh Power BI, \u00edt ph\u1ee5 thu\u1ed9c v\u00e0o m\u1ea1ng v\u00e0 database.<\/td><td>Ph\u1ee5 thu\u1ed9c v\u00e0o t\u1ed1c \u0111\u1ed9 database, t\u1ed1i \u01b0u index, t\u1ea3i h\u1ec7 th\u1ed1ng v\u00e0 ch\u1ea5t l\u01b0\u1ee3ng m\u1ea1ng. N\u1ebfu ngu\u1ed3n ch\u1eadm, b\u00e1o c\u00e1o s\u1ebd ph\u1ea3n h\u1ed3i ch\u1eadm.<\/td><\/tr><tr><td>\u0110\u1ed9 \u201cm\u1edbi\u201d c\u1ee7a d\u1eef li\u1ec7u<\/td><td>D\u1eef li\u1ec7u ph\u1ea3n \u00e1nh tr\u1ea1ng th\u00e1i t\u1ea1i l\u1ea7n refresh g\u1ea7n nh\u1ea5t (theo l\u1ecbch ho\u1eb7c manual).<\/td><td>D\u1eef li\u1ec7u c\u00f3 th\u1ec3 g\u1ea7n nh\u01b0 \u201cth\u1eddi gian th\u1ef1c\u201d v\u00ec truy v\u1ea5n tr\u1ef1c ti\u1ebfp v\u00e0o ngu\u1ed3n khi ng\u01b0\u1eddi d\u00f9ng t\u01b0\u01a1ng t\u00e1c.<\/td><\/tr><tr><td>Kh\u1ea3 n\u0103ng x\u1eed l\u00fd d\u1eef li\u1ec7u l\u1edbn<\/td><td>B\u1ecb gi\u1edbi h\u1ea1n b\u1edfi dung l\u01b0\u1ee3ng m\u00f4 h\u00ecnh v\u00e0 t\u00e0i nguy\u00ean m\u00e1y\/Power BI Service. D\u1eef li\u1ec7u c\u00e0ng l\u1edbn c\u00e0ng c\u1ea7n t\u1ed1i \u01b0u.<\/td><td>Ph\u00f9 h\u1ee3p h\u01a1n khi d\u1eef li\u1ec7u r\u1ea5t l\u1edbn v\u00ec kh\u00f4ng ph\u1ea3i n\u1ea1p to\u00e0n b\u1ed9 v\u00e0o m\u00f4 h\u00ecnh; tuy nhi\u00ean database ph\u1ea3i \u0111\u1ee7 m\u1ea1nh \u0111\u1ec3 ch\u1ecbu t\u1ea3i truy v\u1ea5n.<\/td><\/tr><tr><td>M\u1ee9c \u0111\u1ed9 linh ho\u1ea1t v\u1edbi DAX v\u00e0 modeling<\/td><td>Linh ho\u1ea1t nh\u1ea5t: h\u1ea7u h\u1ebft h\u00e0m DAX v\u00e0 k\u1ef9 thu\u1eadt modeling \u0111\u1ec1u c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ea7y \u0111\u1ee7.<\/td><td>C\u00f3 gi\u1edbi h\u1ea1n nh\u1ea5t \u0111\u1ecbnh: m\u1ed9t s\u1ed1 kh\u1ea3 n\u0103ng modeling\/DAX b\u1ecb r\u00e0ng bu\u1ed9c do truy v\u1ea5n ph\u1ea3i \u201c\u0111\u1ea9y xu\u1ed1ng\u201d ngu\u1ed3n d\u1eef li\u1ec7u.<\/td><\/tr><tr><td>Y\u00eau c\u1ea7u t\u1ed1i \u01b0u ph\u00eda ngu\u1ed3n d\u1eef li\u1ec7u<\/td><td>Y\u00eau c\u1ea7u t\u1ed1i \u01b0u \u1edf m\u1ee9c v\u1eeba ph\u1ea3i, v\u00ec ph\u1ea7n l\u1edbn x\u1eed l\u00fd di\u1ec5n ra trong Power BI.<\/td><td>Y\u00eau c\u1ea7u r\u1ea5t cao: schema, index, partition, query performance\u2026 quy\u1ebft \u0111\u1ecbnh tr\u1ef1c ti\u1ebfp hi\u1ec7u n\u0103ng b\u00e1o c\u00e1o.<\/td><\/tr><tr><td>R\u1ee7i ro l\u1ed7i khi nhi\u1ec1u ng\u01b0\u1eddi truy c\u1eadp<\/td><td>Th\u01b0\u1eddng \u1ed5n \u0111\u1ecbnh h\u01a1n v\u00ec ph\u1ea7n l\u1edbn truy v\u1ea5n ch\u1ea1y trong Power BI engine.<\/td><td>C\u00f3 th\u1ec3 t\u1ea1o t\u1ea3i l\u1edbn l\u00ean database khi nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng c\u00f9ng filter\/drill, d\u1eabn t\u1edbi ch\u1eadm ho\u1eb7c ngh\u1ebdn t\u00e0i nguy\u00ean.<\/td><\/tr><tr><td>\u1ee8ng d\u1ee5ng<\/td><td>Khi \u01b0u ti\u00ean hi\u1ec7u n\u0103ng m\u01b0\u1ee3t, ph\u00e2n t\u00edch linh ho\u1ea1t, b\u00e1o c\u00e1o nghi\u1ec7p v\u1ee5 th\u00f4ng th\u01b0\u1eddng v\u00e0 d\u1eef li\u1ec7u c\u00f3 th\u1ec3 refresh theo l\u1ecbch.<\/td><td>Khi d\u1eef li\u1ec7u qu\u00e1 l\u1edbn \u0111\u1ec3 import ho\u1eb7c c\u1ea7n d\u1eef li\u1ec7u c\u1eadp nh\u1eadt li\u00ean t\u1ee5c, \u0111\u1ed3ng th\u1eddi t\u1ed5 ch\u1ee9c c\u00f3 h\u1ea1 t\u1ea7ng database \u0111\u1ee7 m\u1ea1nh \u0111\u1ec3 ph\u1ee5c v\u1ee5 truy v\u1ea5n.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-bi\u1ebfn-d\u1ed5i-d\u1eef-li\u1ec7u-v\u1edbi-power-query\"><span class=\"ez-toc-section\" id=\"Bien_doi_du_lieu_voi_Power_Query\"><\/span><strong>Bi\u1ebfn \u0111\u1ed5i d\u1eef li\u1ec7u v\u1edbi Power Query<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Trong th\u1ef1c t\u1ebf, d\u1eef li\u1ec7u th\u00f4 hi\u1ebfm khi s\u1eb5n s\u00e0ng \u0111\u1ec3 \u0111\u01b0a v\u00e0o ph\u00e2n t\u00edch ngay. D\u1eef li\u1ec7u c\u00f3 th\u1ec3 b\u1ecb thi\u1ebfu gi\u00e1 tr\u1ecb, sai ki\u1ec3u d\u1eef li\u1ec7u, tr\u00f9ng l\u1eb7p, \u0111\u1ecbnh d\u1ea1ng kh\u00f4ng \u0111\u1ed3ng nh\u1ea5t ho\u1eb7c ch\u1ee9a nhi\u1ec1u c\u1ed9t kh\u00f4ng c\u1ea7n thi\u1ebft. Do \u0111\u00f3, sau khi k\u1ebft n\u1ed1i d\u1eef li\u1ec7u, b\u1ea1n c\u1ea7n bi\u1ebfn \u0111\u1ed5i v\u00e0 l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u v\u1edbi Power Query tr\u01b0\u1edbc khi n\u1ea1p v\u00e0o m\u00f4 h\u00ecnh.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-power-query-ho\u1ea1t-d\u1ed9ng-nh\u01b0-th\u1ebf-nao\"><strong>Power Query ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o?<\/strong><\/h3>\n\n\n\n<p>V\u1ec1 b\u1ea3n ch\u1ea5t, Power Query l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 ETL (Extract &#8211; Transform &#8211; Load) t\u00edch h\u1ee3p s\u1eb5n trong Power BI. C\u00f4ng c\u1ee5 n\u00e0y cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb ngu\u1ed3n, th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc bi\u1ebfn \u0111\u1ed5i c\u1ea7n thi\u1ebft v\u00e0 cu\u1ed1i c\u00f9ng n\u1ea1p d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c chu\u1ea9n h\u00f3a v\u00e0o data model \u0111\u1ec3 ph\u1ee5c v\u1ee5 ph\u00e2n t\u00edch.<\/p>\n\n\n\n<p>Power Query ho\u1ea1t \u0111\u1ed9ng \u1edf giai \u0111o\u1ea1n ti\u1ec1n x\u1eed l\u00fd d\u1eef li\u1ec7u. Khi b\u1ea1n th\u1ef1c hi\u1ec7n b\u1ea5t k\u1ef3 thao t\u00e1c n\u00e0o trong Power Query Editor, v\u00ed d\u1ee5 nh\u01b0 x\u00f3a c\u1ed9t, \u0111\u1ed5i t\u00ean c\u1ed9t hay l\u1ecdc d\u1eef li\u1ec7u, Power BI kh\u00f4ng ch\u1ec9nh s\u1eeda tr\u1ef1c ti\u1ebfp d\u1eef li\u1ec7u g\u1ed1c m\u00e0 thay v\u00e0o \u0111\u00f3 m\u1ed7i thao t\u00e1c s\u1ebd \u0111\u01b0\u1ee3c ghi l\u1ea1i th\u00e0nh m\u1ed9t step trong b\u1ea3ng <em>Applied Steps<\/em>.&nbsp;<\/p>\n\n\n\n<p>C\u00e1c b\u01b0\u1edbc n\u00e0y \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ed5i th\u00e0nh ng\u00f4n ng\u1eef M (Power Query Formula Language) v\u00e0 \u0111\u01b0\u1ee3c ch\u1ea1y l\u1ea1i t\u1ef1 \u0111\u1ed9ng m\u1ed7i khi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c refresh. Nh\u1edd c\u01a1 ch\u1ebf n\u00e0y m\u00e0 quy tr\u00ecnh x\u1eed l\u00fd d\u1eef li\u1ec7u tr\u1edf n\u00ean minh b\u1ea1ch h\u01a1n, c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda, t\u00e1i s\u1eed d\u1ee5ng v\u00e0 \u0111\u1eb7c bi\u1ec7t ph\u00f9 h\u1ee3p cho c\u00e1c b\u00e1o c\u00e1o c\u1ea7n refresh \u0111\u1ecbnh k\u1ef3.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-nh\u1eefng-thao-tac-bi\u1ebfn-d\u1ed5i-d\u1eef-li\u1ec7u-ph\u1ed5-bi\u1ebfn\"><strong>Nh\u1eefng thao t\u00e1c bi\u1ebfn \u0111\u1ed5i d\u1eef li\u1ec7u ph\u1ed5 bi\u1ebfn<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>L\u00e0m s\u1ea1ch d\u1eef li\u1ec7u (Data Cleaning): <\/strong>Bao g\u1ed3m x\u00f3a d\u00f2ng tr\u1ed1ng, lo\u1ea1i b\u1ecf d\u1eef li\u1ec7u l\u1ed7i, x\u1eed l\u00fd gi\u00e1 tr\u1ecb null, chu\u1ea9n h\u00f3a \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng v\u00e0 s\u1ed1 li\u1ec7u.<\/li>\n\n\n\n<li><strong>Chu\u1ea9n h\u00f3a c\u1ea5u tr\u00fac d\u1eef li\u1ec7u: <\/strong>\u0110\u1ed5i t\u00ean c\u1ed9t cho d\u1ec5 hi\u1ec3u, chu\u1ea9n h\u00f3a ki\u1ec3u d\u1eef li\u1ec7u (text, number, date), pivot \/ unpivot d\u1eef li\u1ec7u, t\u00e1ch ho\u1eb7c g\u1ed9p c\u1ed9t \u0111\u1ec3 ph\u00f9 h\u1ee3p v\u1edbi m\u00f4 h\u00ecnh ph\u00e2n t\u00edch.<\/li>\n\n\n\n<li><strong>L\u1ecdc v\u00e0 ch\u1ecdn d\u1eef li\u1ec7u c\u1ea7n thi\u1ebft: <\/strong>Gi\u1eef l\u1ea1i c\u00e1c c\u1ed9t v\u00e0 d\u00f2ng ph\u1ee5c v\u1ee5 ph\u00e2n t\u00edch, lo\u1ea1i b\u1ecf d\u1eef li\u1ec7u d\u01b0 th\u1eeba gi\u00fap gi\u1ea3m dung l\u01b0\u1ee3ng model v\u00e0 t\u0103ng hi\u1ec7u n\u0103ng.<\/li>\n\n\n\n<li><strong>K\u1ebft h\u1ee3p d\u1eef li\u1ec7u (Merge &amp; Append): <\/strong>G\u1ed9p nhi\u1ec1u b\u1ea3ng l\u1ea1i v\u1edbi nhau th\u00f4ng qua kh\u00f3a chung ho\u1eb7c n\u1ed1i d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u file, nhi\u1ec1u th\u00e1ng th\u00e0nh m\u1ed9t b\u1ea3ng th\u1ed1ng nh\u1ea5t.<\/li>\n\n\n\n<li><strong>T\u1ea1o c\u1ed9t m\u1edbi trong Power Query: <\/strong>Th\u00eam c\u1ed9t \u0111i\u1ec1u ki\u1ec7n, c\u1ed9t logic ho\u1eb7c x\u1eed l\u00fd text tr\u01b0\u1edbc khi \u0111\u01b0a d\u1eef li\u1ec7u v\u00e0o m\u00f4 h\u00ecnh, gi\u00fap gi\u1ea3m t\u1ea3i cho DAX.<\/li>\n<\/ul>\n\n\n\n<p><strong>L\u01b0u \u00fd quan tr\u1ecdng:<\/strong>&nbsp;<\/p>\n\n\n\n<p>N\u00ean x\u1eed l\u00fd c\u00e0ng nhi\u1ec1u d\u1eef li\u1ec7u c\u00e0ng t\u1ed1t \u1edf Power Query v\u00e0 h\u1ea1n ch\u1ebf x\u1eed l\u00fd b\u1eb1ng DAX. L\u00fd do l\u00e0 v\u00ec khi d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c x\u1eed l\u00fd t\u1ed1t ngay t\u1eeb \u0111\u1ea7u th\u00ec m\u00f4 h\u00ecnh s\u1ebd nh\u1eb9 h\u01a1n, d\u1ec5 hi\u1ec3u h\u01a1n v\u00e0 gi\u1ea3m \u0111\u00e1ng k\u1ec3 \u0111\u1ed9 ph\u1ee9c t\u1ea1p c\u1ee7a c\u00e1c c\u00f4ng th\u1ee9c DAX.&nbsp;<\/p>\n\n\n\n<p>Ng\u01b0\u1ee3c l\u1ea1i, n\u1ebfu qu\u00e1 nhi\u1ec1u logic x\u1eed l\u00fd \u0111\u01b0\u1ee3c d\u1ed3n sang DAX th\u00ec m\u00f4 h\u00ecnh s\u1ebd tr\u1edf n\u00ean kh\u00f3 b\u1ea3o tr\u00ec, c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p h\u01a1n v\u00e0 hi\u1ec7u n\u0103ng c\u00f3 th\u1ec3 gi\u1ea3m khi d\u1eef li\u1ec7u t\u0103ng l\u00ean. V\u1eady n\u00ean l\u00e0 Power Query n\u00ean \u0111\u01b0\u1ee3c d\u00f9ng cho c\u00e1c thao t\u00e1c bi\u1ebfn \u0111\u1ed5i d\u1eef li\u1ec7u, c\u00f2n DAX ch\u1ec9 n\u00ean t\u1eadp trung v\u00e0o t\u00ednh to\u00e1n ph\u00e2n t\u00edch v\u00e0 nghi\u1ec7p v\u1ee5.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-xay-d\u1ef1ng-mo-hinh-d\u1eef-li\u1ec7u-data-model\"><span class=\"ez-toc-section\" id=\"Xay_dung_mo_hinh_du_lieu_data_model\"><\/span><strong>X\u00e2y d\u1ef1ng m\u00f4 h\u00ecnh d\u1eef li\u1ec7u (data model)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Sau khi \u0111\u00e3 k\u1ebft n\u1ed1i v\u00e0 l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u, b\u1ea1n s\u1ebd \u0111\u1ebfn m\u1ed9t b\u01b0\u1edbc r\u1ea5t quan tr\u1ecdng trong Power BI l\u00e0 x\u00e2y d\u1ef1ng m\u00f4 h\u00ecnh d\u1eef li\u1ec7u.&nbsp;<\/p>\n\n\n\n<p>Trong th\u1ef1c t\u1ebf, d\u1eef li\u1ec7u hi\u1ebfm khi n\u1eb1m g\u1ecdn trong m\u1ed9t b\u1ea3ng duy nh\u1ea5t m\u00e0 th\u01b0\u1eddng \u0111\u01b0\u1ee3c ph\u00e2n t\u00e1n \u1edf nhi\u1ec1u b\u1ea3ng kh\u00e1c nhau. Thay v\u00ec g\u1ed9p t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u v\u00e0o m\u1ed9t b\u1ea3ng l\u1edbn, Power BI x\u00e2y d\u1ef1ng m\u00f4 h\u00ecnh b\u1eb1ng c\u00e1ch li\u00ean k\u1ebft c\u00e1c b\u1ea3ng th\u00f4ng qua nh\u1eefng c\u1ed9t chung, \u0111\u1ed3ng th\u1eddi x\u00e1c \u0111\u1ecbnh r\u00f5 cardinality v\u00e0 h\u01b0\u1edbng l\u1ecdc c\u1ee7a t\u1eebng m\u1ed1i quan h\u1ec7. N\u00f3i m\u1ed9t c\u00e1ch d\u1ec5 hi\u1ec3u, m\u00f4 h\u00ecnh d\u1eef li\u1ec7u gi\u00fap \u201cn\u00f3i\u201d cho Power BI bi\u1ebft c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u n\u00e0y li\u00ean quan v\u1edbi nhau ra sao, v\u00e0 n\u1ebfu b\u1ea1n thi\u1ebft k\u1ebf m\u1ed1i quan h\u1ec7 \u0111\u00fang ngay t\u1eeb \u0111\u1ea7u, c\u00e1c con s\u1ed1 trong b\u00e1o c\u00e1o s\u1ebd nh\u1ea5t qu\u00e1n, d\u1ec5 ki\u1ec3m so\u00e1t v\u00e0 \u00edt r\u1ee7i ro sai l\u1ec7ch h\u01a1n v\u1ec1 sau.<\/p>\n\n\n\n<p>Gi\u1ea3 s\u1eed ta c\u00f3 m\u1ed9t b\u1ea3ng <strong>B\u00e1n h\u00e0ng<\/strong> l\u01b0u th\u00f4ng tin giao d\u1ecbch h\u1eb1ng ng\u00e0y, m\u1ed9t b\u1ea3ng <strong>S\u1ea3n ph\u1ea9m<\/strong> ch\u1ee9a t\u00ean v\u00e0 lo\u1ea1i s\u1ea3n ph\u1ea9m, v\u00e0 m\u1ed9t b\u1ea3ng <strong>Kh\u00e1ch h\u00e0ng<\/strong> l\u01b0u th\u00f4ng tin kh\u00e1ch mua. C\u00e1ch thi\u1ebft k\u1ebf ph\u00f9 h\u1ee3p l\u00e0:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Gi\u1eef b\u1ea3ng <strong>B\u00e1n h\u00e0ng<\/strong> \u1edf m\u1ee9c chi ti\u1ebft giao d\u1ecbch (kh\u00f4ng l\u00e0m ph\u1eb3ng ho\u1eb7c g\u1ed9p qu\u00e1 nhi\u1ec1u th\u00f4ng tin v\u00e0o \u0111\u00e2y),<\/li>\n\n\n\n<li>Li\u00ean k\u1ebft b\u1ea3ng B\u00e1n h\u00e0ng v\u1edbi b\u1ea3ng S\u1ea3n ph\u1ea9m th\u00f4ng qua <strong>m\u00e3 s\u1ea3n ph\u1ea9m<\/strong><\/li>\n\n\n\n<li>Li\u00ean k\u1ebft b\u1ea3ng B\u00e1n h\u00e0ng v\u1edbi b\u1ea3ng Kh\u00e1ch h\u00e0ng th\u00f4ng qua <strong>m\u00e3 kh\u00e1ch h\u00e0ng<\/strong>.<\/li>\n<\/ul>\n\n\n\n<p>V\u1edbi c\u1ea5u tr\u00fac n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng xem doanh thu theo t\u1eebng s\u1ea3n ph\u1ea9m, t\u1eebng nh\u00f3m kh\u00e1ch h\u00e0ng ho\u1eb7c t\u1eebng khu v\u1ef1c ch\u1ec9 v\u1edbi v\u00e0i thao t\u00e1c k\u00e9o th\u1ea3 tr\u01b0\u1eddng d\u1eef li\u1ec7u. V\u00e0 quan tr\u1ecdng h\u01a1n, Power BI c\u00f3 th\u1ec3 t\u1ed5ng h\u1ee3p s\u1ed1 li\u1ec7u m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c d\u1ef1a tr\u00ean c\u00e1c m\u1ed1i quan h\u1ec7 \u0111\u00e3 \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp.<\/p>\n\n\n\n<p>Th\u00f4ng th\u01b0\u1eddng, m\u1ed9t m\u00f4 h\u00ecnh d\u1eef li\u1ec7u trong Power BI s\u1ebd bao g\u1ed3m hai lo\u1ea1i b\u1ea3ng ch\u00ednh:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>B\u1ea3ng ch\u00ednh (fact table):<\/strong> ch\u1ee9a c\u00e1c s\u1ed1 li\u1ec7u nh\u01b0 doanh thu, s\u1ed1 l\u01b0\u1ee3ng b\u00e1n, chi ph\u00ed ho\u1eb7c l\u1ee3i nhu\u1eadn. \u0110\u00e2y th\u01b0\u1eddng l\u00e0 b\u1ea3ng c\u00f3 nhi\u1ec1u d\u00f2ng nh\u1ea5t trong m\u00f4 h\u00ecnh. Vi\u1ec7c gi\u1eef fact table \u1edf m\u1ee9c chi ti\u1ebft ph\u00f9 h\u1ee3p gi\u00fap b\u1ea1n v\u1eeba c\u00f3 th\u1ec3 ph\u00e2n t\u00edch s\u00e2u, v\u1eeba tr\u00e1nh l\u00e0m m\u00f4 h\u00ecnh tr\u1edf n\u00ean qu\u00e1 c\u1ed3ng k\u1ec1nh.<\/li>\n\n\n\n<li><strong>C\u00e1c b\u1ea3ng danh m\u1ee5c (dimension table \/ dim table):<\/strong> d\u00f9ng \u0111\u1ec3 m\u00f4 t\u1ea3 th\u00f4ng tin nh\u01b0 s\u1ea3n ph\u1ea9m, kh\u00e1ch h\u00e0ng, th\u1eddi gian, khu v\u1ef1c. C\u00e1c b\u1ea3ng n\u00e0y n\u00ean \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf r\u00f5 r\u00e0ng, c\u00f3 kh\u00f3a duy nh\u1ea5t cho m\u1ed7i d\u00f2ng v\u00e0 \u00edt thay \u0111\u1ed5i c\u1ea5u tr\u00fac theo th\u1eddi gian, \u0111\u1ec3 m\u00f4 h\u00ecnh \u1ed5n \u0111\u1ecbnh v\u00e0 d\u1ec5 b\u1ea3o tr\u00ec.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-cach-lam-vi\u1ec7c-v\u1edbi-dax\"><span class=\"ez-toc-section\" id=\"Cach_lam_viec_voi_DAX\"><\/span><strong>C\u00e1ch l\u00e0m vi\u1ec7c v\u1edbi DAX<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Sau khi d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c k\u1ebft n\u1ed1i v\u00e0 l\u00e0m s\u1ea1ch b\u1eb1ng Power Query, Power BI v\u1eabn ch\u01b0a th\u1ec3 t\u1ea1o ra c\u00e1c ch\u1ec9 s\u1ed1 ph\u00e2n t\u00edch ngay l\u1eadp t\u1ee9c. \u1ede th\u1eddi \u0111i\u1ec3m n\u00e0y, d\u1eef li\u1ec7u m\u1edbi ch\u1ec9 \u1edf d\u1ea1ng b\u1ea3ng, ch\u01b0a th\u1ec3 hi\u1ec7n \u0111\u01b0\u1ee3c c\u00e1c th\u00f4ng tin nh\u01b0 t\u1ed5ng doanh thu, l\u1ee3i nhu\u1eadn, t\u1ef7 l\u1ec7 t\u0103ng tr\u01b0\u1edfng hay so s\u00e1nh gi\u1eefa c\u00e1c kho\u1ea3ng th\u1eddi gian. \u0110\u1ec3 th\u1ef1c hi\u1ec7n nh\u1eefng ph\u00e9p t\u00ednh \u0111\u00f3, Power BI s\u1eed d\u1ee5ng m\u1ed9t ng\u00f4n ng\u1eef ri\u00eang g\u1ecdi l\u00e0 DAX.<\/p>\n\n\n\n<p><strong>DAX (Data Analysis Expressions) l<\/strong>\u00e0 ng\u00f4n ng\u1eef c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c d\u00f9ng trong Power BI \u0111\u1ec3 t\u1ea1o ra c\u00e1c ph\u00e9p t\u00ednh ph\u1ee5c v\u1ee5 ph\u00e2n t\u00edch d\u1eef li\u1ec7u. DAX cho ph\u00e9p b\u1ea1n x\u00e2y d\u1ef1ng c\u00e1c ch\u1ec9 s\u1ed1 \u0111\u1ed9ng, c\u00f3 th\u1ec3 t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i khi ng\u01b0\u1eddi d\u00f9ng l\u1ecdc b\u00e1o c\u00e1o theo th\u1eddi gian, s\u1ea3n ph\u1ea9m, khu v\u1ef1c ho\u1eb7c b\u1ea5t k\u1ef3 chi\u1ec1u d\u1eef li\u1ec7u n\u00e0o kh\u00e1c.&nbsp;<\/p>\n\n\n\n<p>N\u1ebfu Power Query \u0111\u00f3ng vai tr\u00f2 chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o, th\u00ec DAX ch\u00ednh l\u00e0 ph\u1ea7n bi\u1ebfn d\u1eef li\u1ec7u \u0111\u00f3 th\u00e0nh th\u00f4ng tin c\u00f3 gi\u00e1 tr\u1ecb. Hai th\u00e0nh ph\u1ea7n n\u00e0y b\u1ed5 tr\u1ee3 cho nhau v\u00e0 kh\u00f4ng th\u1ec3 thay th\u1ebf l\u1eabn nhau. DAX ch\u1ee7 y\u1ebfu \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>T\u1ea1o measure ph\u1ee5c v\u1ee5 ph\u00e2n t\u00edch v\u00e0 dashboard<\/li>\n\n\n\n<li>T\u00ednh to\u00e1n KPI v\u00e0 ch\u1ec9 s\u1ed1 nghi\u1ec7p v\u1ee5<\/li>\n\n\n\n<li>So s\u00e1nh d\u1eef li\u1ec7u theo th\u1eddi gian (MoM, YoY, YTD\u2026)<\/li>\n\n\n\n<li>X\u00e2y d\u1ef1ng logic ph\u00e2n t\u00edch \u0111\u1ed9ng theo filter ng\u01b0\u1eddi d\u00f9ng<\/li>\n<\/ul>\n\n\n\n<p>Trong c\u00e1c b\u00e1o c\u00e1o Power BI th\u1ef1c t\u1ebf, DAX \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi b\u1ea1n c\u1ea7n t\u00ednh to\u00e1n nh\u1eefng ch\u1ec9 s\u1ed1 m\u00e0 c\u00e1c ph\u00e9p t\u1ed5ng h\u1ee3p \u0111\u01a1n gi\u1ea3n (nh\u01b0 SUM, AVERAGE trong visual) kh\u00f4ng th\u1ec3 \u0111\u00e1p \u1ee9ng. V\u00ed d\u1ee5 nh\u01b0: t\u1ed5ng doanh thu theo t\u1eebng th\u00e1ng, doanh thu t\u1eeb \u0111\u1ea7u n\u0103m \u0111\u1ebfn hi\u1ec7n t\u1ea1i (YTD), doanh thu c\u00f9ng k\u1ef3 n\u0103m tr\u01b0\u1edbc (YoY) ho\u1eb7c t\u1ef7 l\u1ec7 t\u0103ng tr\u01b0\u1edfng ph\u1ea7n tr\u0103m gi\u1eefa hai giai \u0111o\u1ea1n.<\/p>\n\n\n\n<p>\u0110i\u1ec3m \u0111\u1eb7c bi\u1ec7t c\u1ee7a DAX n\u1eb1m \u1edf ch\u1ed7 k\u1ebft qu\u1ea3 t\u00ednh to\u00e1n kh\u00f4ng c\u1ed1 \u0111\u1ecbnh. C\u00f9ng m\u1ed9t c\u00f4ng th\u1ee9c, nh\u01b0ng khi ng\u01b0\u1eddi d\u00f9ng thay \u0111\u1ed5i b\u1ed9 l\u1ecdc tr\u00ean b\u00e1o c\u00e1o, gi\u00e1 tr\u1ecb hi\u1ec3n th\u1ecb c\u0169ng s\u1ebd thay \u0111\u1ed5i theo. Nh\u1edd \u0111\u00f3, Power BI c\u00f3 th\u1ec3 t\u1ea1o ra c\u00e1c dashboard t\u01b0\u01a1ng t\u00e1c thay v\u00ec nh\u1eefng b\u00e1o c\u00e1o t\u0129nh nh\u01b0 trong Excel truy\u1ec1n th\u1ed1ng.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-measure-va-calculated-column-trong-dax\"><strong>Measure v\u00e0 Calculated Column trong DAX<\/strong><\/h3>\n\n\n\n<p>Khi l\u00e0m vi\u1ec7c v\u1edbi DAX, b\u1ea1n s\u1ebd th\u01b0\u1eddng g\u1eb7p hai kh\u00e1i ni\u1ec7m quan tr\u1ecdng l\u00e0 calculated column v\u00e0 measure.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Calculated column<\/strong> \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n ngay khi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c t\u1ea3i v\u00e0o m\u00f4 h\u00ecnh. M\u1ed7i d\u00f2ng d\u1eef li\u1ec7u s\u1ebd c\u00f3 m\u1ed9t gi\u00e1 tr\u1ecb c\u1ed1 \u0111\u1ecbnh v\u00e0 k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c l\u01b0u tr\u1ef1c ti\u1ebfp trong b\u1ea3ng d\u1eef li\u1ec7u.<\/li>\n\n\n\n<li><strong>Measure<\/strong> ng\u01b0\u1ee3c l\u1ea1i ch\u1ec9 \u0111\u01b0\u1ee3c t\u00ednh khi b\u00e1o c\u00e1o \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb. Gi\u00e1 tr\u1ecb c\u1ee7a measure ph\u1ee5 thu\u1ed9c ho\u00e0n to\u00e0n v\u00e0o b\u1ed9 l\u1ecdc v\u00e0 ng\u1eef c\u1ea3nh hi\u1ec3n th\u1ecb tr\u00ean t\u1eebng visual. Nh\u1edd v\u1eady, measure linh ho\u1ea1t h\u01a1n r\u1ea5t nhi\u1ec1u v\u00e0 kh\u00f4ng l\u00e0m t\u0103ng dung l\u01b0\u1ee3ng dataset. Trong ph\u1ea7n l\u1edbn c\u00e1c b\u00e1o c\u00e1o Power BI th\u1ef1c t\u1ebf, measure l\u00e0 th\u00e0nh ph\u1ea7n \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nhi\u1ec1u nh\u1ea5t.<\/li>\n<\/ul>\n\n\n\n<p>V\u00ed d\u1ee5 ta t\u1ea1o m\u1ed9t measure t\u00ednh t\u1ed5ng doanh thu v\u1edbi DAX:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Total Sales =\nSUM ( Sales&#91;Amount] )<\/code><\/pre>\n\n\n\n<p>C\u00f4ng th\u1ee9c n\u00e0y kh\u00f4ng tr\u1ea3 v\u1ec1 m\u1ed9t con s\u1ed1 c\u1ed1 \u0111\u1ecbnh. Khi ng\u01b0\u1eddi d\u00f9ng thay \u0111\u1ed5i b\u1ed9 l\u1ecdc theo th\u1eddi gian, s\u1ea3n ph\u1ea9m ho\u1eb7c chi nh\u00e1nh, Power BI s\u1ebd t\u1ef1 \u0111\u1ed9ng t\u00ednh l\u1ea1i k\u1ebft qu\u1ea3 t\u01b0\u01a1ng \u1ee9ng.<\/p>\n\n\n\n<p>C\u00f4ng th\u1ee9c n\u00e0y kh\u00f4ng tr\u1ea3 v\u1ec1 m\u1ed9t con s\u1ed1 c\u1ed1 \u0111\u1ecbnh. Khi ng\u01b0\u1eddi d\u00f9ng thay \u0111\u1ed5i b\u1ed9 l\u1ecdc theo th\u1eddi gian, s\u1ea3n ph\u1ea9m ho\u1eb7c chi nh\u00e1nh, Power BI s\u1ebd t\u1ef1 \u0111\u1ed9ng t\u00ednh l\u1ea1i k\u1ebft qu\u1ea3 t\u01b0\u01a1ng \u1ee9ng.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-tr\u1ef1c-quan-hoa-d\u1eef-li\u1ec7u-visualization\"><span class=\"ez-toc-section\" id=\"Truc_quan_hoa_du_lieu_Visualization\"><\/span><strong>Tr\u1ef1c quan h\u00f3a d\u1eef li\u1ec7u (Visualization)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Sau khi d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c l\u00e0m s\u1ea1ch b\u1eb1ng Power Query v\u00e0 t\u00ednh to\u00e1n b\u1eb1ng DAX, b\u01b0\u1edbc ti\u1ebfp theo trong Power BI l\u00e0 tr\u1ef1c quan h\u00f3a d\u1eef li\u1ec7u (visualization). \u0110\u00e2y l\u00e0 giai \u0111o\u1ea1n bi\u1ebfn c\u00e1c con s\u1ed1 kh\u00f4 khan th\u00e0nh bi\u1ec3u \u0111\u1ed3, b\u1ea3ng bi\u1ec3u, th\u1ebb KPI v\u00e0 dashboard gi\u00fap ng\u01b0\u1eddi d\u00f9ng d\u1ec5 quan s\u00e1t, so s\u00e1nh v\u00e0 \u0111\u01b0a ra quy\u1ebft \u0111\u1ecbnh.&nbsp;<\/p>\n\n\n\n<p>M\u1ed7i visual \u0111\u1ea1i di\u1ec7n cho m\u1ed9t g\u00f3c nh\u00ecn kh\u00e1c nhau c\u1ee7a d\u1eef li\u1ec7u v\u00e0 c\u00f3 th\u1ec3 t\u01b0\u01a1ng t\u00e1c v\u1edbi nhau th\u00f4ng qua b\u1ed9 l\u1ecdc, slicer v\u00e0 drill-down. Khi ng\u01b0\u1eddi d\u00f9ng ch\u1ecdn m\u1ed9t ph\u1ea7n c\u1ee7a bi\u1ec3u \u0111\u1ed3, to\u00e0n b\u1ed9 c\u00e1c visual kh\u00e1c tr\u00ean b\u00e1o c\u00e1o c\u00f3 th\u1ec3 t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i theo. \u0110\u00e2y ch\u00ednh l\u00e0 y\u1ebfu t\u1ed1 t\u1ea1o n\u00ean tr\u1ea3i nghi\u1ec7m ph\u00e2n t\u00edch t\u01b0\u01a1ng t\u00e1c, \u0111i\u1ec3m m\u1ea1nh l\u1edbn nh\u1ea5t c\u1ee7a Power BI so v\u1edbi c\u00e1c b\u00e1o c\u00e1o t\u0129nh truy\u1ec1n th\u1ed1ng.<\/p>\n\n\n\n<p>C\u00e1c lo\u1ea1i visualization ph\u1ed5 bi\u1ebfn:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Bi\u1ec3u \u0111\u1ed3 so s\u00e1nh<\/strong> nh\u01b0 column chart v\u00e0 bar chart th\u01b0\u1eddng \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 so s\u00e1nh s\u1ed1 li\u1ec7u gi\u1eefa c\u00e1c danh m\u1ee5c, v\u00ed d\u1ee5 doanh thu theo s\u1ea3n ph\u1ea9m ho\u1eb7c theo chi nh\u00e1nh.<\/li>\n\n\n\n<li><strong>Bi\u1ec3u \u0111\u1ed3 xu h\u01b0\u1edbng<\/strong> nh\u01b0 line chart ho\u1eb7c area chart ph\u00f9 h\u1ee3p \u0111\u1ec3 theo d\u00f5i s\u1ef1 thay \u0111\u1ed5i theo th\u1eddi gian, ch\u1eb3ng h\u1ea1n doanh thu theo th\u00e1ng ho\u1eb7c s\u1ed1 l\u01b0\u1ee3ng \u0111\u01a1n h\u00e0ng theo ng\u00e0y.<\/li>\n\n\n\n<li><strong>Bi\u1ec3u \u0111\u1ed3 t\u1ef7 tr\u1ecdng<\/strong> nh\u01b0 pie chart ho\u1eb7c donut chart gi\u00fap th\u1ec3 hi\u1ec7n c\u01a1 c\u1ea5u, v\u00ed d\u1ee5 t\u1ef7 l\u1ec7 doanh thu theo nh\u00f3m s\u1ea3n ph\u1ea9m. Tuy nhi\u00ean, lo\u1ea1i bi\u1ec3u \u0111\u1ed3 n\u00e0y ch\u1ec9 n\u00ean d\u00f9ng khi s\u1ed1 nh\u00f3m \u00edt \u0111\u1ec3 tr\u00e1nh g\u00e2y r\u1ed1i m\u1eaft.<\/li>\n\n\n\n<li><strong>Table v\u00e0 matrix<\/strong> \u0111\u01b0\u1ee3c d\u00f9ng khi ng\u01b0\u1eddi xem c\u1ea7n nh\u00ecn d\u1eef li\u1ec7u chi ti\u1ebft. Matrix \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi c\u1ea7n ph\u00e2n t\u00edch theo nhi\u1ec1u chi\u1ec1u nh\u01b0 th\u1eddi gian, s\u1ea3n ph\u1ea9m, khu v\u1ef1c.<\/li>\n\n\n\n<li><strong>Card v\u00e0 KPI visual<\/strong> th\u01b0\u1eddng d\u00f9ng \u0111\u1ec3 hi\u1ec3n th\u1ecb c\u00e1c con s\u1ed1 quan tr\u1ecdng nh\u1ea5t tr\u00ean dashboard nh\u01b0 t\u1ed5ng doanh thu, l\u1ee3i nhu\u1eadn ho\u1eb7c t\u1ef7 l\u1ec7 t\u0103ng tr\u01b0\u1edfng.<\/li>\n<\/ul>\n\n\n\n<p>Visualizations kh\u00f4ng ch\u1ec9 \u0111\u01a1n thu\u1ea7n l\u00e0 \u201cv\u1ebd bi\u1ec3u \u0111\u1ed3\u201d. M\u1ed9t visualization t\u1ed1t ph\u1ea3i truy\u1ec1n t\u1ea3i \u0111\u01b0\u1ee3c th\u00f4ng tin ch\u00ednh, l\u00e0m n\u1ed5i b\u1eadt xu h\u01b0\u1edbng v\u00e0 gi\u00fap ng\u01b0\u1eddi xem hi\u1ec3u d\u1eef li\u1ec7u ch\u1ec9 trong v\u00e0i gi\u00e2y \u0111\u1ea7u ti\u00ean. M\u1ed9t s\u1ed1 tip b\u1ea1n n\u00ean c\u00e2n nh\u1eafc \u0111\u1ec3 ph\u1ea7n visualization t\u1ed1t h\u01a1n nh\u01b0:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>M\u00e0u s\u1eafc nh\u1ea5t qu\u00e1n gi\u1eefa c\u00e1c visual,<\/li>\n\n\n\n<li>Ti\u00eau \u0111\u1ec1 r\u00f5 r\u00e0ng th\u1ec3 hi\u1ec7n n\u1ed9i dung bi\u1ec3u \u0111\u1ed3,<\/li>\n\n\n\n<li>H\u1ea1n ch\u1ebf s\u1ed1 l\u01b0\u1ee3ng bi\u1ec3u \u0111\u1ed3 tr\u00ean m\u1ed9t trang,<\/li>\n\n\n\n<li>S\u1eafp x\u1ebfp theo lu\u1ed3ng \u0111\u1ecdc t\u1ef1 nhi\u00ean t\u1eeb tr\u00e1i sang ph\u1ea3i, t\u1eeb tr\u00ean xu\u1ed1ng d\u01b0\u1edbi.<\/li>\n<\/ul>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><em>\u0110\u1ecdc chi ti\u1ebft: <strong><a href=\"https:\/\/itviec.com\/blog\/power-bi-template\/\" target=\"_blank\" rel=\"noreferrer noopener\">Power BI Template: Best practices l\u00e0m b\u00e1o c\u00e1o Power BI hi\u1ec7u qu\u1ea3<\/a><\/strong><\/em><\/p>\n<\/blockquote>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-publish-bao-cao-vao-power-bi-service\"><span class=\"ez-toc-section\" id=\"Publish_bao_cao_vao_Power_BI_Service\"><\/span><strong>Publish b\u00e1o c\u00e1o v\u00e0o Power BI Service<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Sau khi ho\u00e0n thi\u1ec7n b\u00e1o c\u00e1o trong Power BI Desktop, b\u01b0\u1edbc ti\u1ebfp theo \u0111\u1ec3 \u0111\u01b0a b\u00e1o c\u00e1o v\u00e0o m\u00f4i tr\u01b0\u1eddng s\u1eed d\u1ee5ng th\u1ef1c t\u1ebf l\u00e0 publish l\u00ean Power BI Service.&nbsp;<\/p>\n\n\n\n<p>Power BI Service l\u00e0 n\u1ec1n t\u1ea3ng \u0111\u00e1m m\u00e2y c\u1ee7a Microsoft cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng chia s\u1ebb b\u00e1o c\u00e1o, thi\u1ebft l\u1eadp l\u1ecbch refresh d\u1eef li\u1ec7u v\u00e0 ph\u00e2n quy\u1ec1n truy c\u1eadp cho nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng trong t\u1ed5 ch\u1ee9c. C\u00f3 th\u1ec3 hi\u1ec3u l\u00e0 Power BI Desktop d\u00f9ng \u0111\u1ec3 x\u00e2y d\u1ef1ng b\u00e1o c\u00e1o, c\u00f2n Power BI Service d\u00f9ng \u0111\u1ec3 tri\u1ec3n khai, v\u1eadn h\u00e0nh v\u00e0 ph\u00e2n ph\u1ed1i b\u00e1o c\u00e1o.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-quy-trinh-publish-report-t\u1eeb-power-bi-desktop\"><strong>Quy tr\u00ecnh publish report t\u1eeb Power BI Desktop<\/strong><\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Ng\u01b0\u1eddi d\u00f9ng \u0111\u0103ng nh\u1eadp Power BI Desktop b\u1eb1ng t\u00e0i kho\u1ea3n Microsoft ho\u1eb7c t\u00e0i kho\u1ea3n doanh nghi\u1ec7p (Microsoft 365).<\/li>\n\n\n\n<li>Nh\u1ea5n n\u00fat <em>Publish<\/em> tr\u00ean thanh c\u00f4ng c\u1ee5.<\/li>\n\n\n\n<li>Ch\u1ecdn workspace tr\u00ean Power BI Service \u0111\u1ec3 l\u01b0u b\u00e1o c\u00e1o.<\/li>\n\n\n\n<li>Power BI t\u1ea3i file .pbix l\u00ean cloud v\u00e0 t\u1ef1 \u0111\u1ed9ng t\u1ea1o dataset \u0111i k\u00e8m.<\/li>\n<\/ol>\n\n\n\n<p>Sau khi publish th\u00e0nh c\u00f4ng, b\u00e1o c\u00e1o s\u1ebd xu\u1ea5t hi\u1ec7n tr\u00ean Power BI Service d\u01b0\u1edbi hai th\u00e0nh ph\u1ea7n l\u00e0 Report &#8211; giao di\u1ec7n dashboard ng\u01b0\u1eddi d\u00f9ng xem v\u00e0 Dataset (Semantic model) &#8211; n\u01a1i l\u01b0u d\u1eef li\u1ec7u, m\u00f4 h\u00ecnh v\u00e0 DAX.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-thi\u1ebft-l\u1eadp-refresh-d\u1eef-li\u1ec7u\"><strong>Thi\u1ebft l\u1eadp refresh d\u1eef li\u1ec7u<\/strong><\/h3>\n\n\n\n<p>M\u1ed9t trong nh\u1eefng b\u01b0\u1edbc quan tr\u1ecdng sau khi publish l\u00e0 c\u1ea5u h\u00ecnh Scheduled Refresh. Vi\u1ec7c refresh t\u1ef1 \u0111\u1ed9ng gi\u00fap b\u00e1o c\u00e1o lu\u00f4n hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u m\u1edbi m\u00e0 kh\u00f4ng c\u1ea7n m\u1edf Power BI Desktop. Ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 thi\u1ebft l\u1eadp t\u1ea7n su\u1ea5t refresh h\u00e0ng ng\u00e0y ho\u1eb7c nhi\u1ec1u l\u1ea7n trong ng\u00e0y\u2026, c\u1ea5u h\u00ecnh th\u00f4ng tin \u0111\u0103ng nh\u1eadp ngu\u1ed3n d\u1eef li\u1ec7u v\u00e0 k\u1ebft n\u1ed1i gateway n\u1ebfu d\u1eef li\u1ec7u n\u1eb1m trong h\u1ec7 th\u1ed1ng n\u1ed9i b\u1ed9.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-phan-quy\u1ec1n-va-chia-s\u1ebb-bao-cao\"><strong>Ph\u00e2n quy\u1ec1n v\u00e0 chia s\u1ebb b\u00e1o c\u00e1o<\/strong><\/h3>\n\n\n\n<p>Power BI Service cho ph\u00e9p qu\u1ea3n l\u00fd quy\u1ec1n truy c\u1eadp r\u1ea5t linh ho\u1ea1t v\u1edbi c\u00e1c l\u1ef1a ch\u1ecdn:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Viewer<\/strong>: ch\u1ec9 xem b\u00e1o c\u00e1o<\/li>\n\n\n\n<li><strong>Contributor<\/strong>: ch\u1ec9nh s\u1eeda report trong Service<\/li>\n\n\n\n<li><strong>Member \/ Admin<\/strong>: qu\u1ea3n l\u00fd workspace<\/li>\n<\/ul>\n\n\n\n<p>Ngo\u00e0i ra, b\u00e1o c\u00e1o c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c chia s\u1ebb th\u00f4ng qua link tr\u1ef1c ti\u1ebfp, Power BI app, Embed v\u00e0o SharePoint ho\u1eb7c website n\u1ed9i b\u1ed9.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-kinh-nghi\u1ec7m-cach-s\u1eed-d\u1ee5ng-power-bi-hi\u1ec7u-qu\u1ea3\"><span class=\"ez-toc-section\" id=\"Kinh_nghiem_cach_su_dung_Power_BI_hieu_qua\"><\/span><strong>Kinh nghi\u1ec7m c\u00e1ch s\u1eed d\u1ee5ng Power BI hi\u1ec7u qu\u1ea3<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Lu\u00f4n l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u b\u1eb1ng Power Query tr\u01b0\u1edbc khi ph\u00e2n t\u00edch: <\/strong>Power Query \u0111\u01b0\u1ee3c sinh ra \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o nh\u01b0 x\u00f3a d\u00f2ng r\u00e1c, chu\u1ea9n h\u00f3a c\u1ed9t v\u00e0 \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u. N\u1ebfu d\u1eef li\u1ec7u ch\u01b0a s\u1ea1ch m\u00e0 vi\u1ebft DAX ngay, c\u00f4ng th\u1ee9c s\u1ebd ph\u1ee9c t\u1ea1p v\u00e0 kh\u00f3 ki\u1ec3m so\u00e1t k\u1ebft qu\u1ea3.<\/li>\n\n\n\n<li><strong>Thi\u1ebft k\u1ebf m\u00f4 h\u00ecnh d\u1eef li\u1ec7u tr\u01b0\u1edbc khi v\u1ebd bi\u1ec3u \u0111\u1ed3: <\/strong>Tr\u01b0\u1edbc khi k\u00e9o b\u1ea5t k\u1ef3 visual n\u00e0o, h\u00e3y x\u00e1c \u0111\u1ecbnh r\u00f5 b\u1ea3ng n\u00e0o l\u00e0 d\u1eef li\u1ec7u ch\u00ednh (fact) v\u00e0 b\u1ea3ng n\u00e0o l\u00e0 d\u1eef li\u1ec7u m\u00f4 t\u1ea3 (dimension). M\u00f4 h\u00ecnh t\u1ed1t gi\u00fap b\u00e1o c\u00e1o ch\u1ea1y nhanh v\u00e0 DAX d\u1ec5 vi\u1ebft h\u01a1n.<\/li>\n\n\n\n<li><strong>\u01afu ti\u00ean d\u00f9ng measure thay v\u00ec calculated column: <\/strong>Measure ch\u1ec9 \u0111\u01b0\u1ee3c t\u00ednh khi ng\u01b0\u1eddi d\u00f9ng xem b\u00e1o c\u00e1o n\u00ean linh ho\u1ea1t v\u00e0 nh\u1eb9 h\u01a1n. Calculated column ch\u1ec9 n\u00ean d\u00f9ng khi th\u1ef1c s\u1ef1 c\u1ea7n d\u1eef li\u1ec7u c\u1ed1 \u0111\u1ecbnh theo t\u1eebng d\u00f2ng.<\/li>\n\n\n\n<li><strong>\u0110\u1eb7t t\u00ean b\u1ea3ng v\u00e0 measure r\u00f5 r\u00e0ng ngay t\u1eeb \u0111\u1ea7u: <\/strong>T\u00ean d\u1ec5 hi\u1ec3u v\u00e0 c\u00f3 \u00fd ngh\u0129a s\u1ebd gi\u00fap b\u1ea1n sau n\u00e0y khi \u0111\u1ecdc l\u1ea1i b\u00e1o c\u00e1o s\u1ebd kh\u00f4ng b\u1ecb r\u1ed1i v\u00e0 c\u0169ng gi\u00fap ng\u01b0\u1eddi kh\u00e1c d\u1ec5 ti\u1ebfp nh\u1eadn khi d\u00f9ng chung file Power BI.<\/li>\n\n\n\n<li><strong>Kh\u00f4ng \u0111\u01b0a qu\u00e1 nhi\u1ec1u visual v\u00e0o m\u1ed9t trang: <\/strong>M\u1ed9t trang dashboard n\u00ean tr\u1ea3 l\u1eddi m\u1ed9t c\u00e2u h\u1ecfi ch\u00ednh v\u00e0 qu\u00e1 nhi\u1ec1u bi\u1ec3u \u0111\u1ed3 s\u1ebd l\u00e0m ng\u01b0\u1eddi xem kh\u00f3 n\u1eafm \u0111\u01b0\u1ee3c insight quan tr\u1ecdng.<\/li>\n\n\n\n<li><strong>S\u1eed d\u1ee5ng m\u00e0u s\u1eafc nh\u1ea5t qu\u00e1n trong to\u00e0n b\u1ed9 b\u00e1o c\u00e1o: <\/strong>N\u00ean d\u00f9ng m\u1ed9t theme m\u00e0u c\u1ed1 \u0111\u1ecbnh \u0111\u1ec3 b\u00e1o c\u00e1o tr\u00f4ng chuy\u00ean nghi\u1ec7p v\u00e0 tr\u00e1nh g\u00e2y nhi\u1ec5u th\u1ecb gi\u00e1c cho ng\u01b0\u1eddi xem.<\/li>\n\n\n\n<li><strong>Lu\u00f4n ki\u1ec3m tra ki\u1ec3u d\u1eef li\u1ec7u (data type): <\/strong>Vi\u1ec7c sai data type l\u00e0 nguy\u00ean nh\u00e2n ph\u1ed5 bi\u1ebfn khi\u1ebfn DAX t\u00ednh sai ho\u1eb7c kh\u00f4ng ch\u1ea1y \u0111\u01b0\u1ee3c, \u0111\u1eb7c bi\u1ec7t v\u1edbi c\u1ed9t ng\u00e0y th\u00e1ng v\u00e0 s\u1ed1.<\/li>\n\n\n\n<li><strong>Ki\u1ec3m tra b\u00e1o c\u00e1o v\u1edbi nhi\u1ec1u b\u1ed9 l\u1ecdc kh\u00e1c nhau: <\/strong>Tr\u01b0\u1edbc khi publish, h\u00e3y th\u1eed l\u1ecdc theo t\u1eebng th\u00e1ng, t\u1eebng s\u1ea3n ph\u1ea9m ho\u1eb7c t\u1eebng khu v\u1ef1c \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o s\u1ed1 li\u1ec7u lu\u00f4n \u0111\u00fang trong m\u1ecdi t\u00ecnh hu\u1ed1ng.<\/li>\n\n\n\n<li><strong>L\u01b0u phi\u00ean b\u1ea3n b\u00e1o c\u00e1o th\u01b0\u1eddng xuy\u00ean: <\/strong>Power BI ch\u01b0a c\u00f3 version control t\u00edch h\u1ee3p n\u00ean h\u00e3y l\u01b0u nhi\u1ec1u b\u1ea3n \u0111\u1ec3 d\u1ec5 quay l\u1ea1i khi ch\u1ec9nh s\u1eeda nh\u1ea7m.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-cau-h\u1ecfi-th\u01b0\u1eddng-g\u1eb7p-v\u1ec1-cach-s\u1eed-d\u1ee5ng-power-bi\"><span class=\"ez-toc-section\" id=\"Cau_hoi_thuong_gap_ve_cach_su_dung_Power_BI\"><\/span><strong>C\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng Power BI<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-power-bi-co-phu-h\u1ee3p-cho-big-data-khong\"><strong>Power BI c\u00f3 ph\u00f9 h\u1ee3p cho Big Data kh\u00f4ng?<\/strong><\/h3>\n\n\n\n<p>Power BI c\u00f3 th\u1ec3 l\u00e0m vi\u1ec7c v\u1edbi Big Data, tuy nhi\u00ean kh\u00f4ng \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 l\u01b0u tr\u1eef hay x\u1eed l\u00fd Big Data tr\u1ef1c ti\u1ebfp. Trong th\u1ef1c t\u1ebf, Power BI \u0111\u00f3ng vai tr\u00f2 l\u00e0 l\u1edbp ph\u00e2n t\u00edch v\u00e0 tr\u1ef1c quan h\u00f3a n\u1eb1m ph\u00eda tr\u00ean c\u00e1c h\u1ec7 th\u1ed1ng Big Data nh\u01b0 Data Warehouse, Data Lake, Azure Synapse, BigQuery hay Snowflake. Khi k\u1ebft h\u1ee3p v\u1edbi c\u00e1c n\u1ec1n t\u1ea3ng n\u00e0y th\u00f4ng qua Import mode ho\u1eb7c DirectQuery, Power BI c\u00f3 th\u1ec3 ph\u00e2n t\u00edch t\u1eadp d\u1eef li\u1ec7u r\u1ea5t l\u1edbn m\u00e0 v\u1eabn \u0111\u1ea3m b\u1ea3o hi\u1ec7u n\u0103ng. V\u00ec v\u1eady, Power BI ph\u00f9 h\u1ee3p \u0111\u1ec3 khai th\u00e1c v\u00e0 ph\u00e2n t\u00edch Big Data, ch\u1ee9 kh\u00f4ng thay th\u1ebf c\u00e1c h\u1ec7 th\u1ed1ng x\u1eed l\u00fd Big Data \u1edf t\u1ea7ng d\u1eef li\u1ec7u.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-power-bi-co-th\u1ec3-thay-th\u1ebf-excel-khong\"><strong>Power BI c\u00f3 th\u1ec3 thay th\u1ebf Excel kh\u00f4ng?<\/strong><\/h3>\n\n\n\n<p>Power BI kh\u00f4ng ho\u00e0n to\u00e0n thay th\u1ebf Excel m\u00e0 hai c\u00f4ng c\u1ee5 n\u00e0y b\u1ed5 tr\u1ee3 cho nhau. Excel m\u1ea1nh \u1edf vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u nh\u1ecf, thao t\u00e1c linh ho\u1ea1t v\u00e0 l\u00e0m vi\u1ec7c c\u00e1 nh\u00e2n. Trong khi \u0111\u00f3, Power BI ph\u00f9 h\u1ee3p h\u01a1n v\u1edbi d\u1eef li\u1ec7u l\u1edbn, b\u00e1o c\u00e1o \u0111\u1ed9ng, t\u1ef1 \u0111\u1ed9ng refresh v\u00e0 chia s\u1ebb trong doanh nghi\u1ec7p. Tr\u00ean th\u1ef1c t\u1ebf, nhi\u1ec1u t\u1ed5 ch\u1ee9c v\u1eabn s\u1eed d\u1ee5ng Excel \u0111\u1ec3 nh\u1eadp li\u1ec7u ho\u1eb7c x\u1eed l\u00fd ban \u0111\u1ea7u, sau \u0111\u00f3 d\u00f9ng Power BI \u0111\u1ec3 x\u00e2y d\u1ef1ng dashboard v\u00e0 b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p. V\u00ec v\u1eady, Power BI n\u00ean \u0111\u01b0\u1ee3c xem l\u00e0 b\u01b0\u1edbc n\u00e2ng c\u1ea5p c\u1ee7a Excel trong ph\u00e2n t\u00edch d\u1eef li\u1ec7u, ch\u1ee9 kh\u00f4ng ph\u1ea3i c\u00f4ng c\u1ee5 thay th\u1ebf tuy\u1ec7t \u0111\u1ed1i.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-power-bi-co-d\u1ec5-s\u1eed-d\u1ee5ng-khong\"><strong>Power BI c\u00f3 d\u1ec5 s\u1eed d\u1ee5ng kh\u00f4ng?<\/strong><\/h3>\n\n\n\n<p>Power BI \u0111\u01b0\u1ee3c \u0111\u00e1nh gi\u00e1 l\u00e0 kh\u00e1 d\u1ec5 ti\u1ebfp c\u1eadn \u0111\u1ed1i v\u1edbi ng\u01b0\u1eddi m\u1edbi h\u1ecdc. Giao di\u1ec7n k\u00e9o-th\u1ea3 tr\u1ef1c quan, nhi\u1ec1u thao t\u00e1c t\u01b0\u01a1ng t\u1ef1 Excel v\u00e0 h\u1ec7 th\u1ed1ng bi\u1ec3u \u0111\u1ed3 phong ph\u00fa gi\u00fap ng\u01b0\u1eddi d\u00f9ng nhanh ch\u00f3ng t\u1ea1o \u0111\u01b0\u1ee3c b\u00e1o c\u00e1o c\u01a1 b\u1ea3n ch\u1ec9 sau th\u1eddi gian ng\u1eafn l\u00e0m quen. Tuy nhi\u00ean, \u0111\u1ec3 x\u00e2y d\u1ef1ng c\u00e1c dashboard chuy\u00ean nghi\u1ec7p, t\u1ed1i \u01b0u hi\u1ec7u n\u0103ng v\u00e0 vi\u1ebft DAX \u0111\u00fang chu\u1ea9n, ng\u01b0\u1eddi d\u00f9ng v\u1eabn c\u1ea7n th\u1eddi gian h\u1ecdc t\u1eadp v\u00e0 th\u1ef1c h\u00e0nh. N\u00f3i c\u00e1ch kh\u00e1c, Power BI d\u1ec5 b\u1eaft \u0111\u1ea7u nh\u01b0ng c\u1ea7n r\u00e8n luy\u1ec7n \u0111\u1ec3 s\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-d\u1ec3-s\u1eed-d\u1ee5ng-power-bi-co-c\u1ea7n-bi\u1ebft-code-khong\"><strong>\u0110\u1ec3 s\u1eed d\u1ee5ng Power BI c\u00f3 c\u1ea7n bi\u1ebft code kh\u00f4ng?<\/strong><\/h3>\n\n\n\n<p>\u0110\u1ec3 s\u1eed d\u1ee5ng Power BI, ng\u01b0\u1eddi d\u00f9ng kh\u00f4ng b\u1eaft bu\u1ed9c ph\u1ea3i bi\u1ebft l\u1eadp tr\u00ecnh. C\u00e1c thao t\u00e1c c\u01a1 b\u1ea3n nh\u01b0 k\u1ebft n\u1ed1i d\u1eef li\u1ec7u, l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u v\u00e0 v\u1ebd bi\u1ec3u \u0111\u1ed3 \u0111\u1ec1u c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n th\u00f4ng qua giao di\u1ec7n. Tuy nhi\u00ean, khi l\u00e0m vi\u1ec7c \u1edf m\u1ee9c n\u00e2ng cao, ng\u01b0\u1eddi d\u00f9ng s\u1ebd ti\u1ebfp x\u00fac v\u1edbi ng\u00f4n ng\u1eef DAX v\u00e0 Power Query M. \u0110\u00e2y kh\u00f4ng ph\u1ea3i l\u00e0 l\u1eadp tr\u00ecnh truy\u1ec1n th\u1ed1ng m\u00e0 l\u00e0 ng\u00f4n ng\u1eef c\u00f4ng th\u1ee9c, t\u01b0\u01a1ng \u0111\u1ed1i d\u1ec5 ti\u1ebfp c\u1eadn \u0111\u1ed1i v\u1edbi ng\u01b0\u1eddi h\u1ecdc ph\u00e2n t\u00edch d\u1eef li\u1ec7u. V\u00ec v\u1eady, Power BI c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u00e0 kh\u00f4ng c\u1ea7n bi\u1ebft code, nh\u01b0ng hi\u1ec3u c\u00f4ng th\u1ee9c v\u00e0 logic s\u1ebd gi\u00fap b\u1ea1n khai th\u00e1c c\u00f4ng c\u1ee5 hi\u1ec7u qu\u1ea3 h\u01a1n r\u1ea5t nhi\u1ec1u.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-t\u1ed5ng-k\u1ebft\"><span class=\"ez-toc-section\" id=\"Tong_ket\"><\/span><strong>T\u1ed5ng k\u1ebft<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Power BI kh\u00f4ng ch\u1ec9 l\u00e0 c\u00f4ng c\u1ee5 v\u1ebd bi\u1ec3u \u0111\u1ed3 m\u00e0 c\u00f2n l\u00e0 m\u1ed9t n\u1ec1n t\u1ea3ng ph\u00e2n t\u00edch d\u1eef li\u1ec7u ho\u00e0n ch\u1ec9nh, k\u1ebft h\u1ee3p gi\u1eefa x\u1eed l\u00fd d\u1eef li\u1ec7u, m\u00f4 h\u00ecnh h\u00f3a v\u00e0 ph\u00e2n t\u00edch \u0111\u1ed9ng. Khi hi\u1ec3u r\u00f5 vai tr\u00f2 c\u1ee7a Power Query, DAX v\u00e0 Power BI Service, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 x\u00e2y d\u1ef1ng c\u00e1c b\u00e1o c\u00e1o ch\u00ednh x\u00e1c, d\u1ec5 m\u1edf r\u1ed9ng v\u00e0 ph\u00f9 h\u1ee3p v\u1edbi nhu c\u1ea7u doanh nghi\u1ec7p. ITviec hy v\u1ecdng b\u00e0i vi\u1ebft tr\u00ean \u0111\u00e3 cung c\u1ea5p cho b\u1ea1n c\u00e1i nh\u00ecn t\u1ed5ng quan v\u1ec1 nh\u1eefng kh\u1ea3 n\u0103ng v\u00e0 \u201cti\u1ec1m n\u0103ng\u201d c\u1ee7a Power BI.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Power BI \u0111ang tr\u1edf th\u00e0nh m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 ph\u00e2n t\u00edch d\u1eef li\u1ec7u ph\u1ed5 bi\u1ebfn nh\u1ea5t hi\u1ec7n nay, gi\u00fap doanh nghi\u1ec7p v\u00e0 c\u00e1 nh\u00e2n d\u1ec5 d\u00e0ng bi\u1ebfn d\u1eef li\u1ec7u th\u00f4 th\u00e0nh nh\u1eefng b\u00e1o c\u00e1o tr\u1ef1c quan, d\u1ec5 hi\u1ec3u. V\u00ec v\u1eady, b\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u00fap b\u1ea1n n\u1eafm \u0111\u01b0\u1ee3c c\u00e1ch s\u1eed d\u1ee5ng Power BI t\u1eeb [&hellip;]<\/p>\n","protected":false},"author":209,"featured_media":95611,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_gspb_post_css":"","footnotes":""},"categories":[109],"tags":[],"class_list":["post-95610","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-chuyen-mon-it"],"blocksy_meta":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.8 (Yoast SEO v27.8) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>C\u00e1ch s\u1eed d\u1ee5ng Power BI hi\u1ec7u qu\u1ea3 v\u00e0 c\u00e1c best practices c\u1ea7n bi\u1ebft - ITviec Blog<\/title>\n<meta name=\"description\" content=\"C\u00e1ch s\u1eed d\u1ee5ng Power BI t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao: h\u01b0\u1edbng d\u1eabn t\u1ea1o b\u00e1o c\u00e1o, tr\u1ef1c quan h\u00f3a d\u1eef li\u1ec7u, k\u1ebft n\u1ed1i ngu\u1ed3n d\u1eef li\u1ec7u v\u00e0 ph\u00e2n t\u00edch hi\u1ec7u qu\u1ea3.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/itviec.com\/blog\/cach-su-dung-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch s\u1eed d\u1ee5ng Power BI hi\u1ec7u qu\u1ea3 v\u00e0 c\u00e1c best practices c\u1ea7n bi\u1ebft\" \/>\n<meta property=\"og:description\" content=\"Power BI \u0111ang tr\u1edf th\u00e0nh m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 ph\u00e2n t\u00edch d\u1eef li\u1ec7u ph\u1ed5 bi\u1ebfn nh\u1ea5t hi\u1ec7n nay, gi\u00fap doanh nghi\u1ec7p v\u00e0 c\u00e1 nh\u00e2n d\u1ec5 d\u00e0ng bi\u1ebfn d\u1eef li\u1ec7u th\u00f4 th\u00e0nh\" \/>\n<meta property=\"og:url\" content=\"https:\/\/itviec.com\/blog\/cach-su-dung-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"ITviec Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ITviec\" \/>\n<meta property=\"article:published_time\" content=\"2026-04-18T15:16:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-04-18T15:16:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/itviec.com\/blog\/wp-content\/uploads\/2026\/04\/2-scaled.png\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"421\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"M\u1ef9 Duy\u00ean\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ITviec\" \/>\n<meta name=\"twitter:site\" content=\"@ITviec\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"M\u1ef9 Duy\u00ean\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"28 ph\u00fat\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00e1ch s\u1eed d\u1ee5ng Power BI hi\u1ec7u qu\u1ea3 v\u00e0 c\u00e1c best practices c\u1ea7n bi\u1ebft - ITviec Blog","description":"C\u00e1ch s\u1eed d\u1ee5ng Power BI t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao: h\u01b0\u1edbng d\u1eabn t\u1ea1o b\u00e1o c\u00e1o, tr\u1ef1c quan h\u00f3a d\u1eef li\u1ec7u, k\u1ebft n\u1ed1i ngu\u1ed3n d\u1eef li\u1ec7u v\u00e0 ph\u00e2n t\u00edch hi\u1ec7u qu\u1ea3.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/itviec.com\/blog\/cach-su-dung-power-bi\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch s\u1eed d\u1ee5ng Power BI hi\u1ec7u qu\u1ea3 v\u00e0 c\u00e1c best practices c\u1ea7n bi\u1ebft","og_description":"Power BI \u0111ang tr\u1edf th\u00e0nh m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 ph\u00e2n t\u00edch d\u1eef li\u1ec7u ph\u1ed5 bi\u1ebfn nh\u1ea5t hi\u1ec7n nay, gi\u00fap doanh nghi\u1ec7p v\u00e0 c\u00e1 nh\u00e2n d\u1ec5 d\u00e0ng bi\u1ebfn d\u1eef li\u1ec7u th\u00f4 th\u00e0nh","og_url":"https:\/\/itviec.com\/blog\/cach-su-dung-power-bi\/","og_site_name":"ITviec Blog","article_publisher":"https:\/\/www.facebook.com\/ITviec","article_published_time":"2026-04-18T15:16:24+00:00","article_modified_time":"2026-04-18T15:16:25+00:00","og_image":[{"width":800,"height":421,"url":"https:\/\/itviec.com\/blog\/wp-content\/uploads\/2026\/04\/2-scaled.png","type":"image\/png"}],"author":"M\u1ef9 Duy\u00ean","twitter_card":"summary_large_image","twitter_creator":"@ITviec","twitter_site":"@ITviec","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"M\u1ef9 Duy\u00ean","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"28 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/itviec.com\/blog\/cach-su-dung-power-bi\/#article","isPartOf":{"@id":"https:\/\/itviec.com\/blog\/cach-su-dung-power-bi\/"},"author":{"name":"M\u1ef9 Duy\u00ean","@id":"https:\/\/itviec.com\/blog\/#\/schema\/person\/73733c0725c7e39e696a896bd1abe2d7"},"headline":"C\u00e1ch s\u1eed d\u1ee5ng Power BI hi\u1ec7u qu\u1ea3 v\u00e0 c\u00e1c best practices c\u1ea7n bi\u1ebft","datePublished":"2026-04-18T15:16:24+00:00","dateModified":"2026-04-18T15:16:25+00:00","mainEntityOfPage":{"@id":"https:\/\/itviec.com\/blog\/cach-su-dung-power-bi\/"},"wordCount":7514,"publisher":{"@id":"https:\/\/itviec.com\/blog\/#organization"},"image":{"@id":"https:\/\/itviec.com\/blog\/cach-su-dung-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/itviec.com\/blog\/wp-content\/uploads\/2026\/04\/2-scaled.png","articleSection":["Chuy\u00ean m\u00f4n IT"],"inLanguage":"vi"},{"@type":"WebPage","@id":"https:\/\/itviec.com\/blog\/cach-su-dung-power-bi\/","url":"https:\/\/itviec.com\/blog\/cach-su-dung-power-bi\/","name":"C\u00e1ch s\u1eed d\u1ee5ng Power BI hi\u1ec7u qu\u1ea3 v\u00e0 c\u00e1c best practices c\u1ea7n bi\u1ebft - ITviec Blog","isPartOf":{"@id":"https:\/\/itviec.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/itviec.com\/blog\/cach-su-dung-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/itviec.com\/blog\/cach-su-dung-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/itviec.com\/blog\/wp-content\/uploads\/2026\/04\/2-scaled.png","datePublished":"2026-04-18T15:16:24+00:00","dateModified":"2026-04-18T15:16:25+00:00","description":"C\u00e1ch s\u1eed d\u1ee5ng Power BI t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao: h\u01b0\u1edbng d\u1eabn t\u1ea1o b\u00e1o c\u00e1o, tr\u1ef1c quan h\u00f3a d\u1eef li\u1ec7u, k\u1ebft n\u1ed1i ngu\u1ed3n d\u1eef li\u1ec7u v\u00e0 ph\u00e2n t\u00edch hi\u1ec7u qu\u1ea3.","breadcrumb":{"@id":"https:\/\/itviec.com\/blog\/cach-su-dung-power-bi\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/itviec.com\/blog\/cach-su-dung-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/itviec.com\/blog\/cach-su-dung-power-bi\/#primaryimage","url":"https:\/\/itviec.com\/blog\/wp-content\/uploads\/2026\/04\/2-scaled.png","contentUrl":"https:\/\/itviec.com\/blog\/wp-content\/uploads\/2026\/04\/2-scaled.png","width":800,"height":421,"caption":"c\u00e1ch s\u1eed d\u1ee5ng power bi - ITviec Blog"},{"@type":"BreadcrumbList","@id":"https:\/\/itviec.com\/blog\/cach-su-dung-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Chuy\u00ean m\u00f4n IT","item":"https:\/\/itviec.com\/blog\/chuyen-mon-it\/"},{"@type":"ListItem","position":2,"name":"C\u00e1ch s\u1eed d\u1ee5ng Power BI hi\u1ec7u qu\u1ea3 v\u00e0 c\u00e1c best practices c\u1ea7n bi\u1ebft"}]},{"@type":"WebSite","@id":"https:\/\/itviec.com\/blog\/#website","url":"https:\/\/itviec.com\/blog\/","name":"ITviec Blog","description":"IT Jobs &amp; People in Vietnam","publisher":{"@id":"https:\/\/itviec.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/itviec.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/itviec.com\/blog\/#organization","name":"ITviec","url":"https:\/\/itviec.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/itviec.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/itviec.com\/blog\/wp-content\/uploads\/2018\/12\/itviec-black-square-facebook.png","contentUrl":"https:\/\/itviec.com\/blog\/wp-content\/uploads\/2018\/12\/itviec-black-square-facebook.png","width":1800,"height":1800,"caption":"ITviec"},"image":{"@id":"https:\/\/itviec.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ITviec","https:\/\/x.com\/ITviec","https:\/\/www.linkedin.com\/company\/itviec","https:\/\/www.youtube.com\/channel\/UCYthAQ3bcGr57M_ag5gHDvQ"]},{"@type":"Person","@id":"https:\/\/itviec.com\/blog\/#\/schema\/person\/73733c0725c7e39e696a896bd1abe2d7","name":"M\u1ef9 Duy\u00ean","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/itviec.com\/blog\/wp-content\/uploads\/2024\/03\/Author_Duyen-Tran-120x120.jpg","url":"https:\/\/itviec.com\/blog\/wp-content\/uploads\/2024\/03\/Author_Duyen-Tran-120x120.jpg","contentUrl":"https:\/\/itviec.com\/blog\/wp-content\/uploads\/2024\/03\/Author_Duyen-Tran-120x120.jpg","caption":"M\u1ef9 Duy\u00ean"},"url":"https:\/\/itviec.com\/blog\/author\/my-duyen\/"}]}},"_links":{"self":[{"href":"https:\/\/itviec.com\/blog\/wp-json\/wp\/v2\/posts\/95610","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itviec.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itviec.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itviec.com\/blog\/wp-json\/wp\/v2\/users\/209"}],"replies":[{"embeddable":true,"href":"https:\/\/itviec.com\/blog\/wp-json\/wp\/v2\/comments?post=95610"}],"version-history":[{"count":2,"href":"https:\/\/itviec.com\/blog\/wp-json\/wp\/v2\/posts\/95610\/revisions"}],"predecessor-version":[{"id":95690,"href":"https:\/\/itviec.com\/blog\/wp-json\/wp\/v2\/posts\/95610\/revisions\/95690"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/itviec.com\/blog\/wp-json\/wp\/v2\/media\/95611"}],"wp:attachment":[{"href":"https:\/\/itviec.com\/blog\/wp-json\/wp\/v2\/media?parent=95610"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itviec.com\/blog\/wp-json\/wp\/v2\/categories?post=95610"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itviec.com\/blog\/wp-json\/wp\/v2\/tags?post=95610"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}