Business
Intelligence Tools
Need
business intelligence tools for an information management project and
want practical suggestions to ensure rapid project delivery?
Business intelligence tools include all of the software and
associated
tools required to support an information management software
development project.
Project
management requires:
- Project methodology;
- Project templates;
- Project scheduling tools;
- Project estimating tools, to support accurate
estimating;
- Project collaboration tools to ensure effective
communications among team members; and
- Document management and storage repositories.
Click
here for more details about software project management tools
Requirements
management requires:
- Software tools to create and manage
requirements; and
- Some mechanism to trace requirements thru
design, development and testing
Data
modeling
requires:
- Tools to create and manage conceptual, logical
and physical data modeling tasks;
- Repositories to store data models;
- The capability to create database data
definition language; and
- The capability to compare physical data models
with database schema
Data
analysis
requires:
- Data profiling software; and
- Data quality tools
Database
software requires
Relational database management software
(RDBMS) and data management tools capable of:
- Storing large data volumes; and
- Security software tools to protect data
Database
development tools require
database development software with the ability to support database
developers creating and maintaining database procedures
Data
movement
(ETL) software tools require:
- Data
integration software tools to schedule the extraction of data from
source systems and transforming and loading it into appropriate staging
areas, data warehouses and data marts; and
- Repositories to store ETL software and common
routines
Master data
management tools requires
software
- Capable of moving master (reference) data from
systems of record to other systems which may need it; and
- Synchronizing all data between systems
as required
Business
intelligence tools requires software applications capable
of supporting:
- Business intelligence solution deign;
- Analytic business intelligence use;
- Business intelligence reporting; and
- Decision support requirements
Quality
assurance requires software-testing tools capable of
supporting:
- The creation of test cases and scripts;
- The initiation of software testing; and
- Defect management and reporting
Metadata
management requires tools capable of supporting the
storing, maintaining, accessing and management of business and
technical metadata
Configuration
management requires
tools capable of:
- Supporting a configuration management database
so that the impact of change can be quickly determined; and
- Software
management to ensure that production release process moves the correct
software versions into production and/or can “back-out” appropriate
software in the event of some form of failure
Search tools require
software capable of providing project team members with a
“search
it” tool so
they can quickly find relevant project
documentation or
information as required.
Project
management considerations
One
of the key project management tasks is to ensure that all of these
tools are available for team members and that appropriate licenses are
purchased in a timely manner to prevent delays.
Ensure that any tools used on a project conform to the information
management framework approved technology standards list.
Business Intelligence tools checklist
Successful business intelligence implementation will require some or
all of the following tools:
 Analysis tools;
Business analysis tools;
Data integration tools;
Data management tools;
Data profiling software;
Data profiling tools;
Data quality tools;
Data warehouse appliance;
Database software;
Documentation management tools;
Enterprise architecture tools;
ETL software;
Information management tools;
Project collaboration software;
Project management tools;
Query tools;
RDBMS software;
Requirements analysis tools;
Security software tools;
Software development tools; and
Software management tools.
Summary...
Business intelligence tools include all of the
software and associated tools
required to support an information management software development
project. It is imperative that these tools are available when required
and that project team member is experienced with their use or have
appropriate training
|
