OLAP vendors hope
to have their OLAP solution running on OLTP architecture.
Why? Simply because OLAP currently requires separate data
modeling and has limitation to support Real Time OLAP, as
data is updated in OLTP and the time gap between the data
updated to OLAP cannot be avoided. The OLAP data modeling
often takes 60 - 70% of the entire Data Warehouse and BI project.
Changes in OLTP design sometimes cause redesign of the OLAP
data model, which is extremely time consuming. The maintenance
effort of OLAP is heavy, and high skill set is required to
be built up within the organization.
Speedminer is the first DW/BI solution
that runs directly on OLTP, Speedminer is not exactly an OLAP
product, however, it provides all functionalities of OLAP
and much more. Best of all, it takes much lesser time to implement,
DOSM is probably
the organization that performs most analysis in the nation.
DOSM stores most data in the country that includes Trade,
Economics, Finance, Population, Agriculture and many other
Censuses. In order to convert the raw data to the final analysis
requested by many government agencies, reporting and analysis
becomes the key task in DOSM. With the constantly changing
reporting requirements, needs of drill down to identify trends
and patterns, alert on exceptional data and complex cleansing
of raw data within a limited time for the various agencies
that require these final reports and analysis, caused DOSM
to look into OLAP and Business Intelligence for solution of
their requirements and needs mentioned.
DOSM has tried out various OLAP tools, but
as the IT Director, Madam Roszaini Omar has mentioned "the
other OLAP solutions require more than 40 days in redesigning
and rebuilding whenever we have new requirement, if we do
not go through this lengthy change, the query will run extremely
A user of the OLAP once mentioned "They
claimed that they have an Ad-Hoc query tool, but whatever
we want to query, we must pre-aggregate first for decent performance,
how can we consider that as Ad-Hoc?"
DOSM iniatiated Speedminer DW & BPM
in August 2005 in Trade Department. The project was very successful,
and the Agriculture Census by the Small Medium Enterprise
With Speedminer's intuitive reporting capabailities,
reports to government agencies are now delivered earlier than
before. As Speedminer is a total web based solution with zero
foot print, DOSM has allowed many government agencies such
as Central Provisional Bank, Inland Revenue Authority, Employee
Provisional Fund and others to directly access Speedminer
DW & BPM reports and analysis via Web browser.
DOSM used to backup historical data
in the tape, but with Speedminer DW & BPM, they are all
made available online. Through the powerful ETL and cleansing
module, Speedminer DW & BPM helps DOSM to track invalid
patterns in information quickly based on historical data and
the business rule entered. For example, inconsistencies in
the patterns that point to fraud error and manipulation can
be detected easily for further actions. Many forwarders who
intentionally enter wrong information to get tax advantage
are discovered using Speedminer.