The 21st Minute


Integration with Tableau – Analytic Toolbox



A Global 500 supplier of technology, integrated project management and information solutions to the oil and gas industry needed a way to manage inventory issues including accrual, adjustment, invoices not received and adequacy of provisions.


Inventory data managed through 18 regions grouped into North America, Latin America, Europe & Africa, Russia, Middle East and Asia needed to be centralized and prepared for analysis. The company planned to use Tableau to provide interactive data visualization to graphically report their findings. CaseWare IDEA® would be used to prepare Inventory Indicator data for import into Tableau’s system.


The Audimation Services Solutions Development team developed a toolkit of custom IDEAScripts to import and prepare data for upload into Tableau where graphs would be generated to track inventory consumption, identify adjustments, identify invoices not received, and calculate the adequacy of provisions as a percentage of the balance.


Previous methods required more than a month to graphically represent the appropriate Excel data for inventory processes, and management preferred to view the data using Tableau’s graphic reports. Audimation Services worked with the company’s in-house Tableau expert to prepare data for automatic import into IDEA, and export into Tableau. IDEAScripts were provided for each process including measuring inventory movements and graphing them by geo-market region. The team also developed an independent driver to perform the automatic import/export from Excel into IDEA, then into Tableau. The result was a seamless process to provide management with accurate inventory reports in graphic form, and saved weeks of manual work that was previously required.


Automate Procedures , CaseWare IDEA , Success Story

Posted By


Related Posts
Tech Tip: Transforming Your Data
May 15 We are inundated with data on a daily basis. Here are a few time-saving tips for transforming your raw or jumbled data into useful information.   Adding...
Task Automation Using IDEA
Apr 16 Audit scenarios rarely require an entirely unique process. Having a preferred set of tests ready to go is a great time saver, but that can be further improved i...
Gain Productivity with RPA
Apr 16 Leaders of professional associations are urging auditors to embrace emerging technologies to advance the industry, create audit efficiencies and manage organiza...

This website has been designed for modern browsers. Please update. Update my browser now