Learn to automate the extraction and cleansing of data. Before Power BI crunches data, Power Query preps it. REMOTE OPTION!
Copy-paste? Dragging formulas down? SAME THING EVERY WEEK?... No more. Teach your computer how to build your reports for you. Set and forget!
Overview: Taught simultaneously in Excel and Power BI.
Power Query makes grabbing and shaping data easy for business people in a way previously only available to advanced IT folks.
This class will teach you how to connect to all of your data (no matter where it lives), shape it so DAX can run "automagically", and have your computer remember the steps so you never have to do it again.
Students are encouraged to take our Foundations course and have hands-on experience with Power Query in Excel or Power BI Desktop.
What’s Included: -Intermediate to Advanced Level Power Query best practices distilled into easy to understand patterns to apply to your most common business challenges. -Downloadable Power BI with embedded Power Query workbook samples for you to take with you. -Pricing includes up to 15 participants