Power Query for Excel and Power BI (Introductory Level)

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

Power Query, also known as “Get & Transform”, is an amazing piece of ETL technology built into Excel 2016 and Power BI Desktop, and is available as a free add-in for Excel 2013 and 2010. It allows you to Extract data from a vast array of sources, Transform it more quickly and easily than you ever thought possible, and then Load it directly into a table or your data model.

If you need to learn one new tool today, Power Query is it! Power Query for Excel and Power BI is an introductory excerpt from our full course, Power Query Academy. In this course, we will introduce you to the magic of Power Query and how it will transform the way you work with data forever.

Ken Puls and Miguel Escobar, both top Power Query experts, will guide you as you learn about this powerful tool. They will walk you through how Power Query works, connecting to basic data sources, performing simple transformation techniques, combining data from multiple sources), and loading the prepared data in Microsoft Excel and Power BI Desktop.


Who this course is for:

  • Excel Users who work with Data Cleansing or Data Transformation
  • Power BI Desktop users
  • Anyone who works with Data or does Data Wrangling to any extent
  • Anyone who has ever used VLOOKUP or tried to consolidate Data in Excel

Course content

6 sections • 20 lectures • 2h 6m total length
  • Introduction Handout
    00:04

Instructors

Data Monkey @ PowerQuery.Training
  • 4.3 Instructor Rating
  • 141 Reviews
  • 554 Students
  • 1 Course

Panamanian consultant and an Excel specialist become a BI specialist using the latest Microsoft tools for BI: Power BI. He is the co-author of 'M is for Data Monkey' and 'Magic Tricks for Data Wizards', blogger and also Youtuber of tricks for Excel.

He is the Managing Director and Lead Consultant for Powered Solutions and one of the founders of the Power Query Training project which is the # 1 worldwide site for Power Query related resources.

He has been recognized as a Microsoft Most Valuable Professional (MVP), is a Microsoft Certified Professional (MCP - MCSA: BI Reporting), a Microsoft Certified Trainer (MCT), and is one of the international pioneers in Power Pivot, Power Query and Power BI.

Excel and Power BI Trainer and Consultant
  • 4.3 Instructor Rating
  • 141 Reviews
  • 554 Students
  • 1 Course

Ken Puls, FCPA, FCMA is a Chartered Professional Accountant, blogger, author and trainer with over 20 years of business and financial modelling experience. His passion lies in exploring tools to turn data into information, and teaching others how to benefit from them. To that end, Ken founded Excelguru Consulting Inc, a company focused on bringing Excel and Power BI training to the masses.

He has held the Microsoft MVP distinction since 2006, has been recognized as a Fellow of his accounting organization and as one of the “Top 20 under 40” business & community leaders on Vancouver Island.

Expected Outcomes

  1. Clear understanding of what Power Query is and what it's designed for Connect to simple Data Sources and create simple transformation solutions Modify and re-purpose existing Power Query solutions Consolidate and/or Merge Data from Multiple Sources Requirements You can use any version of Power Query (aka Get & Transform) inside Excel (Excel 2010 or later) or even inside Power BI Desktop No prior knowledge of Power BI, Excel formulas or functions is required Description Power Query, also known as “Get & Transform”, is an amazing piece of ETL technology built into Excel 2016 and Power BI Desktop, and is available as a free add-in for Excel 2013 and 2010. It allows you to Extract data from a vast array of sources, Transform it more quickly and easily than you ever thought possible, and then Load it directly into a table or your data model. If you need to learn one new tool today, Power Query is it! Power Query for Excel and Power BI is an introductory excerpt from our full course, Power Query Academy. In this course, we will introduce you to the magic of Power Query and how it will transform the way you work with data forever. Ken Puls and Miguel Escobar, both top Power Query experts, will guide you as you learn about this powerful tool. They will walk you through how Power Query works, connecting to basic data sources, performing simple transformation techniques, combining data from multiple sources), and loading the prepared data in Microsoft Excel and Power BI Desktop. Who this course is for: Excel Users who work with Data Cleansing or Data Transformation Power BI Desktop users Anyone who works with Data or does Data Wrangling to any extent Anyone who has ever used VLOOKUP or tried to consolidate Data in Excel Show more Show less Course content 6 sections • 20 lectures • 2h 6m total length Expand all sections Introduction 3 lectures • 15min What is Power Query? Preview 06:21 Versions of Power Query Preview 08:07 Introduction Handout 00:04 Importing Basic Data 4 lectures • 34min Sample Files and Documents 00:05 Connecting to Delimited Flat Files 11:48 Connecting to Data in Excel Workbooks 08:07 Connecting to Non-Delimited Flat Files 14:29 Query Settings 5 lectures • 38min Sample Files and Documents 00:05 Step Settings 04:02 Choosing Query Load Destinations 13:47 Query Error Auditing 09:22 The Importance of Defining Data Types 10:48 Simple Transformation Techniques 4 lectures • 22min Sample Files and Documents 00:05 Unpivoting Columns 07:45 Split Columns into Other Columns 06:16 Filtering Data 08:23 Combining Data 3 lectures • 16min Sample Files and Documents 00:05 Appending Tables Individually 09:25 Merging Tables - Basics 06:19 Bonus Section 1 lecture • 1min eBooks (Links) 00:37 Instructors Miguel Escobar Data Monkey @ PowerQuery.Training 4.3 Instructor Rating 141 Reviews 554 Students 1 Course Panamanian consultant and an Excel specialist become a BI specialist using the latest Microsoft tools for BI: Power BI. He is the co-author of 'M is for Data Monkey' and 'Magic Tricks for Data Wizards', blogger and also Youtuber of tricks for Excel. He is the Managing Director and Lead Consultant for Powered Solutions and one of the founders of the Power Query Training project which is the # 1 worldwide site for Power Query related resources. He has been recognized as a Microsoft Most Valuable Professional (MVP), is a Microsoft Certified Professional (MCP - MCSA: BI Reporting ), a Microsoft Certified Trainer ( MCT ), and is one of the international pioneers in Power Pivot, Power Query and Power BI. Show more Show less Ken Puls Excel and Power BI Trainer and Consultant 4.3 Instructor Rating 141 Reviews 554 Students 1 Course Ken Puls, FCPA, FCMA is a Chartered Professional Accountant, blogger, author and trainer with over 20 years of business and financial modelling experience. His passion lies in exploring tools to turn data into information, and teaching others how to benefit from them. To that end, Ken founded Excelguru Consulting Inc, a company focused on bringing Excel and Power BI training to the masses. He has held the Microsoft MVP distinction since 2006, has been recognized as a Fellow of his accounting organization and as one of the “Top 20 under 40” business & community leaders on Vancouver Island. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67814ee8af96ce57',m:'ae0c4574d0be8a1f7d3f85ef186e1cdd393ec3bf-1627844415-1800-ASHFj3Qxr6ac1GaOOmRrFxhL35i17nEqzOCNTyV6+gu74Ie+To+3u0LsI2PAEQDbO6pI0cLM97qUXbCRaQZC55tkO5NEWrThXWyH7bp+Sb/ijU6za6QZVfFboQK70M8r42sHZKFsMtNvZ+yUab8c3HvlC8+MA8z1VqocZ+wqa58K4TJjwqwd9IcDV4ksZO8BrA==',s:[0xeb90893371,0x37a5fcbe1c],}})();
  2. Connect to simple Data Sources and create simple transformation solutions Modify and re-purpose existing Power Query solutions Consolidate and/or Merge Data from Multiple Sources Requirements You can use any version of Power Query (aka Get & Transform) inside Excel (Excel 2010 or later) or even inside Power BI Desktop No prior knowledge of Power BI, Excel formulas or functions is required Description Power Query, also known as “Get & Transform”, is an amazing piece of ETL technology built into Excel 2016 and Power BI Desktop, and is available as a free add-in for Excel 2013 and 2010. It allows you to Extract data from a vast array of sources, Transform it more quickly and easily than you ever thought possible, and then Load it directly into a table or your data model. If you need to learn one new tool today, Power Query is it! Power Query for Excel and Power BI is an introductory excerpt from our full course, Power Query Academy. In this course, we will introduce you to the magic of Power Query and how it will transform the way you work with data forever. Ken Puls and Miguel Escobar, both top Power Query experts, will guide you as you learn about this powerful tool. They will walk you through how Power Query works, connecting to basic data sources, performing simple transformation techniques, combining data from multiple sources), and loading the prepared data in Microsoft Excel and Power BI Desktop. Who this course is for: Excel Users who work with Data Cleansing or Data Transformation Power BI Desktop users Anyone who works with Data or does Data Wrangling to any extent Anyone who has ever used VLOOKUP or tried to consolidate Data in Excel Show more Show less Course content 6 sections • 20 lectures • 2h 6m total length Expand all sections Introduction 3 lectures • 15min What is Power Query? Preview 06:21 Versions of Power Query Preview 08:07 Introduction Handout 00:04 Importing Basic Data 4 lectures • 34min Sample Files and Documents 00:05 Connecting to Delimited Flat Files 11:48 Connecting to Data in Excel Workbooks 08:07 Connecting to Non-Delimited Flat Files 14:29 Query Settings 5 lectures • 38min Sample Files and Documents 00:05 Step Settings 04:02 Choosing Query Load Destinations 13:47 Query Error Auditing 09:22 The Importance of Defining Data Types 10:48 Simple Transformation Techniques 4 lectures • 22min Sample Files and Documents 00:05 Unpivoting Columns 07:45 Split Columns into Other Columns 06:16 Filtering Data 08:23 Combining Data 3 lectures • 16min Sample Files and Documents 00:05 Appending Tables Individually 09:25 Merging Tables - Basics 06:19 Bonus Section 1 lecture • 1min eBooks (Links) 00:37 Instructors Miguel Escobar Data Monkey @ PowerQuery.Training 4.3 Instructor Rating 141 Reviews 554 Students 1 Course Panamanian consultant and an Excel specialist become a BI specialist using the latest Microsoft tools for BI: Power BI. He is the co-author of 'M is for Data Monkey' and 'Magic Tricks for Data Wizards', blogger and also Youtuber of tricks for Excel. He is the Managing Director and Lead Consultant for Powered Solutions and one of the founders of the Power Query Training project which is the # 1 worldwide site for Power Query related resources. He has been recognized as a Microsoft Most Valuable Professional (MVP), is a Microsoft Certified Professional (MCP - MCSA: BI Reporting ), a Microsoft Certified Trainer ( MCT ), and is one of the international pioneers in Power Pivot, Power Query and Power BI. Show more Show less Ken Puls Excel and Power BI Trainer and Consultant 4.3 Instructor Rating 141 Reviews 554 Students 1 Course Ken Puls, FCPA, FCMA is a Chartered Professional Accountant, blogger, author and trainer with over 20 years of business and financial modelling experience. His passion lies in exploring tools to turn data into information, and teaching others how to benefit from them. To that end, Ken founded Excelguru Consulting Inc, a company focused on bringing Excel and Power BI training to the masses. He has held the Microsoft MVP distinction since 2006, has been recognized as a Fellow of his accounting organization and as one of the “Top 20 under 40” business & community leaders on Vancouver Island. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67814ee8af96ce57',m:'ae0c4574d0be8a1f7d3f85ef186e1cdd393ec3bf-1627844415-1800-ASHFj3Qxr6ac1GaOOmRrFxhL35i17nEqzOCNTyV6+gu74Ie+To+3u0LsI2PAEQDbO6pI0cLM97qUXbCRaQZC55tkO5NEWrThXWyH7bp+Sb/ijU6za6QZVfFboQK70M8r42sHZKFsMtNvZ+yUab8c3HvlC8+MA8z1VqocZ+wqa58K4TJjwqwd9IcDV4ksZO8BrA==',s:[0xeb90893371,0x37a5fcbe1c],}})();
  3. Modify and re-purpose existing Power Query solutions Consolidate and/or Merge Data from Multiple Sources Requirements You can use any version of Power Query (aka Get & Transform) inside Excel (Excel 2010 or later) or even inside Power BI Desktop No prior knowledge of Power BI, Excel formulas or functions is required Description Power Query, also known as “Get & Transform”, is an amazing piece of ETL technology built into Excel 2016 and Power BI Desktop, and is available as a free add-in for Excel 2013 and 2010. It allows you to Extract data from a vast array of sources, Transform it more quickly and easily than you ever thought possible, and then Load it directly into a table or your data model. If you need to learn one new tool today, Power Query is it! Power Query for Excel and Power BI is an introductory excerpt from our full course, Power Query Academy. In this course, we will introduce you to the magic of Power Query and how it will transform the way you work with data forever. Ken Puls and Miguel Escobar, both top Power Query experts, will guide you as you learn about this powerful tool. They will walk you through how Power Query works, connecting to basic data sources, performing simple transformation techniques, combining data from multiple sources), and loading the prepared data in Microsoft Excel and Power BI Desktop. Who this course is for: Excel Users who work with Data Cleansing or Data Transformation Power BI Desktop users Anyone who works with Data or does Data Wrangling to any extent Anyone who has ever used VLOOKUP or tried to consolidate Data in Excel Show more Show less Course content 6 sections • 20 lectures • 2h 6m total length Expand all sections Introduction 3 lectures • 15min What is Power Query? Preview 06:21 Versions of Power Query Preview 08:07 Introduction Handout 00:04 Importing Basic Data 4 lectures • 34min Sample Files and Documents 00:05 Connecting to Delimited Flat Files 11:48 Connecting to Data in Excel Workbooks 08:07 Connecting to Non-Delimited Flat Files 14:29 Query Settings 5 lectures • 38min Sample Files and Documents 00:05 Step Settings 04:02 Choosing Query Load Destinations 13:47 Query Error Auditing 09:22 The Importance of Defining Data Types 10:48 Simple Transformation Techniques 4 lectures • 22min Sample Files and Documents 00:05 Unpivoting Columns 07:45 Split Columns into Other Columns 06:16 Filtering Data 08:23 Combining Data 3 lectures • 16min Sample Files and Documents 00:05 Appending Tables Individually 09:25 Merging Tables - Basics 06:19 Bonus Section 1 lecture • 1min eBooks (Links) 00:37 Instructors Miguel Escobar Data Monkey @ PowerQuery.Training 4.3 Instructor Rating 141 Reviews 554 Students 1 Course Panamanian consultant and an Excel specialist become a BI specialist using the latest Microsoft tools for BI: Power BI. He is the co-author of 'M is for Data Monkey' and 'Magic Tricks for Data Wizards', blogger and also Youtuber of tricks for Excel. He is the Managing Director and Lead Consultant for Powered Solutions and one of the founders of the Power Query Training project which is the # 1 worldwide site for Power Query related resources. He has been recognized as a Microsoft Most Valuable Professional (MVP), is a Microsoft Certified Professional (MCP - MCSA: BI Reporting ), a Microsoft Certified Trainer ( MCT ), and is one of the international pioneers in Power Pivot, Power Query and Power BI. Show more Show less Ken Puls Excel and Power BI Trainer and Consultant 4.3 Instructor Rating 141 Reviews 554 Students 1 Course Ken Puls, FCPA, FCMA is a Chartered Professional Accountant, blogger, author and trainer with over 20 years of business and financial modelling experience. His passion lies in exploring tools to turn data into information, and teaching others how to benefit from them. To that end, Ken founded Excelguru Consulting Inc, a company focused on bringing Excel and Power BI training to the masses. He has held the Microsoft MVP distinction since 2006, has been recognized as a Fellow of his accounting organization and as one of the “Top 20 under 40” business & community leaders on Vancouver Island. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67814ee8af96ce57',m:'ae0c4574d0be8a1f7d3f85ef186e1cdd393ec3bf-1627844415-1800-ASHFj3Qxr6ac1GaOOmRrFxhL35i17nEqzOCNTyV6+gu74Ie+To+3u0LsI2PAEQDbO6pI0cLM97qUXbCRaQZC55tkO5NEWrThXWyH7bp+Sb/ijU6za6QZVfFboQK70M8r42sHZKFsMtNvZ+yUab8c3HvlC8+MA8z1VqocZ+wqa58K4TJjwqwd9IcDV4ksZO8BrA==',s:[0xeb90893371,0x37a5fcbe1c],}})();
  4. Consolidate and/or Merge Data from Multiple Sources Requirements You can use any version of Power Query (aka Get & Transform) inside Excel (Excel 2010 or later) or even inside Power BI Desktop No prior knowledge of Power BI, Excel formulas or functions is required Description Power Query, also known as “Get & Transform”, is an amazing piece of ETL technology built into Excel 2016 and Power BI Desktop, and is available as a free add-in for Excel 2013 and 2010. It allows you to Extract data from a vast array of sources, Transform it more quickly and easily than you ever thought possible, and then Load it directly into a table or your data model. If you need to learn one new tool today, Power Query is it! Power Query for Excel and Power BI is an introductory excerpt from our full course, Power Query Academy. In this course, we will introduce you to the magic of Power Query and how it will transform the way you work with data forever. Ken Puls and Miguel Escobar, both top Power Query experts, will guide you as you learn about this powerful tool. They will walk you through how Power Query works, connecting to basic data sources, performing simple transformation techniques, combining data from multiple sources), and loading the prepared data in Microsoft Excel and Power BI Desktop. Who this course is for: Excel Users who work with Data Cleansing or Data Transformation Power BI Desktop users Anyone who works with Data or does Data Wrangling to any extent Anyone who has ever used VLOOKUP or tried to consolidate Data in Excel Show more Show less Course content 6 sections • 20 lectures • 2h 6m total length Expand all sections Introduction 3 lectures • 15min What is Power Query? Preview 06:21 Versions of Power Query Preview 08:07 Introduction Handout 00:04 Importing Basic Data 4 lectures • 34min Sample Files and Documents 00:05 Connecting to Delimited Flat Files 11:48 Connecting to Data in Excel Workbooks 08:07 Connecting to Non-Delimited Flat Files 14:29 Query Settings 5 lectures • 38min Sample Files and Documents 00:05 Step Settings 04:02 Choosing Query Load Destinations 13:47 Query Error Auditing 09:22 The Importance of Defining Data Types 10:48 Simple Transformation Techniques 4 lectures • 22min Sample Files and Documents 00:05 Unpivoting Columns 07:45 Split Columns into Other Columns 06:16 Filtering Data 08:23 Combining Data 3 lectures • 16min Sample Files and Documents 00:05 Appending Tables Individually 09:25 Merging Tables - Basics 06:19 Bonus Section 1 lecture • 1min eBooks (Links) 00:37 Instructors Miguel Escobar Data Monkey @ PowerQuery.Training 4.3 Instructor Rating 141 Reviews 554 Students 1 Course Panamanian consultant and an Excel specialist become a BI specialist using the latest Microsoft tools for BI: Power BI. He is the co-author of 'M is for Data Monkey' and 'Magic Tricks for Data Wizards', blogger and also Youtuber of tricks for Excel. He is the Managing Director and Lead Consultant for Powered Solutions and one of the founders of the Power Query Training project which is the # 1 worldwide site for Power Query related resources. He has been recognized as a Microsoft Most Valuable Professional (MVP), is a Microsoft Certified Professional (MCP - MCSA: BI Reporting ), a Microsoft Certified Trainer ( MCT ), and is one of the international pioneers in Power Pivot, Power Query and Power BI. Show more Show less Ken Puls Excel and Power BI Trainer and Consultant 4.3 Instructor Rating 141 Reviews 554 Students 1 Course Ken Puls, FCPA, FCMA is a Chartered Professional Accountant, blogger, author and trainer with over 20 years of business and financial modelling experience. His passion lies in exploring tools to turn data into information, and teaching others how to benefit from them. To that end, Ken founded Excelguru Consulting Inc, a company focused on bringing Excel and Power BI training to the masses. He has held the Microsoft MVP distinction since 2006, has been recognized as a Fellow of his accounting organization and as one of the “Top 20 under 40” business & community leaders on Vancouver Island. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67814ee8af96ce57',m:'ae0c4574d0be8a1f7d3f85ef186e1cdd393ec3bf-1627844415-1800-ASHFj3Qxr6ac1GaOOmRrFxhL35i17nEqzOCNTyV6+gu74Ie+To+3u0LsI2PAEQDbO6pI0cLM97qUXbCRaQZC55tkO5NEWrThXWyH7bp+Sb/ijU6za6QZVfFboQK70M8r42sHZKFsMtNvZ+yUab8c3HvlC8+MA8z1VqocZ+wqa58K4TJjwqwd9IcDV4ksZO8BrA==',s:[0xeb90893371,0x37a5fcbe1c],}})();