How does FHB use Python in its Workiva implementations?

Python is the programming language used to support Workiva’s scripting functionality. FHB utilizes this functionality to eliminate a plethora of manual, complex, and time-consuming tasks that would otherwise need to be done manually. One way in which we frequently use scripts is to automate the loading of your data from the underlying data source by automatically reaching out to your FTP site and downloading data into Workiva, where it is transformed into the required structure. We can then automate the production of much of your reports – moving columns around, chopping one column into 9 columns, collapsing 12 columns into two columns for use inside Workiva, loading it into the database, and then refreshing all of your sheets downstream in your documents so that they now have the right numbers. Without scripting, some of this automation would not be possible, and our clients would have to revert to manual, time-consuming processes.