Overview of Data Integration & Business Intelligence

Over the years, most organizations have made significant investments in enterprise resource planning, customer relationship management, and supply chain management packages in addition to their home grown applications. This has resulted in larger amounts of data being captured about their businesses.

To turn all this data into consistent, timely, and accurate information for decision-making requires an effective means of integrating information.

ETL & ELT addresses this critical information integration Requirements of consistent, complete, and trustworthy information with a Comprehensive, unified foundation for enterprise information architectures.

Business intelligence enables the right access to the right data or information needed to make the right business decisions at the Right time. The data might be raw or might have been analyzed in some way. Having access to such information enables management of the business by fact instead of by primarily relying on intuition.

Typical Warehouse Architecture

 

Training Highlights

  1. Training classes are conducted by most experienced Trainers.
  2. Very basic level to In-depth coverage of all concepts.
  3. Industry based best practices and scenarios.
  4. Hands on and workouts after each session.
  5. Offering all the Technologies in the above mentioned architecture.
  6. Course Customization as per the corporate requirement.
  7. Unlimited online support after the course.
  8. Online packages offered with reasonable Pricing.
  9. Mock Interviews for Entry level developers.
  10. Interview Assistance for genuine candidates
 

Training Programs offered

Data warehousing concepts:
     Data Warehouse, OLTP Vs Warehouse Applications, Data marts Vs Data Warehouses, ODS, Warehouse Architectures, Components, Warehouse Design & Common Mistakes.

Data Modeling Concepts:
     E-R Data Model, Normalization, Normal forms, Designing ER Database, Dimensional Modeling, Sub Models, Designing a star schema

ETL Process:
     Extraction Types, Extraction Types, Data Transformation, Loading- Types, Data Warehouse Updates, SCD-Types, Real World Problems & Best Practices.

ETL & ELT Tools

Informatica Power Centre(7.x / 8.x / 9)

Informatica Architecture:
Informatica Administration
Informatica Development
Advanced Mapping Design Strategies.
Informatica power Analyzer.
Metadata Manager.
Best Practices & Case Studies.

Certification Programme
   • Data Integration Certification Path
       1. Informatica Certified Administrator
       2. Informatica Certified Developer
       3. Informatica Certified Consultant

InfoSphere Data Stage 8

Info sphere Information server Architecture.
Datastage Architecture.
Server Jobs.
Parallel Jobs.
Advanced Techniques in Parallel Jobs.
Programming in Data Stage.
Information Analyzer.
Best Practices & Case Studies.

Certification Programme
   • IBM Certified Solution Developer - InfoSphere QualityStage v8
   • IBM Certified Solution Developer - InfoSphere QualityStage v8
   • IBM Certified Solution Developer - WebSphere IIS QualityStage v7.5
   • IBM Certified Solution Developer - WebSphere IIS DataStage Enterprise Edition v7.5
   • IBM Certified Solution Developer - WebSphere Information Analyzer v8.0

OLAP: OLAP Functionality, functional requirements, technical requirements, Architecture, Olap Tools, Hyperion Essbase.

Cognos 8.4 BI

Cognos Architecture
Cognos Administration
Cognos Connection
Framework Manager
Query Studio
Report Studio
Analysis Studio
Metric Studio
Event Studio
Report Studio
Cognos Planning
Cognos TM1
Best Practices & Case Studies.
Certification Programme
   • IBM Certified Administrator - Cognos 8 BI
   • IBM Certified Designer - Cognos 8 BI Reports
   • IBM Certified Designer - Cognos 8 BI Multidimensional Reports
   • IBM Certified Developer - Cognos 8 BI Metadata Models
   • IBM Certified Developer - Cognos 8 BI OLAP Models
   • IBM Certified Developer - Cognos 8 BI Scorecards
  

Business Objects XI (R3)

BO Architecture
Designer
Web Intelligence
Desktop Intelligence
Olap Intelligence
Crystal Reports
Business Views
BO Enterprise Integration
Business Objects Data Integrator (BODI)
Best Practices & Case Studies

 

To register for the course contact : 9731451451 / 9731452452