Advanced Power Query

{"id":3656600,"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:\/\/vananh28.id.vn\/datafiles\/86338\/upload\/images\/san-pham\/khoahoc-19.jpg?t=1753113029","image_thumb_url":"https:\/\/vananh28.id.vn\/datafiles\/86338\/upload\/thumb_images\/san-pham\/khoahoc-19.jpg?t=1753113008","tags":["Computer Science","Advanced Power Query"],"count_view":194,"seo_name":"advanced-power-query","date_update":"1768878248","date_created_format":"","meta_title":"","meta_desc":"","meta_keyword":"","sku":"","code":"","rate":5,"image_2_url":"https:\/\/vananh28.id.vn\/datafiles\/86338\/upload\/images\/san-pham\/khoahoc-5.jpg","image_2_thumb_url":"https:\/\/vananh28.id.vn\/datafiles\/86338\/upload\/\/thumb_images\/san-pham\/khoahoc-5.jpg","image_list":[{"image_url":"https:\/\/vananh28.id.vn\/datafiles\/86338\/upload\/images\/san-pham\/khoahoc-19.jpg","image_thumb_url":"https:\/\/vananh28.id.vn\/datafiles\/86338\/upload\/\/thumb_images\/san-pham\/khoahoc-19.jpg"},{"image_url":"https:\/\/vananh28.id.vn\/datafiles\/86338\/upload\/images\/san-pham\/khoahoc-5.jpg","image_thumb_url":"https:\/\/vananh28.id.vn\/datafiles\/86338\/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:\/\/vananh28.id.vn\/datafiles\/86338\/upload\/images\/san-pham\/khoahoc-19.jpg","config_panorama":[],"brand_name":"","qr_code":"https:\/\/vananh28.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:\/\/vananh28.id.vn\/datafiles\/86338\/upload\/files\/z7376018676361_d2e74ad5deefbfa4757192a3c570a772.jpg?t=1766978815","company_name":"NGÔ THỊ VÂN ANH","company_email":"vananhngothi2812@gmail.com","company_phone":"0889276581","company_address":"Hà Tĩnh","company_fax":"Ngô Thị Vân Anh","date_now":1777453303,"company_tags":[],"search_keyword":null,"facebook_comment":"https:\/\/vananh28.id.vn\/advanced-power-query","breadscrumb":[{"url":"https:\/\/vananh28.id.vn","name":"Trang chủ","icon":"","active":false},{"url":"https:\/\/vananh28.id.vn\/san-pham","name":"Sản phẩm","icon":"","active":false},{"url":"https:\/\/vananh28.id.vn\/office-information-technology","name":"Office Information Technology","icon":"","active":true}],"list_products_tmp":[],"list_section":[{"id":714678,"name":"SECTION-103217","seo_name":"#w30s-section-714678","url":"#w30s-section-714678"},{"id":714677,"name":"SECTION-103217","seo_name":"#w30s-section-714677","url":"#w30s-section-714677"},{"id":714675,"name":"SECTION-80700","seo_name":"#w30s-section-714675","url":"#w30s-section-714675"},{"id":714676,"name":"SECTION-78159","seo_name":"#w30s-section-714676","url":"#w30s-section-714676"},{"id":714673,"name":"Liên hệ","seo_name":"#w30s-section-714673","url":"#w30s-section-714673"}],"type_page":4,"id_page":507745,"widget_16217716":{"content_data":{"content":"Button"}},"widget_16217721":{"content_data":[{"id":122272,"title":"American","code":"us","is_expires":false,"is_active":0},{"id":122271,"title":"Tiếng Việt","code":"vn","is_expires":false,"is_active":1}]},"widget_16217728":{"content_data":{"content":""}},"widget_16217727":{"content_data":{"content":"quy chế hoạt động"}},"widget_16217702":{"content_data":{"content":"Bạn cần chúng tôi giúp đỡ?"}},"widget_16217705":{"content_data":{"content":"Địa chỉ:&nbsp;"}},"widget_16217708":{"content_data":{"content":"Email:"}},"widget_16217711":{"content_data":{"content":"Số điện thoại"}},"widget_16217703":{"content_data":{"content":"Hãy liên hệ với chúng tôi&nbsp;"}},"widget_16217714":{"content_data":{"content":"Thiết Kế Website bởi P.A Việt Nam <\/span>"}},"title_page":"Sản phẩm","relate_object_id":3656600}