- Why should we consider Data Warehousing solutions?
- Definition of Data Warehouse
- Characteristics of DWH
- Difference between DW’s and OLTP
- DWH Life Cycle
- DWH Architecture
- Dimensions & Facts
- Star Schema & Snowflake Schema Design
IBM Cognos Training
Quick Facts
particular | details | ||||
---|---|---|---|---|---|
Medium of instructions
English
|
Mode of learning
Self study, Virtual Classroom
|
Mode of Delivery
Video and Text Based
|
Frequency of Classes
Weekdays, Weekends
|
Course overview
IBM Cognos Training course is a short certification programme developed and offered by Mindmajix that helps the learners to have mastery in IBM Cognos Business Intelligence(BI) tool. The IBM Cognos is designed with the aim of helping business ventures to make effective business decisions by scrutinizing data and events and making business reports. The curriculum will explore a wide range of topics related to IBM Cognos including Cognos Architecture, Cognos Analytics, Query Studio reporting types, and charts, Data Warehouse Basics, etc.
IBM Cognos Training online course could be pursued by the learners in two methods. The first one is self-paced videos that consist of 35 hours of e-Learning videos and provide lifetime access to these learning materials. Whereas the second method of taking the training is a live online mode where the 35 hours of class will be provided via Zoom or Google meet. The course also enables the participants to have practical knowledge of creating reports in Query Studio, and Relational Data Modeling by assigning two real-time projects.
IBM Cognos Training certification also offers a thorough training on the advanced level knowledge including Analysis Studio, advanced report authoring, and many more. The learners will be awarded a certificate at the end of the programme and become an IBM Certified Cognos Developer boosting the chances of getting hired.
The highlights
- Flexible Schedules
- FREE Demo on Request
- 24/7 Lifetime Support
- 100% practical-oriented classes
- One-on-One Doubt Clearing
- Certification Oriented Curriculum
- Real-time Project Use cases
- Placement Support
Program offerings
- 35 hours of sessions
- 20 hours of labs
- Flexible schedules
- Free demo on request
- 24/7 lifetime support
- One-on-one doubt clearing
- Certification oriented curriculum
- Real-time project use cases.
Course and certificate fees
Fees information
The fees for the course IBM Cognos Training is -
Head | Amount |
Original fees | Rs. 10,000 |
Discounted fees | Rs. 8,000 |
certificate availability
Yes
certificate providing authority
Mindmajix Technologies
Who it is for
What you will learn
At the end of the IBM Cognos Training online certification, the learners will be able to develop a detailed knowledge of IBM Cognos and the capacity to come up with multi-dimensional reports. Plus, the enrolled students will have the opportunity to create dashboards making use of the Cognos report studio and build data models using the Cognos metadata layer.
The syllabus
Data Warehouse Basics
Cognos Architecture and Analytics Administration
- What is IBM Cognos Analytics?
- Examine IBM Cognos Analytics UI elements
- Run and view reports
- View the run history of a report
- Organize content with folders and shortcuts
- Customize report outputs by using report views
- Schedule single and multiple reports
- Backups-Export of Cognos Content
- Create a Data source
- Deployment
- Users, Groups, and Roles
Introduction to Query Studio
- List the packages available for reporting
- Understand report types
- Add and save data to ad hoc reports
- View data by using charts
Create Reports in Query Studio
- Create a list, grouped list, and crosstab reports
- Calculate and sort report data
Enhance Reports in Query Studio
- Highlight report items using conditional styles
- Focus the scope of a report using filters
- Format report objects
IBM Cognos Framework Manager: Relational Metadata Modeling
- Introduction to Framework Manager
- User Interface, Navigation, Objects
- Designing Project
- Create project
- Importing Metadata
- Working with Data Source Connections
- Create and Modify Data Sources
- Preparing Relational Metadata for use in Reports
- Verifying Relationships
- Working with Dimensions
- Working with Query Subjects
- Working with Query Items
- Supporting Multilingual Metadata
- Adding Business Rules
- Organizing the Model
- Verify Model
- Set Governors
- Create or Modify Package
- Publish Package
- Object ,Data and package security
- Making Metadata Available to Report Authors
- Edit Governors
- Guidelines for Modeling Metadata
- DMR model - Regular Dimensions, Measure Dimensions, Scope Relationship
Advanced Report Authoring
Introduction to the Reporting Application
- Examine Report Studio and its interface
- Explore different report types
- Create a simple, sorted, and formatted report
- Explore how data items are added to queries
Create List Reports
- Group, format, and sort list reports
- Describe options for aggregating data
- Create a multi-fact query
- Create a report with repeated data
Focus Reports Using Filters
- Create filters to narrow the focus of reports
- Examine detail and summary filters
- Determine when to apply filters on aggregate data
Create Cross Tab Reports
- Format and sort crosstab reports
- Create complex crosstabs using drag and drop functionality
- Create crosstabs using unrelated data items
Present Data Graphically
- Create charts containing peer and nested columns
- Present data using new chart type options
- Add context to charts
- Present key data in a single dashboard report
Focus Reports Using Prompts
- Identify various prompt types
- Use parameters and prompts to focus data
Extend Reports Using Calculations
- Create calculations based on data in the data source
- Add run-time information to the reports
- Create expressions using functions
Design Effective Reports
- Enhance report design with report objects
- Reuse objects within the same report
- Share layout components among separate reports
Customize Reports With Conditional Forming
- Create multi-lingual reports
- Highlight exceptional data
- Show and hide data
- Conditionally render objects in reports
Drill-Through from One Report to Another
- Let users navigate from a specific report to a target report
- Pass parameter values to filter the data in drill-through targets
- Navigate through multiple reports
Analysis Studio
Analysis Studio Fundamentals
- Define the fundamental terms of Analysis Studio
- Explain how to insert objects
- Define and create sets
- Identify the work area, overview area, and properties pane
Tools for Investigation in Analysis Studio
- Employ drilling down and up to different levels of detail
- Apply changes to rows, columns, and measures in the analysis
- Explain how to change the display of data
- Use charts to display data graphically
Nest Data in Cross Tabs in Analysis Studio
- Apply depth to rows and columns by nesting data
- Recognize drill behaviour in nested rows and columns
- Demonstrate how to swap nested levels
Build Advanced Cross Tabs in Analysis Studio
- Demonstrate how to view a complete level of data
- Design a crosstab without retrieving data
- Compare multiple measures
- Apply stacked sets to the crosstab
- Construct an asymmetrical crosstab
- Compose a custom sort
Focus with Filtersin Analysis Studio
Apply Filters Using Expressions
- Apply filters using the Context area
- Create top and bottom lists
- Use several techniques to remove rows and columns
Event Studio - Work Space
Handouts
- Data Warehousing concepts ppt
- Cognos Connection ppt along with screenshots
- Query studio ppt along with screenshots
- Query Studio Topics for Practice Doc
- Report studio ppt along with screenshots
- Report Studio Topics for Practice Doc
- Framework Manager ppt along with screenshots
- Analysis Studio ppt along with screenshots