DATA MART FOR EXCEL (D4E SQL)
See today’s numbers instantly with real-time flash reports that support faster, more confident business decisions.
Run reconciliations in seconds and close your books faster with flash reporting that delivers instant accuracy before data changes.
BoBot - your AI Agent inside Excel - knows what's happened, plans what's next, and turns plain English and images into runnable SQL, RestAPI or Excel action (using VBA).
E.g., "helpme using SQL create sales by product last 12 months"
"helpme analyse current sheet for next steps"
"helpme using VBA find sheet with sales summary and save to downloads folder"
"helpme using API get business partners from SAP"
"helpme using logs explain why SAP call failed?"
D4E SQL replaces unmanaged spreadsheets with a governed, compiled, centrally managed framework that runs inside Microsoft 365 — not as a source system, but as a flash-reporting and validation layer on top of governed platforms. Existing Excel models, SQL routines, and Power BI workflows can be re-platformed into a consistent, auditable environment that remains easy to run from the Excel ribbon. By standardising logic, automating data access, and removing manual copy/paste, D4E SQL reduces EUC risk and supports CPS 230 objectives by improving transparency, repeatability, and governance across Excel-based analysis while securely accessing ODBC/JDBC/REST APIs (Oracle, DB2, SQL Server, SAP, cloud services).
Google Sheets™ is a trademark of Google LLC.
Microsoft Excel™ and Microsoft 365™ are trademarks of the Microsoft group of companies.
AI Agent Mode – Any user simply describes the Data Action they need in plain English - D4E generates and runs it.
Classic Mode – Developers create secure Data Actions; business users run them instantly via menus.
Decide with confidence using flash reports that give real-time answers instead of waiting for BI or DWH refreshes.
Try D4E today - get flash reports running in minutes.
Enterprise Edition (Paid) unlocks powerful features like scheduling of flash reports, macro automation, secure back-end execution, and AI Agent workflows. Community Edition (Free) provides all advanced features with monthly limits, but will always let developers build and test SQL in EDIT mode, while business users interact via menu-driven RUN mode.
Build secure queries once and let business users self-serve through flash reporting, cutting down ad-hoc requests.
Data Actions are reusable building blocks, stored in Excel sheets, generated by D4E AI (or by developers manually). They include instant flash reports, ad-hoc reports, complete SQL queries, REST/API calls, JDBC connectors, macros, and Excel/VBA/Python automations. Since VBA can call any API or run scripts, just describe in plain English and AI builds a powerful Data Action.
Watch the videos to see how D4E turns SQL into scalable, self-service apps for Finance, Operations and beyond.
AI Flash Reports in Excel - instant answers, not 15-minute BI or DWH refreshes.
When every minute matters, D4E delivers answers from live product systems directly inside Excel.
D4E SQL is a self-service analytics platform inside Excel, combining AI-powered agents with a unique two-tiered collaboration workflow that bridges IT and business. It complements structured, governed BI platforms like Power BI - and the upcoming Copilot Agent Mode on Windows - by delivering true flash reports — preliminary financial and operational summaries — and ad-hoc reports for one-off business questions, all directly in Excel, with:
+61 (0) 418 217 114
Caratrel Consultants Pty Ltd ©2025 All Rights Reserved. (All names and trademarks are the property of their respective owners.)
DATA MART FOR EXCEL (D4E SQL)
FREE SUPPORT