How To Buy | Solutions | Services | Contact Us
Home
Solutions
Streamline
Consolidate
Roll-Out
More Info
Platforms
CubeGen
Services
Contact Us
About Us
Partners


Java is a trademark of Oracle Corporation. Excel is a trademark of Microsoft Corporation.
Consolidate Information Quickly into MS Excel
Contenlo Quest delivers rapid Return On Investment by delivering Consolidated information from multiple data sources directly into Excel.
The Problem
Microsoft Excel is widely used in companies for a variety of important tasks; preparing reports, forecasting, budgeting, scenario modelling etc. The data required for these tasks will be held in a variety of systems, databases and legacy applications. Getting that information into Excel in the first place can be time consuming and error-prone with the increasing demands for more frequent reporting this is becoming a bottleneck for many organisations. Often the purpose of getting information into Excel is to do a consolidation across Operating Divisions or Group Companies it would save a lot of work if the data could arrive in a consolidated form.
The Questions
  • Would faster capture of information to Excel help your reporting process?
  • Is too much time spent checking that the data in Excel matches the originating system?
  • Would saving time on the reporting cycle be of benefit to your organisation?
  • Would some of the month-end information be useful throughout the month?
The Vision
Quest uses the latest Web Services technology to deliver data directly into Excel. The user clicks on the Quest menu option in Excel and runs the Quest Wizard which allows them to choose the reports they want to run and which data sources they wish to include in the report, the reports are run and the information transmitted to Excel and the spreadsheet is populated. Quest can run multiple queries against multiple data sources simultaneously using multi-threading for fast results. Automating manual processes which involve copying files, copy/paste operations and spreadsheet manipulation removes a lot of chances of errors leading to improved data integrity.

Value Delivered
At a large financial services company Quest’s Excel integration dramatically speeded up Excel reporting and helped shortened the monthly reporting cycle by half from a typical 5 days to just under 2 days with some tasks which previously took a whole day to do being reduced to a minute or so. Quest has delivered the following benefits;
  • Staff no longer have to work weekends.
  • Work on the month-end can start much earlier because it is easy to run the reports, previously they waited until the last minute to avoid having to repeat processes if late invoices were posted etc.
  • Time freed up from reporting can be used for more productive activities.
  • Confidence in working reports much improved and the time previously spent checking that the data in working reports corresponded to the originating system can now be spent checking that the numbers make sense overall!
  • A consolidated view across 20 companies is now available within seconds that just wasn't feasible before.

Detailed Product Information
Platform Support
How To Buy|Solutions|Services|Contact Us
© Contenlo 1998-2017