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
Wayfair Woes One Year Later
Jul 24 The rise in online shopping has sharply impacted state sales tax revenue. Rather than increasing the tax rate, states are setting parameters to define nexus, wh...
Importing Date Fields
Jul 24 There are times when you import a date field and it just does not work out as expected. Here are ways to address the problem before or after the import.  ...
Tech Tip: Understanding Join and Visual Connector
Jun 19 Using IDEA’s Join and Visual Connector features can help you search for matches and correlations between different data sets, but they are often confused with...

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