# Power Query Bootcamp Canonical URL: ## Overview Learn to use Power Query to clean, transform, and organize data for analysis. Working directly within the Power Query interface, you'll apply structured transformations, reshape datasets using tools such as Pivot, Unpivot, and Transpose, and combine data from multiple sources through appending and merging. The course also covers creating grouped summaries, conditional columns, and columns from examples to enrich your data. You'll finish by learning how to organize and manage queries effectively using applied steps, duplication, dependencies, and refresh behavior. ## What you'll learn - Navigate the Power Query interface, understand the data analysis process, and work with Power Query options, applied steps, and refresh behavior. - Clean and transform data by filtering rows, removing and reordering columns, changing data types, splitting and merging columns, and applying text cleanup techniques. - Create structured transformations using grouping, conditional columns, date and duration calculations, and columns generated from examples. - Reshape datasets using Pivot, Unpivot, Transpose, and split-to-rows techniques to support analysis and reporting. - Combine data from multiple sources by appending tables, worksheets, and CSV files, and merging data using inner and anti joins. - Organize and manage queries by duplicating and referencing queries, handling errors and values, removing duplicates and blank rows, and working with query dependencies. ## Curriculum #### Getting Started with Power Query - The Data Analysis Process - What Is Power Query? - The Power Query Interface - Power Query Options & Settings - One – Extracting - Two – Transforming - Three – Loading - Four – Refreshing - Benefits of Power Query #### Transpose, Pivot, and Un-Pivot - Transformations Overview - Introduction to Transforming Data - Removing Rows by Filtering Data - Removing, Renaming & Reordering Columns - Loading Your Transformations - Applied Steps - Saving Transformations - Data Type Transformations #### Combining Data from Two or More Data Sets - Relationships - Appending Two Tables - Appending Multiple Tables - Query Organization - Appending Multiple CSVs - Appending Data with Different Column Headers - Merging Tables - Merging via Composite Columns - Inner Joins - Right & Left Anti Joins - Appending Multiple Worksheets #### Duplicating and Parameters - Duplicate & Reference Queries - Remove Duplicates - Deleting Queries - Replacing Errors & Values - Removing Top/Bottom Rows - Using First Row as Headers - Removing Blank Rows #### Steps, Groups and Dependencies - Transformation Steps Level 1 - Splitting Columns - Merging Columns - Trim, Clean, and Changing Case - Transformation Steps Level 2 - Filling Down - Sorting - Extracting - Math Calculations - Unpivot - Pivot - Transpose - Split Columns into Rows - Group By - Grouping by Dates/Times - Date/Duration Calculations - Conditional Columns - Columns from Examples - Extracting from Data Sources - Getting Data from Excel - Getting Data from CSV - Getting Data from PDF - Getting Data from Websites ## Schedule - Jun 18, 2026 10:00am–5:00pm — NYC - Sep 18, 2026 10:00am–5:00pm — NYC ## Instructors ### Brian McClain — Program Director & Senior Instructor Brian McClain is an experienced instructor, curriculum developer, and web developer. Brian served as Director for a coding bootcamp before joining Noble Desktop in 2022, where he is now a lead instructor and course developer for both JavaScript and Python. He teaches Web Development, JavaScript, Python for Data Science, Machine Learning, and AI. Prior to Noble, he taught Python Data Science and Machine Learning as an Adjunct Professor of Computer Science at Westchester County College. Brian is also an active industry professional in the field of generative AI app development. His website and iOS app, Artmink, provides appraisals of art and antiques from user-uploaded images. ### Mourad Kattan — Program Director & Instructor Mourad Kattan is an instructor and Program Director of Business, Finance, & Excel at Noble Desktop, teaching classes and designing courses in Excel, finance, accounting, and financial modeling. Before Noble Desktop, Mourad worked as a financial analyst at Credit Suisse and H/2 Capital Partners. In those positions, he used advanced analytical and financial skills to evaluate a variety of investments. Mourad graduated from the University of Pennsylvania summa cum laude and is part of the Beta Gamma Sigma honor society. Learn more about [Mourad Kattan's](/mourad-kattan) background and expertise. ### Adebayo Norman — Instructor Adebayo "Ade" Norman is a Senior Software Trainer with over 14 years of experience in the classroom. He is a training professional with vast troubleshooting/help desk experience and thousands of hours of software training & delivery experience. His specialty is in the In-person/Online Hybrid training environment needed in these new & changing times. ### Garfield Stinvil — Senior Instructor Garfield is an experienced software trainer with over 16 years of real-world professional experience. He started as a data analyst with a Wall Street real estate investment company & continued working in the professional development department at New York Road Runners Organization before working at Noble. He enjoys bringing humor to whatever he teaches and loves conveying ideas in novel ways that help others learn more efficiently. Since starting his professional training career in 2016, he has worked with several corporate clients including Adobe, HBO, Amazon, Yelp, Mitsubishi, WeWork, Michael Kors, Christian Dior, and Hermès. Outside of work, his hobbies include rescuing & archiving at-risk artistic online media using his database management skills. ## Pricing **Tuition:** $299