|
Speedminer DW & BPM has unique
features to automatically consolidate multiple tables,
multiple databases or multiple files into a single environment.
The consolidated table has a new "Site ID"
field to record the data sources. Database consolidation,
which normally takes much time to design and implement
is now only a click away! You can now easily analyze
the organization's performance across all subsidiaries
or focus just on a particular business area.
Many large corporations have the problem
of producing consolidated reports of their subsidiaries.
As individual subsidiaries may have its own system running
on different platforms, the traditional approach is
to allow each subsidiary to submit its reports in MS
Excel format, and the HQ will manually put these together
to produce the consolidated report. This is time consuming,
prone to error, without any flexibility of drilling
down on the information, and consumes much resources.
Therefore such consolidated reports are produced quarterly,
half yearly or annually; a daily consolidated report
will not be possible without a tool such as Speedminer.
|
|
"We selected
Speedminer as the Business Intelligence and Data Mining
tool on InterSystem's Caché database, because
of its unrivalled functionalities, analytical flexibility,
and dynamic interfaces that could automatically integrate
and consolidate our databases that sit on various operating
systems and transactional databases easily without any
programming or even SQL coding. And the team in Speedminer
is able to deliver a strategic support system in the
form of the afore mentioned at the most efficient way
that enable us to complete the project with least resource
and thus cut down implementation cost to minimum (most
competitive overall pricing)."
-- Mr. Choo Kah Yean
Senior Manager
(Corporate and Finance Planning)
IOI Corporation Ltd. |
IOI
Corporation Ltd.
IOI Corporation Ltd. is the world's
largest oil-palm grower listed in the first board in
Malaysia's Stock Exchange, with an annual revenue of
over RM 6 billion and hundreds of subsidiary companies
involved in Plantation, Property, Oleo-Chemical, Specialty
Oils & Fats, Leisure and others. The biggest challenge
of IOI is to consolidate the data of various subsidiaries
to automatically produce consolidated Financial Statement
(P&L, Balance Sheet, and Cash Flow) and other reports
that allows slice and dice. All statements and reports
must be updated daily.
During the early BI initiative in
IOI, one of the best analytical tool was presented to
the board, but as the tool was too complicated for business
users, it was rejected.
As the business grew fast, IOI started
to look for BI tools again. Two vendors were selected
for the Proof of Concept - Speedminer DW & BPM and
another well known OLAP vendor from US. Speedminer DW
& BPM was able to complete all the analysis requested
with 1 resource in 1 month. This included the Finance
module, Customer Service, Property, and Sales. The other
vendor was only able to complete a portion of the Customer
Service with 4 technical resources, in 1 month, due
to time constraint in designing and building the CUBE
for customer service alone.
The entire implementation for Phase
I took around 12 man months. This included hundreds
of complex analysis, KPIs, dashboards, as well as consolidation
of data from various subsidiaries across different states.
In Phase II, IOI's IT staffs were more well versed with
the system and therefore took the lead to implement
it for other business areas in IOI. As IOI is a large
corporation, we see continuous expansion of use of Speedminer
DW & BPM.
|
.gif){kind=spacer}
.gif){kind=spacer}
