ABOUT US


OUR COMPANY
Data Mart for Excel (D4E SQL) is developed and maintained by Caratrel Consultants Pty Ltd, an independent Australian consulting firm providing IT consulting services since 1995.

Caratrel Consultants has worked extensively in enterprise data environments and ERP infrastructures, including platforms such as Oracle Database, IBM DB2, Microsoft SQL Server, SAP R/3, Oracle E-Business Suite, and other enterprise financial systems.

Through these engagements the firm has provided consulting services to large organizations including:

  1. Publicly listed companies
  2. Insurance organizations
  3. Banking institutions


Our work has focused on enterprise reporting systems, data mart design, and the integration of operational data with financial and analytical systems used by business users.

This experience led to the development of tools designed to simplify the way business users interact with enterprise data.

ORIGIN OF DATA MART FOR EXCEL
Data Mart for Excel was developed to address a practical problem frequently encountered in enterprise environments.

Business users often rely on Microsoft Excel as a convenient interface for analyzing operational and financial data. At the same time, enterprise data is typically stored in relational databases that require SQL expertise and specialized tools to access.

D4E was created to bridge this gap by allowing Excel to operate as a structured interface for retrieving and working with data stored in enterprise systems.


By retrieving data from multiple sources across the enterprise, the system effectively created a consolidated working dataset that users could analyze within Excel. In practice this environment functioned in a similar way to a data mart, where data from different operational systems is brought together to support reporting and analysis.

For this reason the system was named Data Mart for Excel, reflecting its role as a practical mechanism for assembling and analyzing enterprise data within the Excel environment.

The product has evolved gradually through years of consulting experience and experimentation with ways to make database queries more accessible and flexible for business users while maintaining the discipline required for enterprise data environments.

TECHNOLOGY ORIGINS
The core technology used in Data Mart for Excel is based on earlier work by the authors in compiler design and programming language interpretation.

Prior to the development of D4E SQL, the authors implemented parsing and recursion technologies while experimenting with recursive implementations of programming languages such as FORTRAN. These experiments explored how structured commands could be parsed, interpreted and combined dynamically.

The concepts developed during this earlier academic research work later formed the basis for the parsing and substitution mechanisms used within Data Mart for Excel.

These mechanisms allow SQL statements to be dynamically composed and parameterized through structured substitution, enabling users to create flexible and reusable queries that can adapt to different reporting needs without rewriting the underlying SQL.

As a result, Data Mart for Excel operates not merely as an SQL execution tool, but as a self-service environment where powerful parameterized queries can be constructed and reused by both developers and business users.

This technology was developed independently and forms the foundation of the D4E software platform today.

INTELLECTUAL PROPERTY
Data Mart for Excel (D4E SQL) and the associated software technologies are proprietary software developed and owned by Caratrel Consultants Pty Ltd.

The software was developed independently by the authors and does not contain proprietary code from client systems or third-party enterprise software platforms.

The ideas and mechanisms used within the product evolved from earlier internal research and practical consulting experience in enterprise reporting and database environments.

FURTHER INFORMATION
For more information about Data Mart for Excel, please contact us through the contact page.

Caratrel Consultants Pty Ltd
ABN 99 063 223 923
Sydney, NSW 2000
Australia