You are currently reviewing an older revision of this page.
From Tom and Neil
You too can deliver production-ready robust queries vis MS Power Query if your avoid "The Ten Pitfalls of the Data Wrangler..." I came across this article that you might find of interest. I know that I have personally discovered some of these issues. https://powerpivotpro.com/2017/02/the-ten-pitfalls-of-the-data-wrangler-aka-the-wielder-of-mpower-query/
You too can deliver production-ready robust queries vis MS Power Query if your avoid "The Ten Pitfalls of the Data Wrangler..." I came across this article that you might find of interest. I know that I have personally discovered some of these issues.
https://powerpivotpro.com/2017/02/the-ten-pitfalls-of-the-data-wrangler-aka-the-wielder-of-mpower-query/
From Neil Cole
Here is the BEST YouTube channel I’ve found regarding Power Query, Power Pivot, and Power BI (I kept running into his videos and then I finally clicked the profile; then my jaw dropped looking at all the videos.) ExcelIsFun Includes links to downloadable files so you can follow along, PDF of notes (well done notes), and time stamped outline of topics (so you can easily get to the part you want)): FREE Excel Education 3,000 Excel videos — 100 Playlists Data Analysis and Business Intelligence Made Easy with Excel Power Tools. Excel Data Analysis Basics (E-DAB). E-DAB 06: The Magic of Power Query to Import, Transform, & Load Data Excel Magic Trick 1331: Import Excel Files & Sheets into Excel: Power Query Get & Transform
Here is the BEST YouTube channel I’ve found regarding Power Query, Power Pivot, and Power BI
(I kept running into his videos and then I finally clicked the profile; then my jaw dropped looking at all the videos.)
ExcelIsFun
Includes links to downloadable files so you can follow along, PDF of notes (well done notes), and time stamped outline of topics (so you can easily get to the part you want)):
FREE Excel Education
3,000 Excel videos — 100 Playlists
Data Analysis and Business Intelligence Made Easy with Excel Power Tools. Excel Data Analysis Basics (E-DAB).
E-DAB 06: The Magic of Power Query to Import, Transform, & Load Data
Excel Magic Trick 1331: Import Excel Files & Sheets into Excel: Power Query Get & Transform