Cognos BI Online Training

IBM Cognos Business Intelligence turns data into past, present and future views of your organization’s operations and performance so your decision makers can capitalize on opportunities and minimize risks. Browse through the contents of the program.

Cognos System Administration
Metadata Modeling Best Practices With Cognos Framework Manager
OLAP Modeling With Cognos Transformer (Power Play Tranformer)
Multidimensional Analysis With Cognos Analysis Studio
Professional Authoring With Cognos Report Studio
Dimensional Authoring With Cognos Report Studio
Business Authoring With Cognos Query Studio
BI Consumer Training
Self-service Authoring with Cognos 10 Business Insight
Cognos 10 BI Advanced Business Insight
Authoring Cognos 10 Active Reports
what is new In cognos 10
Cognos System Administration
Detailed Cognos System architecture overview
Hardware, software and network topologies
Capacity planning and Scalability
Applications and services
Data flows, memory, processing and communication bandwidth implications
Security configuration
Audit logging
Common troubleshooting tips
Recommended maintenance
Performance Tuning
Metadata Modeling Best Practices with Cognos Framework Manager
Become proficient with the Framework Manager modeling tool following a best practices
proach
Identify common data structures and reporting traps
Create a project and prepare metadata
Model for predictable results
Create business-friendly views of data
Secure metadata to allow appropriate access by users (Row-level, Object-level, and Package-level)
Create and deploy custom packages for different audiences
Dimensionally model relational content
OLAP Modeling with Cognos Transformer
Transformer Fundamentals
Discuss the basics of OLAP analysis
Discuss the importance of business requirements
Review PowerPlay components
Review Cognos BI components
Define a model
Course Content
Describe the purpose of a Transformer model plan
Match business requirements to the model
Discuss an approach for creating a Transformer model plan
Review the relation of the model plan to the Transformer model
A2. Data Sources in Transformer
Identify source data
Discuss the types of data used by Transformer
Create data source files
Connect the data source to the model
Define the data source and column properties in the model
Preview source data and SQL
Maintain and synchronize data sources with the model
A3. Building a Model
Create model structures using manual techniques and AutoDesign
Modify property sheets for dimensions, levels, and categories
Confirm the data source origin
Generate categories to populate the Transformer model
Modify the model using the dimension diagram
Verify the model
Create a default PowerCube
A4. The Time Dimension
Discuss the purpose of a time dimension
Identify the specific properties of a time column
Define a regular time dimension
Discuss a nonstandard time dimension
A5. Relative Time
Compare trends over time
Set the current period
Create relative time categories
Customize relative time categories
Discuss the use of multiple data sources
Plan the data source
Define data source types
Identify and resolve conflicts between data sources
Validate a multiple data source model
Discuss a unique move
Discuss the purpose and uses of measures
Describe the differences between regular and calculated measures
Set measure properties
Compare rollup options
Create calculations before or after rollups
Create a category count
Explore the Analysis Studio interface
Summarize data to define exact values in a report
Compare data using advanced crosstab layouts
Analyze performance by focusing on the best or worst results
Limit the data that displays in a report by creating user-defined filters
Determine relative importance using rank calculations
Understand and define a custom set
Examine Cognos Connection, personalize your portal, and manage your reporting environment
Explore Report Studio and different report types
Create and format reports using grouping, headers, footers, and other formatting options
Narrow the focus of reports by filtering data
Create interactive reports by building report prompts
Add value to your reports using calculations including advanced database and report functions
Enhance reports with advanced formatting and layout
Create complex reports using queries
Highlight exceptional data in your reports
Link reports to one another by setting up drill-through access
Understanding the query model
Adding and modifying elements of the query model (data items, aggregate properties, filters)
Creating relationships between queries ( set operations, joins, query references)
Authoring complex reports
Designing effective prompts to determine report contents and/or format at runtime
Create Dashboards in the Cognos Connection Portal using interactive Portal Pages
Fundamental Differences between dimensional reporting and relational reporting
Dimensional reporting vocabulary
Creating basic dimensional reports
Understanding members, member sets, and tuples
Using dimensional expressions to control report context
Using MDX (Dimensional) functions in calculations
Relative and hierarchical functions
Controlling advanced drill-up and drill-down behavior
Defining report and package-level drill-through
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
Create ad hoc reports with filters and calculations
Create ad hoc charts and crosstabs
Create ad hoc exception reports
Define custom groups
Contact us today at info@techflames.com or call us at +91-9100947004.