Advanced Power Query

{"id":3653203,"name":"Advanced Power Query","desc":"Power Query in Microsoft Excel and Power BI have become indispensable tools, helping users transform data from many different sources quickly and flexibly.<\/p>\n","content":"<h3>Why learn Advanced Power Query?<\/font><\/font><\/strong><\/h3>\n\nWhile basic Power Query is powerful, to really turn raw data into valuable information, you need to overcome the following challenges:<\/font><\/font><\/p>\n\n<ul>\n\t<li>\n\tComplex and heterogeneous data:<\/font><\/font><\/b> Handle CSV, Excel files with messy structures, fragmented data, or need to combine from different sources with mismatched formats.<\/font><\/font><\/p>\n\t<\/li>\n\t<li>\n\tOptimize performance:<\/font><\/font><\/b> When working with large amounts of data, it is important to know how to write efficient queries to avoid slowdowns and crashes.<\/font><\/font><\/p>\n\t<\/li>\n\t<li>\n\tDeeper automation:<\/font><\/font><\/b> Desire to create custom functions, parameterize queries for reuse and reduce manual effort.<\/font><\/font><\/p>\n\t<\/li>\n\t<li>\n\tDeep understanding of the M language:<\/font><\/font><\/b> This is the &quot;heart&quot; of Power Query, allowing you to refine, debug, and write more complex commands that the user interface cannot accommodate.<\/font><\/font><\/p>\n\t<\/li>\n\t<li>\n\tConnect to diverse data sources:<\/font><\/font><\/b> Master how to connect and convert data from database systems (SQL Server, Access), web API, directories...<\/font><\/font><\/p>\n\t<\/li>\n<\/ul>\n\n<hr \/>\nMain content of the Advanced Power Query course<\/font><\/font><\/p>\n\nThis course will delve into more complex topics, making you an expert in data preprocessing:<\/font><\/font><\/p>\n\n<ol start=\"1\">\n\t<li>\n\tReview and improve basic transformations:<\/font><\/font><\/b><\/p>\n\n\t<ul>\n\t\t<li>\n\t\tOptimize common transformation steps: Split Columns, Merge Columns, Unpivot Columns, Pivot Columns.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tUse advanced conditions (Conditional Columns) and complex Text, Number, Date\/Time functions.<\/font><\/font><\/p>\n\t\t<\/li>\n\t<\/ul>\n\t<\/li>\n\t<li>\n\tWorking with M Language:<\/font><\/font><\/b><\/p>\n\n\t<ul>\n\t\t<li>\n\t\tUnderstand the structure and syntax of the M language.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tWrite M queries directly in the Advanced Editor.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tDebugging and error handling in M code.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tUse advanced and custom M functions.<\/font><\/font><\/p>\n\t\t<\/li>\n\t<\/ul>\n\t<\/li>\n\t<li>\n\tConnect and transform data from multiple complex sources:<\/font><\/font><\/b><\/p>\n\n\t<ul>\n\t\t<li>\n\t\tFolder:<\/font><\/font><\/b> Combine hundreds of Excel\/CSV files in one folder automatically.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tWeb Data:<\/font><\/font><\/b> Extract data from websites (Web Scraping) using HTML tables or API.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tDatabase:<\/font><\/font><\/b> Optimize connection and query data from SQL Server, Access.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tData Flows (in Power BI Service):<\/font><\/font><\/b> Introduction to preparing data in the cloud.<\/font><\/font><\/p>\n\t\t<\/li>\n\t<\/ul>\n\t<\/li>\n\t<li>\n\tParameters &amp; Custom Functions:<\/font><\/font><\/b><\/p>\n\n\t<ul>\n\t\t<li>\n\t\tCreate and use parameters to make queries more flexible (e.g. change file path, report year).<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tBuild custom M functions to reuse complex transformation logic, saving time and ensuring consistency.<\/font><\/font><\/p>\n\t\t<\/li>\n\t<\/ul>\n\t<\/li>\n\t<li>\n\tAdvanced techniques in data transformation:<\/font><\/font><\/b><\/p>\n\n\t<ul>\n\t\t<li>\n\t\tAdvanced Group By:<\/font><\/font><\/b> Group data with multiple aggregation operations.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tAdvanced Merge &amp; Append:<\/font><\/font><\/b> Merge types (Full Outer, Left Anti, Right Anti) and complex Append cases.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tBuffer Tables\/Lists:<\/font><\/font><\/b> Optimize performance when working with large amounts of data.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tHandling Errors and Exceptions:<\/font><\/font><\/b> Error Handling Techniques in Power Query.<\/font><\/font><\/p>\n\t\t<\/li>\n\t<\/ul>\n\t<\/li>\n\t<li>\n\tPerformance optimization and query management:<\/font><\/font><\/b><\/p>\n\n\t<ul>\n\t\t<li>\n\t\tPractice tips and tricks to speed up Power Query processing.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tManage queries and query groups in an organized manner.<\/font><\/font><\/p>\n\t\t<\/li>\n\t\t<li>\n\t\tIntroduction to <\/font><\/font>Query Folding<\/font><\/font><\/b> and its impact on performance.<\/font><\/font><\/p>\n\t\t<\/li>\n\t<\/ul>\n\t<\/li>\n<\/ol>\n\n<hr \/>\nWho should take this course?<\/font><\/font><\/p>\n\nThe Advanced Power Query course is suitable for:<\/font><\/font><\/p>\n\n<ul>\n\t<li>\n\tData Analyst:<\/font><\/font><\/b> Want to prepare data more effectively for reports and Dashboards.<\/font><\/font><\/p>\n\t<\/li>\n\t<li>\n\tAccounting, Finance Specialist:<\/font><\/font><\/b> Need to automate data aggregation from multiple tables and files.<\/font><\/font><\/p>\n\t<\/li>\n\t<li>\n\tHR, Marketing Specialist:<\/font><\/font><\/b> Want to clean and prepare customer data, survey data.<\/font><\/font><\/p>\n\t<\/li>\n\t<li>\n\tAnyone who already knows basic Power Query:<\/font><\/font><\/b> And wants to deepen their knowledge, master this tool to improve work productivity.<\/font><\/font><\/p>\n\t<\/li>\n<\/ul>\n","image_url":"https:\/\/www.donghuuhung.id.vn\/datafiles\/74640\/upload\/images\/san-pham\/khoahoc-19.jpg?t=1753113029","image_thumb_url":"https:\/\/www.donghuuhung.id.vn\/datafiles\/74640\/upload\/thumb_images\/san-pham\/khoahoc-19.jpg?t=1753113008","tags":["Computer Science","Advanced Power Query"],"count_view":196,"seo_name":"advanced-power-query","date_update":"1766979369","date_created_format":"","meta_title":"","meta_desc":"","meta_keyword":"","sku":"","code":"","rate":5,"image_2_url":"https:\/\/www.donghuuhung.id.vn\/datafiles\/74640\/upload\/images\/san-pham\/khoahoc-5.jpg","image_2_thumb_url":"https:\/\/www.donghuuhung.id.vn\/datafiles\/74640\/upload\/\/thumb_images\/san-pham\/khoahoc-5.jpg","image_list":[{"image_url":"https:\/\/www.donghuuhung.id.vn\/datafiles\/74640\/upload\/images\/san-pham\/khoahoc-19.jpg","image_thumb_url":"https:\/\/www.donghuuhung.id.vn\/datafiles\/74640\/upload\/\/thumb_images\/san-pham\/khoahoc-19.jpg"},{"image_url":"https:\/\/www.donghuuhung.id.vn\/datafiles\/74640\/upload\/images\/san-pham\/khoahoc-5.jpg","image_thumb_url":"https:\/\/www.donghuuhung.id.vn\/datafiles\/74640\/upload\/\/thumb_images\/san-pham\/khoahoc-5.jpg"}],"product_articles":[],"total_point_review":0,"link_youtube":"https:\/\/www.youtube.com\/embed\/","video_url":"","booking_url":"javascript:void(0)","file_url":"https:\/\/www.donghuuhung.id.vn\/datafiles\/74640\/upload\/images\/san-pham\/khoahoc-19.jpg","config_panorama":[],"brand_name":"","qr_code":"https:\/\/www.donghuuhung.id.vn\/advanced-power-query","promotion_name":"","status_inventory_value":1,"status_inventory":"Còn hàng","price":false,"price_final":"9.900.000 đ","percent_discount":false,"price_discount":false,"company_logo":"https:\/\/www.donghuuhung.id.vn\/datafiles\/74640\/upload\/files\/IMG_3209.JPG?t=1770824337","company_name":"Đổng Hữu Hưng","company_email":"hungdh050995@tvu-onschool.edu.vn","company_phone":"0987081664","company_address":"Ấp Chợ, Xã Nhơn Trạch, Tỉnh Đồng Nai.","company_fax":"","date_now":1777785003,"company_tags":[],"search_keyword":null,"facebook_comment":"https:\/\/www.donghuuhung.id.vn\/advanced-power-query","breadscrumb":[{"url":"https:\/\/www.donghuuhung.id.vn","name":"Trang chủ","icon":"","active":false},{"url":"https:\/\/www.donghuuhung.id.vn\/san-pham","name":"Sản phẩm","icon":"","active":false},{"url":"https:\/\/www.donghuuhung.id.vn\/office-information-technology","name":"Office Information Technology","icon":"","active":true}],"list_products_tmp":[],"list_section":[{"id":718532,"name":"Header","seo_name":"#w30s-section-718532","url":"#w30s-section-718532"},{"id":718533,"name":"Header","seo_name":"#w30s-section-718533","url":"#w30s-section-718533"},{"id":718534,"name":"Footer","seo_name":"#w30s-section-718534","url":"#w30s-section-718534"}],"type_page":4,"id_page":510232,"widget_16286848":{"content_data":{"content":"Eric Đổng Hữu Hưng"}},"widget_16286850":{"content_data":{"content":"Liên hệ ngay"}},"widget_16286854":{"content_data":{"content":"John Thompson\n"}},"widget_16286856":{"content_data":{"content":"Liên hệ ngay"}},"widget_16286862":{"content_data":{"content":"Thông tin"}},"widget_16286863":{"content_data":{"content":"Eric - Đổng Hữu Hưng"}},"widget_16286844":{"content_data":{"content":"Sản phẩm của"}},"widget_16286846":{"content_data":{"content":"Cung cấp bởi P.A Việt Nam"}},"title_page":"Sản phẩm","relate_object_id":3653203}

EricĐổng Hữu Hưng

John Thompson

Đổng Hữu Hưng

Thông tin

Eric - Đổng Hữu Hưng

Eric
Đổng Hữu Hưng