|
|
OVERVIEW |
|
1.
|
Is
Speedminer able to provide improved access of data from many
databases within the organization?
|
|
2.
|
Is
it able to retrieve data that is required?
|
|
3.
|
Does
it allow more time to analyze and act on data than spending
time on compiling data from disparate systems?
|
|
4.
|
Is
it able to quickly answer a series of questions, based on
the answer to the previous answer?
|
|
5.
|
Does
it support reduction in paper reporting and administration?
|
|
6.
|
Does
it support general financial analysis for the organization
easily?
|
|
7.
|
Is
minimal amount of administrative labor needed to maintain
the Data Warehouse?
|
|
8.
|
Does
it support both strategic and tactical or 'active' decision
support?
|
|
9.
|
Does
it provide a single enterprise view of business to allow previously
hidden insights to emerge, enabling consistent decision making
across the enterprise?
|
|
10.
|
Does
it serve as a historical store of strategic information, with
the history relating to either the data or its relationships?
|
| |
ETL |
|
11.
|
Is
it able to interface to popular databases and text files
for loading of data?
|
|
12.
|
Does
it support multiple ETL servers to allow load sharing and
all data will be consolidated to a centralized data warehouse
(OLAP database) server?
|
|
13.
|
Does
it support less time spent on data reconciliation and problem
resolution?
|
|
14.
|
Is
it able to perform fast ETL especially on loading Text File
(Please indicate the performance of loading 1 million records
from Text File, each record at 1 kb and indicate the hardware
including RAM, processor speed and hard disk specs)?
|
|
15.
|
Is
it able to support incremental delta load using Ascending
Index and Custom Log and Full Log methods?
|
|
16.
|
Does
it support pre and post ETL cleansing?
|
|
17.
|
Is
it able to support real time or near real time Data Warehouse?
|
|
18.
|
Will
user be able to use the Data Warehouse system while ETL job
is in process?
|
|
19.
|
Does
it have automatic support of Slowly Changing Dimension without
any coding?
|
|
20.
|
Does
it support auto consolidation of multiple sites of same database
structure into a single consolidated structure without coding?
|
|
21.
|
Does
it provide characteristic calls for a modeling technique that
easily supports incorporation of history?
|
|
22.
|
Does
it provide characteristic calls for a modeling technique that
support subject-orientation and provide the flexibility to
integrate data from additional sources over time.
|
|
23.
|
Does
it serve as the source of information that is subsequently
delivered to the data marts? The data marts in question may
be used for exploration, data mining, managed queries or online
analytical processing
|
| |
OLAP |
|
24.
|
Is
the data warehouse CUBE based?
|
|
25.
|
Explain
the structure of data storage.
|
|
26.
|
Does
Speedminer need to build and maintain FACT tables and DIMENSION
tables?
|
|
27.
|
Is
Speedminer an OLAP client?
|
|
28.
|
What
is the performance for storing 1,000,000 records of 200 kb
each (total of about 200 MB) on a normal Pentium IV PC with
EIDE hard disk?
|
|
29.
|
Is
the OLAP database able to scale up to Penta Byte (1024 Giga
Bytes) of data?
|
|
30.
|
Is
it able to support multi-tier architecture where a centralized
database is connected to multiple business servers, and the
client will only be connected to business server and not database
server directly?
|
|
31.
|
Is
it able to support distributed database where the OLAP database
is broken into multiple smaller database distributed between
multiple OLAP database servers for load balancing purpose.
The distributed databases are mapped to each other to form
the complete OLAP database.
|
|
32.
|
Is
it able to provide data retrieval facility whereby this function
can identify and obtain only the changed date to be transferred
from operational systems to the OLAP database?
|
|
33.
|
Able
to support real time data warehouse update.
|
|
34.
|
Easily
accommodates changes to the business rules that includes new
data elements, shifts in hierarchical relationships or changes
to relationships.
|
| |
BUSINESS
TERMINOLOGY SETUP |
|
35.
|
Able
to support Snowflakes, and Many-to-Many data relationship. |
|
36.
|
Does
it skip missing levels (support ragged dimensions)?
|
| |
MULTIDIMENSIONAL
VIEWING/DETAIL LISTING |
|
37.
|
Is
it able to perform "Slice and Dice" data? This shall
include the capability to quickly and easily view data along
multiple dimensions.
|
|
38.
|
Is
it able to "Drill Down", which allows the user to
view greater levels of detail? The user should also able to
navigate from summary level to detail that makes up the summary
level.
|
|
39.
|
From
detail level, is it able to traverse to related records, to
traverse to parent record, or to list the entire child records
according to the operation data architecture?
|
|
40.
|
Is
it able to support export of charts to vector graphics like
SVG?
|
|
41.
|
Is
it able to print all charts with the option to save to clipboard
or to file in various windows format including BMP and direct
the chart to printer?
|
|
42.
|
Is
it able to support pictures and attach pictures to records?
|
| |
ANALYZER/CHARTING/QUERY |
|
43.
|
Is
it able to support exception data highlighting, aggregate
function customization, zero suppression for row and/or column,
null replacement, charts formatting etc?
|
|
44.
|
Is
it able to produce various chart type including bar chart,
Gantt chart, line chart, pie chart, Area chart, curve chart,
cube chart?
|
|
45.
|
Does
it have web interface for analysis and reports?
|
|
46.
|
Is
it able to cater for the formatting of currencies, number,
and various date format (long date, medium date, detail date,
short date format)?
|
|
47.
|
Is
it able to support Top/Bottom records based on any measure
and provide option to group remainder records into "Others"
category?
|
|
48.
|
Is
it able to provide Grand Total, Overall Average and many more
Statistical Functions for columns and rows?
|
|
49.
|
Does
it support analytical functionalities, bubble-up exceptions,
ranking, sorting, restriction result by data range, drag and
drop, attach note cells?
|
|
50.
|
Does
it allow users to define temporary measures and computation
for a particular report or analysis and will the result of
the calculation be performed upon execution?
|
|
51.
|
Is
it able to apply resolution of rounding differences?
|
|
52.
|
Is
it able to merge analysis from different subject area?
|
|
53.
|
Does
it have the capability to save commonly used queries for quick
retrieval and execution?
|
|
54.
|
Is
it able to toggle between charts and cross tabs easily?
|
|
55.
|
Does
it allow single row, single column or multi-dimensional data
charting?
|
|
56.
|
Is
it able to support Outcomes Analysis, Cross Selling Analysis,
Time Series Analysis, Trend Analysis etc.?
|
|
57.
|
Is
it able to support user defined formula for calculation?
|
|
58.
|
Is
it able to perform forecasting using moving average, trend
adjusted exponential smoothing and custom written algorithm?
|
|
59.
|
Is
it able to perform statistical calculations like variance,
standard deviation, percentage etc?
|
|
60.
|
Is
it able to perform summary functions like sum, average, minimum,
maximum, count, etc.?
|
|
61.
|
Is
it able to extend the summary and statistical calculations
with custom written mathematical functions?
|
|
62.
|
Is
the formula able to incorporate 'if-else' logic to produce
results based on conditions and allow the establishment of
conditions to determine when a formula will be applied and
will the store and share formula be able to incorporate 'for-loop'
logic to facilitate repetition operation?
|
|
63.
|
Is
it able to provide support for ad-hoc queries and reports
with average of not more than 2 seconds response time
|
|
64.
|
Is
it able to support VB scripting.
|
|
65.
|
Is
it able to return text? (e.g. if value above 90 returns as
'excellent').
|
|
66.
|
Include
impact analysis-objects impacted by change?
|
| |
OFFICE
AUTOMATION SUPPORT |
|
67.
|
Is
it able to transfer all query results and detail listing into
a Microsoft Excel spreadsheet, with the support of template
and the option to export (or not to export) the column header?
|
|
68.
|
Is
it able to export the report to PDF with support of chart
and pictures?
|
|
69.
|
Is
it able to export query results and detail listing to MS Word?
|
|
70.
|
Does
it interface to generate E-Mail?
|
| |
WORKFLOW |
|
71.
|
Is
it able to support slide presentation showing OLAP analysis
and reports dynamically.
|
| |
SCHEDULER |
|
72.
|
Schedule
process can run overnight?
|
| |
DIMENSIONS
AND MEASURES |
|
73.
|
Is
it able to define various time dimensions to store data based
on units of time frame - year, quarter, year-quarter, month,
year-month (period), week count, days of week, and day.
|
|
74.
|
Is
it able to create views ("Abstract Dimension") from
query and able to mix and use view with dimension in queries?
|
|
75.
|
Is
it able to group numeric and date/time items into range (e.g.
'below 1000', '1000 to 2000' with the option to include or
exclude the boundary values.
|
|
76.
|
Is
it able to setup dimension like YTD (year to date), MTD (month
to date) based on another time/date dimension and when analysed
with such dimension only records that fall into YTD or MTD
will be listed?
|
|
77.
|
Is
it able to arbitrary time span (e.g. date brackets like 30
days, 60-90 days, 1 to 2 years) dimension?
|
|
78.
|
How
is the performance of query on date bracket dimensions (arbitrary
time span) as compared to query on normal dimension?
|
| |
ENTERPRISE
REPORTER |
|
79.
|
Does
Enterprise Reporter support analysis reports (BI reports)
as well as normal reports (listing)?
|
|
80.
|
Is
it able to provide a common shared repository whereby users
can access the shared repository for reports and queries at
anywhere, anytime?
|
|
81.
|
Is
it able to provide reporting in a variety of flexible formats
like MS Excel, MS Word, delimitered text file, PDF, and HTML?
|
|
82.
|
Is
it able to support export reports to vector graphics like
SVG?
|
|
83.
|
Is
it able to support export reports to XML format?
|
|
84.
|
Is
it able to save reports and queries at any point in time?
|
|
85.
|
Is
it able to support mix Multi-dimensional Queries and Standard
SQL in a single report of analysis?
|
|
86.
|
Portal
generation that includes HTML report?
|
|
|
Provide
details of data models and interfaces that can be used for
external reporting and warehousing of data.
|
|
88.
|
Describe
the tools/methods used for persistently storing reporting
data.
|
|
89.
|
Describe
the tools/methods used to allow external reporting/analysis
tools (e.g. Crystal Reports) to access reporting data.
|
|
90.
|
Describe
the tools/methods used to access real time reporting data.
|
| |
SEARCH
ENGINE AND EXTENDED DATA CAPTURING |
|
91.
|
Is
it able to create custom form to search for information in
Operation Data Store (ODS) using Dimension as filter?
|
|
92.
|
Is
it able to create custom form to capture extended data not
available from the data source?
|
|
93.
|
Does
it allow report authors to intuitively incorporate several
sub-reports within a main report?
|
| |
DASHBOARD
/ VISUALIZER |
|
94.
|
Is
it able to support dashboard, and support frame (HTML frame
like) to show dashboard within another dashboard?
|
|
95.
|
Is
it able to support Speedometer, pie, bar and many other chart
types, images and pictures, many other common windows web-based
components like list box, text box, radio buttons etc?
|
|
96.
|
Is
it able to show reports and analysis of results on the dashboard
and allow drill down of the report?
|
|
97.
|
Is
it able to display Key Performance Indicators (KPIs) in the
form of text, speedometer, as well as images according to
the performance level?
|
|
98.
|
Does
it allow display of Hyperlinks to web sites or windows files
on dashboard?
|
| |
INTELLIGENCE
ALERT AND SCORECARD |
|
99.
|
Is
it able to automatically and intelligently create alerts to
user based on KPI threshold value?
|
|
100.
|
Is
it able to setup Key Performance Indicator as well as color,
font, alignment and image representation for different value
ranges?
|
|
101.
|
Does
it support drill down of KPI into the lower components (e.g.
From Country Sales down to State Performance to identify the
major contribution of the performance), even down to the detail
transaction records level?
|
|
102.
|
Is
it able to support Balance Scorecard with integration to Dashboards?
|
| |
SECURITY
AND TRANSLATION |
|
103.
|
Does
it support multilevel security for restricted data access?
|
|
104.
|
Is
it able to control user access security down to record level
(which record is accessible) and field level?
|
|
105.
|
Is
it able to create a subset of data for the access of different
user group?
|
|
106.
|
Is
there security and restriction on detail listing record to
be displayed for user group access?
|
|
107.
|
Does
the Dashboard show only objects accessible by the user, and
hide other objects that require higher access level than that,
which is assigned to the user?
|
|
108.
|
Will
the user be given access right to delete/create/modify objects
stored in folders, which include dashboards, KPIs, and reports?
|
|
109.
|
Is
it able to support Translation and Unicode (e.g. Bahasa Malaysia/French
/Thai /Arabic version etc.)?
|
|
110.
|
Does
it support password scans by company, by department/division,
menu, function (e.g. view, add, change, delete) by dimension,
by level and by cell?
|
|
111.
|
Is
it able to organize reports under folders, and able to attach
security to folders?
|
| |
USER
FRIENDLINESS |
|
112.
|
What
is the Front-end tool -Is it User friendly?
|
| |
TRAINING |
|
113.
|
Is
it simple, initiative interface with minimal training to effectively
utilize the system?
|
| |
SYSTEM
REQUIREMENTS |
|
114.
|
What
is the infrastructure that is required to install the tool,
i.e. hardware requirements, OS versions and upgrade compatibility?
|
|
115.
|
What
is the capability of handling real time data? If the tool
is capable of handling real time, specify the volume and the
technology used to handle real time, i.e. bi-indexing.
|
| |
DEVELOPMENT
TOOLS |
|
116.
|
What
are the development tools used to build application?
|
| |
SMS |
|
117.
|
Can the
system support SMS?
|
|
|
OTHERS |
|
118.
|
Is
Speedminer API enabled, web based for the entire application,
support .NET web services and JAVA web services?
|
|
119.
|
Does
the system support document management, web mail and BLOG?
|
|
120.
|
Can
the result of analysis be placed on the map according to location?
|
|
121.
|
Can
the system support creation of Venn diagram from queries?
|
| |
ANSOWERS |
|
1.
|
Is
Speedminer able to provide improved access of data from
many databases within the organization?
Yes, Speedminer consolidates information from various data
source, various platform and format to form the Operation
Data Store (ODS). ODS represent the single version of truth
for the entire organization and all reports and analysis
can be easily retrieved from here using very user friendly
tools like Speed Analyzer and Speed Visualizer.
|
|
2.
|
Is
it able to retrieve data that is required?
Yes, unlike traditional
reporting where IT department has to provide data to managers,
and managers will be restricted to the information given to
make a day to day decision, Speedminer gives managers an easy
way to retrieve the data they need/want, and display it in
whatever format desired.
|
|
3.
|
Does
it allow more time to analyze and act on data than spending
time on compiling data from disparate systems?
Yes, the most complex and
tedious work of integration will be handled by Speedminer
to produce the Operation Data Store (ODS) and users will not
need to worry about the accuracy of the data, or how to integrate
the information, instead they can go ahead to analyze the
information.
|
|
4.
|
Is
it able to quickly answer a series of questions, based on
the answer to the previous answer?
Yes, Speedminer has the
most complete Drill Down range of option from common drill
down to drill component and drill report, which is only available
in Speedminer. All these options will allow users to get answers
quicker, easier and accurately from the system.
|
|
5.
|
Does
it support reduction in paper reporting and administration?
Yes, traditional reporting
emphasizes printing on paper and further queries by the user
may end up in the generation of additional reports and printing.
Speedminer allows ad-hoc query and generation of reports on
the fly, and allows saving of report when it satisfies the
requirement. Reports can be viewed on-line and shared with
other user group within the organization, thus reducing paper
reporting and administration.
|
|
6.
|
Does
it support general financial analysis for the organization
easily?
Yes, Speedminer comes with
many analysis including forecasting, calculation of mean,
medium, variance, and many statistical functions.
|
|
7.
|
Is
minimal amount of administrative labor needed to maintain
the Data Warehouse?
Yes, Speedminer allows administrator
to manage the Data Warehouse from anywhere, anytime. However,
most Speedminer sites show that it requires minimum maintenance
from the users.
|
|
|