#No.1 online platform for trending courses!
IBM Cognos Training
SK, LLC provides services in complete Software Development Life Cycle (SDLC) starting from requirement gathering, analysis as per client need, the design, technical documentation, coding, testing and ongoing support. SK has a team of subject knowledge experts working in the industry with trending technical skills like Service now, Selenium, QA, Tableau, Power BI and Industry standards like ITIL setup knowledge. We partner with companies and individuals to address their unique needs, providing training and coaching that helps everyone to achieve their career goals.
Course Prerequisites
About Course
-
No prerequisite
-
Course designed for non-IT as well as IT professionals
-
Flexible batch switch is available
-
Classroom & Online Training – Can switch from online training to classroom training with nominal fee
-
100% placement calls guaranteed till you get placed
-
Working professional as instructor
-
Hands-on Experience with Real-Time Projects.
-
Proof of concept (POC) to demonstrate or self-evaluate the concept or theory taught by the instructor. 2 – Python POC, 5 – Data Science POC
-
Resume Building & Mock Interviews
-
Evaluation after each Topic completion
-
Interview Preparation Support
Curriculum
162 Lessons
Why should we consider Data Warehousing solutions?
Definition of Data Warehouse
Who needs Data Warehouse?
What are the most common sectors where Data Warehouse is used?
Characteristics of DWH
Difference between DW’s and OLTP
DWH Life Cycle
DWH Architecture
Dimensions & Facts
Star Schema & Snowflake Schema Design
Assignments Q&A’s
Quiz Q&A’s
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
Assignments Q&A’s
Quiz Q&A’s
List the Packages available for reporting.
Understand report types.
Add and save data to ad hoc reports.
View data by using charts.
Assignment Q&A’s
Quiz Q&A’s
Create a list, grouped list, and crosstab reports.
Calculate and sort report data.
Assignments Q&A’s
Quiz Q&A’s
Highlight report items using conditional styles.
Focus the scope of a report using filters.
Format report objects
Assignments in Q&A’s
Quiz Q&A’s
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
Assignments Q&A’s
Quiz Q&A’s
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 multilingual reports.
Highlight exceptional data.
Show and hide data.
Conditional 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.
Examine the specification structure.
Save and edit reports locally.
Discuss considerations for modifying a report specification.
Create reports by joining queries.
Combine data containers based on relationships from different queries.
Distribute reports using bursting.
Create bursts Keys.
Identify report recipients and data items using burst tables.
Distribute reports using email and IBM Cognos connection.
Active Reports Introduction
Create active report templates.
Describe active report connections, Apply Filter and Select behavior to active report controls.
Identify active report controls and variables in a report controls and variables in a report
Use variables to control multiple controls independently.
Describe characteristics of traditional charts inactive reports
Control data display using decks and data decks.
Assignments Q&A’s
Quiz Q&A’s
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.
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.
Apply Depth to rows and columns by nesting data.
Recognize drill behavior in nested rows and columns.
Demonstrate how to swap nested levels.
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 a crosstab.
Compose a custom sort.
Apply filters using the Context area.
Create top and bottom lists.
Use several techniques to remove rows and columns.
Assignments Q&A’s
Quiz Q&A’s
Data warehousing concepts ppt
Cognos Connections 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
Assignments Q&A’s
Quiz Q&A’s
Real time Project Done by Students.