|
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 |
