@ Geoinsyssoft,the one and only BI Solution providers in Chennai
Call @044 43542263
Sunday, August 15, 2010
Monday, August 2, 2010
OBIEE-Oracle Business Intelligence training in chennai
OBIEE Overview
New Features of OBIEE
OBIEE Architecture
• Clients
• OBIEE Presentation Services
• OBIEE Server
• OBIEE Repository (.rpd)
• Data Sources
OBIEE Components
• OBIEE Administration Tool
• OBIEE Answers
• Intelligence dashboards
Repository Basics
• Oracle Business Analysis Warehouse
• DAC and Informatica Server
• Informatica Server ETL
• Sample Request Processing
• Using the OracleBI Administration Tool
• Repository Directory
• Repository Files ( Initialization files and log files)
• Loading a repository into Oracle BI Server memory
• Creating a repository
• Connection Pool
• Repository Modes ( ONLINE and OFFLINE )
• Physical Layer
• Business Model & Mapping Layer
• Presentation Layer
• Presentation Catalogs, Folders and Columns
• Error Messages
Building the Physical Layer of a Repository
• Defining an ODBC System DSN
• Setting up connection pool properties
• Importing data sources ( Physical Schema )
• Verifying the import
• Defining physical keys and joins
• Creating alias and select tables
Building the Business Model and Mapping Layer of a Repository
• Creating the logical business model
• Creating the logical tables, columns, and sources
• Defining logical joins
• Adding Calculation to a Fact Table
• Building measures
Building the Presentation Layer of a Repository
• Creating a new Presentation Catalog
• Modifying Presentation layer objects
• Rename tables
• Reorder Table
Testing and Validating a Repository
• Checking repository consistency
• Defining a repository in the initialization file
• Testing a repository using Oracle BI Answers
Adding Multiple Logical Table Sources
• Adding multiple logical table sources to a logical table
• Specifying logical content
Adding Calculations to a Fact Table
• Creating new calculation measures based on existing logical columns
• Creating new calculation measures based on physical columns
• Creating new calculation measures using the Calculation Wizard
Creating Dimension Hierarchies and Level-Based Measures
• Creating dimension hierarchies
• Creating level-based measures
Creating & Using Aggregates
• Purpose of aggregate tables in dimensional modeling
• Modeling aggregate tables to improve query performance
• Testing aggregate navigation
Using Initialization Blocks Repository Variables
Creating Dynamic Repository Variables
Execute Direct Database Requests
• Accessing database directly
Creating Time series Measures
• Using time comparisons in business analysis
• Using Oracle BI time series functions to model time series data
Providing Security for Groups & Users
Answers (REPORTS)
Working with Oracle Business Intelligence Answers
• Introduction to Oracle BI Answers
• Working with requests in Oracle BI Answers
• Using advanced formatting
• Creating report Level Hierarchy
Filtering Requests in Oracle Business Intelligence Answers
• Introduction to filters in Answers
• Adding filter prompts to requests
• Using saved requests as filters
Building Views and Charts in Requests
• Introduction to Answers views and charts
• Creating and editing charts
• Performing common view tasks
• Creating a Narrative View
• Creating a column Selector
• Creating View Selector
Showing Results with Pivot Tables
• Introduction to pivot tables
• Formatting pivot tables
• Setting aggregation rules and building formulas
Creating Oracle Business Intelligence Interactive Dashboards
• Introduction to Interactive Dashboards and pages
• Adding Objects to Dashboard
• Creating Dashboard prompts
• Embedding content in an Interactive Dashboard
Introduction to Oracle BI Publisher
• Creating a BI Publisher report from an Answers request
• Creating a BI Publisher report from the BI Server
• Integrating Discoverer worksheet content in a BI Publisher report
New Features of OBIEE
OBIEE Architecture
• Clients
• OBIEE Presentation Services
• OBIEE Server
• OBIEE Repository (.rpd)
• Data Sources
OBIEE Components
• OBIEE Administration Tool
• OBIEE Answers
• Intelligence dashboards
Repository Basics
• Oracle Business Analysis Warehouse
• DAC and Informatica Server
• Informatica Server ETL
• Sample Request Processing
• Using the OracleBI Administration Tool
• Repository Directory
• Repository Files ( Initialization files and log files)
• Loading a repository into Oracle BI Server memory
• Creating a repository
• Connection Pool
• Repository Modes ( ONLINE and OFFLINE )
• Physical Layer
• Business Model & Mapping Layer
• Presentation Layer
• Presentation Catalogs, Folders and Columns
• Error Messages
Building the Physical Layer of a Repository
• Defining an ODBC System DSN
• Setting up connection pool properties
• Importing data sources ( Physical Schema )
• Verifying the import
• Defining physical keys and joins
• Creating alias and select tables
Building the Business Model and Mapping Layer of a Repository
• Creating the logical business model
• Creating the logical tables, columns, and sources
• Defining logical joins
• Adding Calculation to a Fact Table
• Building measures
Building the Presentation Layer of a Repository
• Creating a new Presentation Catalog
• Modifying Presentation layer objects
• Rename tables
• Reorder Table
Testing and Validating a Repository
• Checking repository consistency
• Defining a repository in the initialization file
• Testing a repository using Oracle BI Answers
Adding Multiple Logical Table Sources
• Adding multiple logical table sources to a logical table
• Specifying logical content
Adding Calculations to a Fact Table
• Creating new calculation measures based on existing logical columns
• Creating new calculation measures based on physical columns
• Creating new calculation measures using the Calculation Wizard
Creating Dimension Hierarchies and Level-Based Measures
• Creating dimension hierarchies
• Creating level-based measures
Creating & Using Aggregates
• Purpose of aggregate tables in dimensional modeling
• Modeling aggregate tables to improve query performance
• Testing aggregate navigation
Using Initialization Blocks Repository Variables
Creating Dynamic Repository Variables
Execute Direct Database Requests
• Accessing database directly
Creating Time series Measures
• Using time comparisons in business analysis
• Using Oracle BI time series functions to model time series data
Providing Security for Groups & Users
Answers (REPORTS)
Working with Oracle Business Intelligence Answers
• Introduction to Oracle BI Answers
• Working with requests in Oracle BI Answers
• Using advanced formatting
• Creating report Level Hierarchy
Filtering Requests in Oracle Business Intelligence Answers
• Introduction to filters in Answers
• Adding filter prompts to requests
• Using saved requests as filters
Building Views and Charts in Requests
• Introduction to Answers views and charts
• Creating and editing charts
• Performing common view tasks
• Creating a Narrative View
• Creating a column Selector
• Creating View Selector
Showing Results with Pivot Tables
• Introduction to pivot tables
• Formatting pivot tables
• Setting aggregation rules and building formulas
Creating Oracle Business Intelligence Interactive Dashboards
• Introduction to Interactive Dashboards and pages
• Adding Objects to Dashboard
• Creating Dashboard prompts
• Embedding content in an Interactive Dashboard
Introduction to Oracle BI Publisher
• Creating a BI Publisher report from an Answers request
• Creating a BI Publisher report from the BI Server
• Integrating Discoverer worksheet content in a BI Publisher report
MS BI Course Content SSIS/SSAS/SSRS
SSIS
Introduction to Integration Services
• Defining SQL Server Integration Services
• Exploring the need for migrating diverse data
• The role of business intelligence (BI)
SSIS Architecture and Tools
Managing heterogeneous data
• Leveraging the Extract, Transform and Load (ETL) capabilities of SSIS
• Running wizards for basic migrations
• Creating packages for complex tasks
Illustrating SSIS architecture
• Distinguishing between data flow pipeline and package runtime
• Executing packages on the client side or hosted in the SSIS service
Upgrading legacy DTS
• Executing existing DTS packages in the SSIS environment
• Converting DTS packages to SSIS with the migration wizard
• Logging migration results
Implementing Tasks and Containers
Utilizing basic SSIS objects
• Configuring connection managers
• Adding data flow tasks to packages
• Reviewing progress with data viewers
• Assembling tasks to perform complex data migrations
Operating system level tasks
• Copying, moving and deleting files
• Transferring files with the FTP task
• Reading system information with WMI query language (WQL)
Communicating with external sources
• Sending messages through mail
• Detecting system events with WMI
Processing XML
• Iterating XML nodes
• Writing XML files from databases
Extending Capabilities with Scripting
Writing expressions
• Making properties dynamic with variables
• Building expressions in Expression Builder
Script Task
• Extending functionality with the Script Task
• Debugging, breakpoints, watches
Transforming with the Data Flow Task
Performing transforms on columns
• Converting and calculating columns
• Transforming with Character Map
Combining and splitting data
• Profiling data
• Merge, Union, Conditional Split
• Multicasting and converting data
Manipulating row sets and BLOB data
• Aggregate, sort, audit and look up data
• Importing and exporting BLOB data
• Redirecting error rows
Performing database operations
• Implementing Change Data Capture (CDC)
• Executing a SQL task
• Bulk inserting data from text files
Error Handling, Logging and Transactions
Organizing package work flow
• Defining success, failure, completion and expression precedence constraints
• Handling events and event bubbling
Designing robust packages
• Choosing log providers
• Adapting solutions with package configurations
• Auditing package execution results
Administering Business Intelligence
Managing and securing packages
• Storing packages in Package Store and msdb
• Encrypting packages with passwords and user keys
Integrating with other BI components
• Displaying data in Reporting Services
• Accessing package data with ADO.NET
SSAS
Building and Modifying an OLAP Cube
Designing a Unified Dimension Model (UDM)
• Identifying measures and their suitable granularities
• Adding new measure groups and creating custom measures
Creating dimensions
• Implementing a Star and Snowflake Schema
• Managing Slow Changing Dimensions (SCD)
• Identifying role-play dimensions
Extending the Cube with Hierarchies
Creating hierarchies
• Building natural hierarchies
• Many-to-many hierarchies
• Creating attribute relationships
• Distinguishing between ragged, balanced and unbalanced hierarchies
• Discretizing attribute values with the Clusters and Equal Areas algorithms
Parent-child relationships
• Defining parent and key attributes
• Generating level captions with the Naming Template feature
• Removing repeated entries with the MembersWithData property
Exploiting Advanced Dimension Relationships
Storing dimension data in fact tables
• Building a degenerate dimension
• Configuring fact relationships
Saving space with referenced dimension relationships
• Identifying candidates for referenced relationships
• Utilizing the Dimension Usage tab to configure referenced relationships
Including dimensions with many-to-many relationships
• Implementing intermediate measure groups and dimensions
• Reporting on many-to-many dimensions without double counting
Designing Optimal Cubes
Assembling cube components
• Selecting the appropriate fact tables
• Adding cube dimensions
• Distinguishing between additive, semiadditive and nonadditive measures
Designing storage and aggregations
• Choosing between ROLAP, MOLAP and HOLAP
• Partitioning cubes for improved performance
• Designing aggregations with the Aggregation Design Wizard
• Leveraging the Usage-Based Optimization Wizard
Automating processing
• Exploiting XMLA scripts and SSIS
• Refreshing cubes with Proactive Caching
Performing Advanced Analysis with MDX
Retrieving data with MDX
• Defining tuples, sets and calculated members
• Querying cubes with MDX
• Navigating hierarchies with MDX and utilizing set functions
Monitoring business performance with KPIs
• Building goal, status and trend expressions
• Using PARALLELPERIOD to compare with past time periods
Creating calculations with MDX
• Adding runtime calculations to the cube
• Comparing MDX calculations with DSV calculated columns
Securing Cube Data
Securing data and simplifying the user interface
• Distinguishing between perspective feature and security
• Creating roles for administrative privileges
• Securing dimension data
• Implementing cell-level security
Gaining Business Advantage with Data Mining
Determining the correct model
• Identifying business tasks for data mining
• Training and testing data mining algorithms
• Comparing algorithms with the accuracy chart and classification matrix
• Optimizing returns with the Profit Chart
Performing real-world predictions
• Classifying with the Decision Trees, Neural Network and Naive Bayes algorithms
• Predicting with the Time Series algorithm
Deploying models
• Predicting new cases with algorithms
• Utilizing DMX to perform batch and singleton predictions
• Exploring results with data mining viewers
SSRS
Introduction to SQL Server 2008 Reporting Services
• Identifying deployment: native, integrated or single server
• Managing Web farm deployment with/without SharePoint
Developing Reports
Designing fundamental reports
• Connecting to relational and multidimensional data sources
• Generating a Tablix reporting structure
• Building an interactive chart
• Creating reports with richly formatted text
Composing expressions
• Computing custom fields
• Managing built-in collections
• Linking expressions to properties
• Employing conditional formatting
Arranging and sorting data
• Multiple-level grouping and categorizing the results
• Applying aggregate functions
Producing various outputs from a Tablix
• Creating parallel dynamic group report formats
• Combining dynamic and static columns
Integrating Parameters and Filters
Incorporating parameters into reports
• Yielding subsets of data with query parameters
• Aligning report parameters to query parameters
• Constructing cascading report parameters
• Transmitting parameters to stored procedures
• Handling multivalued parameters
Applying filters to report data
• Augmenting performance with filters
• Determining filters vs. query parameters
Implementing Interactive Features
Combining multiple data regions in one report
• Applying sequential and nested regions
• Creating master/detail reports and linking subreports
Executing advanced data visualizations
• Applying the radial and linear gauge
• Customizing charts with scale breaks
• Charting KPIs from Analysis Services
Showing robust data with relevant detail
• Drilling through report detail and drilling down report data
• Navigating reports with document maps
• Reporting with hierarchical rows and dynamic headers
Deploying and Delivering Reports
Deploying reports to the server
• Publishing reports and configuring project properties
• Verifying results with Report Manager
Identifying delivery options
• Electing on demand or via subscription
• Enhancing performance with cached instances and snapshots
• Configuring snapshot history
• Formatting different outputs
Dispatching subscription reports
• Publishing reports via e-mail and fileshare
• Seamlessly delivering reports by data-driven subscriptions
Integrating reports with SharePoint
• Deploying reports to SharePoint
• Viewing results in Report Center and Data Connections libraries
Safeguarding Reporting Services
Structuring content security
• Leveraging existing Windows authentication
• Establishing permission levels on report items
Ensuring the RS system
• Instituting varying levels of administrative roles
• Allowing and withdrawing system-level permissions
Empowering Users with Ad Hoc Reporting
Designing models for users
• Building personalized reports with Model Designer
• Defining data source views
• Creating and refining models
Designing reports with Report Builder
• Launching Report Builder to users across the enterprise
• Dragging and dropping entities onto charts and tabular reports
• Exploiting Analysis Services cubes as report models
Delivering Reports to Users
• Accessing and controlling reports using URLs
• Leveraging RS Web services
• Embedding reports in applications with the Report Viewer
• Delivering reports through SharePoint
Introduction to Integration Services
• Defining SQL Server Integration Services
• Exploring the need for migrating diverse data
• The role of business intelligence (BI)
SSIS Architecture and Tools
Managing heterogeneous data
• Leveraging the Extract, Transform and Load (ETL) capabilities of SSIS
• Running wizards for basic migrations
• Creating packages for complex tasks
Illustrating SSIS architecture
• Distinguishing between data flow pipeline and package runtime
• Executing packages on the client side or hosted in the SSIS service
Upgrading legacy DTS
• Executing existing DTS packages in the SSIS environment
• Converting DTS packages to SSIS with the migration wizard
• Logging migration results
Implementing Tasks and Containers
Utilizing basic SSIS objects
• Configuring connection managers
• Adding data flow tasks to packages
• Reviewing progress with data viewers
• Assembling tasks to perform complex data migrations
Operating system level tasks
• Copying, moving and deleting files
• Transferring files with the FTP task
• Reading system information with WMI query language (WQL)
Communicating with external sources
• Sending messages through mail
• Detecting system events with WMI
Processing XML
• Iterating XML nodes
• Writing XML files from databases
Extending Capabilities with Scripting
Writing expressions
• Making properties dynamic with variables
• Building expressions in Expression Builder
Script Task
• Extending functionality with the Script Task
• Debugging, breakpoints, watches
Transforming with the Data Flow Task
Performing transforms on columns
• Converting and calculating columns
• Transforming with Character Map
Combining and splitting data
• Profiling data
• Merge, Union, Conditional Split
• Multicasting and converting data
Manipulating row sets and BLOB data
• Aggregate, sort, audit and look up data
• Importing and exporting BLOB data
• Redirecting error rows
Performing database operations
• Implementing Change Data Capture (CDC)
• Executing a SQL task
• Bulk inserting data from text files
Error Handling, Logging and Transactions
Organizing package work flow
• Defining success, failure, completion and expression precedence constraints
• Handling events and event bubbling
Designing robust packages
• Choosing log providers
• Adapting solutions with package configurations
• Auditing package execution results
Administering Business Intelligence
Managing and securing packages
• Storing packages in Package Store and msdb
• Encrypting packages with passwords and user keys
Integrating with other BI components
• Displaying data in Reporting Services
• Accessing package data with ADO.NET
SSAS
Building and Modifying an OLAP Cube
Designing a Unified Dimension Model (UDM)
• Identifying measures and their suitable granularities
• Adding new measure groups and creating custom measures
Creating dimensions
• Implementing a Star and Snowflake Schema
• Managing Slow Changing Dimensions (SCD)
• Identifying role-play dimensions
Extending the Cube with Hierarchies
Creating hierarchies
• Building natural hierarchies
• Many-to-many hierarchies
• Creating attribute relationships
• Distinguishing between ragged, balanced and unbalanced hierarchies
• Discretizing attribute values with the Clusters and Equal Areas algorithms
Parent-child relationships
• Defining parent and key attributes
• Generating level captions with the Naming Template feature
• Removing repeated entries with the MembersWithData property
Exploiting Advanced Dimension Relationships
Storing dimension data in fact tables
• Building a degenerate dimension
• Configuring fact relationships
Saving space with referenced dimension relationships
• Identifying candidates for referenced relationships
• Utilizing the Dimension Usage tab to configure referenced relationships
Including dimensions with many-to-many relationships
• Implementing intermediate measure groups and dimensions
• Reporting on many-to-many dimensions without double counting
Designing Optimal Cubes
Assembling cube components
• Selecting the appropriate fact tables
• Adding cube dimensions
• Distinguishing between additive, semiadditive and nonadditive measures
Designing storage and aggregations
• Choosing between ROLAP, MOLAP and HOLAP
• Partitioning cubes for improved performance
• Designing aggregations with the Aggregation Design Wizard
• Leveraging the Usage-Based Optimization Wizard
Automating processing
• Exploiting XMLA scripts and SSIS
• Refreshing cubes with Proactive Caching
Performing Advanced Analysis with MDX
Retrieving data with MDX
• Defining tuples, sets and calculated members
• Querying cubes with MDX
• Navigating hierarchies with MDX and utilizing set functions
Monitoring business performance with KPIs
• Building goal, status and trend expressions
• Using PARALLELPERIOD to compare with past time periods
Creating calculations with MDX
• Adding runtime calculations to the cube
• Comparing MDX calculations with DSV calculated columns
Securing Cube Data
Securing data and simplifying the user interface
• Distinguishing between perspective feature and security
• Creating roles for administrative privileges
• Securing dimension data
• Implementing cell-level security
Gaining Business Advantage with Data Mining
Determining the correct model
• Identifying business tasks for data mining
• Training and testing data mining algorithms
• Comparing algorithms with the accuracy chart and classification matrix
• Optimizing returns with the Profit Chart
Performing real-world predictions
• Classifying with the Decision Trees, Neural Network and Naive Bayes algorithms
• Predicting with the Time Series algorithm
Deploying models
• Predicting new cases with algorithms
• Utilizing DMX to perform batch and singleton predictions
• Exploring results with data mining viewers
SSRS
Introduction to SQL Server 2008 Reporting Services
• Identifying deployment: native, integrated or single server
• Managing Web farm deployment with/without SharePoint
Developing Reports
Designing fundamental reports
• Connecting to relational and multidimensional data sources
• Generating a Tablix reporting structure
• Building an interactive chart
• Creating reports with richly formatted text
Composing expressions
• Computing custom fields
• Managing built-in collections
• Linking expressions to properties
• Employing conditional formatting
Arranging and sorting data
• Multiple-level grouping and categorizing the results
• Applying aggregate functions
Producing various outputs from a Tablix
• Creating parallel dynamic group report formats
• Combining dynamic and static columns
Integrating Parameters and Filters
Incorporating parameters into reports
• Yielding subsets of data with query parameters
• Aligning report parameters to query parameters
• Constructing cascading report parameters
• Transmitting parameters to stored procedures
• Handling multivalued parameters
Applying filters to report data
• Augmenting performance with filters
• Determining filters vs. query parameters
Implementing Interactive Features
Combining multiple data regions in one report
• Applying sequential and nested regions
• Creating master/detail reports and linking subreports
Executing advanced data visualizations
• Applying the radial and linear gauge
• Customizing charts with scale breaks
• Charting KPIs from Analysis Services
Showing robust data with relevant detail
• Drilling through report detail and drilling down report data
• Navigating reports with document maps
• Reporting with hierarchical rows and dynamic headers
Deploying and Delivering Reports
Deploying reports to the server
• Publishing reports and configuring project properties
• Verifying results with Report Manager
Identifying delivery options
• Electing on demand or via subscription
• Enhancing performance with cached instances and snapshots
• Configuring snapshot history
• Formatting different outputs
Dispatching subscription reports
• Publishing reports via e-mail and fileshare
• Seamlessly delivering reports by data-driven subscriptions
Integrating reports with SharePoint
• Deploying reports to SharePoint
• Viewing results in Report Center and Data Connections libraries
Safeguarding Reporting Services
Structuring content security
• Leveraging existing Windows authentication
• Establishing permission levels on report items
Ensuring the RS system
• Instituting varying levels of administrative roles
• Allowing and withdrawing system-level permissions
Empowering Users with Ad Hoc Reporting
Designing models for users
• Building personalized reports with Model Designer
• Defining data source views
• Creating and refining models
Designing reports with Report Builder
• Launching Report Builder to users across the enterprise
• Dragging and dropping entities onto charts and tabular reports
• Exploiting Analysis Services cubes as report models
Delivering Reports to Users
• Accessing and controlling reports using URLs
• Leveraging RS Web services
• Embedding reports in applications with the Report Viewer
• Delivering reports through SharePoint
Monday, July 19, 2010
Course contents updated on July 2010
Data Warehouse Concepts
Introduction of Data Warehouse
Need arise of DWH
OLTP V/S DWH
OLTP V/s OLAP
Data Warehouse /Data Marts Architecture
Staging/without Staging
Dimensions (Simple and Confirm)
Fact (Simple, fact less, coverage, confirm)
Warehouse Implementation Methods
STAR SCHEMA
SNOW FLAKE SCHEMA
Difference between STAR and SNOW FLAKE Schema.
Other terminologies Cleansing, Purging etc.
Database Modeling Tool (Erwin)
Introduction of Erwin
Designing Methods
Logical Designing
Physical Designing
Introduction of ER-Modeling
Introduction of Dimension Modeling
Difference between ER-Modeling and Dimension Modeling
Implementation of ER-Model
Implementation of Dimension Model
Forward Engineering and Reverse Engineering
Introduction of various Database Components
E T L Informatica Power Center 8.6
1. Power Center Components
a) Designer
b) Repository Manager
c) Workflow Manager
d) Workflow Monitor
2. Informatica Concepts and Overview
a) Informatica Architecture.
b) Source Qualifier
c) Target Qualifier
d) Transformations
e) Mappings
f) Mapplets
g) Sessions
h) Tasks
3. Sources
a) Working with relational Sources
b) Working with Flat Files
4. Targets
a) Working with Relational Targets
b) Working with Flat file Targets
5. Transformations
a) Expression
b) Lookup
c) Sequence Generator
d) Filter
e) Joiner
f) Sorter
g)Stored Procedural
h) Router
i) Aggregator
j) Active and Passive Transformations
k) Update Strategy
l) Data Concatenation
m) Debugging Mappings
6. Mappings & Mapplets
a) Mapping Variables & Parameters
b) Creating Cubes & Dimensions
c) Working with Mapping Wizards
7. Workflow Manger
a) Server Architecture
b) Workflows, Worklets & Sessions
c) Tasks, Assignments, Events, Command etc,
8. Performance Tuning
a) Informatica Tuning (Source, target, mapping & Session)
Including Parameter file ,Unix scripts to run ,Scheduling ,Pre session and Post session.
9. Project - Case Study
Cognos 8.4
Overview of Business Intelligence
What is Business Intelligence
Why is BI Important and where can we use it
Components of BI
Business Intelligence Roadmap
Overview of Data Warehousing
What is Data Warehouse, Why do we need it
Data Warehouse Architecture and its components
Define Star Schema - Fact and Dimensions
Understand OLTP and OLAP Systems
Overview of Cognos 8.4 BI and Architecture
Introduce Cognos 8 BI
Examine the different studios in Cognos 8 BI
Identify the different data sources within the studios
Highlight key capabilities of Cognos 8 BI
Understand Cognos Multi Layered architecture
Cognos 8.4 Installations and Configuration
Installing Cognos 8.4
Install Database (MS SQL)
Install Framework Manager
Install Cognos BI Application
Setting up the Environment
Configuring Cognos 8.4
Setting up Samples in Cognos 8.4
Uninstalling Cognos 8.4
Cognos 8.4 BI Administration
Create and Modify a Data Source
Create Database backups
Understand Roles, Users and Groups
Specify Permission Settings
Cognos 8.4 Framework Manager (Metadata Modeling)
Introduction to Framework Manager
Framework Manager Basics
User Interface, Navigation, Objects
Planning the project and data model. Framework Manager Workflow
Naming Conventions for objects in a project
Designing Project
Create project
Importing Metadata from one and more sources
Exporting Metadata
Data Sources
Working with Data Source Connections
Create and Modify Data Sources
Improve Performance by setting Query Processing Type
Preparing Relational Metadata for use in Reports
Verifying Relationships
Working with Dimensions
Working with Query Subjects- Data, Model and Stored Procedure Query Subject
Working with Query Items- Set Usage and Aggregate Property
Making Metadata Available to Report Authors
Verify Model
Set Governors
Improving Performance
Create or Modify Package
Controlling access to Metadata
Explore Package
Publish Package
Guideline for Modeling Metadata
Best Practices – Presentation and Database layers
Merge Metadata
Perform Calculations and Filters
Cognos 8.4 Connection
What is Cognos Connection
Examine Cognos Connection UI elements – Create a URL, Login, Logoff
Entry Properties: General Properties, Permissions, Report, Query, Analysis, Job, Agent and Page Properties
Navigation- Public and Private Folder
Open reports with Report Name, Go to Links, Run Reports from a View
Run Reports- Prompt Pages, Printing a report and Open in Excel
View the run history of a report and Historical Reports
Closing and Creating Quick links to Reports – My Folder Shortcut and Browser Bookmark
Personalize Cognos Connection
Backups- Export of Cognos, Content Store or select items for Backups
Restore an exported Backup
Create and Customize a Page and share a single page with Multiple Users
Cognos 8.4 Query Studio
Introduction to Query Studio
Create Reports (List, Grouped List, Crosstab, Charts)
Changing the Appearance of Reports (Format)
Sorting and Grouping
Filters and Prompts
Subtotals and Calculations
Run and Manage Reports
Drill Through reports
Cognos 8.4 Analysis Studio
Introduction to Analysis Studio
Creating a Basic Analysis
Working with data in Crosstab
Exploring Data
Limiting Data
Calculating Data
Sharing Data
Cognos 8.4 Report Studio
Introduction to Report Studio
Report Studio User Interface
Creating, Save and Run Reports
Report Templates
Managing Reports
Types of Reports
List Reports
Crosstab Reports
Charts
Formatting a Report
Report Layout Guidelines
Fonts, Styles, Header, Footer and Borders
Insert objects
Swap Columns and Rows
Working with Data
Filters, Parameters and Prompts
Sorting and Grouping
Subtotals and Calculations
Working with Queries
Working with Reports
Managing changes in the Package
Conditional Formatting
Drill-through Reports
Drill-up/Drill-down Reports
Master-Detail Reports
Scheduling Reports
Cognos 8.4 Event Studio
Introduction to Event Studio
Studio User Interface
Creating, Save and Run Agents
Create agents
Different tasks
Task Execution rules
Cognos 8.4 Metric Studio
Introduction to Report Studio
Cognos 8 Power Play Transformer (Power Cube Modeling)
Fundamentals
What is Cognos Transformer
Understanding Power Play Data Sources
Starting and Navigating Transformer
Importing your source Data
Creating your Power Cube
Building the Time Dimension
Create the Time Dimension Manually
Building a Transformer Model
Performance Considerations
Build Model with AutoDesign
Modify Property sheets for Dimensions, Levels and Categories
Build Model without AutoDesign
Create New Dimensions from Source Data
Creating Exception Dimensions from Source Data
Specify a Level Label
SAS
About the SAS
Steps of SAS
MODULE 1) BASE SAS:
a) SAS system options
b) SAS statements
c) SAS data set options
d) SAS functions
e) SAS date formats
f)SAS ODS formats
g) SAS input statements options and methods
h) SAS infile statements options and usage
i) BASE SAS Procedures and SAS/STAT procedures.
MODULE 2) SAS / MACRO
MODULE 3) SAS /SQL
MODULE 4) SAS /ACCESS
MODULE 5) SAS/ODS.
MODULE 6) SAS/GRAPH
Subscribe to:
Posts (Atom)