Advanced Power Query

{"id":3621166,"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.phamquoclinh.id.vn\/datafiles\/70906\/upload\/images\/san-pham\/khoahoc-19.jpg?t=1753113029","image_thumb_url":"https:\/\/www.phamquoclinh.id.vn\/datafiles\/70906\/upload\/thumb_images\/san-pham\/khoahoc-19.jpg?t=1753113008","tags":["Computer Science","Advanced Power Query"],"count_view":107,"seo_name":"advanced-power-query","date_update":"1757401747","date_created_format":"","meta_title":"","meta_desc":"","meta_keyword":"","sku":"","code":"","rate":5,"image_2_url":"https:\/\/www.phamquoclinh.id.vn\/datafiles\/70906\/upload\/images\/san-pham\/khoahoc-5.jpg","image_2_thumb_url":"https:\/\/www.phamquoclinh.id.vn\/datafiles\/70906\/upload\/\/thumb_images\/san-pham\/khoahoc-5.jpg","image_list":[{"image_url":"https:\/\/www.phamquoclinh.id.vn\/datafiles\/70906\/upload\/images\/san-pham\/khoahoc-19.jpg","image_thumb_url":"https:\/\/www.phamquoclinh.id.vn\/datafiles\/70906\/upload\/\/thumb_images\/san-pham\/khoahoc-19.jpg"},{"image_url":"https:\/\/www.phamquoclinh.id.vn\/datafiles\/70906\/upload\/images\/san-pham\/khoahoc-5.jpg","image_thumb_url":"https:\/\/www.phamquoclinh.id.vn\/datafiles\/70906\/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.phamquoclinh.id.vn\/datafiles\/70906\/upload\/images\/san-pham\/khoahoc-19.jpg","config_panorama":[],"brand_name":"","qr_code":"https:\/\/www.phamquoclinh.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.phamquoclinh.id.vn\/datafiles\/70906\/upload\/your-logo.png","company_name":"Phạm Quốc Lịnh","company_email":"phamthigiaan.2024@gmail.com","company_phone":"","company_address":"","company_fax":"","date_now":1781947881,"company_tags":[],"search_keyword":null,"facebook_comment":"https:\/\/www.phamquoclinh.id.vn\/advanced-power-query","breadscrumb":[{"url":"https:\/\/www.phamquoclinh.id.vn","name":"Trang chủ","icon":"","active":false},{"url":"https:\/\/www.phamquoclinh.id.vn\/san-pham","name":"Sản phẩm","icon":"","active":false},{"url":"https:\/\/www.phamquoclinh.id.vn\/office-information-technology","name":"Office Information Technology","icon":"","active":true}],"list_products_tmp":[],"list_section":[{"id":741658,"name":"Header","seo_name":"#w30s-section-741658","url":"#w30s-section-741658"},{"id":741659,"name":"Header","seo_name":"#w30s-section-741659","url":"#w30s-section-741659"},{"id":741660,"name":"Footer","seo_name":"#w30s-section-741660","url":"#w30s-section-741660"}],"type_page":4,"id_page":531870,"widget_16684561":{"content_data":{"content":"Phạm Quốc Lịnh"}},"widget_16684567":{"content_data":{"content":"Phạm Quốc Lịnh"}},"widget_16684575":{"content_data":{"content":"Thông tin"}},"widget_16684576":{"content_data":{"content":"Phạm Quốc Lịnh&nbsp; "}},"title_page":"Sản phẩm","relate_object_id":3621166}