We provide online trainings on data warehousing, data visualization and analytical tools like Cognos BI series, Cognos TM1, Informatica, Qlikview, Tableau. Please feel to contact us - bharati.dwconsultancy@gmail.com or cell # +1-562-646-6746 (Whatsapp enabled).
Friday, February 15, 2013
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
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 BIOverview 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
Subscribe to:
Posts (Atom)