DATA Robots FOR EXCELLENCE
A DATA DISCOVERY TOOL WITH EXCELLENT MS 365 INTEGRATION
Does your accountant work so closely with Financials that he can see the wires coming out of the Financials database server?
Empower your accountants further by providing reporting access to bare-metal Financials data from the comfort of MS Excel.
Create D4E apps that understand your Financials and access them directly from Excel - no web logons, no "export to Excel", no intermediate steps. Using the Excel environment only, automatically generate and publish hundreds if not thousands of high-fidelity customised reports every month for top management.
Immediately report and analyse Financials data securely from Oracle eBusiness Suite, SAP Netweaver BW or other General Ledgers. With D4E apps linked directly to GL tables, your accountants do not have to wait for OLAP/BI refresh after posting a journal. With Data Marts integrated with Excel and delivering data right into spreadsheets, your dashboards can be refreshed with real-time production data without leaving Excel.
D4E is the tool for accountants because it provides business intelligence and enterprise reporting capabilities that inter-operate with MS Office. D4E integrates with menu options and toolbars but is not embedded in spreadsheets. D4E creates spreadsheets with financial data extracted from databases. It does not use external formulas that can become missing values (‘#NAME?’) inside cells. (Instead, D4E uses key values in the sheets top-most row and left-most column as well as the the tabsheet name to access D4E apps and ODBC databases.) Consequently, the spreadsheet integration provides the highest-fidelity formatting of Financials that only Excel can provide. It can be refreshed, signed-off, sent to managers or submitted to the Board as is. Because there are no external formulas, other accountants/managers (with no D4E) can receive, open, analyse, annotate, and then send back the spreadsheet for instant reuse within D4E.
Chief Financial Officers
As the head of a large Finance team, do you feel you are being bogged down by the 80/20 dilemma of "data gathering" versus "data analysis"? Wouldn't you like to have a tool that can compress your team's data gathering time, allocate more resources to data analysis, and leave the rest of the pack in the performance race?
Many CFO's today are inundated with the preponderance of Business Intelligence tools that offer to improve the analysis of financial data. Business Intelligence and OLAP tools offer the ability to slice-and-dice large amounts of information to provide a single metric. This helps the managers and the management accountants. But it does not help the Financial Accountants who have to collect accurate and reconciled information before analysis. It is this financial accounting work that needs to be compressed as it accounts for 80 percent of your time and resources. The very latest BI tools will try to squeze the data analysis time, but without working on compressing data collection time, your 80/20 benchmark actually gets worse!
What is needed is a tool to help Financial Accountants improve the time they take to prepare accounting information. D4E is the tool you have been looking for because its powerful filtering and parameter processing provides a way for the Financial Accountant to slice-and-dice information from a large database, and produce, not a single metric, but a manageable set of results tailored to the financial accounting requirements. Without this tool, the alternative is for the Financial Accountants to depend on drill-downs with a lot of guess work - hoping that the required set of transactions and balances will appear on one of several ways to drill-down. It can also involve a tedious amount of search using large spreadsheets, if the results are not easily managed.
D4E provides the Financial Accountant a way to create a subset of any General Ledger information, by applying powerful filters across any segment codes and other parameters. With powerful filters, you are able to search based on a simple list of values, ranges, patterns or any combination thereof. Because the D4E actions are integrated with MS Office, you experience MS Office and Excel's familiar look-and-feel. The powerful filters can be re-used in other searches and therefore provide the Financial Accountant a way to repeatedly massage/refine/manage the resulting data searches until the accounting data is complete, accurate and reportable.
Does your company have UDA's (user developed applications) scattered all over the place that it's a nightmare just to change a server name.
Store all your ex-UDA's (including SQL, ODBC connections and credentials) in one secured, central repository for easy maintenance and SOX compliance.
Prove that you have financial and risk control over all your finance processes to comply with Sarbanes-Oxley Act 2002 (Section 404).
Convert UDA's into D4E apps in seconds and watch them inter-operate seamlessly with the Excel ribbon. Parameters can be entered and complicated ex-UDA's simply become one-click actions. Have confidence that the extract process is using the same secured data mart each time, and not some unstable error-prone UDA.
In your yearly attestations for Sarbanes-Oxley Act 2002, report the existence of only one system (D4E) instead of hundreds. All future extract processes incorporated in data marts (robots) do not need to be documented separately as they share common financial control points. Extract and analyse your Financials data securely from Oracle eBusiness Suite, SAP Netweaver BW or other General Ledgers - without risk of losing financial control.
D4E can provide the financial control points that auditors look for because of business intelligence and enterprise reporting capabilities that inter-operate with MS 365. D4E exists in menu options and toolbars but is not embedded in spreadsheets. D4E creates spreadsheets with financial data extracted from databases. It does not use external formulas that can become missing values (‘#NAME?’) inside cells. Consequently, the spreadsheet can have the highest-fidelity formatting of Financials that only Excel can provide.
Caratrel Consultants Pty Ltd © All Rights Reserved.
+61 (0) 418 217 114
DATA MART FOR EXCEL