1 / 8

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. What Is Business Intelligence.

braith
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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

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

  2. Agenda • What is Business Intelligence • Traditional Challenges • Business Impact of the Challenges • How Business Intelligence can Help • Questions

  3. 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

  4. 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

  5. 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

  6. 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

  7. 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

  8. Conclusion Additional Questions????

More Related