|
| If you are
knowledgeable of IBM's Business Intelligence solutions and the fundamental
concepts of DB2 Universal Database, and are capable of performing the
intermediate and advanced skills required to design, develop and support
Business Intelligence applications, you may benefit from this certification
. This certification is applicable to those who
specialize in identifying the business and technical requirements of a Business
Intelligence opportunity; and consult, architect and manage Business
Intelligence solutions. This is a software based test for use by consultants
and implementors that is based on IBM's Business Intelligence software and
solutions. |
|
|
|
Section 1 - Business Intelligence Terminology, Functions and
Differentiators (27%) - Define Business Intelligence
terms
- Differentiate characteristics and purpose of data marts from
those of a data warehouse
- Articulate the benefits of business
intelligence (e.g., timely information, extending the ability of query tools,
to extend the ability to understand your business, provide historical view of
operational business data, it extends the number of people who can make use of
it, etc.)
- Explain scheduling options (time/event/function)
- Illustrate how network communications impacts Business Intelligence
architecture
- Differentiate multi-dimensional database versus
relational database warehouse
- Differentiate between Operational data
store and data warehouse
- Given BI data and customer requirement
criteria, select appropriate tools to perform transformation, extraction, data
modeling, data cleansing, loading, and propagation
- Define and
distinguish metadata
- Describe metadata management techniques and
processes
- Given BI data and customer needs, implement metadata
strategy
- Given BI data, determine appropriate analysis techniques
(query, cluster, trend, discovery, predictive, explanatory, visualization)
- Given BI data and customer requirement criteria, select appropriate
visualization and presentation techniques (charts, maps, reports, tables,
agent-driven, messaging)
- Given customer requirement criteria, select
appropriate front-end features based on criteria such as presentation, level of
interactivity, web-versus-FAT client, static versus dynamic, and user skill
level
Section 2 - Gather Customer BI Requirements (24%) - Identify business requirements of the customer as relates to a Business
Intelligence solution
- Define the business goals and objectives of the
customer
- Determine number of users, types of queries, number of
queries, user work tables
- Evaluate existing hardware and software
environment
- Identify constraints (financing, political, timing, legal,
technical, competition, legacy issues, customer skill level, etc.)
- Determine customer growth requirements
- Identify geographical
constraints (human language issues, computer language issues, currency issues,
etc.)
- Identify critical success factors and how to validate them
- Determine availability and recovery requirements (user uptime,
maintenance windows, system maintenance, data mart, and data warehouse for
update/refresh situations, disaster recovery, hardware/software failures,
aggregation for data marts
- Prepare for a production environment from a
test environment
Section 3 - Business Intelligence Data Sourcing/Movement (25%) - Identify sources of data (operational, non-operational within
the company, external to the company)
- Identify methods for extraction
- Identify methods for transformation
- Identify methods for
cleansing
- Differentiate between full differential capturing and
snapshot capturing
- Define methods for data moving (differential,
full-refreshed, incremental)
- Define methods for scheduling
- Define methods for error detection and handling
- Describe data
modeling techniques and processes
- Identify methods for work load
balancing
Section 4 - Business Intelligence Solution Architecture (24%) - Describe data warehouse management techniques and processes
(conversion of data model to the data warehouse; creation & loading of
Enterprise Relational Data Warehouse; extraction & management of metadata;
creation & loading of data marts from DW
- Describe to a customer the
infrastructure and organization necessary to support a data warehouse
- Given source data tables, identify measures, attributes, and dimension
- Given a BI scoped project, build logical data models (create fact
tables, identify dimension, associate the attributes with dimensions)
- Given a BI business requirement, determine data that is applicable to
the business question
- Given a BI business requirement, transform it
into a solution based on requirements such as functionality, performance,
security, size, availability, interface with front-end or other systems,
connectivity, communications, etc.
- Given a BI business requirement,
select appropriate tools to build the solution (e.g., data extraction,
scrubbing, transporting, transforming, data modeling, querying, business
process modeling)
- Given a BI business requirement, select appropriate
middleware tools for diverse information integration to the datawarehouse
- Given a BI business requirement, select appropriate presentation to
the customer based on complexity of data, sophistication of tools, complexity
of the data model, user skills, level of interactivity, deployment &
accessibility, level of detail needed and level of summarization needed
- Given an architecture for a BI solution, determine the feasibility of
the design based on customer performance expectations, growth requirements, and
scalability factors
- Given a Business Intelligence project, plan for
education
- Determine a solution for producing a searchable meta data
repository for business users
|
