Curriculam

Introduction to Data warehousing
Module 1: Characteristics of DWH
• OLTP Vs OLAP Databases
• Architecture of DWH
• Different Approaches of DWH (Kimball Vs Inmon)
• Data mart Vs Data Warehouse
• Fact Table Vs Dimension Table
• Concepts of Schemas (Star schema & Snowflake schema)
• Types of Dimensional Data Modeling
• Data Modelling and Types
• Logical Data Model
• Physical Data Model
• Onine Analytical Processing (OLAP and Types)
• ROLAP, MOLAP, HOLAP, CUBES
• Industry leading ETL and Reporting tools
• BI Vendor Comparison
Module 2: Introduction of IBM Cognos 10 BI
• Review Corporate Performance Management
• Introduce Cognos 10 BI Architecture
• What is Content store,Content Manager, Dispatcher?
• Different studios in Cognos 10 BI
• Working with different data sources in Framework manager
• Highlight key capabilities of Cognos 10 BI and new features
• Cognos Architecture( Single Tier, Three Tier and Multi Tier)
Module 3: Introduction to Framework Manager
• Define Framework Manager and its purpose
• Describe the Framework Manager environment
• Examine the Cognos 10 and Framework Manager workflow processes
• Examine the Framework Manager user interface
• Create a project
Module 4: Create Metadata Modelling
• Create Data source connection
• Create Namespaces
• Overview of Business view and Database view
• Overview of Presentation view
• Create Cardinality Relationships
• Create Model Query Subjects
• Data source Query subjects and Query items
• Create Determinants
• Regular Dimension and Measure Dimension
• Model Filters, Prompts & Calculations
• Create Business Logic
• Leverage user defined functions
• Stored procedures
• Data for mutilingual Audience
• Create Preparing the Metadata
• Create Creating Star Schema
• Security level Types
• Data level Security
• Object Level Security
• Package Level Security
• Verify Objects
• Performance Tuning
• Create & publish Packages
Module 5: Introduction to Query Studio
• List the packages available for reporting
• Examine report types
• Add and save data to ad hoc reports
• View data by using charts
Module 6: Create Reports in Query Studio
• Create list, grouped list, and crosstab reports
• List the charts available and their appropriate use
• Calculate and sort report data
• Define a custom group to define your own report item
• Drill down and drill up
• Change rows, columns and measures
• Sort
• Show values as percentages
• Manage the number of items retrieved
• Display data graphically
Module 7: Introduction to the Report Studio
• Examine Report Studio and its interface
• Explore different report types
• Create a simple, sorted, and formatted report
Module 8: Create List and Crosstab Reports
• Format, group, and sort list reports
• Format and sort crosstab reports
• Create a report with repeated data
• Work with dimensional data in a report
Module 9: Present Data Graphically
• Create charts
• Present data using new chart type options
• Create and reuse custom chart palettes
• Present key data in a single dashboard report
Module 10: Focus Reports Using Filters
• Create filters to narrow the focus of reports
• Determine when to apply filters on aggregate data
• Examine source filters
Module 11: Focus Reports Using Prompts
• Use parameters and prompts to focus data
• Identify various prompt types
• Customize prompts to facilitate users’ choices
• Search for prompt items
• Navigate between pages
Module 12: Design Effective Reports
• Enhance report design
• Add report objects to enhance design
• Format data and report objects
• Add a background image to a report
• Add row numbers to a report
Module 13: Customize Reports with Conditional Formatting
• Create multi-lingual reports
• Highlight exceptional data
• Show and hide data
• Conditionally render objects in reports
Module 14: Analysis Studio
• Analysis Studio Fundamentals
• Nest Data in Crosstabs in Analysis Studio
• Create Analysis with Multiple filter
• Reusable analysis
• Build Advanced Crosstabs in Analysis Studio
• Focus with Filters in Analysis Studio
• Creating reports from cubes
• Drill down and drill up
Module 15: Event Studio
• Introduction to Event Studio
• Create an agent
• Add tasks to an agent
• Run an agent through its lifecycle
• Schedule an agent
Module 16: Business Insight
• Introdcution to Dashboards
• Create Dashboard
• Types of Filter-Value, Slider and advanced filter
• Overview of RSS Feed and web Page
• Content Pane
• Create Widgets
• Sort, Filter and Calculate data
• Hands on
Module 17: Business Insight Advanced
• Overview of Business Intelligence Advance level
• Create Different types of Reports
• Reporting Styles and filters
• Create dashboard objects
• Summarize data and Create Calculations
• Dispatcher and Services
Module 18: Dispatcher in detail
• All Services
• Properties of Services