Moss L.T., Atre S. Business intelligence roadmap: The complete project lifecycle for decision-support applications
Подождите немного. Документ загружается.
16. Release Evaluation
[ Team LiB ]
北斗成功社区 BeiDouWeb.com 教育音视频/电子书/实用资料文档/励志音乐影视 仅供免费试用/版权原著所有
491/631
[ Team LiB ]
Chapter Twenty. Task/Subtask
Matrix
Development Step
Activities
Tasks/Subtasks
1. Business Case
Assessment
1. Determine the business
need
Identify the business
need (business problem
or business opportunity)
Determine current
financial consequences of
the business need (lost
revenue, lost
opportunity, competition,
obsolescence, cost
overrun)
2. Assess the current
decision-support system
(DSS) solutions
Assess current usage of
the existing DSS
Determine the
shortcomings of the
existing DSS (different
keys, data redundancy,
inconsistencies, difficult
to access)
Perform gap analysis,
identifying which
business questions are
being answered by the
existing DSS and which
ones are not
北斗成功社区 BeiDouWeb.com 教育音视频/电子书/实用资料文档/励志音乐影视 仅供免费试用/版权原著所有
492/631
3. Assess the operational
sources and procedures
Assess the data quality of
operational systems in
terms of:
- File structures
and database
structures
- Content (domain)
of source data
elements
Assess the current data
movement in terms of:
- Data entry
- Data extraction
- Data
manipulation
- Data duplication
Assess current
operational procedures in
terms of:
- Poor data entry
practices
- Lack of edit
checks
- Defective
program code
- Lack of training
4. Assess the competitors'
BI decision-support
initiatives
Determine the
competitors' successes
and failures with their BI
decision-support
initiatives, especially
their data mining
initiatives
Determine whether your
competitors gained
market advantages, such
as more sales, new
customers, or innovative
products
北斗成功社区 BeiDouWeb.com 教育音视频/电子书/实用资料文档/励志音乐影视 仅供免费试用/版权原著所有
493/631
5. Determine the BI
application objectives
Identify the strategic
business goals of the
organization
Define the overall BI
decision-support
objectives
Define the project-
specific BI application
objectives
Match the overall BI
decision-support
objectives to the
strategic business goals
Match the project-specific
BI application objectives
to the strategic business
goals
6. Propose a BI solution
Review current DSS
solutions
Review DSS gap analysis
Determine how the BI
application will lessen the
business pain
Create a high-level
architecture for the
proposed BI solution
Consolidate and prioritize
unfulfilled requirements
from previous BI projects
with new requirements
Create a high-level
(conceptual) logical data
model
北斗成功社区 BeiDouWeb.com 教育音视频/电子书/实用资料文档/励志音乐影视 仅供免费试用/版权原著所有
494/631
7. Perform a cost-benefit
analysis
Determine costs
Determine benefits:
- Identify tangible
benefits
- Identify
intangible benefits
- Identify short-
term benefits to
the organization
- Identify long-
term benefits to
the organization
Calculate the projected
return on investment
(ROI)
8. Perform a risk
assessment
Create a risk assessment
matrix, listing all
possible BI project risks
in terms of technology,
complexity, integration,
organization, project
team, and financial
investment
Assign weights to the
risks
Rank the risks: low,
medium, or high
Determine the risks
(ramifications) of not
addressing the business
need and not
implementing a BI
solution
北斗成功社区 BeiDouWeb.com 教育音视频/电子书/实用资料文档/励志音乐影视 仅供免费试用/版权原著所有
495/631
9. Write the assessment
report
Write the assessment
report to describe:
- Business need
(business problem
or business
opportunity)
- Lost opportunities
(ramifications of
not addressing the
business need)
- Proposed BI
solution (and
alternative
solutions)
- Cost justification
and expected ROI
- Risk assessment
-
Recommendations
(include
operational
business process
improvements)
Development Step
Step Activities
Tasks/Subtasks
2. Enterprise
Infrastructure
Evaluation
Section A.
Technical
Infrastructure
Evaluation
1. Assess the existing
platform
Review hardware
Review operating
systems
Review middleware,
especially DBMS
gateways
Review custom interfaces
Review network
components and
bandwidth
Review the DBMS
Review tools (CASE, ETL,
OLAP, report writers,
data mining tool)
北斗成功社区 BeiDouWeb.com 教育音视频/电子书/实用资料文档/励志音乐影视 仅供免费试用/版权原著所有
496/631
Review the meta data
repository (if one exists)
Perform gap analysis,
identifying which
platform components
seem adequate and
which ones seem
inadequate
2. Evaluate and select new
products
Identify the product
categories you need to
evaluate (for example,
hardware, middleware,
DBMS, tools)
List all products being
considered for each
category
Itemize your
requirements for the
products
Weigh each product
requirement on a scale of
1 to 10
Rank each product
against the weighted
requirements on a scale
of 0 to 10 (0 means the
product cannot satisfy
the requirement)
Determine the total score
for each product by
multiplying the rank by
the requirement weight
factor
List all vendors of all
products
Itemize your
requirements for the
vendors
Weigh each vendor
requirement on a scale of
1 to 10
Rank each vendor
against the weighted
requirements on a scale
of 0 to 10 (0 means the
北斗成功社区 BeiDouWeb.com 教育音视频/电子书/实用资料文档/励志音乐影视 仅供免费试用/版权原著所有
497/631
vendor cannot satisfy the
requirement)
Determine the total score
for each vendor by
multiplying the rank by
the requirement weight
factor
Evaluate the product
scores and vendor scores
Create a short list of
products and vendors in
each category
Have the products
demonstrated by the
vendors
Choose the final product
in each product category
Obtain business sponsor
approval to license the
products
3. Write the technical
infrastructure assessment
report
Fill in the following
sections of the
assessment report:
- Executive
summary
- Findings about
servers, operating
systems,
middleware,
interfaces, network
and bandwidth,
DBMS, tools, and
meta data
repository
- List of weighted
requirements
- Product scores
- Vendor scores
- Product costs
- Products on the
short list
北斗成功社区 BeiDouWeb.com 教育音视频/电子书/实用资料文档/励志音乐影视 仅供免费试用/版权原著所有
498/631
- Rationale for
selecting or
rejecting products
- Final selection
criteria
4. Expand the current
platform
Order new products
Install new products
Test new products
Train technical staff on
new products
Section B.
Nontechnical
Infrastructure
Evaluation
1. Assess the effectiveness
of existing nontechnical
infrastructure components
Review standards for
data naming,
abbreviations, logical
data modeling, testing,
and reconciliation
Review the use of the
development
methodology
Review estimating
guidelines
Review change-control
procedures
Review issues
management procedures
Review roles and
responsibilities
Review security
processes and guidelines
Review meta data
capture and delivery
processes for business
meta data as well as
technical meta data
Review meta data
repository functionality
Review the process for
merging logical data
models into the
enterprise data model
Review data quality
measures and the
北斗成功社区 BeiDouWeb.com 教育音视频/电子书/实用资料文档/励志音乐影视 仅供免费试用/版权原著所有
499/631
cleansing triage process
Review the service-level
agreement (SLA) process
Review the BI support
function
Review the dispute
resolution process
Review the
communication process
Perform gap analysis,
identifying which
standards, guidelines,
and procedures are
adequate and which ones
are inadequate
2. Write the nontechnical
infrastructure assessment
report
Fill in the following
sections of the
assessment report:
- Executive
summary
- Findings about
inadequate
standards,
guidelines,
procedures, and
processes
-
Recommendations
for nontechnical
infrastructure
changes
- Prioritized
nontechnical
infrastructure
requirements to be
implemented
within the BI
project
- Prioritized
nontechnical
infrastructure
enhancements to
be implemented
outside the BI
project
北斗成功社区 BeiDouWeb.com 教育音视频/电子书/实用资料文档/励志音乐影视 仅供免费试用/版权原著所有
500/631