Informatica, Cognos , Hyperion Online Training & Job Support

[b]Hi,[/b]
[b]We are providing online training on[/b] [color=#ff0000][b]INFORMATICA ,COGNOS, HYPERION[/b][/color][b]. If anyone interested, please contact us.[/b]

[b]Email: [email protected][/b]

[b]Contact No: +91-8123414771[/b]

[b]Course: Cognos BI 8/10[/b]
[b]Course Content:[/b]
[b]DATA WAREHOUSING CONCEPTS[/b]
• Data Warehouse
• Data Mart
• Data mart Vs Data Warehouse
• OLTP and OLAP’s(Types)
• OLAP VS OLTP
• Data Warehouse Architecture (Basic)
• Data Warehouse Architecture (with a Staging Area)
• Dimensional Modeling and ER Modeling
• Star Schema
• Snowflake Schema
• Dimension
• Fact
• Fact Table Vs Dimension Table
• Type Of Facts
• Slowly Changing Dimension
• Hierarchy
• Confirmed Dimension
• Fact less Fact
• Summary / Aggregations table
• Change Data capture
[b]COGNOS 8.4 COURSE CONTENT[/b]
[b]Cognos 8BI Introduction and Installation[/b]
• Cognos introduction
• Various components of Cognos 8 BI suite
• Installation and configuration
• Data Source Creation
• Basic requirement to create a report
[b]Metadata Modeling Requirement in Cognos 8BI[/b]
• Project
• Model
• Namespace
• Objects in FM
• Relationships and parameters maps
• Significance of Various Layers/Views
[b]Cognos Interface[/b]
• Navigating the Cognos Connection portal
• GUI walk through
• Content and functionality
• Creating folders
• Scheduling reports and jobs
[b]Over View of Query Studio[/b]
• Query Studio Interface
• Capabilities and basics
• Report types
• Capabilities and basics
[b]Report Studio Overview and Navigation[/b]
• Prerequisite for Creating reports Report Studio
• Report Studio Interface
• Report Studio capabilities and basics
• Report types and templates
• Running reports
• Defining the toolbars
• Viewing a report
• Explorer bars
• Report structure
• Adding report objects
• Displaying data
• Creating queries
[b]Organizing and Summarizing[/b]
• Using lists and crosstabs
• Sorting
• Grouping
[b]Create a Baseline Project[/b]
• Report sections
• Summarizing, Aggregation
[b]Filters and Prompts[/b]
• Report functions
• Stand alone, embedded
• Detail and summary filters
• Prompt objects
• Prompt pages
[b]Calculations and Conditional Formatting[/b]
• Query calculations
• Layout calculations
• Creating and applying variables
[b]Layout Formatting[/b]
• Styling
• Free standing objects
• Tables
• Alignment, spacing, object size
• Headers and Footers
• Page Sets
[b]Extra![/b]
• Advanced formatting
• Working with Queries
• Visualizations (Charts and Maps)
• Beyond the Report
• Encountering Problems and Issues
[b]Overview of Analysis Studio[/b]
• Introduction and Functionality
• Working with Analysis Studio
• Visualizations (Charts and Crosstab)
• Slice & Dice
• Drill-up & Down Functionality
[b]Overview of Event Studio[/b]
• Introduction and Functionality
• Working with Event Studio
[b]COGNOS 10 BA COURSE CONTENT[/b]

• Cognos 8.4 Content will be covered
• Cognos 10 BA new features
• Active Report
• Cognos Business Insight
• Cognos Business Insight Advanced