D4E is installed as a secure COM Add-in (.dll) environment hosted in MS Excel with Ribbon functions, where users can execute previously converted end-user computing (EUC) tools as an integrated computing system. All compiled objects created under D4E are managed once only under a single enterprise control (e.g., single LAN id). As a development environment, D4E extends SQL's functional programming concepts by implementing higher-order functions.
By using industry standard ODBC, D4E users and report developers can access complete databases and warehouses without going outside Excel. Users who will benefit greatly from D4E can be accountants, business analysts, data analysts, testers, business users, sales managers, database administrators, report writers and general knowledge workers.
By being fully hosted in Excel, the users do not see apps or web logons, no "export to Excel", no intermediate steps. By delivering results directly to Excel, high-fidelity customized reports can be generated every month for top management from Oracle eBusiness Suite, SAP Netweaver BW or other General Ledgers.
D4E is a specialist form of Business Intelligence as it does not actually require (but can work with) the traditional BI components of Extract-Transform-Load (ETL) and Data Warehouse schemas, given the existence of ERP's and application databases. Instead, it assumes that the ERP or application database is the primary real-time source of truth and simply provides a data mart facility to directly access the ERP. For Finance and Accounting, this specialist form is also known as Accounting Intelligence. Below are some user types that can benefit from Data Mart for Excel services.
All UDA's and apps will look like the menu options below. Everything is inside Excel- no repetitive going in and out of Excel just to utilise data.
Many enterprises today discourage Excel VBA because of security and maintenance concerns. Fortunately, D4E provides a way to convert your current and future user-developed applications (including Excel VBA, MS Access, SQL) into a security-hardened change-controlled apps repository with each app able to integrate with MS 365 ribbons and menus. As an enterprise-class data discovery tool, it can be used by anyone in the organization who may have a need for an easy-to-use reporting tool and self-service Business Intelligence. The D4E enterprise reporting tool can access enterprise data while inter-operating with MS 365 menus only and without programming assistance.
Replace all Excel/Access UDA's, SQL's, PowerBI M code, and more with D4E Apps. Apps are created using the D4E editor by compiling SQL instructions and other codes; then stored centrally within the secure enterprise environment (apps store). End-users then access the D4E apps store via the D4E connector to produce reports, run dashboards, operate MIS reporting processes, and submit background/ batch processes. All outputs are instantly delivered in MS 365 through Excel integration.
UDA's and apps are defined easily as SQL commands like below:
Did you know with D4E, you can...
DATA Robots FOR EXCELLENCE
A DATA DISCOVERY TOOL WITH EXCELLENT MS 365 INTEGRATION
Caratrel Consultants Pty Ltd © All Rights Reserved.
DATA MART FOR EXCEL
+61 (0) 418 217 114