Using Business Intelligence to Improve Auditability and Accounting Operations
Download
1 / 8

Using Business Intelligence to Improve Auditability and Accounting Operations 14 March 2012 - PowerPoint PPT Presentation


  • 90 Views
  • Uploaded on

Using Business Intelligence to Improve Auditability and Accounting Operations 14 March 2012. Agenda. What is Business Intelligence Traditional Challenges Business Impact of the Challenges How Business Intelligence can Help Questions. What Is Business Intelligence.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Using Business Intelligence to Improve Auditability and Accounting Operations 14 March 2012' - braith


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

Using Business Intelligence to Improve Auditability and Accounting Operations

14 March 2012


Agenda Accounting Operations

  • What is Business Intelligence

  • Traditional Challenges

  • Business Impact of the Challenges

  • How Business Intelligence can Help

  • Questions


What Is Business Intelligence Accounting Operations

  • Core BI vs Extended BI

    • Reporting, Query and Visualization/Dashboards

      • Use Cases for Each

    • Data Management Tools

      • What are they, and What do they Bring to the Table?

      • Additional Use Cases for Data Management

  • Providers

    • Many Providers Similar Solutions

      • They may just have a different way to get you at the data


Traditional challenges
Traditional Challenges Accounting Operations

  • Many systems with pertinent information each with different:

    • Data Structures

    • Master Data format and values

    • Systems Access Requirements

    • Reporting Tools and Methods

  • Many Systems Owned by Others

  • Limited Documentation to older systems

  • Key Systems Experts are Retiring

  • Limited Funds for Investment

    • Non-Compliant Legacy Systems may cause Compliance Issues with Modernized Core Financials Systems


Business impact of the challenges
Business Impact of the Challenges Accounting Operations

  • Very Difficult to Compare and Reconcile between Feeder Systems and Core Accounting Systems

    • Even More Difficult with Feeders of Feeders

    • Crosswalking, if even possible, is hindered because of the Brain Drain

    • Who actually has Access to the Data?

    • Can I Get any System Changes to Fix my Problems

  • How does the Core Accounting/Business User know Where their Data Comes from?

  • Controls in Legacy Systems may not be Documented

    • If the Control Environment isn’t testable, the audit become more complex and costly

  • Posting Model Differences can result in Out-of-Balance conditions


How business intelligence can help
How Business Intelligence Can Help Accounting Operations

  • Data Rationalization

    • Build the Crosswalks, and Standardize the Output

      • Forces All Parties to Talk and Agree to a Common Vernacular

      • Does NOT Require Changes to the Underlying System Data Structures or Models

  • Continuous Monitoring

    • Users can Monitor Data

    • Metrics are Measurable and Management can Hold Users Accountable

    • Scientific Proof of Problem Children


How business intelligence can help1
How Business Intelligence Can Help Accounting Operations

  • Data Quality

    • Automatically Change Known Errors

      • Posting Model Errors

      • Qwerty/10-Key Errors

      • Missing Data

  • Data Lineage

    • Document the Data Rationalization/Data Quality Activities

    • PROVE that the System Works as Documented


Conclusion Accounting Operations

Additional Questions????


ad