PRODUCTS --> PRODUCTS OVERVIEW | ACCOUNTANTS | IT ANALYSTS | BUSINESS USERS | DATABASE ADMINISTRATORS | CHIEF FINANCIAL OFFICERS

IT Analysts

As a Business Analyst, Data Analyst or Test Analyst, wouldn’t you like to have an easy-to-use tool to view your application data without constantly writing SQLs or asking others to do it for you?

Empower yourself by having access to all application data from the comfort of MS Office Excel and sharing this tool with the rest of the agile project team.

Without programming effort, create Data Marts that understand your application schema and access information directly from Excel. Use SQL once to create data viewers that will then take parameters instead. Customised SQLs are automatically created on the fly and data returned as spreadsheets in real-time.

Immediately report and analyse application data securely from any database or ERP (IBM DB2, MS SQL, Oracle, or SAP). With Data Marts linked directly to the database tables, you can analyse and compare between production and test data, new and legacy data, pre- and post-migration data, as well as between entirely different production applications.

Datamart4Excel is the tool you have been looking for because it provides business intelligence and enterprise reporting capability all within Excel. Datamart4Excel uses Excel friendly menu options and toolbars to create simple spreadsheets. You can create Data Marts with SQL written for any database and see them all in your Excel menu and toolbars. Because it can be deployed to all desktops with Excel, the same proven tool can cater for a wide range of reporting requirements by end-users.

Datamart4Excel is a specialist form of Business Intelligence (BI) as it does not actually require the traditional BI components of Extract-Transform-Load (ETL) and/or Data Warehouse. Datamart4Excel creates spreadsheets with application data extracted directly from databases. It does not use external formulas that can become missing values (‘#NAME?’) inside cells. Because there are no external formulas, other project team members (even those with no Datamart4Excel) can open and update the spreadsheet. By using a common BI data discovery tool, the data marts can be shared by members of the project team and any end-users who have Excel.

Learn more or view some screenshots demonstration of Excel to see empowerment in action. See also our solution profile for IT Analysts in Oracle.com and our Products Brochure.