Data Warhouse Advanced Real Project (Informatica & Web Base BI)
（更多资料和具体参加方法）
Informatica
1. Course Introduction
This Project oriented Co-op course provides the experience to design and build Oracle Data Warehouse using most popular ETL tools Informatica, A real Data Warehousing Project guides you through the process of planning, designing, building and developing an integrated Oracle Data Warehouse / Data Mart. The most important point is you will gain Real Project experience working with Oracle Data Warehouse, Erwin, Informatica.
Your will learn How to:
· Plan, design and build comprehensive Oracle Data Warehousing & BI project
· Implement logical and physical Data Model for Oracle Data Warehouse / Data Mart using Erwin.
· Develop Star Schema, Data warehouse summary table by using Materialized Views
· Design ETL process, implement OLTP to OLAP source to target mapping process
· Extract, transform and load (ETL) data into data warehouse
· Design complex mapping process from data source to target
· Perform Informatica Administrator and Developer tasks including install, configure and develop the ETL solution using the most important ETL software Informatica
Who should attend:
This course valuable for Oracle Developer / Database & Warehouse Design / ETL Developer / Database modeler, System Analyst, System Engineers, Consultants and others involved in building Oracle applications.
2. Objective
Upon completion of the course, participants should be able to:
- Plan, Design and Build real Oracle Data warehouse project
- Understand with Data Warehouse development life cycle, include define business requirement, system analysis, system design, construction and deployment.
- Develop a multidimensional data model and generating Oracle database structure using Erwin
- Gain Data Warehouse experience in Data Architecture, Data Modeling and logical and physical Database design
- Perform Extracting, transforming and loading (ETL) data to Data Warehouse using Informatica
3. Course Content
Introduction
- Data Warehouse Architectures
- Introduction of Informatica
- Introduction of the data warehousing Co-op project
Data Warehouse Project Plan
· Phase One – Vision
o Vision Goals
o Key Vision Deliverables
o Vision Flow
· Phase Two - Discovery
o Discovery Goals
o Key Discovery Deliverables
o Discovery Flow
· Phase Three – Architecture
o Architecture Goal
o Key Architecture Deliverables
o Architecture Flow
· Phase Four – Construction
o Construction Goal
o Key Construction Deliverables
o Construction Flow
· Phase Five – Implementation
o Implementation Goal
o Key Construction Deliverables
o Construction Flow
· Phase Six – Audit and Iteration
o Audit and Iteration Goals
o Key Audit and Iteration Deliverables
o Audit and Iteration Flow
Define Data Warehouse Project Requirements
· Interview process
· Developing analytic themes
· Linking themes to business process
· Developing the data warehouse bus matrix
· Prioritizing business processes
Data Warehouse / Data Mart Modeling
- Design star schemas
- Star schema benefits
- Implementing database portioning
- Dimensional vs. traditional approaches
- Data Mart vs. Data warehouse
- Define the metadata and metadata model sample
Creating the Logical Model
- Develop the logical Data Model
- Building Logical Relationships
- Organizing and Enhancing the logical data model
- Reviewing the logical data model
- Delivering the logical data model
- Advanced features for logical model
Creating the Physical Model
- Develop the physical model
- Build the physical model in Erwin
- Build physical relationships
- Review the physical data model
- Delivery the physical data model
- Default values and Validation rule
- Tables / Columns
- Views / Materialized Views / Temporary Tables
- PK / FK / UK & Indexes
- Script Generate procedure
ETL fundamental
- Design ETL architecture
- Design ETL metadata repository
- Design ETL process
- Document ETL process
Building Data Warehouse Using Informatica
- Informatica architecture
- Informatica connectivity
- Informatica Clint tools
- Informatica workflow
Informatica Designer
- Source Analyzer
- Warehouse Designer
- Transformation Developer
- Mapplet Designer
- Mapping Designer
Informatica Sever Manager
- Workflow
- Configure Server
- Create a Session
- Run a Session
- Monitor a session
- Check Log
Repository Manager
- Metadata Repository
- Security Management
- User Management
- Permission
Advanced Mapping process design
- Sorter Transformation
- Aggregator Transformation
- Active and Passive Transformations
- Data Concatenation
- Router, update Strategy and Overrides
- Router Transformation
- Update Strategy Transformation
- Expression Default Values
- Source Qualifier Override
- Target Override
- Session Task Mapping Overrides
- Dynamic Lookup and Error Logging
- Dynamic Lookup
- Error Logging
Data Warehouse loading
- Dimension table loading
- Implementation of slowly change dimension
- Fact table loading
- Lookup all surrogate keys
Debugger
- Debugging Mappings
- Parameters and Variables
Mapplets
- Mapping Input Transformation
- Mapping Output Transformation
Workflow Variables and Tasks
- Link Conditions
- Workflow variables
- Assignment task
- Decision Task
- Email Task
Summary of the Data warehouse project
- Description of project lifecycle
- Achievements Review
Web Base BI
1. Course Introduction
This new generation BI course focus on the web based BI system, which provides the experiences needed to modeling and implementing BI Analysis and Reporting. A series of extensive hands-on exercises guides you through the process of modeling & developing a new generation of BI. The most important point is you will gain practical hands-on experience working with web based BI upon Oracle Data Warehouse.
Your will learn How to:
· Provide report authors and query users with a business presentation of the information in the corporate data sources.
· understand and modify the query model that underlies reports created in Report Studio
· distribute customized report content by bursting to the Web and to email
· create and debug report specifications written in Extensible Markup Language (XML)
2. Objective
Upon completion of the course, participants should learn:
· BI Modeling with Framework Manager
· Ad Hoc Query on demand
· Web based BI reporting
· OLAP via Analysis Studio
3. Course Content
- Administer the Reporting Environment
- examine the role of System Administrators, Directory Administrators and Report Administrators
- manage the reporting environment
- administer security
- deploy entries from one environment to another
- BI modeling with Framework Manager
- Design and Create a Project
- Prepare the Metadata
- Prepare the Business View
- Manage Packages
- Set Security in Framework Manager
- Manage Projects
- Use Advanced Modeling Techniques
- Web based Ad Hoc Query
- use Cognos Connection to access ReportNet tools
- create ad hoc reports in Query Studio
- add data to existing ad hoc reports
- customize ad hoc reports
- view ad hoc reports in different formats and languages
- distribute ad hoc reports
- administer ad hoc reports in Cognos Connection
- Web based BI Reporting
- Customize the Query Model
- Distribute Reports Through Bursting
- Customize the Report Specification
- Create Custom Toolbox Objects and Templates
（更多资料和具体参加方法）
