Using Business Intelligence to Improve Auditability and Accounting Operations
This presentation is the property of its rightful owner.
Sponsored Links
1 / 8

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


  • 58 Views
  • Uploaded on
  • Presentation posted in: General

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.

Download Presentation

Using Business Intelligence to Improve Auditability and Accounting Operations 14 March 2012

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

Using Business Intelligence to Improve Auditability and Accounting Operations

14 March 2012


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


Using business intelligence to improve auditability and accounting operations 14 march 2012

What Is Business Intelligence

  • 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

  • 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

  • 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

  • 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

  • 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


Using business intelligence to improve auditability and accounting operations 14 march 2012

Conclusion

Additional Questions????


  • Login