Courses Offered :
Cognos
- INTRODUCTION TO DATAWARE HOUSING (DWH)
- Introduction and Characteristics of DWH
- OLTP and OLAP Databases
- Different Approaches of DWH(Kimball vs Inmon)
- Data mart vs. Data warehouse
- Fact Table vs. Dimension table
- Concepts of Schemas(Star & Snowflake)
- Leading ETL and Reporting tools in market
- INTRODUCTION TO COGNOS
- About Cognos and its versions
- Features of Cognos
- Cognos vs. other OLAP tools
- Cognos Modeling and Reporting components
- Cognos Connections
- FRAMEWORK MANAGER
- Data Sources and metadata modeling
- Data Modeling and relational & dimensional data
- Types of relationships in FM
- Creating Query Subjects/Query Items/Namespace/Filters/Folder
- Properties of Query Items – Usage Property/Aggregate Property
- Creating NameSpace/Project, Model and Package
- Publishing Package and Exploring Package
- REPORT STUDIO
- Creating List, Cross Tab, Chart, Repeater & Other Reports
- Report templates, formatting Reports – fonts, style, header, footer, boarder...etc
- Type of Prompts
- Generating and Creating Prompt Page with Cascading
- Query Calculations & Layout Calculations
- Filters and Dynamic Filters
- Conditional Formatting and Conditional Variables
- Master Detail relationship
- Usage of HTML, JavaScript
- Set Operators
- Drill through
- Drill Up &Drill down
- Report Functions
- Report Validation
- Schedule and Bursting
- View Run History of a Report/Report Output Versions
- QUERY STUDIO
- Introduction
- About Ad-hoc Reports
- Types of Reports(List, Cross Tab, Charts & Others)
- Applying Filters, Prompts & Calculations
- Sorting, Grouping, Sections & Aggregate Functions
- Run and Manage reports
- ANALYSIS STUDIO
- Insert Data
- Explore Data
- Calculate
- Limit Data
