![]() Power Query is a powerful tool for modeling and shaping data. ![]() While it is a best practice to do as much data scrubbing and transforming in a native application, Power Query can still add value in cleaning raw data and modeling them in a fashion that facilitates further analysis. This article describes how Microsoft Power Query for Excel can be used to easily transform data and be applied in subsequent periods so that very little additional work has to be done to obtain clean data. Challenges occur when subsequent data are added to the general ledger, because it is time- consuming to repeat all the steps in the scrubbing process. The approach works very well for most analyses. The January 2017 JofA article " Data Mining Your General Ledger With Excel" presents a step- by- step, formula- based approach to extracting general ledger data and then scrubbing them so that they can be readily analyzed through the use of PivotTables.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |