Skip the boilerplate stuff to focus on what

Skip the boilerplate stuff to focus on what matters - Analysis © Grant Thornton International. All rights reserved.

Agenda - Brief introduction - Objective - Scenario Examples 1. Bulk import 2. Renaming of field names 3. Exporting of final output - Putting it all together -Q&A © Grant Thornton International. All rights reserved.

Introduction - Data Analytics Manager within the BRS at GT - Experience in delivery of data analytics in both internal and external audits - Maintain (and develop if needed) IDEA based scripts/tools used by team - Also works with Tableau, SQL, ACL, VBA (Excel, Access) - Was an IT external auditor in previous life © Grant Thornton International. All rights reserved.

Objectives Share scenarios where we have had success in automating aspects of our workflow in order to increase efficiency. Hopefully you can look into your workflows as well and spot opportunities for automation. © Grant Thornton International. All rights reserved.

Bulk Import Scenario You have been given 100 Excel files and have been asked to bring them into IDEA for analysis. © Grant Thornton International. All rights reserved.

Renaming of field names Scenario You are working on SAP data and the tables you have been given have their field names in German. © Grant Thornton International. All rights reserved.

Exporting of final output Scenario You have finished your analysis and need to share your output with the rest of your team. Your team has a reporting template that you need to use. © Grant Thornton International. All rights reserved.

Putting it all together Scenario You are an internal auditor and have been asked to perform a journal entry analysis. Your company uses Sage 200 (sat in an SQL Server). You have been asked to do this ASAP. © Grant Thornton International. All rights reserved.

Thank you for listening Please feel free to ask any questions. © Grant Thornton International. All rights reserved.