|
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
|
