Print Page   |   Your Cart   |   Sign In   |   Join
(1920432) Microsoft PowerBI - Fundamentals of Power Query
View Registrations Tell a Friend About This EventTell a Friend
 

Data can be messy. Since data comes from various sources, like text files, Excel spreadsheets, databases and report files, it is not always clean and neat. This inability to get the correct and clean data is exactly why most data analysis projects fail. This webcast focuses on using Power Query, as well as Get and Transform in Excel 2016, to clean, shape and transform your messy data while still allowing you the one-click refresh. We will review various data issues including appending files,

6/13/2019
When: 06/13/2019
8:00 AM
Where: Webcast
AICPA
1920432:651A9F71829C3D3A6226AEC47A3144A5
United States
Presenter: Bryan Smith


Online registration is closed.
« Go to Upcoming Event List  

Acronym 1920432
CPE 2
Vendor AICPA
Category
Computer Software & Applications
Level Advanced
Yellow Book? N
Registration Fees
Members* $99
Non-Members $129

*The Member rate applies to UACPA members and reciprocal state society members. To register online, use the ‘Register’ button above. To register by phone, call the UACPA at 801-466-8022, Monday through Friday, 8am to 4pm.

Course Description

Data can be messy. Since data comes from various sources, like text files, Excel spreadsheets, databases and report files, it is not always clean and neat. This inability to get the correct and clean data is exactly why most data analysis projects fail. This webcast focuses on using Power Query, as well as Get and Transform in Excel 2016, to clean, shape and transform your messy data while still allowing you the 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.

Objectives

When you complete this webcast, you will be able to:

Membership Management Software Powered by YourMembership  ::  Legal