Power BI Part 5 - Use Power Query to Transform Your Data

OL931  |  On Demand Course  |  Update  |  Self-Study

Description

This course is the fifth in the Microsoft Power BI series of courses.

Data can be messy! In other words, it is not always clean and neat. Data comes from various sources like text files, Excel spreadsheets, databases, report files, etc. This is how most data analysis projects fail - the inability to get the correct data.

This class focuses on using Power Query (Get and Transform) to clean, shape and transform your messy data while still allowing you a one-click refresh. We will review various data issues including appending files, combining multiple files from a folder, adding custom columns, unpivoting data, creating a lookup table, and much more.

Credits

Number of Credits Type of Credits
2.00 Computer Software & Applications

Prices

Member (Early Bird)
$79.00
Non-Member (Early Bird)
$109.00
Member
$79.00
Non-Member
$109.00
Your Price: $109.00

This is your base price and does not reflect any additional session fees, optional add-ons, or guest registrations.

Members log in and save $30.00 on this event. Not a member? join today.

Instructors

Bryan L. Smith, CPA, CITP, CISA

Bryan serves as a trusted adviser to CPAs in public accounting, as well as business and industry, on all aspects of information technology. Bryan's expertise includes in-depth knowledge of paperless work flow solutions, the impact of technology on internal controls, strategic IT infrastructure design and information security best practices. As a nationally recognized author and presenter on information technology issues impacting CPAs, Bryan is passionate about the opportunities for CPAs to benefit from safe and secure computing.

Back to Instructors
Return to Events