Friday, February 15, 2013

Informatica Data Quality Tutorial - Creating Rules Analyst Tool Part 4 ...

Monday, February 4, 2013

Cognos 10 Tutorial Video

IBM COGNOS SELF LEARNING TUTORIAL VIDEOS:

1 Cognos 10 Training - Report Studio Basics - Part 1 of 30
    http://www.youtube.com/watch?v=iPumj-PVAYE

2 Cognos 10 Training - Creating Prompts  - Part 2 of 30
    http://www.youtube.com/watch?v=3uUYPUt0pUk

3 Cognos 10 Training - Creating Cascading Prompts  - Part 3 of 30
    http://www.youtube.com/watch?v=n10hPVveIHc

4 Cognos 10 Training - Drill Thru Definition  - Part 4 of 30
    http://www.youtube.com/watch?v=z0_dUoZfEG0

5 Cognos 10 Training - Master Detail Report  - Part 5 of 30
    http://www.youtube.com/watch?v=yFWscNj7sgU

6 Cognos 10 Training - Advanced RS - Creating Joins  - Part 6 of 30
    http://www.youtube.com/watch?v=7xv7Rl33lNA

7 Advanced RS - Creating Unions - Intersect  - Part 7 of 30
    http://www.youtube.com/watch?v=ae2tnqsif-0

8 Cognos 10 Training - Creating Dashboards  - Part 8 of 30
    http://www.youtube.com/watch?v=YlBYDsbrbrg

9 Cognos 10 Training - Conditional Formating-Boolean  - Part 9 of 30
    http://www.youtube.com/watch?v=hk74GC8IqJg

10 Cognos 10 Training - Conditional Formating-String   - Part 10 of 30
    http://www.youtube.com/watch?v=Ooqxm9DfB84

11 Cognos 10 Training - Report Scheduling  - Part 11 of 30
    http://www.youtube.com/watch?v=zatzcA6hW20

12 Cognos 10 Training - Advanced RS - Dynamic Grouping  - Part 12 of 30
    http://www.youtube.com/watch?v=aNUjjxyHazo

13 Cognos 10 Training - Creating Datasource  - Part 13 of 30
    http://www.youtube.com/watch?v=FLHj9McKpO8

14 Cognos 10 Training - FM Project RMR  - Part 14 of 30
    http://www.youtube.com/watch?v=0GYhaGxeWLw

15 Cognos 10 Training - FM Data Level Security  - Part 15 of 30
    http://www.youtube.com/watch?v=oeZw4HrNSG0

16 Cognos 10 Training - Advanced FM - Using Scripts  - Part 16 of 30
    http://www.youtube.com/watch?v=hdYuFHchM54

17 Cognos 10 Training - FM Dimensional Model - DMR  - Part  17 of 30
    http://www.youtube.com/watch?v=kZu5Na0QPNo

18 Cognos 10 Training - Calculations - Filters FM  - Part 18 of 30
    http://www.youtube.com/watch?v=WQFSx6FVwg8

19 Cognos 10 Training - Administration Deployment  - Part 19 of 30
    http://www.youtube.com/watch?v=WYiNjiOw6qM

20 Cognos 10 Training - Creating Security Groups  - Part 20 of 30
    http://www.youtube.com/watch?v=vA33qalbYTg

21 Cognos 10 Training - Restoring Sample SQL Database  - Part 21 of 30
    http://www.youtube.com/watch?v=YCvq9b2Olj8

22 Active Reports - Data Toggle Button Bar  - Part 22 of 30
    http://www.youtube.com/watch?v=Zi_mFIW8k7Y

23 Active Reports - Data Tab Control Filter & Select  - Part 23 of 30
    http://www.youtube.com/watch?v=FJc2FE0uu4w

24 Cognos 10 Training - Business Insight & Advanced - Part 24 of 30
    http://www.youtube.com/watch?v=6H2AzryYWLQ

25 Cognos 10 Training - FM Advanced Prompts &Session Parameters P-25 of 30
    http://www.youtube.com/watch?v=oveM0MV_u1w

26 Cognos 10 Training - FM Advanced Parameter Maps Part 26 of 30
    http://www.youtube.com/watch?v=6doWLvl7x58

27 Cognos 10 Training- Javascript Default Date Prompt Part 27 of 30
    http://www.youtube.com/watch?v=STHJVFTbXIc

28 Cognos 10 Training - Performance Tuning Prompt Page Part 28 of 30
    http://www.youtube.com/watch?v=FY-oGgv6BMU

Cognos 10 BI Training in Mumbai

Cognos 10 BI Training in Mumbai:

Whats new Cognos 10 BI
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 10 BI and Architecture
• Introduce Cognos 10 BI
• Whats new Cognos 10 BI
• Examine the different studios in Cognos 8 BI
• Identify the different data sources within the studios
• Highlight key cap abilities of Cognos 8 BI
• Understand Cognos Multi Layered architecture

Cognos 10 Installations and Configuration
• Installing Cognos 10
• Install Framework Manager
• Install Cognos BI Application
• Setting up the Environment
• Configuring Cognos 10
• Setting up Samples in Cognos 10
• Uninstalling Cognos 10

Cognos 10 BI Administration
• Create and Modify a Data Source
• Create Database backups
• Understand Roles, Users and Groups
• Specify Permission Settings

Cognos 10 Connection Administration
• 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 10 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 10 Analysis Studio
• Introduction to Analysis Studio
• Creating a Basic Analysis
• Working with data in Crosstab
• Exploring Data
• Limiting Data
• Calculating Data
• Sharing Data

Cognos 10 Report Studio
• Introduction to Report Studio
• Report Studio User Interface
• Creating, Save and Run Reports
• Report Templates
• Managing Reports
• Types of Reports
• Active 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 10 Framework Manager
• 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 Meta data 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