More than ever, organizations are realizing the valuable insights and opportunities that lie hidden within both structured and unstructured data. Getting access to data is another story. Data acquisition remains a top challenge for auditors.
Before any work can be done in IDEA, you’ll first need to acquire the data to be analyzed.
Here are the steps to export data from three commonly used applications; SAP, Peoplesoft and QuickBooks. Note that your exact steps may vary slightly depending on the version of software you are using.
Visualization allows us to explain complex data and make connections that would otherwise remain unknown. The new functionality of IDEA 10 gives you the ability to navigate your data with confidence, and share your results in more meaningful ways.
IDEA’s Discover and Visualization tools let you take advantage of that shared visual language, letting you turn thousands of detailed line items into meaningful charts and graphs.
When one of the world’s leading suppliers to the oil and gas industry wanted to develop a global view into company inventory management, they needed a sophisticated set of scripts to analyze available data, and a graphical interface to review the results.
HOUSTON – April 3, 2017 – University of Virginia graduate students in the McIntire School of Commerce are learning to apply data analytics techniques to extract meaningful insights and identify potential risks by participating in the IDEA Academic Partnership.
What if you could replace two weeks of work each month with a 3-minute process that actually delivered more consistent results? Our Solutions Development team was recently approached by a client to write an IDEAScript that could perform pre-field work analysis for an audit of submitted labor charges and expenses.
A common problem with importing any file into IDEA is dealing with date fields. The import assistant reads the field and does its best to determine what kind of data is being imported and what type of field to create. If there is anything in the field that doesn’t look like a date, it will either create a Numeric or Character field. Fortunately, there are ways to either correct this at the time of import or in the database after the file has been imported.
More than ever, auditors are taking on the role of programmers; writing scripts to run automated analysis and tests on a regular basis for the organization. Luckily, tools like IDEA offer a graphical user interface (GUI) and built-in compiler to design scripts while reducing or eliminating the need for manually typing code. IDEAScripts work much like Microsoft® Excel macros, but with greater speed and flexibility.
Technology impacts our lives. It has the capacity to make the world feel smaller, and make us feel more connected. Very early in my career, I realized the importance of embracing and learning to use technology in my work would generate opportunities. What I didn’t realize is the magnitude of its impact.