| Class Dates and Times | ||
| 04/25/2025 | Friday | 10:00-4:45 EDT |
| 9:00-3:45 CDT | ||
| 8:00-2:45 MDT | ||
| 7:00-1:45 PDT | ||
Ready to Run Class
A Ready to Run date will not cancel due to low enrollments. Seats are still available but filling fast - Register soon!
| Last Reg Date | 4/22 |
| Class Dates and Times | ||
| 06/20/2025 | Friday | 10:00-4:45 EDT |
| 9:00-3:45 CDT | ||
| 8:00-2:45 MDT | ||
| 7:00-1:45 PDT | ||
Follow the link to our self-service price quote form to generate an email with a price quote.
We can deliver this class for your group. Follow the link to request more information.
Receive an email when this class is available as "Ready to Run" or "Early Notice" status.
If you have high-speed internet and a computer you can likely take this class from your home or office.
This course is for individuals responsible for taking data and turning it into powerful business intelligence solutions. With Power Query you can transform data (by reducing, adding columns, and combining data sets) so that it is setup for additional analysis. Power Query makes “data munging” and “data wrangling” easy for non-programmers working as data scientists.
This course takes an in-depth approach to the Power Query and will provide an introduction to the M language, allowing you to replay a series of transformations. This is helpful when readying data on a weekly, monthly or quarterly basis, saving you time on these repetitive tasks. M Code will also allow you to manipulate data using features that are not accessible via keyboard commands.
This class is for users of either
Power BI
, Excel Power Tools, or SQL Server Analysis Services (SSAS). While all three products have a very similar Power Query-related interface, the course will be taught using the Excel 2016 software. Users of Power BI and SQL Server should have no problems with the slight differences between products.
This course is aimed at Excel power-users, Power BI users, BI professionals, and Excel power-users who have a general familiarity with Power Query but need more knowledge and experience to take it to its full potential. Our
Power BI Tools: DAX Introduction course is a great complement to this class and is also designed for users of Excel, Power BI or SQL Server.
While attendees do not need extensive prior experience with DAX formulas, it is recommended that they have taken either
Microsoft Power BI Data Analyst OR Power BI Introduction for Excel Users class OR have similar experience.
View outline in Word
Attend hands-on, instructor-led Power BI Tools: Get and Transform Data (with M Programming) training classes at ONLC's nationwide locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.
For additional training options, check out our list of Power BI Courses and select the one that's right for you.
Facebook
LinkedIn