Apac
  • Home
  • CXO Insights
  • CIO Views
  • News
  • Conferences
  • Newsletter
  • Whitepapers
  • About us
Apac
  • Admired Tech

    Agile

    AI Healthcare

    Artificial Intelligence

    Augmented Reality

    Aviation

    Big Data

    Blockchain

    Cloud

    Cryptocurrency

    Cyber Security

    DevOps

    Digital Transformation

    Drone

    HPC

    Infrared

    Internet of Things

    IT Services

    Marine Tech

    Networking

    PropTech

    Remote Work

    Robotics

    Scheduling Software

    Sensor Tech

    Simulation

    Smart City

    Software Testing

    Startup

    Storage

    Unified Communication

    Web Development

    Wireless

  • Automotive

    Banking

    Capital Market

    Construction

    E-Commerce

    Education

    FinTech

    Food and Beverages

    Gov and Public

    Healthcare

    Insurance

    Legal

    Logistics

    Manufacturing

    Media and Entertainment

    Metals and Mining

    Pharma and Life Science

    Retail

    Sports

    Travel and Hospitality

  • CISCO

    Google

    IBM

    Microsoft

    Oracle

    Salesforce

    SAP

    ServiceNow

  • Business Intelligence

    CEM

    Cloud-based Planning

    Cognitive

    Collaboration

    Compliance

    Contact Center

    Contact Tracing

    Contactless Payments

    Corporate Finance

    CRM

    Custom Software Development

    Data Center

    Digital Signage

    Enterprise Architecture

    Enterprise Asset Management

    Enterprise Communications

    Enterprise Contract Management

    Enterprise Performance Management

    ERP

    Facility Management

    Field Service

    Fleet Management

    Gamification

    HR Technology

    IT Infrastructure

    IT Service Management

    Managed Services

    PLM

    Procurement

    Product Management

    Project Management

    RegTech

    Revenue Management

    Sales Tech

Menu
    • Oracle
    • CISCO
    • Collaboration
    • Compliance
    • Contact Center
    • Healthcare
    • IT Service Management
    • Microsoft
    • Retail
    • MORE
    #

    Apac CIO Outlook Weekly Brief

    ×

    Be first to read the latest tech news, Industry Leader's Insights, and CIO interviews of medium and large enterprises exclusively from Apac CIO Outlook

    Subscribe

    loading

    THANK YOU FOR SUBSCRIBING

    • Home
    • Oracle
    • Vendor
    • Data Mart For Excel
    Previous
    Next

    Data Mart for Excel: Fostering Progress through Data Discovery

    Dr. Antonio Elinon,Managing Director, Data Mart for ExcelDr. Antonio Elinon, Managing Director

    The database could arguably be considered as the pinnacle of business technology and has aided many a company in sorting their business clutter and managing their data. The excel database has been a popular draw amongst companies of all verticals. Since its inception in 1993 by Microsoft many IT companies have taken it upon themselves to customise the software and its applications to optimize its use and derive better results from the software. Data Mart for Excel is one such company that has been at the forefront of delivering excel database related services to the corporate sector for over half a decade. The company first took shape as a compilation of mainframe tools that aided in the extraction of DB2 files which were further processed into excel files in one easy to use process. This method helped the company garner huge success early on as it enabled accountants to analyse and manipulate mainframe data using powerful excel functions.

    Despite its early success, the tool’s major function which was limited to pulling from mainframe and pushing to exchange, lost its charm amongst users who favoured an excel based tool that could interact with the oracle database to derive data directly. After several modifications on the original database tool, Data Mart launched D4E which was completely excel based and enabled them to extract data directly from the Oracle e-Business suite applications and related databases via OBDC connectivity. “As a modern tool, it uses Excel ribbons and add-in VBA code to deliver functionality without embedding any user defined formulas or code in user spreadsheets,” elaborates Antonio Elinon, Managing Director, Data Mart for Excel.

    The D4E tool was a landmark achievement for accounting technology as it changed the way the accounting process was handled. The tool provided financial control over accounting data through the add-in based extract capability rendered by the D4E. Despite its various advantages D4E is not invulnerable to the threat of becoming obsolete and incapable of coping with the demand for further financial control introduced by SOX and other regulations. To cope with the standards suggested by these regulations, Data Mart aligns to the latest excel versions to ensure that D4E users are able adapt to the financial controls while reaping the benefits of optimized excel services. The automation UDA’s is one of the company’s core competencies and has been instrumental in communicating the various aspects of User Developed Applications to the consumers. Data Mart’s proficiency in delivering an excel tool that is user-friendly, powerful and effective has made the company a top draw in the market amongst consumers who seek to procure excel services.


    Data Mart stands out from its industry peers through its focus on speed and efficiency in delivering excel data directly to the end consumers thereby providing full transparency



    Data Mart stands out from its industry peers through its focus on speed and efficiency in delivering excel data directly to the end consumers thereby providing full transparency. “D4E is unique in how it focuses on turning Excel into a true apps system, where each app is a complete data mart delivering corporate data directly to Excel and into the finger tips of accountants,” elaborates Elinon. This has earned the company, the loyalty of long term clients who prefer the ease and comfort offered by D4E’s services for all their excel needs. Even after 5 years the flexibility provided by multiple wild card parameters, has allowed the D4E app tools to remain the favoured extract tool of choice, says Elinon. Having cemented its position well in the market, Data Mart plans to maintain its modern approach of using Excel ribbon menus and add-ins to maintain a steady growth aligned with the growth of Excel usage within the accounting space.
    Previous
    Next
    Share this Article: Tweet
    2016

    I agree We use cookies on this website to enhance your user experience. By clicking any link on this page you are giving your consent for us to set cookies. More info

    CIO Speaks

    • Cloud Computing: Pharma Takes the Plunge

      Andy Newsom, SVP & CIO, CSL Behring

      WiFi 6, 5G and the Internet of Things (IoT)

      Mark Badal, CIO, IT&E

      In Augmented Reality, Size Matters

      Jason Blackman, CIO, Carsales.Com

      Enhancing Customers

      Marc A. Hamer, VP & CIO, Babcock & Wilcox Enterprises, Inc.

      Cloud or On-Premise? When Would The Question End?

      Kevin Soh, CIO and Director, e-Strategies, BH Global Corporation

      Responsible AI: The Human-Machine Symbiosis

      Sal Cucchiara, CIO & Head Of Wealth Management Technology, Morgan Stanley

    • Asian Development Bank: Using Emerging Digital Technologies for the Common Good

      Shirin Hamid, CIO, & CTO, Asian Development Bank

      Diversity and Inclusion can Drive Better Solutions for Clients and Employee Engagement

      Linda K. Lannen, CIO & Sr. VP, Kleinfelder

      Cyber Security - Integrated enterprise approach required to address the multifaceted challenges

      Sumit Puri, CIO, Max Healthcare

      The Great Tech Arms Race: How Changing Consumer Behaviour and Expectation is Driving Ecommerce Transformation

      Brett Raven, CIO, Big Red Group

      Relying On Technologies To Transform Data Into Information

      Mark Ohlund, CIO & Sr. V.P., Armada Supply Chain Solution

      3D Printing Requires Wildly Different Thinking

      James MacLennan, SVP & CIO, IDEX Corporation

    Copyright © 2021 APAC CIOoutlook. All rights reserved. Registration on or use of this site constitutes acceptance of our Terms of Use and Privacy Policy  |  Sitemap |  Subscribe

    follow on linkedinfollow on twitter follow on rss
    This content is copyright protected

    However, if you would like to share the information in this article, you may use the link below:

    https://oracle.apacciooutlook.com/vendor/data-mart-for-excel-fostering-progress-through-data-discovery-cid-286-mid-16.html