A DATA DISCOVERY TOOL WITH EXCELLENT MS OFFICE INTEGRATION

Business Users

    

As a Business User do you often feel the need for one-off application reports but have always been told that such reports will take time and resources? As an avid Excel user, do you feel that you could do the reports yourself if only the data was made available to you? Empower yourself by having access to all data from applications, data warehouses and data lakes - from the comfort of MS Office Excel. Free yourself from the priority list of IT projects in the pipeline.

Without programming effort, create Data Marts that understand your application and access information directly from Excel. Create data viewers once that will then take parameters to cater for varied requests. Custom SQLs are automatically created on the fly and data returned as spreadsheets in real-time.

Immediately report and present application data securely from any database or ERP (IBM DB2, MS SQL, Oracle, or SAP). With D4E apps linked directly to the database tables, you can report on any details as they are changed or become available from the production system. Change the reports as appropriate if new data calls for it.

D4E is for business users because it provides business intelligence and enterprise reporting capabilities that inter-operate with MS Office. D4E integrates with Office Ribbon menu options and toolbars to create simple spreadsheets. You can create D4E apps with SQL previously written for any database and see them all in your Ribbon menu and toolbars. Because it can be deployed to all desktops with Office, the same proven tool can cater for a wide range of reporting requirements by end-users.


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


Sales Managers


As a Sales Manager responsible for large clients and intermediaries, do you require the capture and upload of voluminous data for quoting and closing - such as details of client properties required to calculate price? Wouldn't you like to have a secure way for your intermediaries and clients to do this for you accurately, efficiently and fully integrated wiih MS Office, without exposing your systems and data to compromised SQL code in your templates.
 
Many Sales Manages today use some form of Excel upload templates to capture customer information used to calculate prices to be more flexible and competitive. These templates must be designed to be secured and not contain SQL code that can be compromised. Any SQL code to upload must be found only within the D4E session when inside the organization. The MS Excel templates therefore contain only local validation macros and helper functions that do not compromise central data.
 
D4E provides the Sales Manager a way to create a secure Excel uploader, by providing SQL code within add-ins installed only on authorised PCs. Data templates can be utilised outside the organisation; but when submitted to the back-office, the SQL code in D4E add-ins can access the data templates to upload data, just as easily as if the SQL codes were embedded in the templates.